TC_PT T/C Tax Working File (TC_PTTaxWorking) Level: 4.40 Record Type: 1 P/R Empr Fica, Unempl Tax Work File 08/28/2009 File Type: Direct Key Size: 15 Rec Len: 330 Min Len: 15 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) State Tax Code. . . . . . . . . . . . . StateTaxCode. . . . . . . . . String *(10,3) Local Tax Code. . . . . . . . . . . . . LocalTaxCode. . . . . . . . . String *(13,3) Total Fica Earnings . . . . . . . . . . TotalFicaEarnings . . . . . . Number [0] 9.2 Total Unemployment Earnings . . . . . . TotalUnemploymentEarnings . . Number [1] 9.2 Remaining Fica Total Earnings . . . . . RemainingFicaTotalEarnings. . Number [2] 9.2 Remaining Unemployment Total Earnings . RemainingUnemploTotalEarn . . Number [3] 9.2 Employer Fica Earnings. . . . . . . . . EmployerFicaEarnings. . . . . Number [4] 9.2 Employer Fica Tax . . . . . . . . . . . EmployerFicaTax . . . . . . . Number [5] 9.2 Remaining Employer Fica Earnings. . . . RemainingEmployerFicaEarnings Number [6] 9.2 Remaining Employer Fica Tax . . . . . . RemainingEmployerFicaTax. . . Number [7] 9.2 Unemployment Earnings . . . . . . . . . UnemploymentEarnings. . . . . Number [8] 9.2 Unemployment Tax. . . . . . . . . . . . UnemploymentTax . . . . . . . Number [9] 9.2 Remaining Unemployment Earnings . . . . RemainingUnemploymentEarnings Number [10] 9.2 Remaining Unemployment Tax. . . . . . . RemainingUnemploymentTax. . . Number [11] 9.2 Total Tips Reported . . . . . . . . . . TotalTipsReported . . . . . . Number [12] 9.2 Remaining Total Tips Reported . . . . . RemainingTotalTipsReported. . Number [13] 9.2 Total Tips Deemed To Be Wages . . . . . TotalTipsDeemedToBeWages. . . Number [14] 9.2 Remaining Total Tips Deemed To Be Wages RemainiTotalTipsDeemedWages . Number [15] 9.2 Total Medicare Earnings . . . . . . . . TotalMedicareEarnings . . . . Number [16] 9.2 Remaining Total Medicare Earn . . . . . RemainingTotalMedicareEarn. . Number [17] 9.2 Employer Medicare Earnings. . . . . . . EmployerMedicareEarnings. . . Number [18] 9.2 Employer Medicare Tax . . . . . . . . . EmployerMedicareTax . . . . . Number [19] 9.2 Remaining Employer Medicare Earn. . . . RemainingEmployerMedicareEarn Number [20] 9.2 Remaining Employer Medicare Tax . . . . RemainingEmployerMedicareTax. Number [21] 9.2 ________ Total Bytes 325