database prcl42 file prc field sid type serial field h00 type char 10 {new block} index dups field h01 type char 10 {new lot} index dups field h02 type char 05 {new qual} field h03 type char 01 {new bldg} field hid type composite h00, h01, h02, h03 index field i00 type char 10 {old block} field i01 type char 10 {old lot} field i02 type char 05 {old qual} field l02 type char 24 {new b/lot/q/b sort format} index {dups} field l03 type char 23 {old b/lot/q sort format} field i24 type char 3 {class} field h77 type char 25 {street} index dups field i18 type char 35 {owner name} index dups field i19 type char 25 {owner street} field i20 type char 30 {owner csz} field l30 type char 17 {billing code/acct#/map page} field i72 type date {sale date} field i73 type char 5 {sale book} field i74 type char 5 {sale page} field i75 type long {sale val} field i88 type char 2 {sale nu} field i89 type char 3 {class4cd, was sale ratio 11-21-10 bkr} field h97 type long {prc land value} field h98 type long {prc impr value} field h99 type long {prc totl value} field h80 type long {land value - used for abatement2 9-9-98} field h81 type long {impr value - used for abatement3 9-9-98} field h86 type long {totl value - used for abatement4 9-9-98} field h58 type long {mod4 land value} field h85 type long {mod4 impr value} field h76 type long {mod4 totl value} field i30 type char 1 {partial asmt} field l74 type char 8 {special tax dist codes} field l31 type char 35 {building desc/lot desc} field l32 type char 20 {additional lots} field l3s type integer {seniors new 6-23-98 bkr} field l3v type integer {deductions: new 6-23-98 bkr} field l3w type integer {deductions: new 6-23-98 bkr} field l3r type integer {deductions: new 6-23-98 bkr} field l3d type integer {deductions: new 6-23-98 bkr} field l33 type char 1 {sale code} field l34 type char 51 {exemption Class 15: 02040608t02345} field l35 type char 1 {exemption1 code - not used 11-21-10 bkr} field l36 type long {exemption1 value} field l42a type char 2 {neigh type} field l42b type char 2 {road 1} field l42c type char 2 {road 2} field l42d type char 1 {curbs} field l42e type char 1 {sidewalk} field l42f type char 1 {util 1} field l42g type char 1 {util 2} field l42h type char 1 {util 3} field l42i type char 1 {util 4} field l42j type char 1 {information} field i27 type char 4 {neighborhood} field l80 type char 4 {vcs-land formula -- new 11-20-90 bkr} field l44 type char 198 {land pricing info/mortgage acct#} field l77 type char 24 {land cond %'s and (4) codes - last 4 not used} field l81 type char 1 {auto land calc -- new 12-1-90 bkr} field i26 type char 5 {zone - zoning in m4 is 4 char 2-22-19 bkr} field i47 type float {size in acres} field i50 type long {size in sqft -- new 11-20-90 bkr} field l78 type float {last year total taxes - mod fr double 3-11-93} field l79 type float {curr year total taxes - mod fr double 3-11-93} field l82 type float {last year municipal - mod fr double 3-11-93} field l83 type float {curr year municipal - mod fr double 3-11-93} field i59 type integer {used for mod4 upd} field s02 type char 676 {sketch} field h84 type integer {num months aa} field h93 type integer {update code} field i53 type char 1 {fake join & print code} field l18 type char 2 {special loc new 3-6-89 bkr} field l19 type char 2 {special phys new 3-6-89 bkr} field l20 type char 2 {add/deduct 1} field l21 type int {add/deduct 1 year} field l22 type char 2 {add/deduct 2} field l23 type int {add/deduct 2 year} field l24 type char 2 {add/deduct 3} field l25 type int {add/deduct 3 year} field l26 type char 2 {add/deduct 4} field l27 type int {add/deduct 4 year} field l28 type float {base year taxes} {ield l29 type int add locational dep -deleted 9-28-94 bkr} field l45 type char 2 {condition} field l46 type float {physical depr } field l47 type float {functional depr } field l48 type float {locational depr ch to float 12-2-90} field l49 type char 4 {quality} field l50 type char 4 {year built} field l51 type char 2 {type/use / units} field l52 type char 3 {story ht} field h72 type char 2 {style table lookup} field l53 type char 4 {ext fin} field l54 type char 3 {brick story - 2,3 is ep/op quality} field l55 type char 3 {stone story - 2,3 is HM for qualifier} field l56 type char 6 {foundation} field l57 type char 7 {basement fin h} field l58 type char 6 {living basement fin h} field l59 type char 23 {heating/air cond-mod from 14 11-19-90 bkr} field l60 type char 4 {plumbing} field l61 type char 6 {built-ins} field l62 type char 4 {int fin} field l63 type char 2 {unfin %} field h13 type char 4 {part brick sf} field h14 type char 4 {part stone sf} field h27 type char 2 {4 fixt. bath} field h28 type char 2 {3 fixt. bath(1)} field h29 type char 2 {2 fixt. bath} field h33 type char 2 {single fixture} field h60 type char 1 {auto depreciate 11-6-90 bkr} field i69 type char 1 {auto eff age y/n} field h52 type long {misc 1added value new 11-19-90 bkr} field h53 type long {misc 2added value new 11-19-90 bkr} field h55 type char 15 {misc 1added desc new 11-19-90 bkr} field h56 type char 15 {misc 2added desc new 11-19-90 bkr} field i97 type long {land hold used for tenant rebate } field i98 type long {impr hold new 11-19-90 bkr} field h61 type long {flat add 1 val 11-6-90 bkr} field h62 type long {flat add 2 val 11-6-90 bkr} field h63 type long {addl bldg val 11-6-90 bkr} field h66 type char 40 {flat add 1 desc 11-6-90 bkr} field h67 type char 40 {flat add 2 desc 11-6-90 bkr} field l64 type char 14 {fireplace(s)} field l65 type char 4 {dormer lf/fin?-!should make fin/unfin lf!} field l66 type char 4 {att/.5sty q} field l67 type char 4 {unfin .5sty% is dormer/patio quality} field l68 type char 8 {floor fin} field s38 type integer {tot livable sf sqft} field l69 type char 88 {room count} field l70 type char 2 {ext kit total} field l71 type char 2 {bed room total} field l72 type char 2 {total rooms} field l73 type char 148 {detached bldgs} field h91 type char 8 {operators initials} field h82 type date {date entered or updated} index dups field l75a type char 2 {notes-visits total 60 [ 1, 2 ])} field l75b type char 8 {notes-collected [ 3, 10 ]} field l75c type char 2 {notes-collector [ 11, 12 ]} field l75d type char 1 {notes-not used [ 13, 13 ]} field l75e type char 2 {notes-mother/daugter [ 14, 15 ]} field l75f type char 2 {notes-condo/townhse [ 16, 17 ]} field l75g type char 2 {notes-multi familiy [ 18, 19 ]} field l75h type char 8 {notes-collected [ 20, 27 ]} field l75i type char 2 {notes-sump pump [ 28, 29 ]} field l75j type char 1 {notes-not used [ 30, 30 ]} field l75k type char 1 {notes-number units [ 31, 31 ]} field l75l type char 1 {notes-row/end [ 32, 32 ]} field l75o type char 1 {notes-not-used [ 33 33 ]} field l75p type char 2 {condition3-layout [ 34 35 ]} field l75q type char 4 {notes-not-used [ 36 39 ]} field l75n type char 21 {notes-notes [ 40, 60 ]} field l76 type char 30 {was free field for future use} field l84 type integer {number of owners - 6-23-98 bkr} field l85 type integer {m4 sf area sqft - 6-23-98 bkr} field l86 type long {deduction amount - 6-23-98 bkr} end