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/tet 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