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