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