     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