Skip to main content
Skip table of contents

Load POSB From Delimited File - BDUTLP

Load Position Budget Detail (POSB) records from a comma-delimited interface file. Uploaded records can be viewed in BID Position Budget Details (BDUPDAPB) page, Details tab.

Input File Format

1.      Record Type

POSB

2.      Ledger Code

2 characters

3.      Org Key

10 characters

4.      Object Code

8 characters

5.      Position

12 characters

6.      Department

8 characters

7.      Salary Amount

####.##

8.      Fringe Amount

####.##

9.      FTE

####.#####

10.  Employee ID

12 characters

11.  Bargaining Unit

8 characters

12.  Job Number

8 characters

13.  Location

8 characters

14.  Salary Table

24 characters

15.  Reference

16 characters

16.  Package

8 characters

17.  Priority

2 characters

18.  Month

2 characters


FQA
If you want to put in an FQA Account Number and have the program derive the Org Key and Object Code, then you would put the FQA in the Org Key field and leave the Object Code field blank.

Validation

  • Ledger Code
  • Org Key – validates, checks that it is active and if an Association is required
  • Object Code – validates and checks that it is active
  • BD-PBCODES Table - inserts into table if not found
  1. Bargaining Unit – code = BARG
  2. Employee ID – code = NAME
  3. Job Number – code = JOB
  4. Location – code = LOC
  5. Salary Table – code = SAL
  6. Position – code = POS
  7. Department – code = DEPT
  • BD-PACK Table - inserts into table if not found
  1. Package – code = PACK

 Example spreadsheet:

Example comma-delimited file:

Example Budget Item Detail – Position Interface report:

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.