PCPA_FTP_DATA_HELP

FTP_PARCEL File Layout

FIELD NAME

DESCRIPTION

TYPE

PARCEL_ID

18 digit account number - common link to all data files and parcel shapefiles

VARCHAR(25)

SECTION

Digits 5 & 6 of Parcel ID

VARCHAR(2)

TOWNSHIP

Digits 3 & 4 of Parcel ID

VARCHAR(2)

RANGE

Digits 1 & 2 of Parcel ID

VARCHAR(2)

SUB

Digits 7-12 of Parcel ID

VARCHAR(6)

PARCEL

Digits 13-18 of Parcel ID

VARCHAR(6)

DORUS_CODE

Department of Revenue (DOR) Mandated Property use code

VARCHAR(16)

DORDESC

Category Grouping of DOR Use code

VARCHAR(10)

DORDESC1

Department of Revenue (DOR) Mandated Property use code description

VARCHAR(100)

NH_CD

Appraisal Neighborhood Code

DECIMAL(10,2)

NH_DSCR

Appraisal Neighborhood Description

VARCHAR(50)

HOMESTEAD

Homestead

INT

OTHEREX

Other exemptions

INT

PORT_VAL

Portability Value

DECIMAL(12,2)

CLS_LND_VAL

Classified Land Value

INT

AG_CLASS

Agricultural Classification

CHAR(1)

VALUETYPE

Valuation Code

VARCHAR(2)

VALUEDESC

Valuation Code Description

VARCHAR(50)

*TOT_LND_VAL

Appraised Land Value

INT

*TOT_BLD_VAL

Appraised Building Value

INT

*TOT_XF_VAL

Appraised Extra Features Value

INT

*TOTALVAL

Total Market Value

INT

RECONCILE

Property is on Reconcile (Y,N)

VARCHAR(6)

*ASSESSVAL

Total Assessed Value

DECIMAL(12,2)

*TAXVAL

Base Taxable Value

DECIMAL(12,2)

CURTAXDIST

Current Tax District

VARCHAR(16)

*TAXDIST

Tax Dist Values are based on.  Usually last years final taxdist

VARCHAR(16)

*AMTDUE

Amount of Taxes

DECIMAL(11,2)

*MILLRATE

Millage Rate

DECIMAL(5,3)

YR_CREATED

Year Parcel was created

INT

YR_IMPROVED

Year Parcel was improved

INT

LAST_INSP_DT

Date of most recent inspection

DATETIME

TOT_ACREAGE

Total Acreage of Parcel

DECIMAL(12,4)

PR_STRAP

Parent or Prior Parcel ID number

CHAR(25)