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
- Bargaining Unit – code = BARG
- Employee ID – code = NAME
- Job Number – code = JOB
- Location – code = LOC
- Salary Table – code = SAL
- Position – code = POS
- Department – code = DEPT
- BD-PACK Table - inserts into table if not found
- Package – code = PACK
Example spreadsheet:
Example comma-delimited file:
Example Budget Item Detail – Position Interface report:
