 |
Lawson Insight Technical Documentation |
|
PAEMPLOYEE FILE
Employee Personnel Information
Contains all the employee information needed in the Lawson Payroll system.
The Personnel Employee file stores additional employee information used by the
Lawson Human Resources, Personnel, and Benefits systems. HR11 (Employee) is
the main program that updates this file.
REFERENCED BY
AC541 AC542 AC550 AC551 BN100 BN101
BN102 BN103 BN104 BN105 BN138 BN140
BN141 BN145 BN150 BN175 BN230 BN231
BN232 BN233 BN236 BN237 BN238 BN240
BN242 BN245 BN246 BN248 BN258 BN285
BN300 BN305 BN31.1 BN31.2 BN310 BN32.1
BN32.2 BN32.3 BN320 BN325 BN330 BN331
BN335 BN340 BN345 BN35.1 BN350 BN36.1
BN430 BN45.1 BN48.1 BN48.2 BN500 BN531
BN55.1 BN55.2 BN555 BN56.1 BN57.1 BN65.1
BN66.1 BN70.1 BN71.1 BN72.1 BS09.1 BS10.1
BS11.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1
HCEM.1 HCOP.1 HCOP.2 HR15.1 HR155 HR170
HR20.1 HR211 HR213 HR217 HR220 HR30.1
HR515 HR54.1 HR55.2 HR70.1 HRS1.1 HRSC.1
HS10.1 HS10.2 HS11.1 HS12.1 HS13.1 HS14.1
HS50.1 HS50.2 PA113 PA149 PA212 PA214
PA215 PA216 PA217 PA220 PA221 PA222
PA224 PA225 PA227 PA248 PA249 PA262
PA272 PA290 PA296 PA300 PA305 PA31.1
PA310 PA311 PA315 PA320 PA325 PA330
PA335 PA345 PA350 PA355 PA360 PA370
PA372 PA390 PA391 PA393 PA406 PA490
PA496 PA53.1 PA531 PA532 PA533 PA54.1
PA59.1 PA590 PA594 PA64.1 PA64.2 PA66.2
PA66.3 PA90.1 TR120 TR121 TR20.1 TR20.2
TR20.3 TR207 PR128 PR130 PR131 PR132
PR134 PR136 PR14.1 PR140 PR15.2 PR160
PR188 PR189 PR195 PR197 PR205 PR240
PR241 PR242 PR243 PR244 PR245 PR250
PR251 PR252 PR253 PR282 PR29.1 PR292
PR293 PR296 PR297 PR298 PR299 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR36.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 PR88.1 PR89.1
PRSC.1 UK102 UK110 TA147 UK120 HRLRD
UPDATED BY
BN180 BN47.1 BN547 BN80.1 BN90.1 HR11.1
HR11.2 HR12.1 HR13.1 HR511 HR513 HR650
HR90.1 HR90.2 PA02.1 PA100 PA102 PA115
PA12.1 PA13.1 PA13.2 PA14.1 PA15.1 PA16.1
PA17.1 PA20.1 PA21.1 PA218 PA22.1 PA24.1
PA26.1 PA27.1 PA34.1 PA35.1 PA36.1 PA38.1
PA41.1 PA502 PA512 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA520 PA96.1 TR21.1 TR22.1
TR26.1 TR500 PR110 PR113 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR84.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEM-COMPANY Numeric 4 HR11.1 HR11.2
Company Contains the number that represents an HR511 HR650
established company and is entered on PA02.1 PA100
all functions. PA102 PA14.1
PA15.1 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-EMPLOYEE Numeric 9 HR11.1 HR11.2
Employee Contains the employee number. An HR511 HR650
employee number is assigned to each PA02.1 PA100
person employed by the company. The PA102 PA14.1
system uses the employee number to PA15.1 PA17.1
correlate all information related to the PA502 PA52.1
employee. This number must be valid in PA52.3 PA52.4
the Employee file. PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-SUPP-ADDR1 Alpha 30 (Lower Case) HR11.1 HR11.2
Supplemental Address Contains the first line of the HR511 HR650
supplemental address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-ADDR2 Alpha 30 (Lower Case) HR11.1 HR11.2
Supplemental Contains the second line of the HR511 HR650
Address 2 supplemental address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-ADDR3 Alpha 30 (Lower Case) HR11.1 HR11.2
Supp Addr3 Contains the third line of the HR511 HR650
supplemental address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-ADDR4 Alpha 30 (Lower Case) HR11.1 HR11.2
Supp Addr4 Contains the fourth line of the HR511 HR650
supplemental address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-CITY Alpha 18 (Lower Case) HR11.1 HR11.2
Supplemental Contains the city of the supplemental HR511 HR650
Address City address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-STATE Alpha 2 HR11.1 HR11.2
Suppl. Address Contains the state of the supplemental HR511 HR650
State/Province address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-ZIP Alpha 10 HR11.1 HR11.2
Suppl. Address Contains the postal code of the HR511 HR650
Postal Code supplemental address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-CNTRY-CD Alpha 2 HR11.1 HR11.2
Supp Cntry Cd Contains the country of the HR511 HR650
supplemental address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HM-PHONE-CNTRY Alpha 6 HR11.1 HR11.2
Hm Phone Cntry Contains the country code of the HR511 HR650
employee's home telephone number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HM-PHONE-NBR Alpha 15 HR11.1 HR11.2
Hm Phone Nbr Contains the employee's home telephone HR511 HR650
number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-WK-PHONE-CNTRY Alpha 6 HR11.1 HR11.2
Work Telephone Contains the country code of the HR511 HR650
Country employee's work telephone number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-WK-PHONE-NBR Alpha 15 HR11.1 HR11.2
Work Telephone Contains the employee's work telephone HR511 HR650
number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-WK-PHONE-EXT Alpha 5 HR11.1 HR11.2
Work Telephone Contains the extension of the HR511 HR650
Extension employee's work telephone number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-EEO-CLASS Alpha 4 (Lower Case) HCOP.2 HR11.1
EEO Class Contains the employee's ethnic origin. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-SEX Alpha 1 HCOP.2 HR11.1
Gender Contains the employee's gender. HR11.2 HR511
F = Female HR650 PA02.1
M = Male PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-HANDICAP-ID Alpha 1 HR11.1 HR11.2
Disability Indicates if the employee is disabled. HR511 HR650
Y = Yes PA02.1 PA100
N = No PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-COMP-CODE Alpha 4 HR11.1 HR11.2
Miscellaneous Code Contains miscellaneous data. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-COMP-NBR Alpha 10 HR11.1 HR11.2
Miscellaneous Number Contains miscellaneous data. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-VETERAN Alpha 1 HR11.1 HR11.2
Veteran Indicates the individual is a veteran. HR511 HR650
1 = Veteran PA02.1 PA100
2 = Disabled Veteran PA102 PA14.1
3 = Vietnam Era Veteran PA502 PA52.1
4 = Vietnam Era Disabled Veteran PA52.3 PA52.4
5 = Gulf War Era Veteran PA52.5 PR110
6 = Special Disabled Veteran PR113 PR120
N = No PR13.1 PR13.5
Y = Yes PR13.6 PR13.8
PEM-BIRTHDATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Birthdate Contains the employee's birthdate. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PA90.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BIRTH-CITY Alpha 18 (Lower Case) HR11.1 HR11.2
Birth Place: City Contains the city where the employee HR511 HR650
was born. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BIRTH-STATE Alpha 2 HR11.1 HR11.2
Birth Place: Contains the two-character abbreviation HR511 HR650
State/Province of the state where the employee was PA02.1 PA100
born. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BIRTH-CNTRY-CD Alpha 2 HR11.1 HR11.2
Birth Cntry Cd Indicates country where employee was HR511 HR650
born. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SENIOR-DATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Seniority Date Contains the employee's seniority date. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR84.1
PEM-MAIDEN-LST-NM Alpha 30 (Lower Case) HR11.1 HR11.2
Maiden Last Name Contains the employee's maiden last HR511 HR650
name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-MAIDEN-FST-NM Alpha 15 (Lower Case) HR11.1 HR11.2
Maiden First Name Contains the employee's maiden first HR511 HR650
name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-MAIDEN-MI Alpha 1 HR11.1 HR11.2
Maiden Name Middle Contains the employee's maiden middle HR511 HR650
Initial initial. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-FORMER-LST-NM Alpha 30 (Lower Case) HR11.1 HR11.2
Former Last Name Contains the employee's former last HR511 HR650
name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-FORMER-FST-NM Alpha 15 (Lower Case) HR11.1 HR11.2
Former First Name Contains the employee's former first HR511 HR650
name. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-FORMER-MI Alpha 1 HR11.1 HR11.2
Former Name Middle Contains the employee's former middle HR511 HR650
Initial initial. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-LOCAT-CODE Alpha 10 HCOP.2 HR11.1
Location Contains a user-defined location code HR11.2 HR511
that identifies where the employee HR650 PA02.1
works. The Human Resource Code file PA100 PA102
validates this field. PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HIRE-SOURCE Alpha 10 HR11.1 HR11.2
Hire Source Contains a user-defined hire source HR511 HR650
code that identifies the source from PA02.1 PA100
which the employee was acquired. This PA102 PA502
field is validated in the Human Resource PA52.1 PA52.3
Code file. PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SECURITY-CODE Alpha 10 HR11.1 HR11.2
Badge Code Contains a user-defined badge code HR511 HR650
assigned to the employee. This field is PA02.1 PA100
not associated with Lawson user PA102 PA502
security. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SECURITY-NBR Alpha 10 HR11.1 HR11.2
Badge Number Contains an internal security number HR511 HR650
that is assigned to the employee. This PA02.1 PA100
field is not associated with Lawson user PA102 PA502
security. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BARGAIN-UNIT Alpha 10 HR11.1 HR11.2
Bargaining Unit Contains a user-defined code that HR511 HR650
represents the employee's union PA02.1 PA100
bargaining unit. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-CLOCK-NBR Alpha 10 HR11.1 HR11.2
Clock Number Contains the employee's clock number. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-MAIL-GROUP Alpha 10 HR11.1 HR11.2
Mail Group Contains a user-defined code that HR511 HR650
identifies the mail group to which an PA02.1 PA100
employee belongs. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-MB-NBR Alpha 10 HR11.1 HR11.2
Mail Box Number Contains the employee's mail box number. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-DRAFT-STATUS Alpha 3 HR11.1 HR11.2
Bill of Exchange Contains a user-defined code that HR511 HR650
Status identifies the employee's draft status. PA02.1 PA100
PA102 PA14.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-FINAL-RANK Alpha 3 HR11.1 HR11.2
Final Military Rank Identifies the highest military rank HR511 HR650
attained by the employee. PA02.1 PA100
PA102 PA14.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-CUR-STATUS Alpha 2 HR11.1 HR11.2
Current Status Indicates if the employee is currently HR511 HR650
in the Reserves or National Guard. PA02.1 PA100
NG = National Guard PA102 PA14.1
RE = Reserves PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LAST-PHYSICAL Numeric 8 (yyyymmdd) HR11.1 HR11.2
Last Physical Date Contains the date of the employee's HR511 HR650
last physical exam. PA02.1 PA100
PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-PHY-SCHD Alpha 2 HR11.1 HR11.2
Physical Schedule Contains the frequency of the HR511 HR650
employee's physical examinations. PA02.1 PA100
2Y = 2 years PA102 PA15.1
3Y = 3 years PA502 PA52.1
4Y = 4 years PA52.3 PA52.4
5Y = 5 years PA52.5 PR110
6Y = 6 years PR113 PR120
7Y = 7 years PR13.1 PR13.5
8Y = 8 years PR13.6 PR13.8
9Y = 9 years
AN = Annual
MO = Monthly
QT = Quarterly
SA = Semi-annual
PEM-NEXT-PHYSICAL Numeric 8 (yyyymmdd) HR11.1 HR11.2
Next Physical Date Contains the date of the employee's HR511 HR650
next scheduled physical exam. PA02.1 PA100
PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-HEIGHT-FT Numeric 2 HR11.1 HR11.2
Height - Feet Contains the employee's height in feet. HR511 HR650
PA02.1 PA100
PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-HEIGHT-IN Numeric 2 HR11.1 HR11.2
Height - Inches Contains the employee's height in HR511 HR650
inches. PA02.1 PA100
01 PA102 PA15.1
11 PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-WGHT Signed 5.2 HR11.1 HR11.2
Weight Contains the employee's weight. HR511 HR650
PA02.1 PA100
PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-BLOOD-TYPE Alpha 3 HR11.1 HR11.2
Blood Type Contains the employee's blood type. HR511 HR650
A+ PA02.1 PA100
A- PA102 PA15.1
AB+ PA502 PA52.1
AB- PA52.3 PA52.4
B+ PA52.5 PR110
B- PR113 PR120
O+ PR13.1 PR13.5
O- PR13.6 PR13.8
PEM-PARKING-LOT Alpha 10 HR11.1 HR11.2
Parking Lot Code Contains a user-defined code that HR511 HR650
represents the employee's assigned PA02.1 PA100
parking lot. PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-PARKING-SPACE Alpha 10 HR11.1 HR11.2
Parking Space Identifies the parking space assigned HR511 HR650
to the employee. PA02.1 PA100
PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-DR-LICENSE Alpha 20 HR11.1 HR11.2
Driver License Contains the employee's driver's HR511 HR650
Number license number. PA02.1 PA100
PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-DR-LIC-ST Alpha 2 HR11.1 HR11.2
Driver License State Contains the abbreviation of the state HR511 HR650
that issued the employee's driver's PA02.1 PA100
license. PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-EXP-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Expiration Contains the expiration date of the HR511 HR650
employee's driver's license. PA02.1 PA100
PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-DR-LIC-CLASS Alpha 3 HR11.1 HR11.2
Driver License Class Contains the class of the employee's HR511 HR650
driver's license. PA02.1 PA100
PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-REV-SCHEDULE Alpha 2 HR11.1 HR11.2
Review Schedule Identifies the frequency of performance HR511 HR650
reviews for the employee. PA02.1 PA100
AN = Annual PA102 PA26.1
MO = Monthly PA502 PA52.1
QT = Quarterly PA52.3 PA52.4
SA = Semi-annual PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-NEXT-REVIEW Numeric 8 (yyyymmdd) HR11.1 HR11.2
Next Review Date Contains the next scheduled performance HR511 HR650
review date for the employee. PA02.1 PA100
PA102 PA26.1
PA345 PA370
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-NEXT-REV-CODE Alpha 10 HR11.1 HR11.2
Next Review Code Identifies the review type for the next HR511 HR650
scheduled review date (for example, PA02.1 PA100
salary review). PA102 PA26.1
PA345 PA370
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LAST-REVIEW Numeric 8 (yyyymmdd) HR11.1 HR11.2
Last Review Date Contains the date of the employee's HR511 HR650
last review. PA02.1 PA100
PA102 PA26.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LAST-MIL-SEQ Numeric 4 HR11.1 HR11.2
Last Military Contains the last sequence number used HR511 HR650
Sequence Number to store a military record. PA02.1 PA100
PA102 PA14.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LAST-REV-SEQ Numeric 4 HR11.1 HR11.2
Last Review Contains the last sequence number used HR511 HR650
Sequence Number to store a review record. PA02.1 PA100
PA102 PA26.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LAST-COM-SEQ Numeric 4 BN90.1 HR11.1
Last Comment Contains the last sequence number used HR11.2 HR511
Sequence Number to store a comment record. HR650 HR90.1
HR90.2 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LAST-INT-SEQ Numeric 4 HR11.1 HR11.2
Last Interview Contains the last sequence number used HR511 HR650
Sequence Number to store an interview record. PA02.1 PA100
PA102 PA41.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LAST-BNF-SEQ Numeric 4 BN47.1 BN547
Last Beneficiary Contains the last sequence number used HR11.1 HR11.2
Sequence Nbr to store a beneficiary record. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-LAST-INV-NBR Numeric 4 BN180 BN80.1
Last Invoice Number Contains the last sequence number used HR11.1 HR11.2
to store an invoice record. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-LAST-EPC-SEQ Numeric 4 HR11.1 HR11.2
Last Emp Code Contains the last sequence number used HR511 HR650
Sequence Number to store HR codes for an employee. PA02.1 PA100
PA102 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA34.1
PA35.1 PA36.1
PA38.1 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PA520 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
TR21.1 TR22.1
TR26.1 TR500
PEM-FNCTN-GROUP Numeric 2 HCOP.2 HR11.1
EEO-4 Group Identifies for the EEO-4 report, the HR11.2 HR511
type of work the employee does. HR650 PA02.1
01 PA100 PA102
15 PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-EXCLUDE-FLAG Alpha 1 HR11.1 HR11.2
Exclude From EEO-4 Determines if an employee is included HR511 HR650
in the EEO-4 report. PA02.1 PA100
N = Include on EEO-4 Report PA102 PA502
Y = Exclude from EEO-4 Report PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-NBR-HL-DEP Numeric 3 HR11.1 HR11.2
Health Dependents Contains the number of dependents HR13.1 HR511
covered by the employee's health HR513 HR650
insurance. PA02.1 PA100
PA102 PA218
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-NBR-DN-DEP Numeric 3 HR11.1 HR11.2
Dental Dependents Contains the number of dependents HR13.1 HR511
covered by the employee's dental HR513 HR650
insurance. PA02.1 PA100
PA102 PA218
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-LIFE-STYLE-CR Numeric 2 HR11.1 HR11.2
Life Style Cr Contains the number of credits given HR511 HR650
for a healthy lifestyle. This is used to PA02.1 PA100
calculate flex credits. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HL-COV-PROOF Alpha 1 HR11.1 HR11.2
Spouse Health Plan Indicates if there is proof that the HR511 HR650
employee is covered by health insurance PA02.1 PA100
outside the company. PA102 PA502
N = No PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-DN-COV-PROOF Alpha 1 HR11.1 HR11.2
Spouse Dental Plan Indicates if there is proof that the HR511 HR650
employee is covered by dental insurance PA02.1 PA100
outside the company. PA102 PA502
N = No PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HL-VERIFY-DT Numeric 8 (yyyymmdd) HR11.1 HR11.2
Spouse Health Plan Contains the date outside health HR511 HR650
Verify Date coverage was verified. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-DN-VERIFY-DT Numeric 8 (yyyymmdd) HR11.1 HR11.2
Spouse Dental Plan Contains the date outside dental HR511 HR650
Verify Date coverage was verified. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SPOUSE-EMP Alpha 30 (Lower Case) HR11.1 HR11.2
Spouse Employer Name Contains the name of the employee's HR511 HR650
spouse's employer. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-ADDR1 Alpha 30 (Lower Case) HR11.1 HR11.2
Spouse Employer Contains the first line of the spouse's HR511 HR650
Address 1 employer's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-ADDR2 Alpha 30 (Lower Case) HR11.1 HR11.2
Spouse Employer Contains the second line of the HR511 HR650
Address 2 spouse's employer's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-ADDR3 Alpha 30 (Lower Case) HR11.1 HR11.2
Sp Emp Addr3 Contains the third line of the spouse's HR511 HR650
employer's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-ADDR4 Alpha 30 (Lower Case) HR11.1 HR11.2
Sp Emp Addr4 Contains the fourth line of the HR511 HR650
spouse's employer's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-CITY Alpha 18 (Lower Case) HR11.1 HR11.2
Spouse Employer City Contains the city of the spouse's HR511 HR650
employer's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-STATE Alpha 2 HR11.1 HR11.2
Spouse Employer Contains the state of the spouse's HR511 HR650
State/Province employer's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-ZIP Alpha 10 HR11.1 HR11.2
Spouse Employer Contains the postal code of the HR511 HR650
Postal Code spouse's employer's address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-COUNTRY Alpha 2 HR11.1 HR11.2
Sp Emp Country Contains country of spouse's employer's HR511 HR650
address. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-PH-CNTR Alpha 6 HR11.1 HR11.2
Sp Emp Ph Cntr Contains the country code of the HR511 HR650
spouse's employer's telephone number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SP-EMP-PH-NBR Alpha 15 HR11.1 HR11.2
Sp Emp Ph Nbr Contains the spouse's employer's HR511 HR650
telephone number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-OWNER-FLAG Alpha 1 HR11.1 HR11.2
Owner Identifies owners of the company. HR511 HR650
N = No PA02.1 PA100
Y = Yes PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-KEY-EMP-FLAG Alpha 1 HR11.1 HR11.2
Key Employee Identifies key employees of the HR511 HR650
company. PA02.1 PA100
N = No PA102 PA502
Y = Yes PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-OFFICER Alpha 1 HR11.1 HR11.2
Officer Identifies officers of the company. HR511 HR650
N = No PA02.1 PA100
Y = Yes PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HIGH-COMP Alpha 1 HR11.1 HR11.2
Highly Compensated Identifies highly compensated employees HR511 HR650
for non-discrimination testing in the PA02.1 PA100
Lawson Benefits System. PA102 PA502
N = No PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SMOKER Alpha 1 HR11.1 HR11.2
Smoker Indicates if an employee is a smoker. HR511 HR650
The Lawson Benefits system uses this PA02.1 PA100
information when calculating employee PA102 PA502
life and disability insurance premiums. PA52.1 PA52.3
N = No PA52.4 PA52.5
Y = Yes PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-STATUS Alpha 10 HR11.1 HR11.2
Eligibility Status Identifies the employee's immigration HR511 HR650
status. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-ALIEN-NBR Alpha 11 HR11.1 HR11.2
Alien Number Contains the employee's alien number. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-ADMIT-NBR Alpha 13 HR11.1 HR11.2
Admission Number Contains the employee's admission HR511 HR650
number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-STA-EXP-DT Numeric 8 (yyyymmdd) HR11.1 HR11.2
Expiration Date Contains the expiration date of the HR511 HR650
employee's work authorization status. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-DOC-NBR Alpha 20 Occurs 2 Times HR11.1 HR11.2
Document Number Contains the document identification HR511 HR650
number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-DOC-TYPE Alpha 10 Occurs 2 Times HR11.1 HR11.2
Document Type Identifies the type of document entered. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-DOC-EXP-DT Numeric 8 (yyyymmdd) Occurs 2 Times HR11.1 HR11.2
Document Expiration Contains the expiration date of the HR511 HR650
Date document. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-AUTHORIZE Alpha 30 (Lower Case) HR11.1 HR11.2
Authorization Identifies the person who examined the HR511 HR650
evidence or documents establishing the PA02.1 PA100
employee's identity and employment PA102 PA502
eligibility. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-TRUE-MAR-STAT Alpha 1 HR11.1 HR11.2
True Marital Status Contains the employee's true marital HR511 HR650
status. PA02.1 PA100
D = Divorced PA102 PA502
M = Married PA52.1 PA52.3
S = Single PA52.4 PA52.5
W = Widowed PR110 PR113
L = Legally Separated PR120 PR13.1
O = Significant Other PR13.5 PR13.6
P = Domestic Partner PR13.8
PEM-LAST-PAE-SEQ Numeric 4 HR11.1 HR11.2
Last Pae Seq Contains the last number used to store HR511 HR650
an emergency contact record for the PA02.1 PA100
employee. PA102 PA12.1
PA502 PA512
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-PRIMARY-CARE Alpha 10 HR11.1 HR11.2
Primary Care Contains the code that represents the HR511 HR650
Physician employee's primary care physician. PA02.1 PA100
PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-FAMILY-AGG Numeric 9 HR11.1 HR11.2
Family Agg Contains the number of the employee HR511 HR650
defined as the family aggregate PA02.1 PA100
employee. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-SALARY-1 Signed 11.2 HR11.1 HR11.2
Ben Salary 1 Contains optional user-defined benefit HR511 HR650
salary information. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-SALARY-2 Signed 11.2 HR11.1 HR11.2
Ben Salary 2 Contains optional user-defined benefit HR511 HR650
salary information. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-SALARY-3 Signed 11.2 HR11.1 HR11.2
Ben Salary 3 Contains optional user-defined benefit HR511 HR650
salary information. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-SALARY-4 Signed 11.2 HR11.1 HR11.2
Ben Salary 4 Contains optional user-defined benefit HR511 HR650
salary information. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-SALARY-5 Signed 11.2 HR11.1 HR11.2
Ben Salary 5 Contains optional user-defined benefit HR511 HR650
salary information. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-DATE-1 Numeric 8 (yyyymmdd) HR11.1 HR11.2
Ben Date 1 Contains an optional user-defined HR511 HR650
benefit date. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-DATE-2 Numeric 8 (yyyymmdd) HR11.1 HR11.2
Ben Date 2 Contains an optional user-defined HR511 HR650
benefit date. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-DATE-3 Numeric 8 (yyyymmdd) HR11.1 HR11.2
Ben Date 3 Contains an optional user-defined HR511 HR650
benefit date. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-DATE-4 Numeric 8 (yyyymmdd) HR11.1 HR11.2
Ben Date 4 Contains an optional user-defined HR511 HR650
benefit date. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BEN-DATE-5 Numeric 8 (yyyymmdd) HR11.1 HR11.2
Ben Date 5 Contains an optional user-defined HR511 HR650
benefit date. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SEC-LVL Numeric 1 HR11.1 HR11.2
Sec Lvl Contains the employee's security level. HR12.1 HR511
HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-SEC-LOCATION Alpha 10 HR11.1 HR11.2
Sec Location Contains the employee's security HR12.1 HR511
location. HR650 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-CUR-AGE Derived
Age
PEM-SEX-1 Derived
Gender
PEM-EEO-CLASS-1 Derived
Eeo Class 1
PEM-WORK-ZIP Alpha 10 HR11.1 HR11.2
Work Zip Contains the employee's work postal HR511 HR650
code. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HEIGHT-UNIT Alpha 1 PA15.1
Height Unit Contains unit in which height is
recorded.
1 = Feet
2 = Meters
PEM-WGHT-UNIT Alpha 1 PA15.1
Wght Unit Contains unit in which the employee's
weight is recorded.
1 = Pounds
2 = Stones
3 = Kilograms
PEM-LANGUAGE-CODE Alpha 10 HR11.1 HR11.2
Language Code Contains employee's language if other HR511 HR650
than company's primary language. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-RELIGION Alpha 10 HR11.1 HR11.2
Religion Contains employee's religion. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-DISABILITY Alpha 10 HR11.1 HR11.2
Disability Contains type of disability. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-PHONE-CNT Alpha 6 HR11.1 HR11.2
Supp Phone Cnt Contains phone country of supplemental HR511 HR650
phone number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-PHONE-NBR Alpha 15 HR11.1 HR11.2
Supp Phone Nbr Contains supplemental phone number. HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-CONSENT Alpha 1 HR11.1 HR11.2
Consent N = No HR511 HR650
Y = Yes PA02.1 PA100
" " = No PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-ABORIGINAL Alpha 1 HR11.1 HR11.2
Aboriginal Designates if an employee is Aboriginal. HR511 HR650
N = No PA02.1 PA100
Y = Yes PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-VISIBLE-MIN Alpha 1 HR11.1 HR11.2
Visible Min Designates if an employee is a visible HR511 HR650
minority. PA02.1 PA100
N = No PA102 PA502
Y = Yes PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-RELATED-EMP Alpha 1 HR11.1 HR11.2
Related Emp Determines whether or not an employee is HR511 HR650
related to the employer. PA02.1 PA100
N = No PA102 PA502
Y = Yes PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-DOC-DESCR Alpha 10 Occurs 2 Times HR11.1 HR11.2
I9 Doc Descr HR511 HR650
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-BILINGUAL Alpha 1 PA96.1
Bilingual N = No
Y = Yes
PEM-SUPP-COUNTY Alpha 25
Supp County
PEM-STOCK-TRADE Alpha 1
Stock Trade " " = Not applicable
1 = Insider
2 = SEC Restricted
3 = Insider & SEC Restricted
PEM-APP-INTEREST Alpha 1
App Interest " " = No
N = No
Y = Yes
PAEMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEMSET1 COMPANY AC541 AC542
EMPLOYEE AC550 AC551
BN100 BN101
BN102 BN103
BN104 BN105
BN138 BN140
BN141 BN145
BN150 BN175
BN180 BN230
BN231 BN232
BN233 BN236
BN237 BN238
BN240 BN242
BN245 BN246
BN248 BN258
...
PAEMPLOYEE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Badge Code PCODES Required
When PEM-SECURITY-CODE != Spaces
"SC" -> PCO-TYPE
PEM-SECURITY-CODE -> PCO-CODE
Bargain Unit PCODES Required
When PEM-BARGAIN-UNIT != Spaces
"BU" -> PCO-TYPE
PEM-BARGAIN-UNIT -> PCO-CODE
Company PRSYSTEM Required
PEM-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Disability PCODES Required
When PEM-DISABILITY != Spaces
"DI" -> PCO-TYPE
PEM-DISABILITY -> PCO-CODE
Employee EMPLOYEE Required
PEM-COMPANY -> EMP-COMPANY
PEM-EMPLOYEE -> EMP-EMPLOYEE
Ethnicity HRCTRYCODE Required
When PEM-EEO-CLASS != Spaces
"ET" -> CTC-TYPE
EMP-WORK-COUNTRY -> CTC-COUNTRY-CODE
PEM-EEO-CLASS -> CTC-HRCTRY-CODE
Family Agg EMPLOYEE Required
When PEM-FAMILY-AGG != Zeroes
PEM-COMPANY -> EMP-COMPANY
PEM-FAMILY-AGG -> EMP-EMPLOYEE
Hire Source PCODES Required
When PEM-HIRE-SOURCE != Spaces
"HS" -> PCO-TYPE
PEM-HIRE-SOURCE -> PCO-CODE
Location PCODES Required
When PEM-LOCAT-CODE != Spaces
"LO" -> PCO-TYPE
PEM-LOCAT-CODE -> PCO-CODE
Mail Group PCODES Required
When PEM-MAIL-GROUP != Spaces
"MG" -> PCO-TYPE
PEM-MAIL-GROUP -> PCO-CODE
Primary Care PCODES Required
When PEM-PRIMARY-CARE != Spaces
"PC" -> PCO-TYPE
PEM-PRIMARY-CARE -> PCO-CODE
Religion PCODES Required
When PEM-RELIGION != Spaces
"RE" -> PCO-TYPE
PEM-RELIGION -> PCO-CODE
Supp Country INSTCTRYCD Required
When (PEM-SUPP-CNTRY-CD != Spaces )
PEM-SUPP-CNTRY-CD -> INT-COUNTRY-CODE
PAEMPLOYEE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accomodation PAMEDICAL Delete Restricted
PEM-COMPANY -> PMD-COMPANY
PEM-EMPLOYEE -> PMD-EMPLOYEE
"AC" -> PMD-TYPE
PMD-CODE
PMD-SEQ-NBR
Applicant APPLICANT
PEM-COMPANY -> APL-COMPANY
PEM-EMPLOYEE -> APL-EMPLOYEE
APL-APPLICANT
Automobiles EMPAUTO Delete Cascades
PEM-COMPANY -> EAT-COMPANY
PEM-EMPLOYEE -> EAT-EMPLOYEE
EAT-AUTO-NBR
Bn Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"BN" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Bnempexer BNEMPEXER
PEM-COMPANY -> BXR-COMPANY
PEM-EMPLOYEE -> BXR-EMPLOYEE
BXR-OPT-GRANT-NBR
BXR-EXERCISE-DATE
BXR-SEQ-NBR
Ce Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"CE" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Certifications EMPCODES Delete Cascades
PEM-COMPANY -> EPC-COMPANY
"CE" -> EPC-TYPE
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Co Property EMPCODES
PEM-COMPANY -> EPC-COMPANY
"CP" -> EPC-TYPE
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Competency EMPCODES Delete Cascades
PEM-COMPANY -> EPC-COMPANY
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
EPC-TYPE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Contract EMPCODES Delete Cascades
PEM-COMPANY -> EPC-COMPANY
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
"CN" -> EPC-TYPE
EPC-CODE
EPC-DATE-ACQUIRED
EPC-SUBJECT
EPC-SEQ-NBR
Correspondence HRCORRESP
PEM-COMPANY -> HCP-COMPANY
"1" -> HCP-REQ-TYPE
PEM-EMPLOYEE -> HCP-ID-NBR
HCP-DEPENDENT
HCP-SEQ-NBR
Cp Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"CP" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Dependents EMDEPEND Delete Restricted
PEM-COMPANY -> EMD-COMPANY
PEM-EMPLOYEE -> EMD-EMPLOYEE
EMD-SEQ-NBR
Dis Action Stp PAGRDISTEP
PEM-COMPANY -> PGI-COMPANY
PEM-EMPLOYEE -> PGI-EMPLOYEE
"2 " -> PGI-TYPE
PGI-GRIEV-DIS-NBR
PGI-EFFECT-DATE
PGI-SEQ-NBR
Discpl Actions PAGRDI
PEM-COMPANY -> PAG-COMPANY
PEM-EMPLOYEE -> PAG-EMPLOYEE
"2 " -> PAG-TYPE
PAG-DATE
PAG-GRIEV-DIS-NBR
Dp Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"DP" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Ec Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"EC" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Ed Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"ED" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Education EMPCODES Delete Cascades
PEM-COMPANY -> EPC-COMPANY
"ED" -> EPC-TYPE
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Emerg Contact PAEMERGCNT Delete Restricted
PEM-COMPANY -> PAE-COMPANY
PEM-EMPLOYEE -> PAE-EMPLOYEE
PAE-SEQ-NBR
Ge Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"GE" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Gri Dis Act St PAGRDISTEP
PEM-COMPANY -> PGI-COMPANY
PEM-EMPLOYEE -> PGI-EMPLOYEE
"2 " -> PGI-TYPE
PGI-GRIEV-DIS-NBR
PGI-EFFECT-DATE
PGI-SEQ-NBR
Griev Dis Act PAGRDI
PEM-COMPANY -> PAG-COMPANY
PEM-EMPLOYEE -> PAG-EMPLOYEE
PAG-TYPE
PAG-DATE
PAG-GRIEV-DIS-NBR
Griev Steps PAGRDISTEP
PEM-COMPANY -> PGI-COMPANY
PEM-EMPLOYEE -> PGI-EMPLOYEE
"1 " -> PGI-TYPE
PGI-GRIEV-DIS-NBR
PGI-EFFECT-DATE
PGI-SEQ-NBR
Grievances PAGRDI
PEM-COMPANY -> PAG-COMPANY
PEM-EMPLOYEE -> PAG-EMPLOYEE
"1 " -> PAG-TYPE
PAG-DATE
PAG-GRIEV-DIS-NBR
Hist Err HISTERR Delete Cascades
PEM-COMPANY -> HER-COMPANY
PEM-EMPLOYEE -> HER-EMPLOYEE
HER-OBJ-ID
HER-EFFECT-DATE
HER-ACTION-CODE
HER-ACTION-NBR
HER-FLD-NBR
HER-SEQ-NBR
Hr Cont Nbr HRCONTNBR
PEM-COMPANY -> HCN-COMPANY
"1" -> HCN-REQ-TYPE
PEM-EMPLOYEE -> HCN-ID-NBR
Zeroes -> HCN-DEPENDENT
HCN-SEQ-NBR
Incid Followup PAFOLLOWUP Delete Cascades
PEM-COMPANY -> PAF-COMPANY
PEM-EMPLOYEE -> PAF-EMPLOYEE
PAF-ESTABLISHMENT
PAF-INCIDENT-NBR
PAF-EFFECT-DATE
PAF-SEQ-NBR
Incident Costs PAINCICOST Delete Cascades
PEM-COMPANY -> PAI-COMPANY
PEM-EMPLOYEE -> PAI-EMPLOYEE
PAI-ESTABLISHMENT
PAI-INCIDENT-NBR
PAI-EFFECT-DATE
PAI-SEQ-NBR
Interviews INTERVIEW Delete Cascades
PEM-COMPANY -> ITV-COMPANY
Zeroes -> ITV-EMP-APP
PEM-EMPLOYEE -> ITV-APPLICANT
ITV-SEQ-NBR
Iv Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"IV" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Job Hist APPJOBHIST
PEM-COMPANY -> AJH-COMPANY
PEM-EMPLOYEE -> AJH-EMPLOYEE
AJH-SEQ-NBR
AJH-APPLICANT
Job Interest PAJOBINTRS Delete Cascades
PEM-COMPANY -> PJI-COMPANY
Zeroes -> PJI-EMP-APP
PEM-EMPLOYEE -> PJI-EMPLOYEE
PJI-JOB-CODE
PJI-POSITION
Jobauth JOBAUTH Delete Cascades
PEM-COMPANY -> JBA-COMPANY
Zeroes -> JBA-EMP-APP
PEM-EMPLOYEE -> JBA-EMPLOYEE
JBA-JOB-CODE
JBA-POSITION
Md Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"MD" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Medical Codes PAMEDICAL Delete Restricted
PEM-COMPANY -> PMD-COMPANY
PEM-EMPLOYEE -> PMD-EMPLOYEE
"EM" -> PMD-TYPE
PMD-CODE
PMD-SEQ-NBR
Mi Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"MI" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Military MILITARY Delete Cascades
PEM-COMPANY -> MIL-COMPANY
Zeroes -> MIL-EMP-APP
PEM-EMPLOYEE -> MIL-EMPLOYEE
MIL-BR-SERVICE
MIL-SEQ-NBR
Off Lang PAOFFLANG
PEM-COMPANY -> PLA-COMPANY
PEM-EMPLOYEE -> PLA-EMPLOYEE
Spaces -> PLA-POSITION
PLA-REPORT-TYPE
PLA-SEQ-NBR
Os Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"OS" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Osha OSHA Delete Cascades
PEM-COMPANY -> OSH-COMPANY
PEM-EMPLOYEE -> OSH-EMPLOYEE
OSH-ESTABLISHMENT
OSH-SEQ-NBR
Pa Benefits EMPCODES Delete Cascades
PEM-COMPANY -> EPC-COMPANY
"BN" -> EPC-TYPE
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Pa Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"PA" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Painstruct PAINSTRUCT
PEM-COMPANY -> INS-COMPANY
PEM-EMPLOYEE -> INS-EMPLOYEE
INS-LAST-NAME
INS-FIRST-NAME
INS-MIDDLE-INIT
INS-INSTRUCT
Pending Action PERSACTION
PEM-COMPANY -> PCT-COMPANY
"E" -> PCT-ACTION-TYPE
PEM-EMPLOYEE -> PCT-EMPLOYEE
PCT-ACTION-CODE
PCT-EFFECT-DATE
PCT-ACTION-NBR
Registrations PAREGISTER
PEM-COMPANY -> REG-COMPANY
PEM-EMPLOYEE -> REG-EMPLOYEE
REG-COURSE
REG-SESSION
REG-START-DATE
Relocation EMPCODES
PEM-COMPANY -> EPC-COMPANY
"RL" -> EPC-TYPE
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Requisitions PAREQAPP Delete Cascades
PEM-COMPANY -> PRA-COMPANY
Zeroes -> PRA-EMP-APP
PEM-EMPLOYEE -> PRA-APPLICANT
PRA-REQUISITION
Reviews REVIEW Delete Cascades
PEM-COMPANY -> REV-COMPANY
PEM-EMPLOYEE -> REV-EMPLOYEE
REV-SCHED-DATE
REV-CODE
Rl Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"RL" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Rv Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"RV" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Sk Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"SK" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Stockgrnt BNEMPGRNT
PEM-COMPANY -> BEG-COMPANY
PEM-EMPLOYEE -> BEG-EMPLOYEE
BEG-OPT-GRANT-NBR
Test Exception PATESTOVER
PEM-COMPANY -> PAV-COMPANY
PEM-EMPLOYEE -> PAV-EMPLOYEE
PAV-TEST
Tracks PAEMPTRACK Delete Cascades
PEM-COMPANY -> ETR-COMPANY
PEM-EMPLOYEE -> ETR-EMPLOYEE
ETR-TYPE
ETR-TRACK
Train Costs PAEMPCOSTS Delete Cascades
PEM-COMPANY -> EMC-COMPANY
PEM-EMPLOYEE -> EMC-EMPLOYEE
EMC-COURSE
EMC-DATE
EMC-COST-TYPE
EMC-COST-CAT
Training PATRNHIST Delete Cascades
PEM-COMPANY -> TRH-COMPANY
PEM-EMPLOYEE -> TRH-EMPLOYEE
TRH-COURSE
TRH-DATE-COMPLETED
Tv Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"TV" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Visas EMPVISA Delete Cascades
PEM-COMPANY -> EMV-COMPANY
PEM-EMPLOYEE -> EMV-EMPLOYEE
EMV-DEPENDENT
EMV-SEQ-NBR
Work Restrict PAMEDICAL Delete Restricted
PEM-COMPANY -> PMD-COMPANY
PEM-EMPLOYEE -> PMD-EMPLOYEE
"WR" -> PMD-TYPE
PMD-CODE
PMD-SEQ-NBR
Wr Comments PACOMMENTS Delete Cascades
PEM-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"WR" -> PAC-CMT-TYPE
PEM-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
|