FTP_SALES File Layout
|
FIELD NAME |
DESCRIPTION |
TYPE |
|
PARCEL_ID |
18 digit account number - common link to all data files and parcel shapefiles |
VARCHAR(25) |
|
SALE_ID |
Number used to make sale per parcel unique |
INT |
|
LN_NUM |
Number used to put sales in order |
INT |
|
SALEDT |
Date of the sale |
DATE/TIME |
|
PRICE |
Sale Price |
INT |
|
BOOK |
Official Record Book Number |
VARCHAR(8) |
|
PAGE |
Official Record Page Number |
VARCHAR(8) |
|
SALETYPE |
Vacant/Improved |
CHAR(1) |
|
TRNS_CD |
Transaction Code |
VARCHAR(16) |
|
TRNS_DSCR |
Transaction Code Description |
VARCHAR(50) |
|
INSTRTYP |
Instrument Type (Reason) Code |
VARCHAR(2) |
|
INSTRTYP_DSCR |
Instrument Type (Reason) Code Description |
VARCHAR(50) |
|
GRANTOR |
Seller |
VARCHAR(100) |
|
GRANTEE |
Buyer |
VARCHAR(100) |
|
FORECLOSURE |
Current or Past Foreclosure blank if not a foreclosure |
CHAR(1) |