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