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