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