PR_27 P/R Periodic Benefit Accrual Update File (PR_27PerdBenftAccrUpdate) Level: 4.40 Record Type: 1 P/R Periodic Benefit Accrual Update File 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 30 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(3,7) Check Entry Number. . . . . . . . . . . CheckEntryNumber. . . . . . . String *(10,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (11,20) No. Days Worked In Pay Period . . . . . NoDaysWorkedInPayPeriod . . . Number [0] 3.0 No. Weeks Worked In Pay Period. . . . . NoWeeksWorkedInPayPeriod. . . Number [1] 3.0 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [10] 0. Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [11] 0. Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [12] 0. Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [13] 0. Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [14] 0. Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [15] 0. Hours Accrued (Vacation). . . . . . . . HoursAccruedVacation. . . . . Number [16] 3.2 Hours Accrued (Sick). . . . . . . . . . HoursAccruedSick. . . . . . . Number [17] 3.2 Hours Accrued (Third Benefit Type). . . HoursAccruedBenefit . . . . . Number [18] 3.2 Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [19] 0. Open Number . . . . . . . . . . . . . . _N16. . . . . . . . . . . . . Open Number [20] 0. Open Number . . . . . . . . . . . . . . _N17. . . . . . . . . . . . . Open Number [21] 0. ________ Total Bytes 85
PR_27 P/R Periodic Benefit Accrual Update File (PR_27PerdBenftAccrUpdate) Level: 4.40 Record Type: 2 P/R Periodic Accrual Control Record 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 30 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Key Field (10 Spaces) . . . . . . . . . KeyField. . . . . . . . . . . String *(1,10) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (11,7) Period End Date (System Date) . . . . . PeriodEndDate . . . . . . . . Date (18,6) Deduction Period. . . . . . . . . . . . DeductionPeriod . . . . . . . String (24,1) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (25,6) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [10] 0. Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [11] 0. Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [12] 0. Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [13] 0. Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [14] 0. Open Number . . . . . . . . . . . . . . _N16. . . . . . . . . . . . . Open Number [15] 0. Open Number . . . . . . . . . . . . . . _N17. . . . . . . . . . . . . Open Number [16] 0. Open Number . . . . . . . . . . . . . . _N18. . . . . . . . . . . . . Open Number [17] 0. Open Number . . . . . . . . . . . . . . _N19. . . . . . . . . . . . . Open Number [18] 0. Open Number . . . . . . . . . . . . . . _N20. . . . . . . . . . . . . Open Number [19] 0. Open Number . . . . . . . . . . . . . . _N21. . . . . . . . . . . . . Open Number [20] 0. Open Number . . . . . . . . . . . . . . _N22. . . . . . . . . . . . . Open Number [21] 0. ________ Total Bytes 54
PR_27 P/R Periodic Benefit Accrual Update File (PR_27PerdBenftAccrUpdate) Level: 4.40 Record Type: 3 Posting Restart Record 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 260 Min Len: 30 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