TC_P8 T/C Job Distribution Tax Summary File (TC_P8JobDistTaxSummary) Level: 4.40 Record Type: 1 T/C Job Distribution Tax Summary File 08/28/2009 File Type: Direct Key Size: 16 Rec Len: 320 Min Len: 16 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Entry Number. . . . . . . . . . . . . . EntryNumber . . . . . . . . . String *(10,1) State Code (Spaces For Federal) . . . . StateCode . . . . . . . . . . String *(11,3) Local Code (Spaces For Federal) . . . . LocalCode . . . . . . . . . . String *(14,3) Gross Wages . . . . . . . . . . . . . . GrossWages. . . . . . . . . . Number [0] 9.2 Wages Subject To Regular W/H. . . . . . WageSubjectToRegularWH. . . . Number [1] 9.2 Wages Subject To Supplemental W/H . . . WageSubjToSupplementalWH. . . Number [2] 9.2 Wages Subject To Employee Fica/Sdi/Ldi. WageSubjToEmployeeFica_Sdi. . Number [3] 9.2 Wages Subj To Empr Fica/Emp Sui/Ol ). . WageSubjToEmprFica_Sui_OL . . Number [4] 9.2 Wages Subject To Unemployment . . . . . WageSubjectToUnemployment . . Number [5] 9.2 Taxable Tips Reported . . . . . . . . . TaxableTipsReported . . . . . Number [6] 9.2 Tips Deemed To Be Wages . . . . . . . . TipsDeemedToBeWages . . . . . Number [7] 9.2 Earned Income Credit. . . . . . . . . . EarnedIncomeCredit. . . . . . Number [8] 9.2 Withholding Tax . . . . . . . . . . . . WithholdingTax. . . . . . . . Number [9] 9.2 Employee Fica/Sdi/Ldi . . . . . . . . . EmployeeFica_Sdi_Ldi. . . . . Number [10] 9.2 Emplr Fica/Empl Sui/Other Local Tax . . EmplrFicaEmplSuiOL. . . . . . Number [11] 9.2 Unemployment Tax. . . . . . . . . . . . UnemploymentTax . . . . . . . Number [12] 9.2 No. Days Worked . . . . . . . . . . . . NoDaysWorked. . . . . . . . . Number [13] 4.2 No. Weeks Worked. . . . . . . . . . . . NoWeeksWorked . . . . . . . . Number [14] 4.2 Hours Used In Tips Calculation. . . . . HrsUsedInTipsCalculation. . . Number [15] 5.2 Non-Tip Earning Amts Used In Tip Calc.. Non_TipEarningsUsedInTipCa. . Number [16] 9.2 Total Reg & O/T Hours Worked. . . . . . TotalRegAndOTHrsWorked. . . . Number [17] 6.2 'P'&'C' Deduction Amount. . . . . . . . P_C_DeductionAmount . . . . . Number [18] 9.2 Employee Medicare . . . . . . . . . . . EmployeeMedicare. . . . . . . Number [19] 6.2 Employer Medicare . . . . . . . . . . . EmployerMedicare. . . . . . . Number [20] 6.2 Wages Subject To Employee Medicare. . . WagesSubjToEmployeeMedicare . Number [21] 9.2 Wages Subject To Employer Medicare. . . WagesSubjToEmployerMedicare . Number [22] 9.2 ________ Total Bytes 317