     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