     TCC    T/C Timeclock Selection File (TCC_TimeclockSelection)                    Level: 4.40
            Record Type: 1    Timeclock Selection File                               08/28/2009

     File Type: Direct   Key Size: 18   Rec Len: 338     Min Len: 203    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. . . . . . . RegularTimeEarningsCode . . . 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. . . UnaccountedHrsEarningCode . . Zero-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: Workmans Comp Code . . . . . . . . . S_WorkmansCompCode. . . . . . 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 Hrs Earnings Code. . S_UnaccountedHrsEarningCode . 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_OtherHoursReported. . . . . Number      [9]       6.2
     Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [10]      0.
     Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [11]      0.
                                                                                       ________
                                                                          Total Bytes  277