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 INVENTORY UPDATE ***************************

 I.  Security Header Record:

       Position     Format    Description
 
         1-1          A1      Header Record Identifier - Value 'H'
         2-12         A11     Organization
        13-19         A7      User Name

II.  Property Master Update Record:

       Position     Format    Description
        
         1-8          A8      Item - (Pr1key 16-23) Before
         9-16         A8      Item - (Pr1key 16-23) After
        17-32         A16     Location Code
        33-33         N1      Condition Code
        34-68         A35     Description
        69-85         A17     Manufacturer's Serial Number
        86-93         A8      Inventory Date (yyyymmdd)

III. Edits

     Field Name                     Requirements
   
     Security Header Record:
     Security Header Indicator      Required  - Value 'H'
     Organization                   Required  - Value 'Security Level Org
                                                Followed By (**)'
     User Name                      Required


  Note: The security record must have update capability for the fixed assets
        custodial (FC) function and the CID must be titled on the property
        custodian file.
        Only one header record is allowed per tape and it must
        be the first record.

     If errors occur in security record except: 'password will expire in x days'
     processing of batch will stop.

      Field Name                      Requirements
     
      Input Record:
      Item Number (Before)            Required - Must be an active record on the
                                                Property Master File.
                                               - If record is found
                                                then (PR1RTP must equal 1-6) and
                                                     (PR1SC must be blank) and
                                                     (Org on master record
                                                      must be within Security
                                                      Org/AU/CID Range)

     Item Number (After)             Required - Cannot be updated if other items
                                                chained to (before-item), Cannot
                                                already be on the Property
                                                Master File, last 6 digits must
                                                be numeric and NE zeros.

     Location Code                   Required - Must be on FLAIR Title File

     Condition Code                  Optional - If present and Record Type = 2,
                                                3, 4 or 6 then must = 1-4;
                                                If blank then no update - other-
                                                wise invalid.

     Description                     Optional - Can be changed; If blank then no
                                                update

     Manufacturer's Serial Number    Optional - Can be changed; If blank then no
                                                update

     Inventory Date                  Required - Must be valid yyyymmdd;
                                              - Cannot be > current date

Note: Records found to have errors will be excluded from the update and will
      appear on an error listing with the reason(s) for rejection.
      Update to property master and generation of property history will occur
      if input fields are NE to property master values.

File Layout
Navigation

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