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 Add***********************************
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-27           A9         Filler
        28-54           A27        Correlated Field - Account Code
        55-69           A13.2      Correlated Amount
 
       Field Name            Requirements
 
       Record Type           Required - Value 'A'
       Data Code             Required - Must be on the Project Information File                                                                      
       Correlated Field      Required - Must be on Account Description
                                        File; must be numeric
       Correlated Amount     Optional
 
    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-27            A14       Filler
        28-46            A19       Correlated Field - GF, SF, FID, BE and IBI
        47-69            A23       Filler
  
      Field Name                 Requirements

      Record Type                Required - Value 'B'
      Data Code                  Required - Must be on Title File
      Correlated Field           Required - GF must = 10,20,30,40,71 or 74;
                                            Cannot equal zeros; must be on
                                            Account Description File.

    5. 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-27            A9         Filler
       28-32            A5         Correlated Field - Contract Number
       33-69            A37        Filler
     
 
       Field Name                 Requirements

       Record Type                Required - Value 'F'
       Data Code                  Required - Must be on Project Information
                                             File
       Correlated Field           Required - Must be on Contract Information
                                             File
File Layout
Navigation

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