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 Update
 
 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        N         Version                              2
                    A         Grant Available Bal Indicator:
       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 Indicator:
       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-100      N         Status Code                          1
       101-105      A         Filler                               5
       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
  
 
 
       Position     Format      Description                         Length
       121-131        A         Project Id                            11
                             Contract Available Balance Indicator:
       132-132        A            Contract Encumbrance/Enc Chang     1
       133-133        A            Contract Encumbered Disbursement   1
       134-134        A            Contract Unencumbered Disbursement 1
                             Project Available Balance Indicator:
       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
 
Note:  Fields on the expansion option record may be overridden by input of
       another data code or may be erased by input of a '-' in the first
       position of the input field.  The fields which may be erased are
       noted in the field requirements below.
1) Cannot be erased
2) Can be erased
        Field Name                       Requirements
        Security Header Record:
        Header Record Identifier         Required - Value 'H'
        Organization                     Required
        User Name                        Required
        Expansion Option Update Record:
        Organization L1-L5               Required
        Expansion Option                 Required
        Account Code Requirements:
         (A) GAAFR Fund                  Optional -                          (1)
         (B) State Fund                  Optional - Cannot = 9               (1)
         (C) Fund Identifier             Optional -                          (1)
         (D) Budget Entity               Optional - If erased, defaults to
                                                    00000000.
                                                  - 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 - If erased, default=00
         (F) There must be a valid header record on the Account Description
             File for input Account Code.
        Grant Available Balance Indicators:        |---Valid for C&G users only;
                                                   | If input must = 0,1,2, or 9
           Grant Enc/Enc Change          Optional -| Cannot be erased if C&G
           Grant Enc Disbursement        Optional -| User & grant is input or
           Grant Unenc Disbursement      Optional -| On Ex1 File.
             Note:  There are no defaults for Grant Available Balance Indicators
        External Fund                    Optional -|---If input must be on (2)
                                                       the Title File
        Field Name                       Requirements
        State Program:                            
             Standard                    Optional -|     "                  (1)
             Optional                    Optional -|     "                  (2)
                                                  - 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 (2)
                                                       the Title File
        Other Cost Accumulator           Optional -|     "                  (2)
        Contract                         Optional -|---If input must be on (2)
                                                   | Contract Information File.
        Available Balance Indicators:              |---If input must = 0,1,2,3,4
             Encumbrance/Enc Change      Optional -| Or 9,If erased default to 0
             Encumbered Disbursement     Optional -|     "
             Unencumbered Disbursement   Optional -|     "
        Revolving Fund                   Optional -|---If input there must be a
                                      valid revolving fund header record on the
                              Account Description File for the fund id input;(2)

        Clearing Fund                    Optional -|---If input there must be a
                                        valid clearing fund header record on the
                              Account Description File for the fund id input;(2)

        Original Fund Source             Optional -|---If input must be on
                                                   | Title File.             (2)
        Beginning Date                   Optional -|---Must be valid calendar
                                                       date (yyyymmdd) (2)

        Ending Date                      Optional -|---Must be valid calendar
                                                       date (yyyymmdd) (2)
        Set Indicator                    Optional -|---If input must be on
                                                   | Expansion Set File.     (2)
        Grant Allotment Level Default    Optional -|-Valid for C&G users only(2)
                                                   | required if grant is input
                                                   | or grant is on EX1 File.If
                                                   |input must = A, B, C, D or E
        Status Code                      Optional -|Must be space,1,2,3, or 4,If
                                                   |EX1STAT =2,3 Or 4;Then input
                                                   |SC must = space, 2, 3, or 4.
                                                   |-If EX1STAT=2,3 Or 4; EX1VER
                                                   |= 98; then no other fields
       Field Name                       Requirements
                                                   |other than SC may be updated
                                                   |-If EX1STAT = 4 then no
                                                   |other fields may be input.
        Allotment Level Default          Optional -|Must = 1, 2, 3, 4, 5, A, B,
                                                   |C, D, or E. (1) If OLO = ...
                                                   |-L10000, ALI must=1-5 or A-E
                                                   |-L1L200, ALI must=2-5 or B-E
                                                   |-L1L2L3, ALI must=3-5 or C-E
        Agency Unique                    Optional -|---Can be erased if Security
                                                   |AU=**. Must be on Title File

        Grant                            Optional - If input must be on Grant
                                                     Information File   (2)
        Contract Year                    Optional -|Invalid if cntrt is blank(2)
        Grant Year                       Optional -|Invalid if grant is blank(2)
        Project Id                       Optional  |---If input must be on
                                                   |Project Information File (2)
                                                   |Project Information File (2)
                                                   |Project Information File (2)
                                                   |Project Information File (2)
                                                   |Project Information File (2)
        Contract Available Bal Ind       Optional  |---Cannot be erased if
             Contract Enc/Enc Change     Optional  | Contract is not blank or if
             Contract Enc Disbursement   Optional  | Contract is on EX1 Record
             Contract Unenc Disbursement Optional  | If input must = 0,1,2, or 9

        Project Available Bal Ind        Optional  |---Cannot be erased if
             Project Enc/Enc Change      Optional  | Project is not blank or
             Project Enc Disbursement    Optional  | Project is on EX1 Record.
             Project Unenc Disbursement  Optional  | If input must = 0,1,2, or 9
        Contract Allot Level Default     Optional  |---Cannot be erased if
                                                   | Contract is not blank or if
                                                   | Contract is on EX1 Record,
                                                   |If input must = A,B,C,D or E
        Project Allot Level Default      Optional  |---Cannot be erased if
                                                   | Project is not blank or if
                                                   | Project is on EX1 Record,
                                                   |If input must = A,B,C,D or E
        Director/Manager                 Optional   If input,
                                                    then edit against Director/
                                                       Manager File.
 

III. 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