4.0 Technical Description of Files
| DATA SET NAME: | FTPUSRn.PUT.SLCEXF.FINALyy where 'n' indicates campus (BK = 1, SF = 2, etc.); and 'yy' represents the report period effective year. |
| RECORD FORMAT: | Fixed blocked (FB) |
| RECORD LENGTH: | 115 |
| BLOCKSIZE: | 4140 |
The SLC Interface File is a fixed file with eight record types. It is currently a straight copy of the RSLS Staffing List Master File, which contains all eight of the record types.
Records in the Staffing List Master File portion are grouped by Location SAU, Sub-Campus, Account, Fund, and Sub-Budget. These records were merged by the Staffing List System from a budget file, a payroll file, and a provision file. Normally records from the budget file correspond to records from the provision and/or payroll file. However, the system can handle budget records only, provisions only, payroll records only, and any combination with a LOC-SAU-SC-ACCT-FUND-SUB.
When Budget records exist within a LOC-SAU-SC-ACCT-FUND-SUB grouping, they appear before any Payroll or Provision records within the grouping. One Budget Header Record, followed by Budget Detail Record(s), if any, followed by one Budget Trailer Record will appear for each unique LOC-SAU-SC-ACCT-FUND-SUB. Budget Detail Records will be sorted by Document Number, Document Suffix, Transaction Class, Transaction Type.
When Provision and/or Payroll Records exist within a LOC-SAU-SC-ACCT-FUND-SUB grouping, they appear after any Budget records, sorted together by Title Code. Within Title Code, any Payroll records will appear first, followed by any Provision records.
Any Payroll records present within a Title Code will be sorted by Employee Number followed by Distribution Number. Within a Distribution Number, a single Payroll Distribution Record will exist followed by all Payroll Cross-Reference Record(s), if any.
Any provision records present within a Title Code will be sorted by Provision Number.
Fields within the Budget, Payroll, and Provision records are arranged so that the records sort into the proper sequence. Note that the character positions in which the XREF Title Code appears in the Payroll Cross-Reference record are left blank in the Payroll Distribution record so that the former sort to follow the latter. Similarly, in the Provision record the former sort to follow the latter. Similarly, in the Provision record one character of high values (hex "FF") or "9" follows the title code and precedes the provision number, so that Provision records sort to follow Payroll records.
Record Layouts for the various record types in the Staffing List Master file:
Last updated: November 28, 2001