{*** This layout to be used for all new systems !!! ***}

{removed index dups on s06, we don't know how it got there  12-21-98 gdl}
{removed index on 09 12 21 and added field 6-23-97 bkr}
{added new fields 5-18-97 bkr}
{indexes aren't the same as /usr4/ctb/defsr for 09 12 21 30}
{added new fields 4-19-96 bkr}
{added new fields 9-25-95 bkr}
{modified length for city and comments 6-28-94 bkr}
database prc

file sr1a

field ssi type serial start 10000
field s00 type char   10	 {new block} 		index dups
field s01 type char   10	 {new lot} 		index dups
field s0q type char   05	 {new q} 	
field s03 type char    1	 {bldg} 	
field s_id type composite s00, s01, s0q, s03			index dups
field s0l type char   24	 {new block/lot/q} 	index dups
field s05 type date             {date entered/updated}
field s06 type char   10        {book - merged w/page 5-29-94 bkr}  index{dups}
{      s07  not used              page}               
field s08 type date             {deed date}
field s09 type char   35        {owner name}           
field s10 type char   25        {owner street}
field s11 type char   30        {owner csz}
field s12 type char   35        {grantee name}        
field s13 type char   25        {grantee street}
field s14 type char   34        {grantee csz - mod fr 30 6-28-94 bkr}
field s15 type float            {r.t. fee}
field s16 type long             {price}
field s17 type char    3        {r.t.f. exempt}               
field s18 type integer          {tax book page}
field s19 type integer          {tax book line}
field s20 type char   3         {class}
field s21 type char   25        {prop loc}               
field s22 type char   1         {condo /used for join}
field s23 type char   4         {class 4 type}
field s24 type integer          {year}
field s25 type long             {land assessed}
field s26 type long             {impr assessed}
field s27 type long             {net  assessed}
field s28 type char    20       {additional lots}
field s29 type char   70        {comments/remarks - mod fr 30 to 70 6-28-94}
field s30 type date             {recorded date}
field s_id2 type composite s30, s0l				index dups
field s31 type float            {ratio}
field s32 type char    2        {nu code}
field s33 type long             {sr1a number}		index dups
field s34 type char    2        {2nd nu code     - new 6-2-94 bkr}
field s35 type char   1         {mod4 update y/n - new 6-2-94 bkr}
field s36 type char   1         {clear y/n       - new 6-2-94 bkr}
field s37 type char   1         {send y/n        - new 6-2-94 bkr}
{blank=got from list& go get it, X=Transfered to Cty, Y=Ok to Trans, N=Don't}
field s39 type integer          {sf area    - new 7-12-94 bkr}
field s40 type integer          {year built - new 7-12-94 bkr}
field s41 type char   25        {add'l bl 1 - new 3-23-95 bkr}
field s42 type char   25        {add'l bl 2 - new 3-23-95 bkr}
field s43 type char   25        {add'l bl 3 - new 3-23-95 bkr}
field s44 type char   25        {add'l bl 4 - new 3-23-95 bkr}
field s45 type char   25        {add'l bl 5 - new 3-23-95 bkr}
field s46 type float            {add'l rt fee - new 9-25-95 bkr}
field s47 type char   34        {m4 csz       - new 9-25-95 bkr}
field s48 type char   1         {mod4 update ded's y/n - new 5-18-97bkr}
field s49 type char   2         {2nd nu code           - new 5-18-97bkr}
field s50 type char   2         {comparable sale y/n   - new 6-07-01bkr}
field s51 type date             {date assigned sr num  - new 5-18-97bkr}
field s52 type date             {date worksht sent     - new 5-18-97bkr}
field s53 type date             {date sent by assr     - new 5-18-97bkr}
field s54 type char   1         {fake join             - new 5-18-97bkr}
field s55 type integer          {class as integer  - not used5-18-97bkr}
field s56 type char  20         {conveyed acreage      - new 5-18-97bkr}
field s57 type date             {date sent by assr     - new 6-23-97bkr}
end