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.