PCPA_FTP_DATA_HELP

FTP_TDE File Layout

FIELD NAME

DESCRIPTION

TYPE

ACCOUNT_ID

8 digit tangible account number

VARCHAR(12)

PARCEL_ID

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

VARCHAR(25)

ADDR_1

Mailing address line 1

VARCHAR(50)

ADDR_2

Mailing address line 2

VARCHAR(50)

ADDR_3

Mailing address line 3

VARCHAR(50)

CITY

Mailing City

VARCHAR(50)

STATE

Mailing State

VARCHAR(2)

ZIP

Mailing Zip

VARCHAR(10)

SCHED_CD

Tangible business code

VARCHAR(1)

SCHED_DSCR

Description of Tangible business code

VARCHAR(50)

PEN_PCT

Account tax penalties

INT

PEN_YEAR

Tax penalty year

INT

PREV_VAL

Prior year value

INT

DTL_VAL

Detail Value

INT

DTL_PEN_VAL

Detail Penalty Value

INT

AMENDMENT1EX

Amendment 1 Exemption

INT

FSEX

Free Standing Amendment 1 Exemption

INT

GVRNMNTEX

Government Exemption

INT

INSTEX

Institutional Exemption

INT

WIDOWEX

Widows/Widowers Exemption

INT

DISEX

Disabilities Exemption

INT

VETERANSEX

Veterans Exemption

INT

OTHEREX

Other Exemptions

INT

EXCODE

Exemption Code

VARCHAR(8)

EXDESC

Exemption Description

VARCHAR(100)

EXCL_VAL

Excluded Value

INT

ASD_VAL

Assessed Value

INT

TAX_VAL

Taxable Value

INT

AMTDUE

Amount Due

INT

MILL_CD

Millage Code

VARCHAR(16)

MILL_DSCR

Millage Description

VARCHAR(100)

MILL_TOT_MILL

Total Millage

REAL

SIC

North American Industry Classification System Code

VARCHAR(8)

SIC_DSCR

North American Industry Classification System Description

VARCHAR(100)