PR1_EmployeeMaster PR1 Employee Master Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/PR"+%C$+"/PR1"+%C$+".SOA"
Fld Column Name M/L TUR Description/Notes Class
1 DepartmentNumber. . . . . . . 2 SNN Department Number . . . . . . . 2 EmployeeNumber. . . . . . . . 7 SNN Employee Number . . . . . . . . 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. . . . . . . . . 7 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . . 8 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . . 9 State . . . . . . . . . . . . 2 SNN State Code. . . . . . . . . . . 10 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . . 11 TelephoneNumber . . . . . . . 10 SNN Telephone No. . . . . . . . . . 12 SocialSecurityNumber. . . . . 9 SNN Social Security Number. . . . . 13 MaritalStatus . . . . . . . . 1 SYN Marital Status. . . . . . . . . Valid:M,S Notes: M=Married, S=Single 14 Sex . . . . . . . . . . . . . 1 SYN Sex . . . . . . . . . . . . . . Valid:M,F Notes: M=Male, F=Female 15 RaceCode. . . . . . . . . . . 1 SYN Race Code . . . . . . . . . . . 16 PensionProfitSharing. . . . . 1 SYN Pension/Profit Sharing. . . . .YESNO DfltVal:N Valid:Y,N 17 HireDate. . . . . . . . . . . 6 SNN Hire Date . . . . . . . . . . .DATE*MAS90 18 HireComment . . . . . . . . . 30 SNN Hire Comment. . . . . . . . . . 19 TerminationDate . . . . . . . 6 SNN Termination Inactive Date . . .DATE*MAS90 20 TerminationComment. . . . . . 30 SNN Termination Inactive Comment. . 21 ReviewDate. . . . . . . . . . 6 SNN Review Date . . . . . . . . . .DATE*MAS90 22 ReviewComment . . . . . . . . 30 SNN Review Comment. . . . . . . . . 23 EmergencyTelephoneNumber. . . 10 SNN Emergency Telephone Number. . . 24 EmergencyContact. . . . . . . 30 SNN Emergency Contact . . . . . . . 25 LaborDistributionCode . . . . 7 SNN Labor Distribution Code . . . . 26 LaborSubCode. . . . . . . . . 9 SNN Labor Sub-Code. . . . . . . . . 27 PrimaryState. . . . . . . . . 3 SYN 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 SNN DepartmentNumber. . . . . . . . 35 BirthDate . . . . . . . . . . 6 SNN Birth Date. . . . . . . . . . .DATE*MAS90 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 . . . 3 SNN State For SUI Contribution. . . 40 DirectDeposit . . . . . . . . 1 SYN Direct Deposit. . . . . . . . .YESNO DfltVal:N Valid:Y,N 41 EmployeeStatus_AIT. . . . . . 1 SYN Employee Status . . . . . . . . Valid:A,I,T Notes: A=Active, I=Inactive, T=Terminated 42 StatutoryEmployee . . . . . . 1 SNN Statutory Employee. . . . . . .YESNO DfltVal:N Valid:Y,N 43 OpenString. . . . . . . . . . 6 SNN OpenString. . . . . . . . . . . 44 AutopayHours. . . . . . . . . 8.2 NNN Autopay Hours . . . . . . . . . 45 PayRate1. . . . . . . . . . . 13.2 NNN Pay Rate 1. . . . . . . . . . . 46 PayRate2. . . . . . . . . . . 13.2 NNN Pay Rate 2. . . . . . . . . . . 47 VacationHoursAccrued. . . . . 6.2 NNN Vacation Hours Accrued. . . . . 48 SickLeaveHoursAccrued . . . . 6.2 NNN Sick Leave Jours Accrued. . . . 49 VacationHoursUsed . . . . . . 6.2 NNN Vacation Hours Used . . . . . . 50 SickLeaveHoursUsed. . . . . . 6.2 NNN Sick Leave Hours Used . . . . . 51 DeductionFor401K. . . . . . . 13.2 NNN Deduction For 401K. . . . . . . 52 CafeteriaPlanDeduction. . . . 13.2 NNN Cafeteria Plan Deduction. . . . 53 AllocatedTips . . . . . . . . 13.2 NNN Allocated Tips. . . . . . . . . 54 FringeBenefits. . . . . . . . 13.2 NNN Fringe Benefits . . . . . . . . 55 NonqualifiedPlans . . . . . . 13.2 NNN Non-Qualified Plans (W2 Form) . 56 DependentCareBenefits . . . . 13.2 NNN Dependent Care Benefits (W2 For 57 HoursAccruedBenefit3. . . . . 6.2 NNN Hours Accrued (Third Benefit Ty 58 HoursUsedBenefit3 . . . . . . 6.2 NNN Hours Used (Third Benefit Type) 59 AnnualHourLimitVacation . . . 6.2 NNN Annual Hour Limit Vacation. . . 60 AnnualHourLimitSick . . . . . 6.2 NNN Annual Hour Limit Sick. . . . . 61 AnnualHourLimitBenefit3 . . . 6.2 NNN Annual Hour Limit Third Benefit 62 CarryOverHoursVacation. . . . 6.2 NNN Carry Over Hours Vacation . . . 63 CarryOverHoursSick. . . . . . 6.2 NNN Carry Over Hours Sick . . . . . 64 CarryOverHoursBenefit3. . . . 6.2 NNN Carry Over Hours Third Benefit.