TC2 T/C Timecard Master Sort File (TC2_TimecardMasterSort) Level: 4.40 Record Type: 1 "2" -- Lc, Emp #, Date, Seq # 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
"2" Sorted For Labor Code. . . . . . . RecordNumber. . . . . . . . . String *(1,1) Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String *(2,7) Department Number . . . . . . . . . . . DepartmentNumber. . . . . . . Zero-Filled *(9,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(11,7) Date. . . . . . . . . . . . . . . . . . Date. . . . . . . . . . . . . Date *(18,6) Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(24,3) ________ Total Bytes 28
TC2 T/C Timecard Master Sort File (TC2_TimecardMasterSort) Level: 4.40 Record Type: 2 "4" -- Date, Emp #, Seq # 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
"4" Sorted For Date/E#/Seq . . . . . . RecordNumber. . . . . . . . . String *(1,1) Date. . . . . . . . . . . . . . . . . . Date. . . . . . . . . . . . . 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
TC2 T/C Timecard Master Sort File (TC2_TimecardMasterSort) Level: 4.40 Record Type: 3 "6" -- Emp #, Ec, Date, Seq # 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
"6" Sorted For Emp #/Ec/Date/Seq . . . 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. . . . . . . . . . . . . . . . . . Date. . . . . . . . . . . . . Date *(13,6) Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(19,3) ________ Total Bytes 23
TC2 T/C Timecard Master Sort File (TC2_TimecardMasterSort) Level: 4.40 Record Type: 4 "8" -- Job #/Cc 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
"8" Sorted For Job/Cc. . . . . . . . . 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. . . . . . . . . . . . . . . . . . Date. . . . . . . . . . . . . Date *(27,6) Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(33,3) ________ Total Bytes 37