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