Scribd
Upload
100 views1 page

CCCCC PDF

This document provides a record layout for a zipped file called m_tape460.zip containing license information. The file contains fixed-length fields with information like license type, number, status, dates, addresses, and more. There are 460 characters per record with fields identified by position and length to allow for sorting and searching of the license records in the file.

Uploaded by

Ganapathi Raj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
100 views1 page

CCCCC PDF

This document provides a record layout for a zipped file called m_tape460.zip containing license information. The file contains fixed-length fields with information like license type, number, status, dates, addresses, and more. There are 460 characters per record with fields identified by position and length to allow for sorting and searching of the license records in the file.

Uploaded by

Ganapathi Raj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

FILE / RECORD

LAYOUT Number:
Page: 01 of 01
RECORD FORMAT FILE NAME: m_tape460.zip
FIELD NAME License File License or Type Type
Type Number Application Status Original
Issue Dates
CHARACTERISTICS* X(2) X(8) X(3) X(8) X(11)
RELATIVE POSITION 1-2 3 - 10 11 - 13 14 - 21 22 - 32

Expiration Fee Duplicate Master Term in Geo District/


Dates Codes Counts Indicator # of Months Code Office
Code
X(11) X(8) X(3) X(1) X(2) X(4) X(2)
33 - 43 44 - 51 52 - 54 55 56 - 57 58 - 61 62 - 63

Primary Premise Premise Premise Premise Premise DBA


Name Street Street City State Zip Name
Address 1 Address 2
X(50) X(50) X(50) X(25) X(2) X(10) X(50)
64 - 113 114 - 163 164 - 213 214 - 238 239 - 240 241 - 250 251 - 300

Mail Mail Mail Mail Mail Premise Premise


Street Street City State Zip County Census
Address 1 Address 2 Tract #
X(50) X(50) X(25) X(2) X(10) X(16) X(7)
301 - 350 351 - 400 401 - 425 426 - 427 428 - 437 438 - 453 454 - 460

Recording Mode: Sorting Fields:


Records per Block: 5 1- File Number
Characters per Record: 460 2-
Date Created: 3-
4-
Remarks: 5-

ZIPPED FILE (needs to be un-zipped) *Characters


ASCII/text file/fixed-length-fields A- Alphabetic or Blank
File may be too large for some versions of EXCEL X- Alphanumeric
More info on our License Lookup Glossary 9- Numeric
V- Assumed Decimal Point
Record Count: Date Format: DD-MON-YYYY

You might also like