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