PR3    P/R Employee Tax Summary File (PR3_EmployeeTaxSummary)                   Level: 4.40
        Record Type: 1    P/R Employee Tax Summary File - Federal                08/28/2009
 
 File Type: Direct   Key Size: 15   Rec Len: 535     Min Len: 30     Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2)
 Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account     *(3,7)
 State Code (Spaces For Federal) . . . . StateCode . . . . . . . . . . String      *(10,3)
 Local Code (Spaces For Federal) . . . . LocalCode . . . . . . . . . . String      *(13,3)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (16,7)
 Filing Status . . . . . . . . . . . . . FilingStatus. . . . . . . . . String      (23,3)
 Tax Calculation Override Code . . . . . TaxCalcOverrideCode . . . . . String      (26,1)
   F=Fixed amt, P=Percentage of Gross. . . . . . . . . . . . . . . . . Memo
   A=Add an amt, Blank = None. . . . . . . . . . . . . . . . . . . . . Memo
 Filing Status Ok? (* If Ok) . . . . . . FilingStatusOk. . . . . . . . String      (27,1)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (28,3)
 No. Dependent Exemptions. . . . . . . . NoOfDependentExemptions . . . Number      [0]       3.2
 No. Personal Exemptions . . . . . . . . NoOrPersonalExemptions. . . . Number      [1]       3.2
 Tax Calc. Override Amount (Or %). . . . TaxCalcOverrideAmount . . . . Number      [2]       7.2
 QTD Days Worked . . . . . . . . . . . . QtdDaysWorked . . . . . . . . Number      [3]       3.0
 QTD Weeks Worked. . . . . . . . . . . . QtdWeeksWorked. . . . . . . . Number      [4]       2.0
 QTD Gross Wages . . . . . . . . . . . . QtdGrossWages . . . . . . . . Number      [5]       7.2
 QTD Wages Subject To Federal WithholdingQtdWagesSubjToWithholding . . Number      [6]       7.2
 QTD Wages Subject To Employee FICA. . . QtdWagesSubjToEmployeeFica. . Number      [7]       7.2
   State=SDI, Local=LDI. . . . . . . . . . . . . . . . . . . . . . . . Memo
 QTD Wages Subject To Employer FICA. . . QtdWagesSubjToEmployerFica. . Number      [8]       7.2
   State=Employer SUI, Local=Other Local . . . . . . . . . . . . . . . Memo
 QTD Wages Subject To Unemployment . . . QtdWagesSubjToUnemployment. . Number      [9]       7.2
   Employer FUTA, State=Employee SUI . . . . . . . . . . . . . . . . . Memo
 QTD Taxable Tips Reported . . . . . . . QtdTaxableTipsReported. . . . Number      [10]      7.2
 QTD Tips Deemed To Be Wages . . . . . . QtdTipsDeemedToBeWages. . . . Number      [11]      7.2
 QTD Earned Income Credit. . . . . . . . QtdEarnedIncomeCredit . . . . Number      [12]      7.2
 QTD Employee Federal Withholding Tax. . QtdWithholdingTax . . . . . . Number      [13]      7.2
 QTD Employee FICA Tax . . . . . . . . . QtdEmployeeFica . . . . . . . Number      [14]      7.2
 QTD Hours Worked. . . . . . . . . . . . QtdHoursWorked. . . . . . . . Number      [15]      4.2
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [16]      0.
 YTD Days Worked . . . . . . . . . . . . YtdDaysWorked . . . . . . . . Number      [17]      3.0
 YTD Weeks Worked. . . . . . . . . . . . YtdWeeksWorked. . . . . . . . Number      [18]      2.0
 YTD Gross Wages . . . . . . . . . . . . YtdGrossWages . . . . . . . . Number      [19]      7.2
 YTD Wages Subject To Federal WithholdingYtdWagesSubjToWithholding . . Number      [20]      7.2
 YTD Wages Subject To Employee FICA. . . YtdWagesSubjToEmployeeFica. . Number      [21]      7.2
   State=SDI, Local=LDI. . . . . . . . . . . . . . . . . . . . . . . . Memo
 YTD Wages Subject To Employer FICA. . . YtdWagesSubjToEmployerFica. . Number      [22]      7.2
   State=Employer SUI, Local=Other Local . . . . . . . . . . . . . . . Memo
 YTD Wages Subject To Unemployment . . . YtdWagesSubjToUnemployment. . Number      [23]      7.2
   Employer FUTA, State=Employee SUI . . . . . . . . . . . . . . . . . Memo
 YTD Taxable Tips Reported . . . . . . . YtdTaxableTipsReported. . . . Number      [24]      7.2
 YTD Tips Deemed To Be Wages . . . . . . YtdTipsDeemedToBeWages. . . . Number      [25]      7.2
 YTD Earned Income Credit. . . . . . . . YtdEarnedIncomeCredit . . . . Number      [26]      7.2
 YTD Federal Withholding Tax . . . . . . YtdWithholdingTax . . . . . . Number      [27]      7.2
 YTD Employee Fica Tax . . . . . . . . . YtdEmployeeFica . . . . . . . Number      [28]      7.2
 YTD Hours Worked. . . . . . . . . . . . YtdHoursWorked. . . . . . . . Number      [29]      4.2
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [30]      0.
 QTD Wages Sub To Employee Medicare. . . QtdWagesSubjToEmployeeMed . . Number      [31]      7.2
 QTD Wages Sub To Employer Medicare. . . QtdWagesSubjToEmployerMed . . Number      [32]      7.2
 YTD Wages Sub To Employee Medicare. . . YtdWagesSubjToEmployeeMed . . Number      [33]      7.2
 YTD Wages Sub To Employer Medicare. . . YtdWagesSubjToEmployerMed . . Number      [34]      7.2
 QTD Employee Medicare Tax . . . . . . . QtdEmployeeMedicare . . . . . Number      [35]      7.2
 YTD Employee Medicare Tax . . . . . . . YtdEmployeeMedicare . . . . . Number      [36]      7.2
 QTD Tips Subject to Employee FICA . . . QtdTipsSubjToEmployeeFica . . Number      [37]      7.2
 QTD Tips Subject to Employer FICA . . . QtdTipsSubjToEmployerFica . . Number      [38]      7.2
 YTD Tips Subject to Employee FICA . . . YtdTipsSubjToEmployeeFica . . Number      [39]      7.2
 YTD Tips Subject to Employer FICA . . . YtdTipsSubjToEmployerFica . . Number      [40]      7.2
 QTD FICA Tips Tax . . . . . . . . . . . QtdFicaTipsTax. . . . . . . . Number      [41]      7.2
 YTD FICA Tips Tax . . . . . . . . . . . YtdFicaTipsTax. . . . . . . . Number      [42]      7.2
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [43]      0.
 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [44]      0.
 Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [45]      0.
                                                                                   ________
                                                                      Total Bytes  489
 

 PR3    P/R Employee Tax Summary File (PR3_EmployeeTaxSummary)                   Level: 4.40
        Record Type: 2    P/R Employee Tax Summary File - State                  08/28/2009
 
 File Type: Direct   Key Size: 15   Rec Len: 535     Min Len: 30     Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2)
 Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account     *(3,7)
 State Code. . . . . . . . . . . . . . . StateCode . . . . . . . . . . String      *(10,3)
 Local Code (Spaces For State) . . . . . LocalCode . . . . . . . . . . String      *(13,3)
 Workers' Comp Code (State Only) . . . . WorkersCompCode . . . . . . . String      (16,7)
 Filing Status . . . . . . . . . . . . . FilingStatus. . . . . . . . . String      (23,3)
 Tax Calculation Override Code . . . . . TaxCalcOverrideCode . . . . . String      (26,1)
   F=Fixed amt, P=Percentage of Gross. . . . . . . . . . . . . . . . . Memo
   A=Add an amt, Blank = None. . . . . . . . . . . . . . . . . . . . . Memo
 Filing Status Ok? (* If Ok) . . . . . . FilingStatusOk. . . . . . . . String      (27,1)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (28,3)
 No. Dependent Exemptions. . . . . . . . NoOfDependentExemptions . . . Number      [0]       3.2
 No. Personal Exemptions . . . . . . . . NoOrPersonalExemptions. . . . Number      [1]       3.2
 Tax Calc. Override Amount (Or %). . . . TaxCalcOverrideAmount . . . . Number      [2]       7.2
 QTD Days Worked . . . . . . . . . . . . QtdDaysWorked . . . . . . . . Number      [3]       3.0
 QTD Weeks Worked. . . . . . . . . . . . QtdWeeksWorked. . . . . . . . Number      [4]       2.0
 QTD Gross Wages . . . . . . . . . . . . QtdGrossWages . . . . . . . . Number      [5]       7.2
 QTD Wages Subject To Withholding. . . . QtdWagesSubjToWithholding . . Number      [6]       7.2
 QTD Wages Subject To Employee SDI . . . QtdWagesSubjToEmployeeSDI . . Number      [7]       7.2
 QTD Wages Subject To Employer SUI . . . QtdWagesSubjToEmployeeSUI . . Number      [8]       7.2
 QTD Wages Subject To Employee SUI . . . QtdWagesSubjToUnemployment. . Number      [9]       7.2
 QTD Taxable Tips Reported . . . . . . . QtdTaxableTipsReported. . . . Number      [10]      7.2
 QTD Tips Deemed To Be Wages . . . . . . QtdTipsDeemedToBeWages. . . . Number      [11]      7.2
 QTD Earned Income Credit. . . . . . . . QtdEarnedIncomeCredit . . . . Number      [12]      7.2
 QTD State Withholding Tax . . . . . . . QtdWithholdingTax . . . . . . Number      [13]      7.2
 QTD Employee SDI Tax. . . . . . . . . . QtdEmployeeSDI. . . . . . . . Number      [14]      7.2
 QTD Hours Worked. . . . . . . . . . . . QtdHoursWorked. . . . . . . . Number      [15]      4.2
 QTD Employee SUI Tax. . . . . . . . . . QtdEmployeeSUI. . . . . . . . Number      [16]      7.2
 YTD Days Worked . . . . . . . . . . . . YtdDaysWorked . . . . . . . . Number      [17]      3.0
 YTD Weeks Worked. . . . . . . . . . . . YtdWeeksWorked. . . . . . . . Number      [18]      2.0
 YTD Gross Wages . . . . . . . . . . . . YtdGrossWages . . . . . . . . Number      [19]      7.2
 YTD Wages Subject To Withholding. . . . YtdWagesSubjToWithholding . . Number      [20]      7.2
 YTD Wages Subject To Employee SDI . . . YtdWagesSubjToEmployeeSdi . . Number      [21]      7.2
 YTD Wages Subject To Employer SUI . . . YtdWagesSubjToEmployeeSui . . Number      [22]      7.2
 YTD Wages Subject To Employee SUI . . . YtdWagesSubjToUnemployment. . Number      [23]      7.2
 YTD Taxable Tips Reported . . . . . . . YtdTaxableTipsReported. . . . Number      [24]      7.2
 YTD Tips Deemed To Be Wages . . . . . . YtdTipsDeemedToBeWages. . . . Number      [25]      7.2
 YTD Earned Income Credit. . . . . . . . YtdEarnedIncomeCredit . . . . Number      [26]      7.2
 YTD State Withholding Tax . . . . . . . YtdWithholdingTax . . . . . . Number      [27]      7.2
 YTD Employee SDI Tax. . . . . . . . . . YtdEmployeeSdi. . . . . . . . Number      [28]      7.2
 YTD Hours Worked. . . . . . . . . . . . YtdHoursWorked. . . . . . . . Number      [29]      4.2
 YTD Employee SUI Tax. . . . . . . . . . YtdEmployeeSui. . . . . . . . Number      [30]      7.2
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [31]      0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [32]      0.
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [33]      0.
 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [34]      0.
 Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [35]      0.
 Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [36]      0.
 Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [37]      0.
 Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [38]      0.
 Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [39]      0.
 Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [40]      0.
 Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [41]      0.
 Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [42]      0.
 Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [43]      0.
 Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [44]      0.
 Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [45]      0.
                                                                                   ________
                                                                      Total Bytes  379
 

 PR3    P/R Employee Tax Summary File (PR3_EmployeeTaxSummary)                   Level: 4.40
        Record Type: 3    P/R Employee Tax Summary File - Local                  08/28/2009
 
 File Type: Direct   Key Size: 15   Rec Len: 535     Min Len: 30     Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2)
 Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account     *(3,7)
 State Code. . . . . . . . . . . . . . . StateCode . . . . . . . . . . String      *(10,3)
 Local Code. . . . . . . . . . . . . . . LocalCode . . . . . . . . . . String      *(13,3)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (16,7)
 Filing Status . . . . . . . . . . . . . FilingStatus. . . . . . . . . String      (23,3)
 Tax Calculation Override Code . . . . . TaxCalcOverrideCode . . . . . String      (26,1)
   F=Fixed amt, P=Percentage of Gross. . . . . . . . . . . . . . . . . Memo
   A=Add an amt, Blank = None. . . . . . . . . . . . . . . . . . . . . Memo
 Filing Status Ok? (* If Ok) . . . . . . FilingStatusOk. . . . . . . . String      (27,1)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (28,3)
 No. Dependent Exemptions. . . . . . . . NoOfDependentExemptions . . . Number      [0]       3.2
 No. Personal Exemptions . . . . . . . . NoOrPersonalExemptions. . . . Number      [1]       3.2
 Tax Calc. Override Amount (Or %). . . . TaxCalcOverrideAmount . . . . Number      [2]       7.2
 QTD Days Worked . . . . . . . . . . . . QtdDaysWorked . . . . . . . . Number      [3]       3.0
 QTD Weeks Worked. . . . . . . . . . . . QtdWeeksWorked. . . . . . . . Number      [4]       2.0
 QTD Gross Wages . . . . . . . . . . . . QtdGrossWages . . . . . . . . Number      [5]       7.2
 QTD Wages Subject To Local Withholding. QtdWagesSubjToWithholding . . Number      [6]       7.2
 QTD Wages Subject To Employee LDI . . . QtdWagesSubjToEmployeeLdi . . Number      [7]       7.2
 QTD Wages Subject To Other Local Tax. . QtdWagesSubjOtherLocalTax . . Number      [8]       7.2
 QTD Wages Subject To Local Unemployment QtdWagesSubjToUnemployment. . Number      [9]       7.2
 QTD Taxable Tips Reported . . . . . . . QtdTaxableTipsReported. . . . Number      [10]      7.2
 QTD Tips Deemed To Be Wages . . . . . . QtdTipsDeemedToBeWages. . . . Number      [11]      7.2
 QTD Earned Income Credit. . . . . . . . QtdEarnedIncomeCredit . . . . Number      [12]      7.2
 QTD Local Withholding Tax . . . . . . . QtdWithholdingTax . . . . . . Number      [13]      7.2
 QTD Employee LDI Tax. . . . . . . . . . QtdEmployeeLdi. . . . . . . . Number      [14]      7.2
 QTD Hours Worked. . . . . . . . . . . . QtdHoursWorked. . . . . . . . Number      [15]      4.2
 QTD Employee Other Local Tax. . . . . . QtdOtherLocalTax. . . . . . . Number      [16]      7.2
 YTD Days Worked . . . . . . . . . . . . YtdDaysWorked . . . . . . . . Number      [17]      3.0
 YTD Weeks Worked. . . . . . . . . . . . YtdWeeksWorked. . . . . . . . Number      [18]      2.0
 YTD Gross Wages . . . . . . . . . . . . YtdGrossWages . . . . . . . . Number      [19]      7.2
 YTD Wages Subject To Local Withholding. YtdWagesSubjToWithholding . . Number      [20]      7.2
 YTD Wages Subject To Employee LDI . . . YtdWagesSubjToEmployeeLdi . . Number      [21]      7.2
 YTD Wages Subject To Other Local Tax. . YtdWagesSubjToOtherLocalTax . Number      [22]      7.2
 YTD Wages Subject To Local Unemployment YtdWagesSubjToUnemployment. . Number      [23]      7.2
 YTD Taxable Tips Reported . . . . . . . YtdTaxableTipsReported. . . . Number      [24]      7.2
 YTD Tips Deemed To Be Wages . . . . . . YtdTipsDeemedToBeWages. . . . Number      [25]      7.2
 YTD Earned Income Credit. . . . . . . . YtdEarnedIncomeCredit . . . . Number      [26]      7.2
 YTD Local Withholding Tax . . . . . . . YtdWithholdingTax . . . . . . Number      [27]      7.2
 YTD Employee LDI Tax. . . . . . . . . . YtdEmployeeLdi. . . . . . . . Number      [28]      7.2
 YTD Hours Worked. . . . . . . . . . . . YtdHoursWorked. . . . . . . . Number      [29]      4.2
 YTD Employee Other Local Tax. . . . . . YtdOtherLocalTax. . . . . . . Number      [30]      7.2
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [31]      0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [32]      0.
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [33]      0.
 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [34]      0.
 Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [35]      0.
 Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [36]      0.
 Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [37]      0.
 Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [38]      0.
 Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [39]      0.
 Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [40]      0.
 Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [41]      0.
 Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [42]      0.
 Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [43]      0.
 Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [44]      0.
 Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [45]      0.
                                                                                   ________
                                                                      Total Bytes  379