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