Lewis-Clark Payroll Cost File Layout–AU444947

DATASET NAME: LCE.S44.AU444947.PRCOSTS

Purpose: Create a file each payroll for Lewis-Clark with payroll cost information.

Created In:  AU444940

Note:  When file is built, program AU444947 will replace sub-object code 4115 with 4116 if not a group position, (position number does not begin with '9').  Program AU444947 will also update the sub-object code to 4125 if the position number is equal to '9999'. 

 

FILE LAYOUT - Detail

Column BeginField Length

Data Type

(Numeric or Alpha)

Field NameDescription
12ASource CodeConstant - PR
32AFund1st 2 digits of PCA
52A Function2nd 2 digits of PCA
77ACost CenterLast 7 digits of Project Number
144ASub-Object Code4 digit expense class
188.2NDebit AmountZero Fill, No Decimal
288.2NCredit AmountZero Fill, No Decimal
387ADescriptionConstant - Payroll
452AReference NumberConstant - HR
474NCurrent Calendar YearYYYY
513NPayroll NumberLast 3 digits of payroll number
546ATransaction/Pay DateMMDDYY

 

Each fund reported on the file will be totaled and added as a separate row at the end of the file.

 

FILE LAYOUT – Totals

Column BeginField Length

Data Type

(Numeric or Alpha)

Field NameDescription
12ASource CodeConstant - PR
32AFund1st 2 digits of PCA
1315NAgency UseAgency Use
288.2NFund Total AmountZero Fill, No Decimal
387ADescriptionConstant - Payroll
452AReference NumberConstant - HR
474NYearYYYY
513NPayroll NumberLast 3 digits of payroll number
546ATransaction/Pay DateMMDDYY