PCPA_FTP_DATA_HELP

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)