jump to main menu jump to subject menu jump to content jump to footer
go image

Division Director

Charles Ghini


Information Systems
200 East Gaines Street
Tallahassee, FL 32399-0318
850-413-3184
design placeholder only

FLAIR File Layout Display

File Layout
Navigation

Help Desk Home  >   FLAIR File Layouts  >   Auxiliary Batch Add / Update File Layouts  >  File Layout Display

File Layout Display
************************Batch Correlation Update*******************************
 
I.  Security Header Record:
 
       Position        Format        Description
         1-1             A1          Header Record Identifier = H
         2-12            A11         Organization
         13-19           A7          User Name
 
       Field Name                     Requirements
       Header Record Identifier       Required - Value 'H'
       Security Organization          Required - Must have update capability
       User Name                      Required - As described below
       If record type = A or F, PJ Sec Function must = 'U'
       If record type = B,      EX Sec Function must = 'U'
 
II. Correlation Records
 
   1. Record Type 'A' - (Project to Account Code)
 
       Position        Format        Description
         1-6             A6           Filler
         7-7             A1           Record Type
         8-18            A11          Data Code - Project Id Number
         19-26           A8           Filler
         27-27           A1           Status Code
         28-55           A27          Current Correlated Field -
                                         27 Digit Account Code
         56-69           A13.2        Correlated Amount
         70-96           A27          New Correlated Field -
                                         27 Digit Account Code
 
       Field Name                    Requirements
       Record Type                   Required - Must = 'A'
       Data Code                     Required
       Status Code                   Optional - If input must = blank or 4
       Current Correlated Field      Required -
       Correlated Amount             Optional
       New Correlated Field          Optional - If input must be numeric and
                                                on Account Description File
    2. Record Type 'B' - (Ownership Fund to Account Code)
 
       Position        Format        Description
         1-6             A6          Filler
         7-7             A1          Record Type
         8-13            A6          Data Code - Ownership Fund Identifier
         14-26           A13         Filler
         27-27           A1          Status Code
         28-46           A19         Current Correlated Field
                                                         - GF, SF, FID, BE, IBI
         47-69           A23         Filler
         70-88           A19         New Correlated Field- GF, SF, FID, BE, IBI
         89-96           A8          Filler
 
       Field Name                    Requirements
 
       Record Type                   Required - Must = 'B'
       Data Code                     Required - Must be on Title File
       Status Code                   Optional - Must = blank or 4
       Current Correlated Field      Required -
       New Correlated Field          Optional - If input; GF must 10,20,30,40,
                                                71 or 74; must be on Account
                                                Description File

    3. Record Type 'F' - (Project to Contract)
 
       Position        Format        Description
         1-6             A6          Filler
         7-7             A1          Record Type
         8-18            A11         Data Code - Project Id Number
         19-26           A8          Filler
         27-27           A1          Status Code
         28-32           A5          Current Correlated Field - Contract Number
         33-69           A37         Filler
         70-74           A5          New Correlated Field - Contract Number
         75-96           A22         Filler
 
       Field Name                    Requirements
       Record Type                   Required - Value 'F'
       Data Code                     Required - Must be on Project Information
                                                File
       Status Code                   Optional - Must = blank or 4
       Current Correlated Field      Required
       New Correlated Field          Optional - Must be on Contract Information
                                                File
File Layout
Navigation

DIS HelpDesk  >   File Layouts  >   Auxiliary Batch Add / Update File Layouts   >  File Layout Display