TC4 T/C Timecard History Sort File (TC4_TimecardHistorySort) Level: 4.40
Record Type: 1 Sort File For Tc3 By Labor Code 08/28/2009
File Type: Sort Key Size: 35 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Sort Type = "2" . . . . . . . . . . . . RecordNumber. . . . . . . . . String *(1,1)
Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . Uppercase *(2,7)
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(9,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(11,7)
Date Worked . . . . . . . . . . . . . . DateWorked. . . . . . . . . . Date *(18,6)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(24,3)
________
Total Bytes 28
TC4 T/C Timecard History Sort File (TC4_TimecardHistorySort) Level: 4.40
Record Type: 2 Sort File For Tc3 By Date Worked 08/28/2009
File Type: Sort Key Size: 35 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Sorte Type = "4". . . . . . . . . . . . RecordNumber. . . . . . . . . String *(1,1)
Date Worked . . . . . . . . . . . . . . DateWorked. . . . . . . . . . Date *(2,6)
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(8,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(10,7)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(17,3)
________
Total Bytes 21
TC4 T/C Timecard History Sort File (TC4_TimecardHistorySort) Level: 4.40
Record Type: 3 Sort File For Tc3 By Emplee-Earn Code 08/28/2009
File Type: Sort Key Size: 35 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Sort Type = "6" . . . . . . . . . . . . RecordNumber. . . . . . . . . String *(1,1)
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(2,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(4,7)
Earnings Code . . . . . . . . . . . . . EarningsCode. . . . . . . . . Zero-Filled *(11,2)
Date Worked . . . . . . . . . . . . . . DateWorked. . . . . . . . . . Date *(13,6)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(19,3)
________
Total Bytes 23
TC4 T/C Timecard History Sort File (TC4_TimecardHistorySort) Level: 4.40
Record Type: 4 Sort File For Tc3 By Job-Cost Code 08/28/2009
File Type: Sort Key Size: 35 Rec Len: Min Len: Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Sort Type = "8" . . . . . . . . . . . . RecordNumber. . . . . . . . . String *(1,1)
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(2,7)
Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(9,9)
Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(18,2)
Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(20,7)
Date Worked . . . . . . . . . . . . . . DateWorked. . . . . . . . . . Date *(27,6)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(33,3)
________
Total Bytes 37