PR_Employee P/R Employee Masterfile Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/PR"+%C$+"/PR_Employee.M4T"
KPRIMARY: DepartmentNo+EmployeeNo KSORT: SortField+DepartmentNo+EmployeeNo KNAME: LastName+FirstName+DepartmentNo+EmployeeNo KSOCIAL: SocialSecurityNumber+DepartmentNo+EmployeeNo KEMPLOYEE: EmployeeNo+DepartmentNo
Fld Column Name M/L TUR Description/Notes Class
1 DepartmentNo. . . . . . . . . 2 SYN Department Number . . . . . . .DEPARTMENT Mask:00 2 EmployeeNo. . . . . . . . . . 7 SYN Employee Number . . . . . . . .EMPLOYEENO FmtType:MASTERNUM 3 LastName. . . . . . . . . . . 15 SNN Employee Last Name. . . . . . . 4 FirstName . . . . . . . . . . 15 SNN Employee First Name . . . . . . 5 SortField . . . . . . . . . . 9 SNN Sort Field. . . . . . . . . . . 6 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . .ADDRESSLINE 7 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . .ADDRESSLINE 8 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .CITY 9 State . . . . . . . . . . . . 2 SNN State Code. . . . . . . . . . .STATE 10 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . .ZIPCODE 11 TelephoneNo . . . . . . . . . 17 SNN Telephone No. . . . . . . . . .TELEPHONENO 12 SocialSecurityNumber. . . . . 9 SNN Social Security Number. . . . . 13 MaritalStatus . . . . . . . . 1 SYN Marital Status (M/S). . . . . . Valid:M,S 14 Sex . . . . . . . . . . . . . 1 SYN Sex (M/F) . . . . . . . . . . . Valid:M,F 15 RaceCode. . . . . . . . . . . 1 SNN Race Code . . . . . . . . . . . 16 PensionProfitSharing. . . . . 1 SYN Yes/No. . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 17 HireDate. . . . . . . . . . . 8 SNN Hire Date . . . . . . . . . . .DATE 18 HireComment . . . . . . . . . 30 SNN Hire Comment. . . . . . . . . .COMMENT30 19 TerminationDate . . . . . . . 8 SNN Termination Inactive Date . . .DATE 20 TerminationComment. . . . . . 30 SNN Termination Inactive Comment. .COMMENT30 21 ReviewDate. . . . . . . . . . 8 SNN Review Date . . . . . . . . . .DATE 22 ReviewComment . . . . . . . . 30 SNN Review Comment. . . . . . . . .COMMENT30 23 EmergencyTelephoneNo. . . . . 17 SNN Emergency Telephone Number. . .TELEPHONENO 24 EmergencyContact. . . . . . . 30 SNN Emergency Contact . . . . . . . 25 LaborDistributionCode . . . . 7 SNN Labor Distribution Code . . . . 26 LaborSubCode. . . . . . . . . 9 SNN Labor Sub-Code. . . . . . . . . 27 PrimaryState. . . . . . . . . 2 SNN Primary State . . . . . . . . . 28 PrimaryLocal. . . . . . . . . 3 SNN Primary Local . . . . . . . . . 29 PayCycle. . . . . . . . . . . 1 SNN Pay Cycle . . . . . . . . . . . 30 PayMethod . . . . . . . . . . 1 SNN Pay Method. . . . . . . . . . . 31 EarnedIncomeCreditCode. . . . 3 SNN Earned Income Credit Code . . . 32 NewEntry. . . . . . . . . . . 1 SYN New Entry . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 33 DefaultWCCode . . . . . . . . 7 SNN Default W/C Code. . . . . . . . 34 DeptNumber. . . . . . . . . . 2 SYN DepartmentNumber. . . . . . . . Mask:00 35 BirthDate . . . . . . . . . . 8 SNN Birth Date. . . . . . . . . . .DATE 36 ExemptFromOvertime. . . . . . 1 SYN Exempt From Overtime. . . . . .YESNO DfltVal:N Valid:Y,N 37 NewYorkCityResident . . . . . 1 SYN New York City Resident. . . . .YESNO DfltVal:N Valid:Y,N 38 BenefitScheduleCode . . . . . 2 SNN Benefit Schedule Code . . . . . 39 StateForSUIContribution . . . 2 SNN State For SUI Contribution. . . 40 DirectDeposit . . . . . . . . 1 SYN Direct Deposit. . . . . . . . .YESNO DfltVal:N Valid:Y,N 41 EmployeeStatus. . . . . . . . 1 SYN Employee Status (A=Active, I=In Valid:A,I,T 42 StatutoryEmployee . . . . . . 1 SYN Statutory Employee. . . . . . .YESNO DfltVal:N Valid:Y,N 43 AutopayHours. . . . . . . . . 8.2 NNN Autopay Hours . . . . . . . . . Mask:##,###.00- 44 PayRate1. . . . . . . . . . . 13.2 NNN Pay Rate 1. . . . . . . . . . . Mask:##,###,###.00- 45 PayRate2. . . . . . . . . . . 13.2 NNN Pay Rate 2. . . . . . . . . . . Mask:##,###,###.00- 46 VacationHoursAccrued. . . . . 6.2 NNN Vacation Hours Accrued. . . . . Mask:###.00- 47 SickLeaveHoursAccrued . . . . 6.2 NNN Sick Leave Jours Accrued. . . . Mask:###.00- 48 VacationHoursUsed . . . . . . 6.2 NNN Vacation Hours Used . . . . . . Mask:###.00- 49 SickLeaveHoursUsed. . . . . . 6.2 NNN Sick Leave Hours Used . . . . . Mask:###.00- 50 DeductionFor401K. . . . . . . 13.2 NNN Deduction For 401K. . . . . . . Mask:##,###,###.00- 51 CafeteriaPlanDeduction. . . . 13.2 NNN Cafeteria Plan Deduction. . . . Mask:##,###,###.00- 52 AllocatedTips . . . . . . . . 13.2 NNN Allocated Tips. . . . . . . . . Mask:##,###,###.00- 53 FringeBenefits. . . . . . . . 13.2 NNN Fringe Benefits . . . . . . . . Mask:##,###,###.00- 54 NonQualifiedPlans . . . . . . 13.2 NNN Non-Qualified Plans (W2 Form) . Mask:##,###,###.00- 55 DependentCareBenefits . . . . 13.2 NNN Dependent Care Benefits (W2 For Mask:##,###,###.00- 56 HoursAccruedBenefit3. . . . . 6.2 NNN Hours Accrued (Third Benefit Ty Mask:###.00- 57 HoursUsedBenefit3 . . . . . . 6.2 NNN Hours Used (Third Benefit Type) Mask:###.00- 58 AnnualHourLimitVacation . . . 6.2 NNN Annual Hour Limit Vacation. . . Mask:###.00- 59 AnnualHourLimitSick . . . . . 6.2 NNN Annual Hour Limit Sick. . . . . Mask:###.00- 60 AnnualHourLimitBenefit3 . . . 6.2 NNN Annual Hour Limit Third Benefit Mask:###.00- 61 CarryOverHoursVacation. . . . 6.2 NNN Carry Over Hours Vacation . . . Mask:###.00- 62 CarryOverHoursSick. . . . . . 6.2 NNN Carry Over Hours Sick . . . . . Mask:###.00- 63 CarryOverHoursBenefit3. . . . 6.2 NNN Carry Over Hours Third Benefit. Mask:###.00- 64 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 65 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . Read Only:Y 66 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000 67 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 68 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . . Read Only:Y 69 UserUpdatedKey. . . . . . . . 10 SNN User Updated Key. . . . . . . .USER Read Only:Y Mask:0000000000