Weekly Data Export - Fixed-Width Layout Definition
Printable Document
Download a printable copy of Weekly Data Export – Fixed-Width Layout Definition by clicking the PDF download button.
- File Name:
- m_tape460.zip
- Record Format:
- See table
- Records per Block:
- 5
- Characters per Record
- 460
- Sorting Fields:
- File Number
- Date Format:
- DD-MON-YYY
- Remarks:
-
- ZIPPED FILE (needs to be un-zipped)
- ASCII/text file/fixed-length-fields
- File may be too large for some versions of EXCEL
- More info can be found in our Glossary
Record Format
| Field Name | Characteristics* | Relative Position |
|---|---|---|
| License Type | X(2) | 1-2 |
| File Number | X(8) | 3-10 |
| License or Application | X(3) | 11-13 |
| Type Status | X(8) | 14-21 |
| Type Original Issue Dates | X(11) | 22-32 |
| Expiration Dates | X(11) | 33-43 |
| Fee Codes | X(8) | 44-51 |
| Duplicate Counts | X(3) | 52-54 |
| Master Indicator | X(1) | 55 |
| Term in Number of Months | X(2) | 56-57 |
| Geo Code | X(4) | 58-61 |
| District/Office Code | X(2) | 62-63 |
| Primary Name | X(50) | 64-113 |
| Premise Street Address 1 | X(50) | 114-163 |
| Premise Street Address 2 | X(50) | 164-213 |
| Premise City | X(25) | 214-238 |
| Premise State | X(2) | 239-240 |
| Premise Zip | X(10) | 241-250 |
| DBA Name | X(50) | 251-300 |
| Mail Street Address 1 | X(50) | 301-350 |
| Mail Street Address 2 | X(50) | 351-400 |
| Mail City | X(25) | 401-425 |
| Mail State | X(2) | 426-427 |
| Mail Zip | X(10) | 428-437 |
| Premise County | X(16) | 438-453 |
| Premise Census Tract Number | X(7) | 454-460 |
*Characters
- A – Alphabetic or Blank
- X – Alphanumeric
- 9 – Numeric
- V – Assumed Decimal Point
TRACE
Law Enforcement Reporting
LEAD
Off-Sale Licensee Training
Google Translate