PR1 P/R Employee Master File (PR1_EmployeeMaster) Level: 4.40 Record Type: 1 P/R Employee Master File 08/28/2009 File Type: Mkeyed Key Size: 9 Rec Len: 582 Min Len: 370 Define: Y
Main Key (KNO=0)Department(1,2)+EmployeeNumber(3,7) 2nd Key (KNO=1) SortField(40,9)+Department(1,2)+EmployeeNumber(3,7) 3rd Key (KNO=2) LastName(10,15)+FirstName(25,15)+Department(1,2)+EmployeeNumber(3,7) 4th Key (KNO=3) SocialSecurityNumber(151,9)+Department(1,2)+EmployeeNumber(3,7) 5th Key (KNO=4) EmployeeNumber(3,7)+Department(1,2)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2) Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account *(3,7) Last Name . . . . . . . . . . . . . . . LastName. . . . . . . . . . . String (10,15) First Name. . . . . . . . . . . . . . . FirstName . . . . . . . . . . String (25,15) Sort Field. . . . . . . . . . . . . . . SortField . . . . . . . . . . String (40,9) Address Line 1. . . . . . . . . . . . . AddressLine1. . . . . . . . . String (49,30) Address Line 2. . . . . . . . . . . . . AddressLine2. . . . . . . . . String (79,30) City. . . . . . . . . . . . . . . . . . City. . . . . . . . . . . . . String (109,20) State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . String (129,2) Zip Code. . . . . . . . . . . . . . . . ZipCode . . . . . . . . . . . String (131,10) Telephone Number. . . . . . . . . . . . TelephoneNumber . . . . . . . Phone (141,10) Social Security Number. . . . . . . . . SocialSecurityNumber. . . . . Account (151,9) Marital Status (M/S). . . . . . . . . . MaritalStatus . . . . . . . . String (160,1) Sex (M/F) . . . . . . . . . . . . . . . Sex . . . . . . . . . . . . . String (161,1) Race Code . . . . . . . . . . . . . . . RaceCode. . . . . . . . . . . String (162,1) Pension/Profit Sharing? (Y/N) . . . . . PensionProfitSharing. . . . . Yes/No (163,1) Hire Date . . . . . . . . . . . . . . . HireDate. . . . . . . . . . . Date (164,6) Hire Comment. . . . . . . . . . . . . . HireComment . . . . . . . . . String (170,30) Termination Inactive Date . . . . . . . TerminationDate . . . . . . . Date (200,6) Termination Inactive Comment. . . . . . TerminationComment. . . . . . String (206,30) Review Date . . . . . . . . . . . . . . ReviewDate. . . . . . . . . . Date (236,6) Review Comment. . . . . . . . . . . . . ReviewComment . . . . . . . . String (242,30) Emergency Phone Number. . . . . . . . . EmergencyPhoneNumber. . . . . Phone (272,10) Emergency Contact . . . . . . . . . . . EmergencyContact. . . . . . . String (282,30) Labor Distribution Code . . . . . . . . LaborDistributionCode . . . . String (312,7) Labor Sub-Code. . . . . . . . . . . . . LaborSubcode. . . . . . . . . String (319,9) Primary State . . . . . . . . . . . . . PrimaryState. . . . . . . . . String (328,3) Primary Local . . . . . . . . . . . . . PrimaryLocal. . . . . . . . . String (331,3) Pay Cycle . . . . . . . . . . . . . . . PayCycle. . . . . . . . . . . String (334,1) Pay Method. . . . . . . . . . . . . . . PayMethod . . . . . . . . . . String (335,1) Earned Income Credit Code . . . . . . . EarnedIncomeCreditCode. . . . String (336,3) New Entry?. . . . . . . . . . . . . . . NewEntry. . . . . . . . . . . Yes/No (339,1) Default W/C Code. . . . . . . . . . . . DefaultWCCode . . . . . . . . String (340,7) Department Number . . . . . . . . . . . DeptNumber. . . . . . . . . . Zero-Filled (347,2) Birth Date. . . . . . . . . . . . . . . BirthDate . . . . . . . . . . Date (349,6) Exempt From Overtime (Y/N). . . . . . . ExemptFromOvertime. . . . . . Yes/No (355,1) New York City Resident (Y/N). . . . . . NewYorkCityResident . . . . . Yes/No (356,1) Benefit Schedule Code . . . . . . . . . BenefitScheduleCode . . . . . Uppercase (357,2) State For Sui Contribution. . . . . . . StateForSUIContribution . . . Uppercase (359,3) Direct Deposit? . . . . . . . . . . . . DirectDeposit . . . . . . . . Yes/No (362,1) Employee Status (AIT) . . . . . . . . . EmployeeStatus_AIT. . . . . . Uppercase (363,1) A=Active, I=Inactive, T=Termin. . . . . . . . . . . . . . . . . . . Memo Statutory Employee Indicator. . . . . . StatutoryEmployee . . . . . . Yes/No (364,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (365,6) Autopay Hours . . . . . . . . . . . . . AutopayHours. . . . . . . . . Number [0] 5.2 Pay Rate 1. . . . . . . . . . . . . . . PayRate1. . . . . . . . . . . Number [1] 8.2 Pay Rate 2. . . . . . . . . . . . . . . PayRate2. . . . . . . . . . . Number [2] 8.2 Vacation Hours Accrued. . . . . . . . . VacationHoursAccrued. . . . . Number [3] 3.2 Sick Leave Hours Accrued. . . . . . . . SickLeaveHoursAccrued . . . . Number [4] 3.2 Vacation Hours Used . . . . . . . . . . VacationHoursUsed . . . . . . Number [5] 3.2 Sick Leave Hours Used . . . . . . . . . SickLeaveHoursUsed. . . . . . Number [6] 3.2 401K Deduction. . . . . . . . . . . . . DeductionFor401K. . . . . . . Number [7] 8.2 Cafeteria Plan Deduction. . . . . . . . CafeteriaPlanDeduction. . . . Number [8] 8.2 Allocated Tips. . . . . . . . . . . . . AllocatedTips . . . . . . . . Number [9] 8.2 Fringe Benefits . . . . . . . . . . . . FringeBenefits. . . . . . . . Number [10] 8.2 Non-Qualified Plans (W2 Form) . . . . . NonqualifiedPlans . . . . . . Number [11] 8.2 Dependent Care Benefits (W2 Form) . . . DependentCareBenefits . . . . Number [12] 8.2 Hours Accrued (Third Benefit Type). . . HoursAccruedBenefit3. . . . . Number [13] 3.2 Hours Used (Third Benefit Type) . . . . HoursUsedBenefit3 . . . . . . Number [14] 3.2 Annual Hour Limit (Vacation). . . . . . AnnualHourLimitVacation . . . Number [15] 3.2 Annual Hour Limit (Sick). . . . . . . . AnnualHourLimitSick . . . . . Number [16] 3.2 Annual Hour Limit (Third Benefit) . . . AnnualHourLimitBenefit3 . . . Number [17] 3.2 Carry Over Hours (Vacation) . . . . . . CarryOverHoursVacation. . . . Number [18] 3.2 Carry Over Hours (Sick) . . . . . . . . CarryOverHoursSick. . . . . . Number [19] 3.2 Carry Over Hours (Third Benefit). . . . CarryOverHoursBenefit3. . . . Number [20] 3.2 ________ Total Bytes 582