{need to add join}
{** note: would be nice to add zip+4 for owner ** 4-1-97 bkr}
database prc

file history1

field asid type serial        
field ah00 type char    10      {new block}			index dups
field ah01 type char    10      {new lot}			index dups
field ah02 type char     5      {new qual}
field ah03 type char     1      {new bldg}
field ah_id type composite ah00, ah01, ah02, ah03		index
field ai00 type char    10      {old block}
field ai01 type char    10      {old lot}
field ai02 type char     5      {old qual}
field al02 type char    24      {new b/lot/q/b sort format}     index
field al03 type char    23      {old b/lot/q   sort format}
field ai24 type char     3      {class}
field ah77 type char    25      {street}			index dups
field ai18 type char    35      {owner name}			index dups
field ai19 type char    25      {owner street}
field ai20 type char    30      {owner csz}
field ai72 type date            {sale date}
field ai73 type char     5      {sale book}
field ai74 type char     5      {sale page}
field ai75 type long            {sale val}
field ai88 type char     2      {sale nu}
field ah58 type long            {land value}
field ah85 type long            {impr value}
field ah76 type long            {totl value}
field ai30 type char     1      {partial asmt}
field al32 type char    20      {additional lots}
field al33 type char    11      {deductions: 02040608t02345}
field al35 type char     1      {exemption1 code}
field al36 type long            {exemption1 value}
field ai59 type integer         {tax list year}
field ai60 type integer         {mod4 page - new 9-9-95 bkr}
field ai61 type integer         {mod4 line - new 9-9-95 bkr}

{permissions}
{file		group inquire		access read }
{file		group tax		access read}
{file		group ctb		access read }
{file		user root		access control}
{file		user root		access all}

end