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