TCA    T/C Employee Master File (TCA_EmployeeMasterfile)                        Level: 4.40
        Record Type: 1    Employee Masterfile                                    08/28/2009
 
 File Type: Direct   Key Size: 9    Rec Len: 68      Min Len: 36     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)
 Timeclock Password. . . . . . . . . . . TimeclockPassword . . . . . . String      (10,7)
 Default Regular Time Earnings Code. . . DefaultRegularTimeEarningsCodeZero-Filled (17,2)
 Default Overtime Earnings Code. . . . . DefaultOvertimeEarningsCode . Zero-Filled (19,2)
 Shift Code. . . . . . . . . . . . . . . ShiftCode . . . . . . . . . . Zero-Filled (21,2)
 Default Unsched Earnings Code . . . . . DefaultUnschedEarningsCode. . Zero-Filled (23,2)
 Badge Number. . . . . . . . . . . . . . BadgeNumber . . . . . . . . . Uppercase   (25,10)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (35,2)
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0]       0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1]       0.
                                                                                   ________
                                                                      Total Bytes  40