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