     PR1    P/R Employee Master File (PR1_EmployeeMaster)                            Level: 4.40
            Record Type: 1    P/R Employee Master File                               08/28/2009

     File Type: Mkeyed   Key Size: 9    Rec Len: 582     Min Len: 370    Define: Y

     Main Key (KNO=0)Department(1,2)+EmployeeNumber(3,7)
     2nd Key (KNO=1) SortField(40,9)+Department(1,2)+EmployeeNumber(3,7)
     3rd Key (KNO=2) LastName(10,15)+FirstName(25,15)+Department(1,2)+EmployeeNumber(3,7)
     4th Key (KNO=3) SocialSecurityNumber(151,9)+Department(1,2)+EmployeeNumber(3,7)
     5th Key (KNO=4) EmployeeNumber(3,7)+Department(1,2)

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Department Number . . . . . . . . . . . Department. . . . . . . . . . Zero-Filled *(1,2)
     Employee Number . . . . . . . . . . . . EmployeeNumber. . . . . . . . Account     *(3,7)
     Last Name . . . . . . . . . . . . . . . LastName. . . . . . . . . . . String      (10,15)
     First Name. . . . . . . . . . . . . . . FirstName . . . . . . . . . . String      (25,15)
     Sort Field. . . . . . . . . . . . . . . SortField . . . . . . . . . . String      (40,9)
     Address Line 1. . . . . . . . . . . . . AddressLine1. . . . . . . . . String      (49,30)
     Address Line 2. . . . . . . . . . . . . AddressLine2. . . . . . . . . String      (79,30)
     City. . . . . . . . . . . . . . . . . . City. . . . . . . . . . . . . String      (109,20)
     State . . . . . . . . . . . . . . . . . State . . . . . . . . . . . . String      (129,2)
     Zip Code. . . . . . . . . . . . . . . . ZipCode . . . . . . . . . . . String      (131,10)
     Telephone Number. . . . . . . . . . . . TelephoneNumber . . . . . . . Phone       (141,10)
     Social Security Number. . . . . . . . . SocialSecurityNumber. . . . . Account     (151,9)
     Marital Status (M/S). . . . . . . . . . MaritalStatus . . . . . . . . String      (160,1)
     Sex (M/F) . . . . . . . . . . . . . . . Sex . . . . . . . . . . . . . String      (161,1)
     Race Code . . . . . . . . . . . . . . . RaceCode. . . . . . . . . . . String      (162,1)
     Pension/Profit Sharing? (Y/N) . . . . . PensionProfitSharing. . . . . Yes/No      (163,1)
     Hire Date . . . . . . . . . . . . . . . HireDate. . . . . . . . . . . Date        (164,6)
     Hire Comment. . . . . . . . . . . . . . HireComment . . . . . . . . . String      (170,30)
     Termination Inactive Date . . . . . . . TerminationDate . . . . . . . Date        (200,6)
     Termination Inactive Comment. . . . . . TerminationComment. . . . . . String      (206,30)
     Review Date . . . . . . . . . . . . . . ReviewDate. . . . . . . . . . Date        (236,6)
     Review Comment. . . . . . . . . . . . . ReviewComment . . . . . . . . String      (242,30)
     Emergency Phone Number. . . . . . . . . EmergencyPhoneNumber. . . . . Phone       (272,10)
     Emergency Contact . . . . . . . . . . . EmergencyContact. . . . . . . String      (282,30)
     Labor Distribution Code . . . . . . . . LaborDistributionCode . . . . String      (312,7)
     Labor Sub-Code. . . . . . . . . . . . . LaborSubcode. . . . . . . . . String      (319,9)
     Primary State . . . . . . . . . . . . . PrimaryState. . . . . . . . . String      (328,3)
     Primary Local . . . . . . . . . . . . . PrimaryLocal. . . . . . . . . String      (331,3)
     Pay Cycle . . . . . . . . . . . . . . . PayCycle. . . . . . . . . . . String      (334,1)
     Pay Method. . . . . . . . . . . . . . . PayMethod . . . . . . . . . . String      (335,1)
     Earned Income Credit Code . . . . . . . EarnedIncomeCreditCode. . . . String      (336,3)
     New Entry?. . . . . . . . . . . . . . . NewEntry. . . . . . . . . . . Yes/No      (339,1)
     Default W/C Code. . . . . . . . . . . . DefaultWCCode . . . . . . . . String      (340,7)
     Department Number . . . . . . . . . . . DeptNumber. . . . . . . . . . Zero-Filled (347,2)
     Birth Date. . . . . . . . . . . . . . . BirthDate . . . . . . . . . . Date        (349,6)
     Exempt From Overtime (Y/N). . . . . . . ExemptFromOvertime. . . . . . Yes/No      (355,1)
     New York City Resident (Y/N). . . . . . NewYorkCityResident . . . . . Yes/No      (356,1)
     Benefit Schedule Code . . . . . . . . . BenefitScheduleCode . . . . . Uppercase   (357,2)
     State For Sui Contribution. . . . . . . StateForSUIContribution . . . Uppercase   (359,3)
     Direct Deposit? . . . . . . . . . . . . DirectDeposit . . . . . . . . Yes/No      (362,1)
     Employee Status (AIT) . . . . . . . . . EmployeeStatus_AIT. . . . . . Uppercase   (363,1)
       A=Active, I=Inactive, T=Termin. . . . . . . . . . . . . . . . . . . Memo
     Statutory Employee Indicator. . . . . . StatutoryEmployee . . . . . . Yes/No      (364,1)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (365,6)
     Autopay Hours . . . . . . . . . . . . . AutopayHours. . . . . . . . . Number      [0]       5.2
     Pay Rate 1. . . . . . . . . . . . . . . PayRate1. . . . . . . . . . . Number      [1]       8.2
     Pay Rate 2. . . . . . . . . . . . . . . PayRate2. . . . . . . . . . . Number      [2]       8.2
     Vacation Hours Accrued. . . . . . . . . VacationHoursAccrued. . . . . Number      [3]       3.2
     Sick Leave Hours Accrued. . . . . . . . SickLeaveHoursAccrued . . . . Number      [4]       3.2
     Vacation Hours Used . . . . . . . . . . VacationHoursUsed . . . . . . Number      [5]       3.2
     Sick Leave Hours Used . . . . . . . . . SickLeaveHoursUsed. . . . . . Number      [6]       3.2
     401K Deduction. . . . . . . . . . . . . DeductionFor401K. . . . . . . Number      [7]       8.2
     Cafeteria Plan Deduction. . . . . . . . CafeteriaPlanDeduction. . . . Number      [8]       8.2
     Allocated Tips. . . . . . . . . . . . . AllocatedTips . . . . . . . . Number      [9]       8.2
     Fringe Benefits . . . . . . . . . . . . FringeBenefits. . . . . . . . Number      [10]      8.2
     Non-Qualified Plans (W2 Form) . . . . . NonqualifiedPlans . . . . . . Number      [11]      8.2
     Dependent Care Benefits (W2 Form) . . . DependentCareBenefits . . . . Number      [12]      8.2
     Hours Accrued (Third Benefit Type). . . HoursAccruedBenefit3. . . . . Number      [13]      3.2
     Hours Used (Third Benefit Type) . . . . HoursUsedBenefit3 . . . . . . Number      [14]      3.2
     Annual Hour Limit (Vacation). . . . . . AnnualHourLimitVacation . . . Number      [15]      3.2
     Annual Hour Limit (Sick). . . . . . . . AnnualHourLimitSick . . . . . Number      [16]      3.2
     Annual Hour Limit (Third Benefit) . . . AnnualHourLimitBenefit3 . . . Number      [17]      3.2
     Carry Over Hours (Vacation) . . . . . . CarryOverHoursVacation. . . . Number      [18]      3.2
     Carry Over Hours (Sick) . . . . . . . . CarryOverHoursSick. . . . . . Number      [19]      3.2
     Carry Over Hours (Third Benefit). . . . CarryOverHoursBenefit3. . . . Number      [20]      3.2
                                                                                       ________
                                                                          Total Bytes  582