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