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