PR_23 P/R Perpetual History Detail File (PR_23PerptHistoryDetail) Level: 4.40 Record Type: 1 Perpetual History Detail--Earnings Line 08/28/2009 File Type: Direct Key Size: 27 Rec Len: 150 Min Len: 82 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Check Date. . . . . . . . . . . . . . . CheckDate . . . . . . . . . . Date *(10,6) Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(16,6) M If Non-Printed Check. . . . . . . . . MIfNonprintedCheck. . . . . . String *(22,1) Sequence Number (blank,0-9) . . . . . . SeqNumber . . . . . . . . . . String *(23,1) Line Type (E/D/T/V) (E = Earnings). . . LineType. . . . . . . . . . . String *(24,1) Detail Sequence Number. . . . . . . . . DetailSeqNumber . . . . . . . Zero-Filled *(25,3) Earning Code. . . . . . . . . . . . . . EarningCode . . . . . . . . . String (28,2) Department Code . . . . . . . . . . . . DeptCode. . . . . . . . . . . String (30,2) Labor Distribution Code . . . . . . . . LaborDistributionCode . . . . String (32,7) Cost Code (If J/C). . . . . . . . . . . CostCode. . . . . . . . . . . String (39,9) State Tax Code. . . . . . . . . . . . . StateCode . . . . . . . . . . String (48,3) Local Tax Code. . . . . . . . . . . . . LocalCode . . . . . . . . . . String (51,3) Workers' Comp Code. . . . . . . . . . . WorkersCompensationCode . . . String (54,7) Earnings Type (R/O/V/S/Etc.). . . . . . EarningsType. . . . . . . . . String (61,1) Earnings Multiplier (In String Form). . EarningsMultiplierStringForm. String (62,5) Job Number (If J/C) . . . . . . . . . . JobNumber . . . . . . . . . . String (67,7) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase (74,3) Benefit Date. . . . . . . . . . . . . . BenefitDate . . . . . . . . . Date (77,6) Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [0] 5.3 Hours/Receipt Amt (Tip Alloc) . . . . . HoursReceiptAmtWages. . . . . Number [1] 6.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 ________ Total Bytes 120
PR_23 P/R Perpetual History Detail File (PR_23PerptHistoryDetail) Level: 4.40 Record Type: 2 Perpetual History Detail--Deduction Line 08/28/2009 File Type: Direct Key Size: 27 Rec Len: 150 Min Len: 82 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Check Date. . . . . . . . . . . . . . . CheckDate . . . . . . . . . . Date *(10,6) Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(16,6) M If Non-Printed Check. . . . . . . . . MIfNonprintedCheck. . . . . . String *(22,1) Sequence Number (blank,0-9) . . . . . . SeqNumber . . . . . . . . . . String *(23,1) Line Type (E/D/T/V) (D = Deduction) . . LineType. . . . . . . . . . . String *(24,1) Detail Sequence Number. . . . . . . . . DetailSeqNumber . . . . . . . Zero-Filled *(25,3) Deduction Code. . . . . . . . . . . . . DeductionCode . . . . . . . . String (28,2) Deduction Type (S/P/C/E) /C/P)DeductionType . . . . . . . . String (30,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (31,17) State Tax Code If (30,1) = P Or C . . . StateTaxCode. . . . . . . . . String (48,3) Local Tax Code If (30,1) = P Or C . . . LocalTaxCode. . . . . . . . . String (51,3) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (54,23) Benefit Date (Not Used) . . . . . . . . BenefitDate . . . . . . . . . Date (77,6) Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [0] 5.3 Hours/Wages . . . . . . . . . . . . . . HoursReceiptAmtWages. . . . . Number [1] 6.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 ________ Total Bytes 120
PR_23 P/R Perpetual History Detail File (PR_23PerptHistoryDetail) Level: 4.40 Record Type: 3 Perpetual History Detail--Tax Line 08/28/2009 File Type: Direct Key Size: 27 Rec Len: 150 Min Len: 82 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Check Date. . . . . . . . . . . . . . . CheckDate . . . . . . . . . . Date *(10,6) Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(16,6) M If Non-Printed Check. . . . . . . . . MIfNonprintedCheck. . . . . . String *(22,1) Sequence Number (blank,0-9) . . . . . . SeqNumber . . . . . . . . . . String *(23,1) Line Type (E/D/T/V) (T = Tax) . . . . . LineType. . . . . . . . . . . String *(24,1) Detail Sequence Number. . . . . . . . . DetailSeqNumber . . . . . . . Zero-Filled *(25,3) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (28,20) State Tax Code. . . . . . . . . . . . . StateTaxCode. . . . . . . . . String (48,3) Local Tax Code. . . . . . . . . . . . . LocalTaxCode. . . . . . . . . String (51,3) Tax Type (F/M/D/W/T/E). . . . . . . . . TaxType . . . . . . . . . . . String (54,1) F = Employee Fica . . . . . . . . . . . . . . . . . . . . . . . . . Memo M = Employee Medicare . . . . . . . . . . . . . . . . . . . . . . . Memo D = Employee Sdi/Ldi. . . . . . . . . . . . . . . . . . . . . . . . Memo W = Withholding . . . . . . . . . . . . . . . . . . . . . . . . . . Memo T = Sui/Other Local Tax . . . . . . . . . . . . . . . . . . . . . . Memo E = Earned Income Credit. . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (55,22) Benefit Date (Not Used) . . . . . . . . BenefitDate . . . . . . . . . Date (77,6) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Hours/Wages . . . . . . . . . . . . . . HoursReceiptAmtWages. . . . . Number [1] 6.2 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 ________ Total Bytes 110
PR_23 P/R Perpetual History Detail File (PR_23PerptHistoryDetail) Level: 4.40 Record Type: 4 Perpetual History Detail--Direct Deposit 08/28/2009 File Type: Direct Key Size: 27 Rec Len: 150 Min Len: 82 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Dept. . . . . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Check Date. . . . . . . . . . . . . . . CheckDate . . . . . . . . . . Date *(10,6) Check Number. . . . . . . . . . . . . . CheckNumber . . . . . . . . . String *(16,6) M If Non-Printed Check. . . . . . . . . MIfNonprintedCheck. . . . . . String *(22,1) Sequence Number (blank,0-9) . . . . . . SeqNumber . . . . . . . . . . String *(23,1) Line Type (E/D/T/V) (V = Direct Dep . . LineType. . . . . . . . . . . String *(24,1) Detail Sequence Number. . . . . . . . . DetailSeqNumber . . . . . . . Zero-Filled *(25,3) Bank Account Number . . . . . . . . . . BankAcctNumber. . . . . . . . String (28,17) Account Desc. . . . . . . . . . . . . . AcctDescription . . . . . . . String (45,15) Account Type. . . . . . . . . . . . . . AcctType. . . . . . . . . . . String (60,1) Routing/Transit Number. . . . . . . . . RoutingTransitNumber. . . . . String (61,9) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (70,7) Benefit Date (Not Used) . . . . . . . . BenefitDate . . . . . . . . . Date (77,6) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Dd Amount . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 ________ Total Bytes 100