{added l30 8-7-13 gdl} {added l77 11-9-10 gdl} {database with l75 & l76 split 6-1-94 gdl} database prc756 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 l30a type char 5 {bank code} field l30b type char 8 {acct#} field l30c type char 4 {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 {sale ratio} field h97 type long {land value} field h98 type long {impr value} field h99 type long {totl value} field h80 type long {land value} field h81 type long {impr value} field h86 type long {totl value} field h58 type long {land value} field h85 type long {impr value} field h76 type long {totl value} field i30 type char 1 {partial asmt} field l74 type char 8 {user field #1} 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 {deductions: 02040608t02345} field l34 type char 51 {exemption Class 15: 02040608t02345} field l35 type char 1 {exemption1 code} field l36 type long {exemption1 value} field l42 type char 13 {neigh, road, curbs} 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} field l77a type char 3 {land cond %1} field l77b type char 3 {land cond %2} field l77c type char 3 {land cond %3} field l77d type char 3 {land cond %4} field l77e type char 2 {land cond reason 1} field l77f type char 2 {land cond reason 2} field l77g type char 2 {land cond reason 3} field l77h type char 2 {land cond reason 4} field l77i type char 4 {not used - used for abatement yr & mo} field l81 type char 1 {auto land calc -- new 12-1-90 bkr} field i26 type char 5 {zone} field i47 type float {size in acres} field i50 type long {size in sq ft -- 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 s2a1 type char 14 field s2a2 type char 52 field s2b1 type char 14 field s2b2 type char 40 field s2c1 type char 14 field s2c2 type char 40 field s2d1 type char 14 field s2d2 type char 40 field s2e1 type char 14 field s2e2 type char 40 field s2f1 type char 14 field s2f2 type char 40 field s2g1 type char 14 field s2g2 type char 40 field s2h1 type char 14 field s2h2 type char 40 field s2i1 type char 14 field s2i2 type char 15 field s2j1 type char 14 field s2j2 type char 15 field s2k1 type char 14 field s2k2 type char 15 field s2l1 type char 14 field s2l2 type char 15 field s2m1 type char 14 field s2m2 type char 15 field s2n1 type char 14 field s2n2 type char 15 field s2o1 type char 14 field s2o2 type char 15 field s2p1 type char 14 field s2p2 type char 15 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 {add functional dep -not used -restr or 2-3-93} {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} 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 char not used} field l55 type char 3 {stone story - 2,3 char not used} 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 l61a type char 2 {built-ins} field l61b type char 2 {built-ins} field l61c type char 1 {built-ins} field l61d type char 1 {realty's number of units} 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 new 11-19-90 bkr} 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 {flat add 3 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} 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] (wayne)} 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 l75m type char 7 {notes-not used [33,39]} field l75n type char 21 {notes-notes [40,60]} field l76a type char 2 {[1,2] heating quality} field l76b type char 2 {[3,4] ac quality} field l76c type char 2 {[5,6] 5 fixt baths} field l76d type char 2 {[7,8] wood stove} field l76e type char 2 {[9,10] dormer - single or fin dormer} field l76f type char 2 {[11,12] dormer - small or unfin dormer} field l76g type char 2 {[13,14] dormer - large} field l76h type char 2 {[15,16] mkt+ % or over impr %} field l76i type char 2 {[17,18] mkt- % or under impr %} field l76j type char 2 {[19,20] economic %} field l76k type char 2 {[21,22] eff age} field l76l type char 4 {[23,26] attic fin % or sf} field l76m type char 2 {[27,28] functional %} field l76n type char 2 {[29,30] age in years} field l84 type integer {number of owners - 6-23-98 bkr} field l85 type integer {m4 sf area - 6-23-98 bkr} field l86 type long {deduction amount - 6-23-98 bkr} end