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:

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