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