TCB T/C Timeclock Master File (TCB_TimeclockMasterfile) Level: 4.40 Record Type: 1 Timeclock Masterfile 08/28/2009 File Type: Direct Key Size: 18 Rec Len: 338 Min Len: 169 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) Status: B=Ok, E=Edited . . . . . . . . Status. . . . . . . . . . . . String (19,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,1) Department. . . . . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled (21,2) Regular Time Earnings Code. . . . . . . RegularTimeEarninsCode. . . . 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) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (51,2) Supervisor Id . . . . . . . . . . . . . SupervisorID. . . . . . . . . Uppercase (53,3) Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String (56,7) Local Code. . . . . . . . . . . . . . . LocalCode . . . . . . . . . . String (63,3) Time Punched In . . . . . . . . . . . . TimePunchedIn . . . . . . . . String (66,5) Date Punched Out. . . . . . . . . . . . DatePunchedOut. . . . . . . . Date (71,6) Time Punched Out. . . . . . . . . . . . TimePunchedOut. . . . . . . . String (77,5) Overtime Hours Earnings Code. . . . . . OvertimeHoursEarningsCode . . Zero-Filled (82,2) Unaccounted For Hours Earning Code. . . UnaccountedForHoursEarningCodeZero-Filled (84,2) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (86,21) S: Date Worked. . . . . . . . . . . . . S_DateWorked. . . . . . . . . Date (107,6) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (113,5) S: Department . . . . . . . . . . . . . S_Department. . . . . . . . . Zero-Filled (118,2) S: Regular Time Earnings Code . . . . . S_RegularTimeEarningsCode . . Zero-Filled (120,2) S: Job Number . . . . . . . . . . . . . S_JobNumber . . . . . . . . . Uppercase (122,7) S: Cost Code. . . . . . . . . . . . . . S_CostCode. . . . . . . . . . Account (129,9) S: W/C Code . . . . . . . . . . . . . . S_WCCode. . . . . . . . . . . String (138,7) S: State Code . . . . . . . . . . . . . S_StateCode . . . . . . . . . String (145,3) Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (148,5) S: Labor Code . . . . . . . . . . . . . S_LaborCode . . . . . . . . . String (153,7) S: Local Code . . . . . . . . . . . . . S_LocalCode . . . . . . . . . String (160,3) S: Time Punched In. . . . . . . . . . . S_TimePunchedIn . . . . . . . String (163,5) S: Date Punched Out . . . . . . . . . . S_DatePunchedOut. . . . . . . Date (168,6) S: Time Punched Out . . . . . . . . . . S_TimePunchedOut. . . . . . . String (174,5) S: Overtime Hours Earnings Code . . . . S_OvertimeHoursEarningsCode . Zero-Filled (179,2) S: Unaccounted For Earnings Code. . . . S_UnaccountedForEarningsCode. Zero-Filled (181,2) Open String . . . . . . . . . . . . . . _S6 . . . . . . . . . . . . . Open String (183,21) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Regular Hours Worked (Inc Vac/Sck). . . RegularHoursWorked. . . . . . Number [1] 6.2 Overtime Hours Worked . . . . . . . . . OvertimeHoursWorked . . . . . Number [2] 6.2 Other Hours Reported. . . . . . . . . . OtherHoursReported. . . . . . Number [3] 6.2 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0. S: Regular Hours Worked . . . . . . . . S_RegularHoursWorked. . . . . Number [7] 6.2 S: Overtime Hours Worked. . . . . . . . S_OvertimeHoursWorked . . . . Number [8] 6.2 S: Other Hours Reported . . . . . . . . S_OthersHoursReported . . . . Number [9] 6.2 Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [10] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [11] 0. ________ Total Bytes 277