{modified fields for deductions 6-23-98 bkr} {deleted l29 and made l28 float 9-28-94 bkr} {restricted over-ride added 2-3-93 bkr} database prc 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 {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 - 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 {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 {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 {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 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} 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 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 {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 / 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 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 {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} 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 l75 type char 60 {notes} { l75[1,2], frminp0:visits l75[1,2], frminp3:insp by l75[1,32], frminp5:remarks l75[1,4], frminp7:effective year l75[1,9], frmmod4n:ssn1 l75[3,10], frminp0:collected l75[5,6], frminp7:write in l75[11,12], frminp0:collector l75[11,12], frminp7:number of units l75[13,14], frminp1:location l75[13,15], frminp7:model l75[13,16], frminp3:effective year l75[13,35], frminp4:notes l75[13,35], frminp6:notes l75[14,15], frminp2:mother/daughter l75[15,37], frminp1:notes l75[16,17], frminp2:condo/townhouse l75[16,19], frminp7:pev-zone* l75[17,18], frminp3:att garage l75[18,19], frminp2:multi-fam l75[19,19], frminp3:att garage-cars l75[19,21], frmmod4n:sp tax #3 l75[20,27], frminp0:collected l75[22,24], frmmod4n:sp tax #4 l75[25,29], frmmod4n:census tract l75[28,29], frminp2:notes l75[28,29], frminp3:built-in l75[30,31], frminp3:built-in l75[30,33], frmmod4n:census block l75[31,31], frminp2:number of units l75[32,32], frminp2:row/end l75[32,33], frminp3:built-in l75[33,37], frminp5: l75[34,35], frminp3:net condition, layout condition l75[36,50], frminp0:notes: char 25 l75[36,55], frmmod4n:addl lots2 & reason l75[36,60], frminp3:notes: char 25 l75[38,38], frminp5:Y = Calculate FF & Avg Depth "; l75[38,60], frminp1:notes l75[39,42], frminp5: l75[43,46], frminp5: l75[47,50], frminp5: l75[56,57], frmmod4n:exempt3 code l75[58,59], frmmod4n:exempt4 code } field l76 type char 30 {was free field for future use} {[1,2] heating quality (fields created for realty) [3,4] ac quality [5,6] 5 fixt baths [7,8] wood stove [9,10] dormer - single -also used for fin lf dormer [11,12] dormer - small -also used for unfin lf dormer [13,14] dormer - large [15,16] over impr % *** this was a waste 3 char not needed *** [17,18] under impr % [19,20] economic % [21,22] eff age new 4-11-91 [23,26] attic fin % or sf new 4-25-91 [27,28] functional % [29,30] age instead of year built - 6-3-91 } 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