This file layout is used to import payroll transmittal files into ASCENDER payroll transaction tables.
Field | Length | Position | Type | Description |
---|---|---|---|---|
Employee Number | 6 | 1-6 | Numeric | 123 = 000123 |
Job Code | 4 | 7-10 | Numeric | Left justified, if 123 = '123' |
Regular Hrs | 5, 2 | 11-15 | Numeric | 37.52 hrs = 03752 |
Absence Deduction | 7, 2 | 16-22 | Numeric | $123.45 = 0012345 |
Overtime Hours | 5, 2 | 23-27 | Numeric | 4.52 hrs = 00452 |
Overtime Amount | 7, 2 | 28-34 | Numeric | $123.45 = 0012345 |
Overtime Budget Fund | 3 | 35-37 | Numeric | Fund 199 = 199 |
Overtime Budget Function | 2 | 38-39 | Numeric | Function 11 = 11 |
Overtime Budget Object | 4 | 40-43 | Numeric | Object 6119 = 6119 |
Overtime Budget Sub Obj | 2 | 44-45 | Numeric | Sub Object 00 = 00 |
Overtime Budget Organization | 3 | 46-48 | Numeric | Organization 001 = 001 |
Overtime Budget Fiscal Yr | 1 | 49 | Numeric | If 2013-2014 = ‘4’ |
Overtime Budget Program | 2 | 50-51 | Numeric | Program Codes |
Overtime Budget Ed Span | 1 | 52 | Numeric | Educational Span Codes |
Overtime Budget Project | 2 | 53-54 | Numeric | Project Detail Codes |
Overtime Code | 1 | 55 | Numeric | 1, 2, 3, 4, or 5 |
Supplemental Amount | 7, 2 | 56-62 | Numeric | If $123.45 = 0012345 |
Supplemental Fund | 3 | 63-65 | Numeric | Fund 199 = 199 |
Supplemental Function | 2 | 66-67 | Numeric | Function 11 = 11 |
Supplemental Object | 4 | 68-71 | Numeric | Object 6119 = 6119 |
Supplemental Sub Obj | 2 | 72-73 | Numeric | Sub Object 00 = 00 |
Supplemental Organization | 3 | 74-76 | Numeric | Organization 001 = 001 |
Supplemental Fiscal Yr | 1 | 77 | Numeric | If 2002-2003 = ‘3’ |
Supplemental Program | 2 | 78-79 | Numeric | Program Codes |
Supplemental Ed Span | 1 | 80 | Numeric | Educational Span Codes |
Supplemental Project | 2 | 81-82 | Numeric | Project Detail Codes |
Actual Hours | 5, 2 | 83-87 | Numeric | 37.52 hrs = 03752 |
Actual Date | 8 | 88-95 | Numeric | 20140102 |