     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.