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

 
 Expansion Option Add
 
 I. Security Header Record:
 
    Position     Format      Description                          Length
    
      1-1          A         Header Record Identifier - H            1
      2-12         A         Organization                            11
     13-19         A         User Name                               7
 
II. Expansion Option Input Record:
 
      Position     Format      Description                        Length
      
       1-11          N         Organization Levels 1-5              11
      12-13          A         Expansion Option                     2
      14-15          -         Filler                               2
                               Grant Available Balance Indicators:
      16-16          A          Grant Encumbrance/Enc Change        1
      17-17          A          Grant Encumbered Disbursement       1
      18-18          A          Grant Unencumbered Disbursement     1
      19-20          N         GAAFR Fund                           2
      21-21          N         State Fund                           1
      22-27          N         Fund Identifier                      6
      28-35          N         Budget Entity                        8
      36-37          N         Internal Budget Indicator            2
      38-38          N         External Fund                        1
      39-48          N         State Program - Standard            10
      49-54          N         State Program - Optional             6
      55-56          N         External Program                     2
      57-61          A         Contract                             5
      62-66          A         Other Cost Accumulator               5
                               Available Balance Indicators:
      67-67          A          Encumbrance/Encumbrance Change      1
      68-68          A          Encumbered Disbursement             1
      69-69          A          Unencumbered Disbursement           1
      70-75          N         Revolving Fund                       6
      76-81          N         Clearing Fund                        6
      82-83          A         Original Fund Source                 2
      84-91          A         Beginning Date (yyyymmdd)            8
      92-99          A         Ending Date (yyyymmdd)               8
     100-105         -         Filler                               6
     106-107         A         Set Indicator                        2
     108-108         A         Grant Allotment Level Default        1
     109-109         A         Allotment Level Default              1
     110-111         A         Agency Unique                        2
     112-116         A         Grant                                5
     117-118         A         Contract Year                        2
     119-120         A         Grant Year                           2
     121-131         A         Project Id                          11
 
 
 
     Position       Format    Description                             Length
    
                             Contract Available Balance Indicators:
     132-132         A         Contract Encumbrance/Enc Change         1
     133-133         A         Contract Encumbered Disbursement        1
     134-134         A         Contract Unencumbered Disbursement      1
                             Project Available Balance Indicators:
     135-135         A         Project Encumbrance/Enc Change          1
     136-136         A         Project Encumbered Disbursement         1
     137-137         A         Project Unencumbered Disbursement       1
     138-138         A         Contract Allotment Level Default        1
     139-139         A         Project Allotment Level Default         1
     140-148         A         Director/Manager                        9

    Field Name                         Requirements
                           
    Security Header Record:
    Header Record Identifier           Required - Value 'H'
    Organization                       Required
    User Name                          Required
    Organization L1-L5                 Required - Must be on Title File and
                                                  within security org range.
    Expansion Option                   Required - Cannot be duplicated on
                                                  Expansion File
    Account Code Requirements:
     (A) Gaafr Fund                    Required - Must be on Title File
     (B) State Fund                    Required - Cannot = 9; must be on Title
                                                  File
     (C) Fund Identifier               Required - Must be on Title File
     (D) Budget Entity                 Optional - Defaults to 00000000; If
                                                  input must be on Title File.
                                                  - The combination of Budget
                                                    Entity and State Standard
                                                    (1st 10 characters) of State
                                                    Program must be valid on the
                                                    Correlation File (DCOF01)
      (E) Internal Budget Indicator   Optional - Defaults to 00; If input
                                                 must be on Title File.
      (F) There must be a valid header record on the Account Description
             File for input account code.

    Expansion Option Add Record:
    Grant Available Balance Indicators        - Valid for C & G users only
                                                  Required if grant is not blank
           Grant Enc/Enc Change                   Must = 0, 1, 2, or 9.
           Grant Enc Disbursement                 Note: There are no defaults
           Grant Unenc Disbursement               for Grant Avail Bal Indicators
    External Fund                      Optional - If input must be on Title
                                                  File.
  
 
    State Program
          Standard                      Required - Must be on Title File
          Optional                      Optional - Defaults to 000000; If input
                                                   must be on Title File.
                                                  - The combination of Budget
                                                    Entity and State Standard
                                                    (1st 10 characters) of State
                                                    Program must be valid on the
                                                    Correlation File (DCOF01)
    External Program                   Optional - If input must be on Title
                                                  File.
    Contract                           Optional - If input must be valid on
                                                  Contract Information File.
    Other Cost Accumulator             Optional - If input must be on Title
                                                  File.
    Available Balance Indicators       (If input, must = 0,1,2,3,4,or 9)
    Encumbrance/Enc Change             Optional - Defaults to 0
    Encumbered Disbursement            Optional - Defaults to 0
    Unencumbered Disbursement          Optional - Defaults to 0
    Revolving Fund                     Optional - If input must be a
                                       valid revolving fund header record on the
                                       Account Desc File for the Fund Id input
    Clearing Fund                      Optional - If input, there must be a
                                       valid clearing fund header record on the
                                       Account Desc File for the Fund Id input
    Original Fund Source               Optional - If input must be on Title
                                                  File.
    Beginning Date                     Optional - If input must be valid
                                                  calendar date in yyyymmdd
                                                  format
    Ending Date                        Optional - If input must be valid
                                                  calendar date in yyyymmdd
                                                  format
    Grant Allotment Level Default        - Valid for C&G users only; required if
                                                    grant is input; if input
                                                    must = A,B,C,D Or E
    Set Indicator                      Optional - If input must be on
                                                  Expansion Set File
    Allotment Level Default            Required - Must be 1,2,3,4,5,A,B,C,D,
                                                  or E.
    Agency Unique                      Optional - If input must be on Title
                                                  File.
    Grant                              Optional - If input must be on Grant
                                                  Information File
    Contract Year                      Optional - Invalid if contract is blank
    Grant Year                         Optional - Invalid if grant is blank
    Project Id                         Optional - If input must be valid on
                                                  Project Information File.
    Contract Avail Balance Indicators         - Required if contract is not
        Contract Encumb/Enc Change              blank; must = 0,1,2, or 9
        Contract Encumb Disbursement            Note: There are no defaults
        Contract Unencumb Disbsmnts             for Cntrt Avail Bal Indict.
   

    Project Avail Balance Indicators          - Required if project is not
          Project Encumb/Enc Change                blank; must be = 0,1,2, or 9
          Project Encumb Disbursement              Note: There are not defaults
          Project Unencumb Disbsmnts               for Project Avail Bal Indict
    Contract Allot Level Default              - Required if contract is not
                                                    Blank; must = A,B,C,D, or E.
    Project Allot Level Default               - Required if project is not
                                                    Blank; must = A,B,C,D, or E.
    Director/Manager                          - Optional; If input must
                                                    be on Director/Manager File
 
    Correlation Edits
 
    Project Id to Account Code Correlation:
            If the agency has opted to always require this correlation
            and a project id is included on the input record, the project id
            must be correlated to the account code on the input record
            (either input or from expansion).
            If the agency has opted to sometimes require this correlation
            and a project id is included on the input record, if the project id
            has been correlated to any account codes, it must be correlated
            to the account code on the input record (either input or from
            expansion).
     Project Id to Contract Correlation:
            If the agency has opted to always require this correlation
            and a project id and contract are included on the input record, the
            project id must be correlated to the contract on the input record.
            If the agency has opted to sometimes require this correlation
            and a project id and contract are included on the input record, if
            the project id has been correlated to any contracts, it must be
            correlated to the contract on the input record.
 
 
 
 
     Contract to Account Code Correlation:
            If the agency has opted to always require this correlation
            and a contract is included on the input record, the contract
            must be correlated to the account code on the input record
            (either input or from expansion).
            If the agency has opted to sometimes require this correlation
            and a contract is included on the input record, if the contract
            has been correlated to any account codes, it must be correlated
            to the account code on the input record (either input or from
            expansion).
 
File Layout
Navigation

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