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