PR6 P/R Payroll Data Entry File (PR6_PayrollDataEntryHeader) Level: 4.40 Record Type: 1 P/R Payroll Data Entry Header File 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 27 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(3,7) Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String *(10,1) Manual Taxes (Y/N). . . . . . . . . . . ManualTaxes . . . . . . . . . String (11,1) Automatic Deductions (Y/N). . . . . . . AutomaticDeductions . . . . . String (12,1) Print Check (Y/N/Printed) . . . . . . . PrntCheck . . . . . . . . . . String (13,1) Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String (14,6) Bank Code For This Check. . . . . . . . BankCodeForThisCheck. . . . . String (20,1) Check Date. . . . . . . . . . . . . . . CheckDate . . . . . . . . . . Date (21,6) Direct Deposit? . . . . . . . . . . . . DirectDep . . . . . . . . . . Yes/No (27,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (28,3) No. Days Worked In Pay Period . . . . . DaysWorked. . . . . . . . . . Number [0] 4.0 No. Weeks Worked In Pay Period. . . . . WeeksWorked . . . . . . . . . Number [1] 3.0 Total Deductions. . . . . . . . . . . . TotalDeductions . . . . . . . Number [2] 8.2 Total Earnings Hours. . . . . . . . . . TotalEarningsHours. . . . . . Number [3] 5.2 Total Regular Hours . . . . . . . . . . TotalRegularHours . . . . . . Number [4] 5.2 Total Gross Earnings. . . . . . . . . . TotalGrossEarnings. . . . . . Number [5] 8.2 Total Taxes . . . . . . . . . . . . . . TotalTaxes. . . . . . . . . . Number [6] 8.2 Total Tips. . . . . . . . . . . . . . . TotalTips . . . . . . . . . . Number [7] 7.2 Total Exempt Tips . . . . . . . . . . . ExemptTips. . . . . . . . . . Number [8] 7.2 Total Wages Excluded from Tips. . . . . XWages. . . . . . . . . . . . Number [9] 8.2 Total Hours Excluded from Tips. . . . . XHours. . . . . . . . . . . . Number [10] 5.2 Check Amount. . . . . . . . . . . . . . CheckAmount . . . . . . . . . Number [11] 8.2 Link To First Detail Record . . . . . . LinkToFirstDetailRecord . . . Number [12] 5.0 Total Overtime Hours. . . . . . . . . . TotalOvertimeHours. . . . . . Number [13] 5.2 Total Regular Earnings. . . . . . . . . TotalRegularEarnings. . . . . Number [14] 8.2 Total Net Deduction Lines . . . . . . . TotalNetDeductionLines. . . . Number [15] 5.0 Hours Accrued (Vacation). . . . . . . . HoursAccruedVacation. . . . . Number [16] 3.2 Hours Accrued (Sick). . . . . . . . . . HoursAccruedSick. . . . . . . Number [17] 3.2 Hours Accrued (Third Benefit Type). . . HoursAccruedBenefit3. . . . . Number [18] 3.2 Direct Deposit Amount . . . . . . . . . DirectDepAmount . . . . . . . Number [19] 8.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [20] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [21] 0. ________ Total Bytes 242
PR6 P/R Payroll Data Entry File (PR6_PayrollDataEntryHeader) Level: 4.40 Record Type: 2 P/R Data Entry Control Record 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 27 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Key Field (10 Spaces) . . . . . . . . . KeyField. . . . . . . . . . . String *(1,10) Pay Cycle (Dwbsmqa - One Used At A Time)PayCycle. . . . . . . . . . . String (11,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (12,6) Period End Date . . . . . . . . . . . . PeriodEndDate . . . . . . . . Date (18,6) Deduction Period. . . . . . . . . . . . DeductionPeriod . . . . . . . String (24,1) Manual Taxes ?. . . . . . . . . . . . . ManualTaxesControlRecord. . . Yes/No (25,1) Auto Deduct ? . . . . . . . . . . . . . AutoDeductControlRecord . . . Yes/No (26,1) Print Checks ?. . . . . . . . . . . . . PrntChecksControlRecord . . . Yes/No (27,1) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (28,6) Standard Earnings Code. . . . . . . . . StdEarningsCode . . . . . . . Zero-Filled (34,2) Status Flag . . . . . . . . . . . . . . StatusFlag. . . . . . . . . . String (36,1) ' '=Tax Calculation Not Done Yet. . . . . . . . . . . . . . . . . . Memo 'M'=Tax Calculation In Process. . . . . . . . . . . . . . . . . . . Memo 'T'=Auto Tax Calculation Completed. . . . . . . . . . . . . . . . . Memo 'C'=Negative Check Needs Correctn . . . . . . . . . . . . . . . . . Memo 'Z'=Checks Have Been Printed. . . . . . . . . . . . . . . . . . . . Memo Direct Deposit? . . . . . . . . . . . . DirectDepControlRecord. . . . Yes/No (37,1) Direct Deposit Entries Exist? . . . . . DirectDepEntriesExist . . . . Yes/No (38,1) Direct Deposit Effective Date . . . . . DirectDepEffectiveDate. . . . Date (39,6) Accrual Date. . . . . . . . . . . . . . AccrualDate . . . . . . . . . Date (45,6) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (51,10) Days Worked . . . . . . . . . . . . . . NoDaysWorkedInPayPeriod . . . Number [0] 4.0 Weeks Worked. . . . . . . . . . . . . . NoWeeksWorkedInPayPeriod. . . Number [1] 3.0 Accrual Percentage. . . . . . . . . . . AccrualPercentage . . . . . . Number [2] 3.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [10] 0. Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [11] 0. Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [12] 0. Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [13] 0. Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [14] 0. Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [15] 0. Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [16] 0. Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [17] 0. Open Number . . . . . . . . . . . . . . _N16. . . . . . . . . . . . . Open Number [18] 0. Open Number . . . . . . . . . . . . . . _N17. . . . . . . . . . . . . Open Number [19] 0. Open Number . . . . . . . . . . . . . . _N18. . . . . . . . . . . . . Open Number [20] 0. Open Number . . . . . . . . . . . . . . _N19. . . . . . . . . . . . . Open Number [21] 0. ________ Total Bytes 102
PR6 P/R Payroll Data Entry File (PR6_PayrollDataEntryHeader) Level: 4.40 Record Type: 3 Posting Restart Record 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 27 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
r1s1. . . . . . . . . . . . . . . . . . r1s1. . . . . . . . . . . . . String *(1,10) r1n1. . . . . . . . . . . . . . . . . . r1n1. . . . . . . . . . . . . Number [0] 8.3 r1n2. . . . . . . . . . . . . . . . . . r1n2. . . . . . . . . . . . . Number [1] 8.3 r1n3. . . . . . . . . . . . . . . . . . r1n3. . . . . . . . . . . . . Number [2] 8.3 ________ Total Bytes 54