     TC3    T/C Timecard History File (TC3_TimecardMastefile)                        Level: 4.40
            Record Type: 1    Timecard History File                                  08/28/2009

     File Type: Direct   Key Size: 18   Rec Len: 233     Min Len: 140    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)
     Workers Comp Code . . . . . . . . . . . WorkersCompCode . . . . . . . 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 By . . . . . . . UserID. . . . . . . . . . . . Uppercase   (53,3)
     Labor Code. . . . . . . . . . . . . . . LaborCode . . . . . . . . . . String      (56,7)
     Local Code. . . . . . . . . . . . . . . LocalCode . . . . . . . . . . String      (63,3)
     Source/Batch Number . . . . . . . . . . SourceBatchNumber . . . . . . 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)
     Aproved?. . . . . . . . . . . . . . . . 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]       6.2
     Lunch Actual Elapsed Time . . . . . . . LunchActualElapsedTime. . . . Number      [4]       6.2
     Lunch Reported Time . . . . . . . . . . LunchReportedTime . . . . . . Number      [5]       6.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  225