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 Expansion Set File - Update ********************
Expansion Set 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 Set Input Record:

     Position   Format    Description                      Length
       1-6        A       Filler                             6
       7-8        A       Set Indicator                      2
       9-14       A       Object Code                        6
      15-15       N       Status Code                        1
      16-21       A       Category                           6
      22-26       A       General Ledger Code                5
      27-29       A       External General Ledger Code       3
      30-32       A       External Object Code               3
      33-33       A       Allotment Level Indicator          1
      34-34       A       Grant Allotment Level Indicator    1
      35-36       A       Year                               2
      37-37       A       Contract Allotment Level Indicator 1
      38-38       A       Project Allotment Level Indicator  1
      39-44       A       External Category                  6

Note:  Fields on the expansion set 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.

III. Field Requirements

      Field Name                     Requirements
     
      Security Header Record:
      Header Record Identifier       Required - Value = 'H'
      Organization                   Required - Security Level Organization
                                                  followed by asterisks
      User Name                      Required
             Note: Access Control Record must have update capability for
                   the Expansion Function (EX)
      Expansion Set Update Record:
      Set Indicator                  Required
      Object Code                    Required
      Status Code                    Optional - Must be space, 1, 3, or 4
                                       - Only the status code may be changed for
                                         inactive or deleted expansion sets
                                         (records with SC of 3 or 4)
        Field Name                     Requirements

        Appropriation Year             Optional - If changed must be numeric.
                                       If changed and object is < 100000, year
                                       must = 00.  If erased, default to 00
        Category                       Optional - If changed must be numeric;
                                       Cannot = 000000; must be Titled  (1)
                                       If object < 100000, CAT must be < 010000;
                                       If object > 099999, CAT must be > 009999
        General Ledger Code            Optional - If changed must be Titled (1)
        External General Ledger Code   Optional - If changed must be Titled (2)
        External Object Code           Optional - If changed must be Titled (2)
        External Category              Optional - If changed must be Titled (2)
        Allotment Level Indicator      Optional - If changed must = 1,2,3,4,5,
                                       A,B,C,D,or E.  (2)
                                       If OLO = L10000, ALI must = 1-5 or A-E
                                       If OLO = L1L200, ALI must = 2-5 or B-E
                                       If OLO = L1L2L3, ALI must = 3-5 or C-E
        Grant Allotment Level Ind      Optional - If changed must be A,B,C,D,
                                       or E.  Valid for C&G users only  (2)
                                       If OLO = L10000, GTALI must = A-E
                                       If OLO = L1L200, GTALI must = B-E
                                       If OLO = L1L2L3, GTALI must = C-E
        Contract Allotment Level Ind   Optional - If changed must be A,B,C,D,
                                       or E. (2)
                                       If OLO = L10000, CTALI must = A-E
                                       If OLO = L1L200, CTALI must = B-E
                                       If OLO = L1L2L3, CTALI must = C-E
        Project Allotment Level Ind    Optional - If changed must be A,B,C,D,
                                       or E. (2)
                                       If OLO = L10000, PJALI must = A-E
                                       If OLO = L1L200, PJALI must = B-E
                                       If OLO = L1L2L3, PJALI must = C-E
(1)  Cannot be erased
(2)  Can be erased

File Layout
Navigation

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