PTAX80 F M Software PAGE- 1 Tax Roll Download File Specifications DATE-10/29/04 SELECTION PARAMETERS: --------------------- Tax Year. . . . . . . . . . . 2005 Municipality Code(s). . . . . *NA Group Payer(s). . . . . . . . *NA Receipt Type(s) . . . . . . . *NA Include Tax Information . . . *YES Paid Status . . . . . . . . . *ALL MASTER FILE: ------------ Physical Format: File-EBCDIC file-Record Length=364. Nine-Track Tape-Record Length=364, Block Length=3640, Unlabeled. Master Record Format Position Start End Field Type Description ----- ---- ---------- ----------------------------- 1 11 Alphameric Record Key 1 4 Numeric/0 Tax Year 5 5 Alphabetic Type Code: R=Real P=Personal S=Public Service 6 11 Numeric/0 Receipt Number (within type) 12 31 Alphameric County Parcel Number 32 66 Alphameric Owner's Name (first line) 67 101 Alphameric Owner's Mailing Address (1st line) 102 136 Alphameric Parcel Description (first line) 137 138 Numeric/0 Section Number 139 141 Alphameric Township 142 144 Alphameric Range 145 153 Numeric/0 Taxable Assessed Valuation 154 158 Numeric/0 H/S Exempt Valuation-Regular 159 163 Numeric/0 Over 65 164 168 Numeric/0 DAV 169 173 Numeric/0 SSI 174 182 Numeric/2 Homestead Tax Credit-Regular 183 191 Numeric/2 Over 65 192 200 Numeric/2 DAV 201 209 Numeric/2 SSI 210 210 Alphameric Beat 211 211 Alphameric Municipality Code (blank=outside) 212 212 Alphameric School District Code 213 228 Alphameric Special Levy Codes (16) 229 235 Numeric/2 Forestry Acres 236 242 Numeric/2 Total Acres 243 244 Alphameric Exemption Code 245 307 Values - Defined three ways. 'R' Receipt type - Real Property. 245 253 Numeric/0 Class 1 Cultivatible Land Value 254 262 Numeric/0 Class 1 Uncultivatible Land Val 263 271 Numeric/0 Class 1 Improvements Value 272 280 Numeric/0 Class 2 Cultivatible Land Value 281 289 Numeric/0 Class 2 Uncultivatible Land Val 290 298 Numeric/0 Class 2 Improvements Value 299 307 Numeric/0 Unused - zeros. 'P' Receipt type - Personal Property. 245 253 Numeric/0 Furniture & Fixtures 254 262 Numeric/0 Machines & Equipment 263 271 Numeric/0 Leased Equipment 272 280 Numeric/0 Inventory 281 289 Numeric/0 Bank's Intangibles 290 298 Numeric/0 Money & Debts 299 307 Numeric/0 Miscellaneous 'S' Receipt type - Public Service. 245 253 Numeric/0 Unused - zeros. 254 262 Numeric/0 Unused - zeros. 263 271 Numeric/0 Unused - zeros. 272 280 Numeric/0 Unused - zeros. 281 289 Numeric/0 Unused - zeros. 290 298 Numeric/0 Unused - zeros. 299 307 Numeric/0 Unused - zeros. Tax Amount Information (optional) 308 314 Numeric/7 Tax Rate (Mills = Rate x 1000) 315 323 Numeric/2 Total Ad-Valorem Taxes 324 332 Numeric/2 Special Levy Tax 333 339 Numeric/4 Forestry Rate Per Acre 340 348 Numeric/2 Forestry Tax 349 351 Numeric/0 State Numeric Tax District Code 352 355 Alphabetic Group Payer Code 356 364 Numeric/2 Balance Due SUPPLEMENTAL FILE: ------------------ Physical Format: File-EBCDIC file-Record Length=48. Nine-Track Tape-Record Length=48, Block Length=480, Unlabeled. Supplemental Record Format Position Start End Field Type Description ----- ---- ---------- ----------------------------- 1 13 Alphameric Record Key 1 11 Alphameric Master Record Key (linking key) 1 4 Numeric/0 Tax Year 5 5 Alphabetic Type Code: R=Real P=Personal S=Public Service 6 11 Numeric/0 Receipt Number (within type) 12 12 Alphameric Data Type: 1=Additional Names. 2=Additional Addresses. 5=Additional Descript. 6=Additional Descript. 7=Deed/Will/Minute Bk. 8=Map Reference. 13 13 Alphameric Data Type Sequence. 14 48 Alphameric Data Line re Data Type Note: Type 29 is a formatted address line as follows. 1-17 City name. 18-19 filler. 20-21 State code. 22-25 filler. 26-30 Zip code (basic). 31 Dash if +4 present. 32-35 Zip code (+4). PAYMENT RETURN FILE: -------------------- Payment Record Format Position Start End Field Type Description ----- ---- ---------- ----------------------------- 1 11 Alphameric Record Key 1 4 Numeric/0 Tax Year 5 5 Alphabetic Type Code: R=Real P=Personal S=Public Service 6 11 Numeric/0 Receipt Number (within type) 12 31 Alphameric County Parcel Number 32 66 Alphameric Owner's Name (first line) 67 80 Alphameric Amount Paid (Amount paid may be an edited amount, i.e. $2,345.67 or it may be all numeric, i.e. 000123456, in which case, it will be interpreted to be $1,234.56)