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) |