File Information and Record Layout for State Agency Address List Downloadable Files

Information: 
Each file is a comma delimited file of one of five
different categories of agency employees: Agency Head, Purchasing Agency,
Accountant, Business Manager, or Property Manager.  Each field is delimited by
a comma; each alphanumeric field is enclosed by single quotes; each numeric
field is not enclosed by single quotes.  The file is not created to fit any
specific need and may need modification before it can be used (although it
follows the format generally used by database, spreadsheet and
word processing software for uploading files). 
The accuracy of each file is the responsibility of each individual state agency.


Record Layout: 

Sequence        Length        Description             Type

1               4             Agency Number           Alphanumeric
2               1             Agency Type             Numeric:
                                                        1 = Executive
                                                        2 = Health-Welfare
                                                        3 = Education
                                                        4 = Judicial
                                                        5 = Other
3               36            Agency Name             Alphanumeric
4               30            Title                   Alphanumeric
5               36            Employee Name           Alphanumeric
6               36            Address Line 1          Alphanumeric
7               36            Address Line 2          Alphanumeric
8               20            City                    Alphanumeric
9               2             State Abbreviation      Alphanumeric
10              9             Zip Code                Numeric
11              2               Highway District        Numeric
12              1               Purchasing Zone         Numeric (1-5)
13              1               Responsible             Alphanumeric (Y or N)
14              1               Capitol Complex         Alphanumeric (Y or N)
15              1               Reporting               Alphanumeric (Not used)
16              1               Employee Type           Numeric
                                                          1 = Agency Head
                                                          2 = Purchasing Agent
                                                          3 = Accountant
                                                          4 = Business Manager
                                                          5 = Property Manager
17              10              Employee Telephone#     Alphanumeric
18              4               Employee Tel# Ext.      Alphanumeric    
19              10              Employee FAX#           Alphanumeric