Reads fixed-width TXT file and loads into MySQL table imprv_detail
| Start | End | Len | Field | Type | Description |
|---|---|---|---|---|---|
| 1 | 12 | 12 | prop_id | BIGINT | Property ID |
| 13 | 16 | 4 | prop_val_yr | SMALLINT | Appraisal Year |
| 17 | 28 | 12 | imprv_id | BIGINT | Improvement ID |
| 29 | 40 | 12 | imprv_det_seq | BIGINT | Improvement Detail Sequence |
| 41 | 50 | 10 | imprv_type_cd | VARCHAR(10) | Improvement Type Code |
| 51 | 75 | 25 | imprv_type_desc | VARCHAR(25) | Improvement Description |
| 76 | 85 | 10 | imprv_state_cd | VARCHAR(10) | State Code |
| 86 | 89 | 4 | year_built | SMALLINT | Year Built |
| 90 | 93 | 4 | year_effective | SMALLINT | Effective Year |
| 94 | 108 | 15 | imprv_val | DECIMAL(15,6) | Improvement Value |
| 109 | 123 | 15 | imprv_homesite_pct | DECIMAL(15,6) | Homesite Apportionment Pct |
| 124 | 124 | 1 | omitted | CHAR(1) | Omitted (Y/N) |
| 125 | 139 | 15 | omitted_imprv_val | DECIMAL(15,6) | Omitted Improvement Value |