TC_PK T/C Employer's Expense Report File (TC_PKEmplExpenseReport) Level: 4.40
Record Type: 1 T/C Employer's Expense Report - Taxes 08/28/2009
File Type: Direct Key Size: 22 Rec Len: 130 Min Len: 22 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"T" For Tax Expense . . . . . . . . . . RecordType. . . . . . . . . . String *(1,1)
Department Code Of Employee . . . . . . DepartmentCodeOfEmployee. . . Zero-Filled *(2,2)
State Tax Code. . . . . . . . . . . . . StateTaxCode. . . . . . . . . String *(4,3)
Local Tax Code. . . . . . . . . . . . . LocalTaxCode. . . . . . . . . String *(7,3)
Spaces For Taxes. . . . . . . . . . . . SpacesForTaxes. . . . . . . . String *(10,13)
Gross Earnings. . . . . . . . . . . . . GrossEarnings . . . . . . . . Number [0] 9.2
Employer Fica Earnings. . . . . . . . . EmployerFicaEarnings. . . . . Number [1] 9.2
Employer Fica Tax . . . . . . . . . . . EmployerFicaTax . . . . . . . Number [2] 9.2
Unemployment Earnings . . . . . . . . . UnemploymentEarnings. . . . . Number [3] 9.2
Unemployment Tax. . . . . . . . . . . . UnemploymentTax . . . . . . . Number [4] 9.2
Employer Medicare Earnings. . . . . . . EmployerMedicareEarnings. . . Number [5] 9.2
Employer Medicare Tax . . . . . . . . . EmployerMedicareTax . . . . . Number [6] 9.2
________
Total Bytes 122
TC_PK T/C Employer's Expense Report File (TC_PKEmplExpenseReport) Level: 4.40
Record Type: 2 T/C Employer's Expense - Worker's Comp 08/28/2009
File Type: Direct Key Size: 22 Rec Len: 130 Min Len: 22 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"W" For Worker'S Comp . . . . . . . . . RecordType. . . . . . . . . . String *(1,1)
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(2,2)
State Tax Code. . . . . . . . . . . . . StateTaxCode. . . . . . . . . String *(4,3)
Workers' Comp Code. . . . . . . . . . . WorkersCompCode . . . . . . . String *(7,7)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . String *(14,9)
String Of X'S For Entry No. . . . . . . StringOfXs. . . . . . . . . . String (23,10)
Hours . . . . . . . . . . . . . . . . . Hours . . . . . . . . . . . . Number [0] 6.2
Earnings. . . . . . . . . . . . . . . . Earnings. . . . . . . . . . . Number [1] 9.2
Days Worked . . . . . . . . . . . . . . DaysWorked. . . . . . . . . . Number [2] 6.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0.
________
Total Bytes 74