TC1 T/C Timecard Master File (TC1_TimecardMasterfile) Level: 4.40 Record Type: 1 Timecard Masterfile 08/28/2009 File Type: Direct Key Size: 18 Rec Len: 281 Min Len: 150 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) Date Worked . . . . . . . . . . . . . . DateWorked. . . . . . . . . . Date *(10,6) Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(16,3) Shift Code. . . . . . . . . . . . . . . ShiftCode . . . . . . . . . . Zero-Filled (19,2) Department Worked . . . . . . . . . . . DepartmentWorked. . . . . . . Zero-Filled (21,2) Earnings Code . . . . . . . . . . . . . EarningsCode. . . . . . . . . Zero-Filled (23,2) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase (25,7) Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account (32,9) Workmans Comp Code. . . . . . . . . . . WorkmansCompCode. . . . . . . String (41,7) State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . String (48,3) P/R Update Status . . . . . . . . . . . PRUpdateStatus. . . . . . . . Uppercase (51,1) J/C Update Status . . . . . . . . . . . JCUpdateStatus. . . . . . . . Uppercase (52,1) User Id--Last Changed . . . . . . . . . UserID. . . . . . . . . . . . Uppercase (53,3) Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String (56,7) Local Code. . . . . . . . . . . . . . . LocalCode . . . . . . . . . . String (63,3) Batch/Source. . . . . . . . . . . . . . BatchSource . . . . . . . . . String (66,8) Time Punched In . . . . . . . . . . . . TimePunchedIn . . . . . . . . String (74,5) Time Punched Out. . . . . . . . . . . . TimePunchedOut. . . . . . . . String (79,5) Exception Codes . . . . . . . . . . . . ExceptionCodes. . . . . . . . String (84,20) Series Number . . . . . . . . . . . . . SeriesNumber. . . . . . . . . String (104,7) Approved? . . . . . . . . . . . . . . . Approved. . . . . . . . . . . Uppercase (111,1) Lunch Punch Out . . . . . . . . . . . . LunchPunchOut . . . . . . . . Uppercase (112,5) Lunch Punch In. . . . . . . . . . . . . LunchPunchIn. . . . . . . . . Uppercase (117,5) Actual Date Punch In For Repunch. . . . ActualDatePunchInForRepunch . Date (122,6) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (128,23) Hours Worked. . . . . . . . . . . . . . HoursWorked . . . . . . . . . Number [0] 6.2 Rate. . . . . . . . . . . . . . . . . . Rate. . . . . . . . . . . . . Number [1] 5.3 Amount. . . . . . . . . . . . . . . . . Amount. . . . . . . . . . . . Number [2] 9.2 Actual Elapsed Time . . . . . . . . . . ActualElapsedTime . . . . . . Number [3] 9.2 Lunch Actual Elapsed Time . . . . . . . LunchActualElapsedTime. . . . Number [4] 9.2 Lunch Reported Time . . . . . . . . . . LunchReportedTime . . . . . . Number [5] 9.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [9] 0. ________ Total Bytes 234