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