{*** PRC-NJ Version 5.0 File Layout ***} {*** MicroSystems-nj.com, L.L.C -- 908-704-8862 ***} {*** Notes on New Features ***} {add field for street number & street name for owner index rpt 9-19-99 bkr} {*** Notes on Changes ***} {used parts of l44 for tenant rebate base yr, flag, bath quality 9-27-94 bkr} {changed use of l28 for tenant rebate 9-27-94 bkr} {use operator initials for zip+4 5-20-93 bkr} {changes to defnprc 2-28-93 -- h91 l82 l28 l29} {mod use 4th loc dep in det bldgs as restricted yr over-ride} {this file used to access fields separately that are merged as one} {copied from defnprc2 1-22-93 and separated all! fields} {*** Notes on Codes Used in this File ***} { char = alpha-numeric data } { float = numeric only with decimal} { long = numeric only no decimal } database prc5 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} index dups field i01 type char 10 {old lot} index dups 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} index dups 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 l30b type char 5 {billing code/acct#/map page 17} field l30a type char 8 {billing code/acct#/map page} field l30m type char 4 {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} 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 l74a type char 3 {user field #1-used as sp taxes 3 char} field l74b type char 3 {user field #2-used as sp taxes 3 char} field l74c type char 2 {user field #2-used as sp taxes 3 char} field l31b type char 15 {building desc} field l31l type char 20 {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 l34a type char 2 {exempt owner} field l34b type char 2 {exempt use} field l34c type char 3 {exempt desc} field l34d type char 6 {exempt init file} field l34e type char 6 {exempt further file} field l34f type char 12 {exempt statute} field l34g type char 20 {exempt facility} field l35 type char 1 {exemption1 code - not used} 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 l44l type char 1 {land class & site=all(realty) - total 198} field l441o type char 2 {1 front - use for bath quality 9-27-94 bkr} field l441p type char 2 {1 rear - use for tenant rebate year 9-27-94 } field l441q type char 2 {1 rear - use for tenant rebate flag 9-27-94 } field l441s type char 3 {1 setback} field l441t type char 1 {1 type/triangle} field l441f type char 3 {1 front feet} field l441a type char 3 {1 avg depth} field l441r type char 4 {1 rate} field l441n type char 4 {1 adj net % -- not used 1 char} field l441c type char 2 {1 adj reason code} field l442o type char 2 {2 front - use for depr table 12-10-96 bkr} field l442p type char 2 {2 abatement 1 years 10-24-96 bkr} field l442q type char 2 {2 rest ovr-ride not used 9-23-09 bkr} field l442s type char 3 {2 setback} field l442t type char 1 {2 type/triangle} field l442f type char 3 {2 front feet} field l442a type char 3 {2 avg depth} field l442r type char 4 {2 rate} field l442n type char 4 {2 adj net % -- 4th digit not used} field l442c type char 2 {[52,53] 2 adj reason code} field l443o type char 3 {[54,56] 3 front - bath quality not used 1 ch} field l443p type char 3 {[57,59] 3 rear - not used, site adj% 10-3-04} field l443s type char 3 {[60,62] 3 setback} field l443t type char 1 {[63,63] 3 type/triangle} field l443f type char 3 {[64,66] 3 front feet} field l443a type char 3 {[67,69] 3 avg depth} field l443r type char 4 {[70,73] 3 rate} field l443n type char 4 {[74,76] 3 adj net % -- 4th digit not used} field l443c type char 2 {[78,79] 3 adj reason code 78,79} field l44ma type char 10 {mortgage acct number 80,89} field l44f1 type char 8 {farmland 1 90,97} field l44f2 type char 8 {farmland 2 98,105} field l44u1q type char 10 {unit 1 quantity 106,115} field l44u1r type char 7 {unit 1 rate} field l44u1n type char 4 {unit 1 net cond -- 4th digit not used} field l44u1c type char 2 {unit 1 reason code} field l44u2q type char 10 {unit 2 quantity} field l44u2r type char 7 {unit 2 rate} field l44u2n type char 4 {unit 2 net cond -- 4th digit not used} field l44u2c type char 2 {unit 2 reason code} field l44u3q type char 10 {unit 3 quantity} field l44u3r type char 7 {unit 3 rate} field l44u3n type char 4 {unit 3 net cond -- 4th digit not used} field l44u3c type char 2 {unit 3 reason code 173,174} field l44mb type char 2 {modern baths 175,176} field l44ab type char 2 {avg baths 177,178} field l44ob type char 2 {old baths 179,180} field l44mk type char 2 {modern kitchen 181,182} field l44ak type char 2 {avg kitchen 183,184} field l44ok type char 2 {old kitchen 185,186} field l44sv type char 8 {site value 187,194} field l44af type char 2 {attic heated 195,196} field l44oi type char 2 {over improved 197,198} 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 abate yr/mo,dwell units} 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 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 {tenant reb amt 9-27-94} 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 l54a type char 1 {brick story} field l54q type char 2 {ep/op porch quality 8-22-93} field l55 type char 1 {stone story } field l55hm type char 2 {hm/HM qualifier 5-20-93} field l56t type char 2 {roof type} field l56m type char 2 {roof material} field l56f type char 2 {foundation} field l57s type char 4 {basement fin sf 7} field l57q type char 2 {[5,6] basement fin quality} field l57h type char 1 {basement fin heated} field l58s type char 4 {living basement fin sf} field l58q type char 2 {[5,6] living basement fin quality} field l59a type char 2 {heating sys type} field l59b type char 5 {heating sys % or sf} field l59c type char 2 {heating sys type} field l59d type char 5 {heating sys % or sf} field l59e type char 2 {heating source} field l59f type char 2 {air cond type} field l59g type char 5 {air cond % or sf} field l60a type char 2 {plumbing code 1} field l60b type char 2 {plumbing code 2} field l61a type char 2 {built-ins} field l61b type char 2 {built-ins} field l61c type char 2 {built-ins} field l62a type char 1 {int fin 1} field l62b type char 1 {int fin 2} field l62c type char 1 {int fin 3} field l62d type char 1 {int fin elec} field l63 type char 2 {unfin %- not used/ used as 4th built-in} 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 l64a type char 2 {fireplace(s) 14 1sty} field l64b type char 2 {fireplace(s) 14 1.5sty} field l64c type char 2 {fireplace(s) 14 2sty} field l64d type char 2 {fireplace(s) 14 same stk} field l64e type char 2 {fireplace(s) 14 free stand} field l64f type char 2 {fireplace(s) 14 heatilator} field l64g type char 2 {[13,14] fireplace(s) 14 quality} field l65a type char 2 {dormer lf / finished? } field l65b type char 2 {dormer finished y/n/s & 3rd plumbing} field l66h type char 2 {[1,2] attic quality} field l66a type char 2 {[3,4] half story quality} field l67d type char 2 {[1,2] dormer quality} field l67p type char 2 {[3,4] patio quality} field l68a type char 2 {floor fin 1} field l68b type char 2 {floor fin 2} field l68c type char 2 {[5,6] floor fin 3 - deck quality 12-22-93} field l68d type char 2 {[7,8] att garage quality} field s38 type integer {tot livable} field l69l1 type char 2 {room count 88 living room (not used by all)} field l69l2 type char 2 {room count 88 living room} field l69l3 type char 2 {room count 88 living room} field l69l4 type char 2 {room count 88 living room} field l69d1 type char 2 {room count 88 din room} field l69d2 type char 2 {room count 88 din room} field l69d3 type char 2 {room count 88 din room} field l69d4 type char 2 {room count 88 din room} field l69k1 type char 2 {room count 88 kitchen} field l69k2 type char 2 {room count 88 kitchen} field l69k3 type char 2 {room count 88 kitchen} field l69k4 type char 2 {room count 88 kitchen} field l69e1 type char 2 {room count 88 extra kitchen} field l69e2 type char 2 {room count 88 extra kitchen} field l69e3 type char 2 {room count 88 extra kitchen} field l69e4 type char 2 {room count 88 extra kitchen} field l6941 type char 2 {room count 88 4 fix bath} field l6942 type char 2 {room count 88 4 fix bath} field l6943 type char 2 {room count 88 4 fix bath} field l6944 type char 2 {room count 88 4 fix bath} field l6931 type char 2 {room count 88 3 fix bath} field l6932 type char 2 {room count 88 3 fix bath} field l6933 type char 2 {room count 88 3 fix bath} field l6934 type char 2 {room count 88 3 fix bath} field l6921 type char 2 {room count 88 2 fix bath} field l6922 type char 2 {room count 88 2 fix bath} field l6923 type char 2 {room count 88 2 fix bath} field l6924 type char 2 {room count 88 2 fix bath} field l6911 type char 2 {room count 88 1 fix } field l6912 type char 2 {room count 88 1 fix } field l6913 type char 2 {room count 88 1 fix } field l6914 type char 2 {room count 88 1 fix } field l69b1 type char 2 {room count 88 bed room} field l69b2 type char 2 {room count 88 bed room} field l69b3 type char 2 {room count 88 bed room} field l69b4 type char 2 {room count 88 bed room} field l69r1 type char 2 {room count 88 rec room} field l69r2 type char 2 {room count 88 rec room} field l69r3 type char 2 {room count 88 rec room} field l69r4 type char 2 {room count 88 rec room} field l69o1 type char 2 {room count 88 den} field l69o2 type char 2 {room count 88 den} field l69o3 type char 2 {room count 88 den} field l69o4 type char 2 {room count 88 den} field l70 type char 2 {ext kit total} field l71 type char 2 {bed room total} field l72 type char 2 {total rooms} field l73a1 type char 10 {detached building 1 (6 char not used)} field l73a2 type char 2 {yr blt (except by pev )} field l73a3 type char 2 {eff yr} field l73a4 type char 4 {width} field l73a5 type char 4 {depth} field l73a6 type char 2 {ht} field l73a7 type char 5 {area} field l73a8 type char 2 {class-qf} field l73a9 type char 2 {pysical} field l73aa type char 2 {functional} field l73ab type char 2 {location/economic} field l73b1 type char 10 {detached building 2} field l73b2 type char 2 field l73b3 type char 2 field l73b4 type char 4 field l73b5 type char 4 field l73b6 type char 2 field l73b7 type char 5 field l73b8 type char 2 field l73b9 type char 2 field l73ba type char 2 field l73bb type char 2 field l73c1 type char 10 {detached building 3} field l73c2 type char 2 field l73c3 type char 2 field l73c4 type char 4 field l73c5 type char 4 field l73c6 type char 2 field l73c7 type char 5 field l73c8 type char 2 field l73c9 type char 2 field l73ca type char 2 field l73cb type char 2 field l73d1 type char 10 {detached building 4 (6 char not used)} field l73d2 type char 2 {yr} field l73d3 type char 2 {effy} field l73d4 type char 4 {width} field l73d5 type char 4 {depth} field l73d6 type char 2 {ht} field l73d7 type char 5 {area} field l73d8 type char 2 {qf} field l73d9 type char 2 {netp} field l73da type char 2 {netf not used often } field l73db type char 2 {netl not used often } field h91 type char 4 {operators initials 3-20-93 bkr} field h91z type char 4 {zip+4} field h82 type date {date entered or updated} index dups {******* frminp7 *******} { l75[ 1, 4] visits - effective year} { l75[ 5, 6] was built-in garage - now is write in} { l75[11,12] number of units} { l75[13,15] model} { l75[16,19] zone} { l75[36,60] notes} { l75[15,18] kitchen remodel year} { l75[51,51] kitchen counters code} { l75[52,52] kitchen cabinets code} { l75[53,53] floors code} {******* realty *******} {l75[ 1,35] notes} {l75[15,37] notes (realty)} {l75[36,60] char 25 - change reason} {l75[38,60] notes (realty)} {******* wayne *******} {frminp2: 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 l75m type char 7 !notes-not used [33,39]! field l75n type char 21 !notes-notes [40,60]! } {frminp7} field l75y type char 4 {eff yr} field l75w type char 2 {write in} field l75f type char 4 {not used} field l75u type char 2 {units} field l75m type char 3 {model} field l75z type char 4 {zone/depth table} field l75g type char 16 {not used 2} field l75n type char 20 {notes} field l75c type char 2 {abatement 3 - new 9-23-05 bkr} field l75d type char 2 {abatement 4 - new 9-23-05 bkr} field l75e type char 1 {na - new 9-23-05 bkr} { frminp0:m75 = l75, upshift!rev@; frminp1:z4 = l75[1,2], upshift; !visits@ frminp1:z5 = l75[3,10], upshift; !collected@ frminp1:z6 = l75[11,12], upshift; !collector@ frminp1:lo = l75[13,14], upshift, !location@ frminp1:not1= l75[15,37], upshift; !notes@ frminp1:not2= l75[38,60], upshift; !notes@ frminp2:z4 = l75[1,2], upshift; !visits@ frminp2:z5 = l75[3,10], upshift; !collected@ frminp2:z6 = l75[11,12], upshift; !collector@ 13,13 - not used frminp2:md = l75[14,15], upshift, !mother/daughter new 4-24-91@ frminp2:ct = l75[16,17], upshift, !condo/townhouse new 4-24-91@ frminp2:mf = l75[18,19], upshift, !multi-fam new 4-24-91@ frminp2:z7 = l75[20,27], upshift; !collected@ frminp2:sp = l75[28,29], upshift, !notes@ 30,30 - not used frminp2:e = l75[31,31], upshift, !2 type/use -- number of units@ frminp2:f = l75[32,32], upshift, upshift, !2 type/use -- row/end@ 33,39 - not used frminp2:not1= l75[40,60], upshift; !notes@ frminp3:z3 = l75[1,4], !effective year@ frminp3:z5 = l75[5,10], upshift; !insp date was 3,10@ frminp3:z6 = l75[11,12], upshift; !collector@ 13,16 - not used frminp3:z4 = l75[17,18], upshift; !insp by - was 1,2@ 19,19 - not used frminp3:z7 = l75[20,27], upshift; !collected@ frminp3:f75 = l75[28,60], upshift; frminp4:z4 = l75[1,2], upshift,reverse; !visits@ frminp4:z5 = l75[3,10], upshift,reverse; !collected@ frminp4:z6 = l75[11,12], upshift,reverse; !collector@ frminp4:not2= l75[13,35], upshift,reverse; !notes@ frminp4:note= l75[36,60], upshift,reverse; !notes: char 25@ frminp5:m75= l75[1,32], upshift,reverse; frminp5:m75a= l75[33,37], upshift,reverse; frminp5:a= l75[38,38], upshift,reverse, frminp5:m75b= l75[39,42], upshift,reverse; frminp5:m75c= l75[43,46], upshift,reverse; frminp5:m75d= l75[47,50], upshift,reverse; 51,60 - not used frminp6:z4 = l75[1,2], upshift,reverse; !visits@ frminp6:z5 = l75[3,10], upshift,reverse; !collected@ frminp6:z6 = l75[11,12], upshift,reverse; !collector@ frminp6:not2= l75[13,35], upshift,reverse; !notes@ frminp6:note= l75[36,60], upshift,reverse; !notes: char 25@ (same as inp4) frminp7:z4 = l75[1,4], upshift; !visits - effective year@ frminp7:z5 = l75[5,6], upshift; !built-in garage y/n@ frminp7:z6 = l75[7,8], upshift; !built-in porch y/n@ frminp7:z7 = l75[9,10], upshift; !plumbing y/n@ frminp7:e = l75[11,12], upshift, !number of units@ 13,35 - not used frminp7:note= l75[36,60], upshift!rev@; !notes: char 25@ history.h: strncpy(stradded.t31 , strprc.l75+35, 15); /* note reason-new 5-21-92 */ } {******* frmmod4n *******} { l75[ 1, 9] ssn1 } { l75[10,18] ssn2 } { l75[19,21] sp tax #3 } { l75[22,24] sp tax #4 } { l75[25,29] census tract } { l75[30,33] census block } { l75[34,35] percent owned } { l75[36,55] addl lots2 & reason} { l75[56,57] exempt3 code } { l75[58,59] exempt4 code } {********* frminp0 *********} { l75[ 1, 2] visits} { l75[ 3,10] collected} { l75[11,12] collector} {s l75[20,27] collected} { l75[36,50] notes: char 25} {********* frminp1 *********} { l75[ 1, 2] visits} { l75[ 3,10] collected} { l75[11,12] collector} { l75[13,14] location} { l75[25,35] notes} { l75[36,55] notes} {********* frminp2 *********} { l75[ 1, 2] visits} { l75[ 3,10] collected} { l75[11,12] collector} { l75[14,15] mother/daughter} { l75[16,17] condo/townhouse} {s l75[18,19] multi-fam} { l75[31,31] 2 type/use -- number of units} { l75[32,32] 2 type/use -- row/end} { l75[20,27] collected} { l75[28,29] notes} {********* frminp3 *********} { l75[ 1, 2] insp by} { l75[ 3,10] insp date} { l75[11,12] collector} { l75[13,16] effective year} { l75[17,18] att garage - cars} {s l75[19,19] att garage - cars} {s l75[20,27] collected} { l75[28,29] built-in} { l75[30,31] built-in} { l75[32,33] built-in} { l75[36,60] } { l75[34,35] net condition, layout condition} {********* frminp4 *********} { l75[ 1, 2] visits} { l75[ 3,10] collected} { l75[11,12] collector} {s l75[13,35] notes} { l75[36,60] notes} {********* frminp5 *********} {s l75[ 1,32] } { l75[33,37] } { l75[38,38] } { l75[39,42] } { l75[43,46] } { l75[47,50] } {********* frminp6 *********} { l75[ 1, 2] visits} { l75[ 3,10] collected} { l75[11,12] collector} {s l75[13,35] notes} { l75[36,60] notes: } {********* frminp7 *********} { l75[ 1, 4] visits - effective year} { l75[ 5, 6] was built-in garage - now is write in} { l75[11,12] number of units} { l75[13,15] model} {s l75[16,19] zone} { l75[36,60] notes} 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 { abatement information Land:[ae07 ] [f027 ] (57):[e78 ] 1 [ay][f031 ] Impr:[ae08 ] [f028 ] [tax2] 2 [cm][e80 ] [an][ae031 ] [d028 ] (58):[e79 ] 3 [em][e81 ] NetCalc Net: [ae09 ] [f029 ] Partial: [m] 4 [gm][e86 ][d029 ] field l442p type char 2 !2 rear - use for abatement years 10-24-96 bkr! field l74c type char 2 !user field #2-used as sp taxes 3 char! field l75c type char 2 !abatement 3 - new 9-23-05 bkr! field l75d type char 2 !abatement 4 - new 9-23-05 bkr! ay = l44[30,31], !exemption1 - new 10-24-96 bkr! cm = l74[7,8], upshift,reverse, !exempt2 code - 6-23-98 bkr! em = l75[56,57], upshift,reverse, !exempt3 code - 6-23-98 bkr! gm = l75[58,59], upshift,reverse, !exempt4 code - 6-23-98 bkr! f031= l36, right,reverse,! long mod4 exemption1! e80 = h80, right,reverse, !old tax list land value 5-1-90 bkr! e81 = h81, right,reverse, !old tax list impr value 5-1-90 bkr! e86 = h86, right,reverse, !old tax list totl value 5-1-90 bkr! } {use these to load into excel sid serial h00 char 10 new block h01 char 10 new lot h02 char 5 new qual h03 char 1 new bldg i00 char 10 old block i01 char 10 old lot i02 char 5 old qual l02 char 24 new b/lot/q/b sort format l03 char 23 old b/lot/q sort format i24 char 3 class h77 char 25 street i18 char 35 owner name i19 char 25 owner street i20 char 30 owner csz l30b char 5 billing code l30a char 8 acct# l30m char 4 map page i72 date sale date i73 char 5 sale book i74 char 5 sale page i75 long sale val i88 char 2 sale nu i89 char 3 sale ratio h97 long land value h98 long impr value h99 long totl value h80 long land value h81 long impr value h86 long totl value h58 long land value h85 long impr value h76 long totl value i30 char 1 partial asmt l74a char 3 user field #1-used as sp taxes 3 char l74b char 3 user field #2-used as sp taxes 3 char l74c char 2 user field #2-used as sp taxes 3 char l31b char 15 building desc l31l char 20 lot desc l32 char 20 additional lots l3s integer seniors new 6-23-98 bkr l3v integer deductions: new 6-23-98 bkr l3w integer deductions: new 6-23-98 bkr l3r integer deductions: new 6-23-98 bkr l3d integer deductions: new 6-23-98 bkr l33 char 1 deductions: 02040608t02345 l34a char 2 exempt owner l34b char 2 exempt use l34c char 3 exempt desc l34d char 6 exempt init file l34e char 6 exempt further file l34f char 12 exempt statute l34g char 20 exempt facility l35 char 1 exemption1 code - not used l36 long exemption1 value l42a char 2 neigh type l42b char 2 road 1 l42c char 2 road 2 l42d char 1 curbs l42e char 1 sidewalk l42f char 1 util 1 l42g char 1 util 2 l42h char 1 util 3 l42i char 1 util 4 l42j char 1 information i27 char 4 neighborhood l80 char 4 vcs-land formula -- new 11-20-90 bkr l44l char 1 land class & site=all(realty) - total 198 l441o char 2 1 front - use for bath quality 9-27-94 bkr l441p char 2 1 rear - use for tenant rebate year 9-27-94 l441q char 2 1 rear - use for tenant rebate flag 9-27-94 l441s char 3 1 setback l441t char 1 1 type/triangle l441f char 3 1 front feet l441a char 3 1 avg depth l441r char 4 1 rate l441n char 4 1 adj net % -- not used 1 char l441c char 2 1 adj reason code l442o char 2 2 front - use for depr table 12-10-96 bkr l442p char 2 2 rear - use for abatement years 10-24-96 bkr l442q char 2 2 rear - use for rest ovr-ride 12-10-96 bkr l442s char 3 2 setback l442t char 1 2 type/triangle l442f char 3 2 front feet l442a char 3 2 avg depth l442r char 4 2 rate l442n char 4 2 adj net % -- not used 1 char l442c char 2 [52,53] 2 adj reason code l443o char 3 [54,56] 3 front - bath quality not used 1 ch l443p char 3 [57,59] 3 rear - not used, site adj% 10-3-04 l443s char 3 [60,62] 3 setback l443t char 1 [63,63] 3 type/triangle l443f char 3 [64,66] 3 front feet l443a char 3 [67,69] 3 avg depth l443r char 4 [70,73] 3 rate l443n char 4 [74,76] 3 adj net % (4th digit not used) l443c char 2 [78,79] 3 adj reason code 78,79 l44ma char 10 mortgage acct number 80,89 l44f1 char 8 farmland 1 90,97 l44f2 char 8 farmland 2 98,105 l44u1q char 10 unit 1 quantity 106,115 l44u1r char 7 unit 1 rate l44u1n char 4 unit 1 net cond -- not used 1 char l44u1c char 2 unit 1 reason code l44u2q char 10 unit 2 quantity l44u2r char 7 unit 2 rate l44u2n char 4 unit 2 net cond -- not used 1 char l44u2c char 2 unit 2 reason code l44u3q char 10 unit 3 quantity l44u3r char 7 unit 3 rate l44u3n char 4 unit 3 net cond (4th digit not used) l44u3c char 2 unit 3 reason code 173,174 l44mb char 2 modern baths 175,176 l44ab char 2 avg baths 177,178 l44ob char 2 old baths 179,180 l44mk char 2 modern kitchen 181,182 l44ak char 2 avg kitchen 183,184 l44ok char 2 old kitchen 185,186 l44sv char 8 site value 187,194 l44af char 2 attic heated 195,196 l44oi char 2 over improved 197,198 l77a char 3 land cond %1 l77b char 3 land cond %2 l77c char 3 land cond %3 l77d char 3 land cond %4 l77e char 2 land cond reason 1 l77f char 2 land cond reason 2 l77g char 2 land cond reason 3 l77h char 2 land cond reason 4 l77i char 4 not used - used for abatement yr & mo l81 char 1 auto land calc -- new 12-1-90 bkr i26 char 5 zone i47 float size in acres i50 long size in sq ft -- new 11-20-90 bkr l78 float last year total taxes - mod fr double 3-11-93 l79 float curr year total taxes - mod fr double 3-11-93 l82 float last year municipal - mod fr double 3-11-93 l83 float curr year municipal - mod fr double 3-11-93 i59 integer used for mod4 upd s2a1 char 14 s2a2 char 52 s2b1 char 14 s2b2 char 40 s2c1 char 14 s2c2 char 40 s2d1 char 14 s2d2 char 40 s2e1 char 14 s2e2 char 40 s2f1 char 14 s2f2 char 40 s2g1 char 14 s2g2 char 40 s2h1 char 14 s2h2 char 40 s2i1 char 14 s2i2 char 15 s2j1 char 14 s2j2 char 15 s2k1 char 14 s2k2 char 15 s2l1 char 14 s2l2 char 15 s2m1 char 14 s2m2 char 15 s2n1 char 14 s2n2 char 15 s2o1 char 14 s2o2 char 15 s2p1 char 14 s2p2 char 15 h84 integer num months aa h93 integer update code i53 char 1 fake join & print code l18 char 2 special loc new 3-6-89 bkr l19 char 2 special phys new 3-6-89 bkr l20 char 2 add/deduct 1 l21 int add/deduct 1 year l22 char 2 add/deduct 2 l23 int add/deduct 2 year l24 char 2 add/deduct 3 l25 int add/deduct 3 year l26 char 2 add/deduct 4 l27 int add/deduct 4 year l28 float tenant reb amt 9-27-94 l45 char 2 condition l46 float physical depr l47 float functional depr l48 float locational depr ch to float 12-2-90 l49 char 4 quality l50 char 4 year built l51 char 2 type/use l52 char 3 story ht h72 char 2 style table lookup l53 char 4 ext fin l54a char 1 brick story l54q char 2 ep/op porch quality 8-22-93 l55 char 1 stone story l55hm char 2 hm/HM qualifier 5-20-93 l56t char 2 roof type l56m char 2 roof material l56f char 2 foundation l57s char 4 basement fin sf 7 l57q char 2 [5,6] basement fin quality l57h char 1 basement fin heated l58s char 4 living basement fin sf l58q char 2 [5,6] living basement fin quality l59a char 2 heating sys type l59b char 5 heating sys % or sf l59c char 2 heating sys type l59d char 5 heating sys % or sf l59e char 2 heating source l59f char 2 air cond type l59g char 5 air cond % or sf l60a char 2 plumbing code 1 l60b char 2 plumbing code 2 l61a char 2 built-ins l61b char 2 built-ins l61c char 2 built-ins l62a char 1 int fin 1 l62b char 1 int fin 2 l62c char 1 int fin 3 l62d char 1 int fin elec l63 char 2 unfin %- not used/ used as 4th built-in h13 char 4 part brick sf h14 char 4 part stone sf h27 char 2 4 fixt. bath h28 char 2 3 fixt. bath(1) h29 char 2 2 fixt. bath h33 char 2 single fixture h60 char 1 auto depreciate 11-6-90 bkr i69 char 1 auto eff age y/n h52 long misc 1added value new 11-19-90 bkr h53 long misc 2added value new 11-19-90 bkr h55 char 15 misc 1added desc new 11-19-90 bkr h56 char 15 misc 2added desc new 11-19-90 bkr i97 long land hold new 11-19-90 bkr i98 long impr hold new 11-19-90 bkr h61 long flat add 1 val 11-6-90 bkr h62 long flat add 2 val 11-6-90 bkr h63 long flat add 3 val 11-6-90 bkr h66 char 40 flat add 1 desc 11-6-90 bkr h67 char 40 flat add 2 desc 11-6-90 bkr l64a char 2 fireplace(s) 14 1sty l64b char 2 fireplace(s) 14 1.5sty l64c char 2 fireplace(s) 14 2sty l64d char 2 fireplace(s) 14 same stk l64e char 2 fireplace(s) 14 free stand l64f char 2 fireplace(s) 14 heatilator l64g char 2 [13,14] fireplace(s) 14 quality l65a char 2 dormer lf / finished? l65b char 2 dormer finished y/n/s & 3rd plumbing l66h char 2 [1,2] attic quality l66a char 2 [3,4] half story quality l67d char 2 [1,2] dormer quality l67p char 2 [3,4] patio quality l68a char 2 floor fin 1 l68b char 2 floor fin 2 l68c char 2 [5,6] floor fin 3 - deck quality 12-22-93 l68d char 2 [7,8] att garage quality s38 integer tot livable l69l1 char 2 room count 88 living room (not used by all) l69l2 char 2 room count 88 living room l69l3 char 2 room count 88 living room l69l4 char 2 room count 88 living room l69d1 char 2 room count 88 din room l69d2 char 2 room count 88 din room l69d3 char 2 room count 88 din room l69d4 char 2 room count 88 din room l69k1 char 2 room count 88 kitchen l69k2 char 2 room count 88 kitchen l69k3 char 2 room count 88 kitchen l69k4 char 2 room count 88 kitchen l69e1 char 2 room count 88 extra kitchen l69e2 char 2 room count 88 extra kitchen l69e3 char 2 room count 88 extra kitchen l69e4 char 2 room count 88 extra kitchen l6941 char 2 room count 88 4 fix bath l6942 char 2 room count 88 4 fix bath l6943 char 2 room count 88 4 fix bath l6944 char 2 room count 88 4 fix bath l6931 char 2 room count 88 3 fix bath l6932 char 2 room count 88 3 fix bath l6933 char 2 room count 88 3 fix bath l6934 char 2 room count 88 3 fix bath l6921 char 2 room count 88 2 fix bath l6922 char 2 room count 88 2 fix bath l6923 char 2 room count 88 2 fix bath l6924 char 2 room count 88 2 fix bath l6911 char 2 room count 88 1 fix l6912 char 2 room count 88 1 fix l6913 char 2 room count 88 1 fix l6914 char 2 room count 88 1 fix l69b1 char 2 room count 88 bed room l69b2 char 2 room count 88 bed room l69b3 char 2 room count 88 bed room l69b4 char 2 room count 88 bed room l69r1 char 2 room count 88 rec room l69r2 char 2 room count 88 rec room l69r3 char 2 room count 88 rec room l69r4 char 2 room count 88 rec room l69o1 char 2 room count 88 den l69o2 char 2 room count 88 den l69o3 char 2 room count 88 den l69o4 char 2 room count 88 den l70 char 2 ext kit total l71 char 2 bed room total l72 char 2 total rooms l73a1 char 10 detached building 1 (6 char not used) l73a2 char 2 yr blt (except by pev ) l73a3 char 2 eff yr l73a4 char 4 width l73a5 char 4 depth l73a6 char 2 ht l73a7 char 5 area l73a8 char 2 class-qf l73a9 char 2 pysical l73aa char 2 functional l73ab char 2 location/economic l73b1 char 10 detached building 2 l73b2 char 2 l73b3 char 2 l73b4 char 4 l73b5 char 4 l73b6 char 2 l73b7 char 5 l73b8 char 2 l73b9 char 2 l73ba char 2 l73bb char 2 l73c1 char 10 detached building 3 l73c2 char 2 l73c3 char 2 l73c4 char 4 l73c5 char 4 l73c6 char 2 l73c7 char 5 l73c8 char 2 l73c9 char 2 l73ca char 2 l73cb char 2 l73d1 char 10 detached building 4 (6 char not used) l73d2 char 2 yr l73d3 char 2 effy l73d4 char 4 width l73d5 char 4 depth l73d6 char 2 ht l73d7 char 5 area l73d8 char 2 qf l73d9 char 2 netp l73da char 2 netf not used often l73db char 2 netl not used often h91 char 4 operators initials 3-20-93 bkr h91z char 4 zip+4 h82 date date entered or updated l75y char 4 eff yr l75w char 2 write in l75f char 4 not used l75u char 2 units l75m char 3 model l75z char 4 zone/depth table l75g char 16 not used 2 l75n char 20 notes l75c char 2 abatement 3 - new 9-23-05 bkr l75d char 2 abatement 4 - new 9-23-05 bkr l75e char 1 na - new 9-23-05 bkr l76a char 2 [1,2] heating quality l76b char 2 [3,4] ac quality l76c char 2 [5,6] 5 fixt baths l76d char 2 [7,8] wood stove l76e char 2 [9,10] dormer - single or fin dormer l76f char 2 [11,12] dormer - small or unfin dormer l76g char 2 [13,14] dormer - large l76h char 2 [15,16] mkt+ % or over impr % l76i char 2 [17,18] mkt- % or under impr % l76j char 2 [19,20] economic % l76k char 2 [21,22] eff age l76l char 4 [23,26] attic fin % or sf l76m char 2 [27,28] functional % l76n char 2 [29,30] age in years l84 integer number of owners - 6-23-98 bkr l85 integer m4 sf area - 6-23-98 bkr l86 long deduction amount - 6-23-98 bkr }