Lawson Insight Technical Documentation |
|
PAEMPLOYEE
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
BN100 BN101 BN102 BN103 BN104 BN105
BN106 BN137 BN138 BN140 BN141 BN145
BN150 BN175 BN230 BN231 BN232 BN233
BN234 BN236 BN237 BN238 BN240 BN242
BN245 BN246 BN248 BN258 BN285 BN300
BN31.1 BN31.2 BN310 BN32.1 BN32.2 BN32.3
BN320 BN325 BN33.1 BN33.2 BN33.3 BN330
BN331 BN335 BN340 BN345 BN35.1 BN350
BN36.1 BN430 BN45.1 BN48.1 BN48.2 BN531
BN533 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 ET530 ET700 ETI2.1 ETI3.1 HCDL.1
HCEM.1 HCHP.1 HAP3.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR15.1 HR155 HR170 HR20.1 HR211
HR213 HR217 HR220 HR30.1 HR515 HR54.1
HR55.2 HR70.1 HRS1.1 HRSC.1 HS08.1 HS10.1
HS10.2 HS208 LP100 LP101 LP130 LP138
LP140 LP251 LP51.1 HS11.1 HS11.2 HS12.1
HS12.2 HS13.1 HS13.2 HS14.1 HS50.1 HS50.2
PA10.1 PA113 PA149 PA210 PA212 PA214
PA215 PA216 PA217 PA220 PA221 PA222
PA223 PA224 PA225 PA227 PA248 PA249
PA262 PA272 PA290 PA296 PA31.1 PA310
PA311 PA315 PA320 PA325 PA330 PA335
PA345 PA350 PA355 PA360 PA370 PA372
PA390 PA391 PA393 PA406 PA490 PA495
PA496 PA53.1 PA531 PA532 PA533 PA534
PA54.1 PA59.1 PA590 PA594 PA64.1 PA64.2
PA66.2 PA66.3 PA702 PA90.1 TR120 TR121
TR20.1 TR20.2 TR20.3 TR207 PR128 PR130
PR131 PR132 PR134 PR136 PR139 PR14.1
PR14.2 PR140 PR15.2 PR160 PR180 PR188
PR189 PR195 PR197 PR198 PR205 PR240
PR241 PR242 PR243 PR244 PR245 PR250
PR251 PR252 PR253 PR274 PR282 PR29.1
PR292 PR293 PR296 PR297 PR299 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR45.1
PR529 PR560 PR80.1 PR80.2 PR82.1 PR85.1
PR88.1 PR89.1 UK102 UK110 UK13.1 UK201
UK560 TA147 HRLRD
UPDATED BY
BN180 BN305 BN47.1 BN547 BN80.1 BN90.1
HR11.1 HR11.2 HR12.1 HR13.1 HR511 HR513
HR90.1 HR90.2 HS701 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 PR530 PR84.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEM-COMPANY Numeric 4 BN305 HR11.1
Element: Company Hr Contains the number that represents an HR11.2 HR511
established company and is entered on PA02.1 PA100
all functions. PA102 PA115
PA13.1 PA13.2
PA14.1 PA15.1
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-EMPLOYEE Numeric 9 BN305 BN350
Element: Employee Contains the employee number. An HR11.1 HR11.2
employee number is assigned to each HR511 PA02.1
person employed by the company. The PA100 PA102
system uses the employee number to PA115 PA13.1
correlate all information related to the PA13.2 PA14.1
employee. This number must be valid in PA15.1 PA17.1
the Employee file. PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SUPP-ADDR1 Alpha 30 (Lower Case) BN305 HR11.1
Element: Supplemental AContains the first line of the HR11.2 HR511
supplemental address. PA02.1 PA100
PA102 PA115
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-SUPP-ADDR2 Alpha 30 (Lower Case) BN305 HR11.1
Supplemental Contains the second line of the HR11.2 HR511
Address 2 supplemental address. PA02.1 PA100
PA102 PA115
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-SUPP-ADDR3 Alpha 30 (Lower Case) BN305 HR11.1
Element: Supp Addr3 Contains the third line of the HR11.2 HR511
supplemental address. PA02.1 PA100
PA102 PA115
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-SUPP-ADDR4 Alpha 30 (Lower Case) BN305 HR11.1
Element: Supp Addr4 Contains the fourth line of the HR11.2 HR511
supplemental address. PA02.1 PA100
PA102 PA115
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-SUPP-CITY Alpha 18 (Lower Case) BN305 HR11.1
Supplemental Contains the city of the supplemental HR11.2 HR511
Address City address. PA02.1 PA100
PA102 PA115
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-SUPP-STATE Alpha 2 BN305 HR11.1
Suppl. Address Contains the state of the supplemental HR11.2 HR511
State/Province address. PA02.1 PA100
PA102 PA115
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-SUPP-ZIP Alpha 10 BN305 HR11.1
Suppl. Address Contains the postal code of the HR11.2 HR511
Postal Code supplemental address. PA02.1 PA100
PA102 PA115
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-SUPP-CNTRY-CD Alpha 2 BN305 HR11.1
Element: Supp Cntry Cd Contains the country of the HR11.2 HR511
supplemental address. PA02.1 PA100
PA102 PA115
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-HM-PHONE-CNTRY Alpha 6 BN305 HR11.1
Element: Hm Phone CntryContains the country code of the HR11.2 HR511
employee's home telephone number. PA02.1 PA100
PA102 PA115
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-HM-PHONE-NBR Alpha 15 BN305 HR11.1
Element: Hm Phone Nbr Contains the employee's home telephone HR11.2 HR511
number. PA02.1 PA100
PA102 PA115
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-WK-PHONE-CNTRY Alpha 6 BN305 HR11.1
Element: Wk Phone CntryContains the country code of the HR11.2 HR511
employee's work telephone number. PA02.1 PA100
PA102 PA115
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-WK-PHONE-NBR Alpha 15 BN305 HR11.1
Element: Wk Phone Nbr Contains the employee's work telephone HR11.2 HR511
number. PA02.1 PA100
PA102 PA115
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-WK-PHONE-EXT Alpha 5 BN305 HR11.1
Element: Wk Phone Ext Contains the extension of the HR11.2 HR511
employee's work telephone number. PA02.1 PA100
PA102 PA115
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-EEO-CLASS Alpha 4 (Lower Case) BN305 HR11.1
Element: Eeo Class Contains the employee's ethnic origin. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-SEX Alpha 1 BN305 HR11.1
Element: Sex Contains the employee's gender. HR11.2 HR511
F = Female PA02.1 PA100
M = Male PA102 PA115
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-HANDICAP-ID Alpha 1 BN305 HR11.1
Element: Handicap Id Indicates if the employee is disabled. HR11.2 HR511
Y = Yes PA02.1 PA100
N = No PA102 PA115
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-COMP-CODE Alpha 4 BN305 HR11.1
Element: Comp Code Contains miscellaneous data. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-COMP-NBR Alpha 10 BN305 HR11.1
Element: Comp Nbr Contains miscellaneous data. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-VETERAN Alpha 4 BN305 HR11.1
Element: Veteran Indicates the individual is a veteran. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-BIRTHDATE Numeric 8 (yyyymmdd) BN305 BN350
Element: Birthdate Contains the employee's birth date. HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 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) BN305 HR11.1
Element: Birth Place: CContains the city where the employee HR11.2 HR511
was born. PA02.1 PA100
PA102 PA115
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-BIRTH-STATE Alpha 2 BN305 HR11.1
Birth Place: Contains the two-character abbreviation HR11.2 HR511
State/Province of the state where the employee was PA02.1 PA100
born. PA102 PA115
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-BIRTH-CNTRY-CD Alpha 2 BN305 HR11.1
Element: Birth Cntry CdIndicates country where employee was HR11.2 HR511
born. PA02.1 PA100
PA102 PA115
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-SENIOR-DATE Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Senior Date Contains the employee's seniority date. HR11.2 HR511
PA02.1 PA10.1
PA100 PA102
PA115 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
PR84.1
PEM-MAIDEN-LST-NM Alpha 30 (Lower Case) BN305 HR11.1
Element: Maiden Lst Nm Contains the employee's maiden last HR11.2 HR511
name. PA02.1 PA100
PA102 PA115
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-MAIDEN-FST-NM Alpha 15 (Lower Case) BN305 HR11.1
Element: Maiden Fst Nm Contains the employee's maiden first HR11.2 HR511
name. PA02.1 PA100
PA102 PA115
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-MAIDEN-MI Alpha 1 BN305 HR11.1
Maiden Name Middle Contains the employee's maiden middle HR11.2 HR511
Initial initial. PA02.1 PA100
PA102 PA115
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-FORMER-LST-NM Alpha 30 (Lower Case) BN305 HR11.1
Element: Former Lst Nm Contains the employee's former last HR11.2 HR511
name. PA02.1 PA100
PA102 PA115
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-FORMER-FST-NM Alpha 15 (Lower Case) BN305 HR11.1
Element: Former Fst Nm Contains the employee's former first HR11.2 HR511
name. PA02.1 PA100
PA102 PA115
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-FORMER-MI Alpha 1 BN305 HR11.1
Former Name Middle Contains the employee's former middle HR11.2 HR511
Initial initial. PA02.1 PA100
PA102 PA115
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-LOCAT-CODE Alpha 10 BN305 HR11.1
Element: Locat Code Contains a user-defined location code HR11.2 HR511
that identifies where the employee PA02.1 PA10.1
works. The Human Resource Code file PA100 PA102
validates this field. PA115 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 BN305 HR11.1
Element: Hire Source Contains a user-defined hire source HR11.2 HR511
code that identifies the source from PA02.1 PA100
which the employee was acquired. This PA102 PA115
field is validated in the Human Resource PA13.1 PA13.2
Code file. PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SECURITY-CODE Alpha 10 BN305 HR11.1
Element: Security Code Contains a user-defined badge code HR11.2 HR511
assigned to the employee. This field is PA02.1 PA100
not associated with Lawson user PA102 PA115
security. 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-SECURITY-NBR Alpha 10 BN305 HR11.1
Element: Security Nbr Contains an internal security number HR11.2 HR511
that is assigned to the employee. This PA02.1 PA100
field is not associated with Lawson user PA102 PA115
security. 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-BARGAIN-UNIT Alpha 10 BN305 HR11.1
Element: Bargain Unit Contains a user-defined code that HR11.2 HR511
represents the employee's union PA02.1 PA100
bargaining unit. PA102 PA115
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-CLOCK-NBR Alpha 10 BN305 HR11.1
Element: Clock Nbr Contains the employee's clock number. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-MAIL-GROUP Alpha 10 BN305 HR11.1
Element: Mail Group Contains a user-defined code that HR11.2 HR511
identifies the mail group to which an PA02.1 PA100
employee belongs. PA102 PA115
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-MB-NBR Alpha 10 BN305 HR11.1
Element: Mb Nbr Contains the employee's mail box number. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-DRAFT-STATUS Alpha 3 BN305 HR11.1
Element: Draft Status Contains a user-defined code that HR11.2 HR511
identifies the employee's draft status. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-FINAL-RANK Alpha 3 BN305 HR11.1
Element: Final Rank Identifies the highest military rank HR11.2 HR511
attained by the employee. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-CUR-STATUS Alpha 2 BN305 HR11.1
Element: Cur Status Indicates if the employee is currently HR11.2 HR511
in the Reserves or National Guard. PA02.1 PA100
NG = National Guard PA102 PA115
RE = Reserves PA13.1 PA13.2
PA14.1 PA502
PA513 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) BN305 HR11.1
Element: Last Physical Contains the date of the employee's HR11.2 HR511
last physical exam. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-PHY-SCHD Alpha 2 BN305 HR11.1
Element: Phy Schd Contains the frequency of the HR11.2 HR511
employee's physical examinations. PA02.1 PA100
2Y = 2 years PA102 PA115
3Y = 3 years PA13.1 PA13.2
4Y = 4 years PA15.1 PA502
5Y = 5 years PA513 PA52.1
6Y = 6 years PA52.3 PA52.4
7Y = 7 years PA52.5 PR110
8Y = 8 years PR113 PR120
9Y = 9 years PR13.1 PR13.5
AN = Annual PR13.6 PR13.8
MO = Monthly
QT = Quarterly
SA = Semi-annual
PEM-NEXT-PHYSICAL Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Next Physical Contains the date of the employee's HR11.2 HR511
next scheduled physical exam. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-HEIGHT-FT Numeric 2 BN305 HR11.1
Element: Height Ft Contains the employee's height in feet. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-HEIGHT-IN Numeric 2 BN305 HR11.1
Element: Height In Contains the employee's height in HR11.2 HR511
inches. PA02.1 PA100
01 PA102 PA115
11 PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-WGHT Signed 5.2 BN305 HR11.1
Element: Wght Contains the employee's weight. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-BLOOD-TYPE Alpha 3 BN305 HR11.1
Element: Blood Type Contains the employee's blood type. HR11.2 HR511
A+ PA02.1 PA100
A- PA102 PA115
AB+ PA13.1 PA13.2
AB- PA15.1 PA502
B+ PA513 PA52.1
B- PA52.3 PA52.4
O+ PA52.5 PR110
O- PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-PARKING-LOT Alpha 10 BN305 HR11.1
Element: Parking Lot Contains a user-defined code that HR11.2 HR511
represents the employee's assigned PA02.1 PA100
parking lot. PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-PARKING-SPACE Alpha 10 BN305 HR11.1
Element: Parking Space Identifies the parking space assigned HR11.2 HR511
to the employee. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-DR-LICENSE Alpha 20 BN305 HR11.1
Element: Dr License Contains the employee's driver's HR11.2 HR511
license number. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 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 BN305 HR11.1
Element: Dr Lic St Contains the abbreviation of the state HR11.2 HR511
that issued the employee's driver's PA02.1 PA100
license. PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 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) BN305 HR11.1
Element: Expiration Contains the expiration date of the HR11.2 HR511
employee's driver's license. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 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 BN305 HR11.1
Element: Dr Lic Class Contains the class of the employee's HR11.2 HR511
driver's license. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-REV-SCHEDULE Alpha 2 PA26.1
Element: Rev Schedule Identifies the frequency of performance
reviews for the employee.
AN = Annual
MO = Monthly
QT = Quarterly
SA = Semi-annual
PEM-NEXT-REVIEW Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Next Review Contains the next scheduled performance HR11.2 HR511
review date for the employee. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA502
PA513 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 BN305 HR11.1
Element: Next Rev Code Identifies the review type for the next HR11.2 HR511
scheduled review date (for example, PA02.1 PA100
salary review). PA102 PA115
PA13.1 PA13.2
PA26.1 PA502
PA513 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) BN305 HR11.1
Element: Last Review Contains the date of the employee's HR11.2 HR511
last review. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA502
PA513 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 BN305 HR11.1
Element: Last Mil Seq Contains the last sequence number used HR11.2 HR511
to store a military record. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 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 BN305 HR11.1
Element: Last Rev Seq Contains the last sequence number used HR11.2 HR511
to store a review record. HS701 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA26.1
PA502 PA513
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 BN305 BN90.1
Element: Last Com Seq Contains the last sequence number used HR11.1 HR11.2
to store a comment record. HR511 HR90.1
HR90.2 PA02.1
PA100 PA102
PA115 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
PR530
PEM-LAST-INT-SEQ Numeric 4 BN305 HR11.1
Element: Last Int Seq Contains the last sequence number used HR11.2 HR511
to store an interview record. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA41.1 PA502
PA513 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 BN305 BN47.1
Element: Last Bnf Seq Contains the last sequence number used BN547 HR11.1
to store a beneficiary record. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-LAST-INV-NBR Numeric 4 BN180 BN305
Element: Last Inv Nbr Contains the last sequence number used BN80.1 HR11.1
to store an invoice record. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-LAST-EPC-SEQ Numeric 4 BN305 HR11.1
Element: Last Epc Seq Contains the last sequence number used HR11.2 HR511
to store HR codes for an employee. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA16.1 PA20.1
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA513
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 BN305 HR11.1
Element: Fnctn Group Identifies for the EEO-4 report, the HR11.2 HR511
type of work the employee does. PA02.1 PA100
01 PA102 PA115
15 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-EXCLUDE-FLAG Alpha 1 BN305 HR11.1
Element: Exclude Flag Determines if an employee is included HR11.2 HR511
in the EEO-4 report. PA02.1 PA100
N = Include on EEO-4 Report PA102 PA115
Y = Exclude from EEO-4 Report 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-NBR-HL-DEP Numeric 3 BN305 HR11.1
Element: Health DependeContains the number of dependents HR11.2 HR13.1
covered by the employee's health HR511 HR513
insurance. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA218 PA502
PA513 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 BN305 HR11.1
Element: Dental DependeContains the number of dependents HR11.2 HR13.1
covered by the employee's dental HR511 HR513
insurance. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA218 PA502
PA513 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 BN305 HR11.1
Element: Life Style Cr Contains the number of credits given HR11.2 HR511
for a healthy lifestyle. This is used to PA02.1 PA100
calculate flex credits. PA102 PA115
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-HL-COV-PROOF Alpha 1 BN305 HR11.1
Element: Spouse Health Indicates if there is proof that the HR11.2 HR511
employee is covered by health insurance PA02.1 PA100
outside the company. PA102 PA115
N = No PA13.1 PA13.2
Y = Yes PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-DN-COV-PROOF Alpha 1 BN305 HR11.1
Element: Spouse Dental Indicates if there is proof that the HR11.2 HR511
employee is covered by dental insurance PA02.1 PA100
outside the company. PA102 PA115
N = No PA13.1 PA13.2
Y = Yes PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-HL-VERIFY-DT Numeric 8 (yyyymmdd) BN305 HR11.1
Spouse Health Plan Contains the date outside health HR11.2 HR511
Verify Date coverage was verified. PA02.1 PA100
PA102 PA115
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-DN-VERIFY-DT Numeric 8 (yyyymmdd) BN305 HR11.1
Spouse Dental Plan Contains the date outside dental HR11.2 HR511
Verify Date coverage was verified. PA02.1 PA100
PA102 PA115
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-SPOUSE-EMP Alpha 30 (Lower Case) BN305 HR11.1
Element: Spouse Emp Contains the name of the employee's HR11.2 HR511
spouse's employer. PA02.1 PA100
PA102 PA115
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-SP-EMP-ADDR1 Alpha 30 (Lower Case) BN305 HR11.1
Spouse Employer Contains the first line of the spouse's HR11.2 HR511
Address 1 employer's address. PA02.1 PA100
PA102 PA115
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-SP-EMP-ADDR2 Alpha 30 (Lower Case) BN305 HR11.1
Spouse Employer Contains the second line of the HR11.2 HR511
Address 2 spouse's employer's address. PA02.1 PA100
PA102 PA115
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-SP-EMP-ADDR3 Alpha 30 (Lower Case) BN305 HR11.1
Element: Sp Emp Addr3 Contains the third line of the spouse's HR11.2 HR511
employer's address. PA02.1 PA100
PA102 PA115
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-SP-EMP-ADDR4 Alpha 30 (Lower Case) BN305 HR11.1
Element: Sp Emp Addr4 Contains the fourth line of the HR11.2 HR511
spouse's employer's address. PA02.1 PA100
PA102 PA115
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-SP-EMP-CITY Alpha 18 (Lower Case) BN305 HR11.1
Element: Spouse EmployeContains the city of the spouse's HR11.2 HR511
employer's address. PA02.1 PA100
PA102 PA115
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-SP-EMP-STATE Alpha 2 BN305 HR11.1
Spouse Employer Contains the state of the spouse's HR11.2 HR511
State/Province employer's address. PA02.1 PA100
PA102 PA115
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-SP-EMP-ZIP Alpha 10 BN305 HR11.1
Spouse Employer Contains the postal code of the HR11.2 HR511
Postal Code spouse's employer's address. PA02.1 PA100
PA102 PA115
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-SP-EMP-COUNTRY Alpha 2 BN305 HR11.1
Element: Sp Emp CountryContains country of spouse's employer's HR11.2 HR511
address. PA02.1 PA100
PA102 PA115
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-SP-EMP-PH-CNTR Alpha 6 BN305 HR11.1
Element: Sp Emp Ph CntrContains the country code of the HR11.2 HR511
spouse's employer's telephone number. PA02.1 PA100
PA102 PA115
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-SP-EMP-PH-NBR Alpha 15 BN305 HR11.1
Element: Sp Emp Ph Nbr Contains the spouse's employer's HR11.2 HR511
telephone number. PA02.1 PA100
PA102 PA115
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-OWNER-FLAG Alpha 1 BN305 HR11.1
Element: Owner Identifies owners of the company. HR11.2 HR511
N = No PA02.1 PA100
Y = Yes PA102 PA115
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-KEY-EMP-FLAG Alpha 1 BN305 HR11.1
Element: Key Employee Identifies key employees of the HR11.2 HR511
company. PA02.1 PA100
N = No PA102 PA115
Y = Yes 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-OFFICER Alpha 1 BN305 HR11.1
Element: Officer Identifies officers of the company. HR11.2 HR511
N = No PA02.1 PA100
Y = Yes PA102 PA115
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-HIGH-COMP Alpha 1 BN305 HR11.1
Element: Highly CompensIdentifies highly compensated employees HR11.2 HR511
for non-discrimination testing in the PA02.1 PA100
Lawson Benefits System. PA102 PA115
N = No PA13.1 PA13.2
Y = Yes PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-SMOKER Alpha 1 BN305 HR11.1
Element: Smoker Indicates if an employee is a smoker. HR11.2 HR511
The Lawson Benefits system uses this PA02.1 PA100
information when calculating employee PA102 PA115
life and disability insurance premiums. PA13.1 PA13.2
N = No PA502 PA513
Y = Yes PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-I9-STATUS Alpha 10 BN305 HR11.1
Element: I9 Status Identifies the employee's immigration HR11.2 HR511
status. PA02.1 PA100
PA102 PA115
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-I9-ALIEN-NBR Alpha 11 BN305 HR11.1
Element: I9 Alien Nbr Contains the employee's alien number. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-I9-ADMIT-NBR Alpha 13 BN305 HR11.1
Element: I9 Admit Nbr Contains the employee's admission HR11.2 HR511
number. PA02.1 PA100
PA102 PA115
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-I9-STA-EXP-DT Numeric 8 (yyyymmdd) BN305 HR11.1
Element: I9 Sta Exp Dt Contains the expiration date of the HR11.2 HR511
employee's work authorization status. PA02.1 PA100
PA102 PA115
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-I9-DOC-NBR Alpha 20 Occurs 2 Times BN305 HR11.1
Element: I9 Doc Nbr Contains the document identification HR11.2 HR511
number. PA02.1 PA100
PA102 PA115
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-I9-DOC-TYPE Alpha 10 Occurs 2 Times BN305 HR11.1
Element: I9 Doc Type Identifies the type of document entered. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-I9-DOC-EXP-DT Numeric 8 (yyyymmdd) Occurs 2 Times BN305 HR11.1
Element: I9 Doc Exp Dt Contains the expiration date of the HR11.2 HR511
document. PA02.1 PA100
PA102 PA115
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-I9-AUTHORIZE Alpha 30 (Lower Case) BN305 HR11.1
Element: I9 Authorize Identifies the person who examined the HR11.2 HR511
evidence or documents establishing the PA02.1 PA100
employee's identity and employment PA102 PA115
eligibility. 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-TRUE-MAR-STAT Alpha 1 BN305 HR11.1
Element: True Mar Stat Contains the employee's true marital HR11.2 HR511
status. PA02.1 PA100
D = Divorced PA102 PA115
M = Married PA13.1 PA13.2
S = Single PA502 PA513
W = Widowed PA52.1 PA52.3
L = Legally Separated PA52.4 PA52.5
O = Significant Other PR110 PR113
P = Domestic Partner PR120 PR13.1
C = Common Law PR13.5 PR13.6
R = Separated PR13.8
U = Unmarried
PEM-LAST-PAE-SEQ Numeric 4 BN305 HR11.1
Element: Last Pae Seq Contains the last number used to store HR11.2 HR511
an emergency contact record for the PA02.1 PA100
employee. PA102 PA115
PA12.1 PA13.1
PA13.2 PA502
PA512 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PEM-PRIMARY-CARE Alpha 10 BN305 HR11.1
Element: Primary Care Contains the code that represents the HR11.2 HR511
employee's primary care physician. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PEM-FAMILY-AGG Numeric 9 BN305 HR11.1
Element: Family Agg Contains the number of the employee HR11.2 HR511
defined as the family aggregate PA02.1 PA100
employee. PA102 PA115
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-BEN-SALARY-1 Signed 11.2 BN305 HR11.1
Element: Benefit SalaryContains optional user-defined benefit HR11.2 HR511
salary information. PA02.1 PA100
PA102 PA115
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-BEN-SALARY-2 Signed 11.2 BN305 HR11.1
Element: Benefit SalaryContains optional user-defined benefit HR11.2 HR511
salary information. PA02.1 PA100
PA102 PA115
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-BEN-SALARY-3 Signed 11.2 BN305 HR11.1
Element: Benefit SalaryContains optional user-defined benefit HR11.2 HR511
salary information. PA02.1 PA100
PA102 PA115
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-BEN-SALARY-4 Signed 11.2 BN305 HR11.1
Element: Benefit SalaryContains optional user-defined benefit HR11.2 HR511
salary information. PA02.1 PA100
PA102 PA115
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-BEN-SALARY-5 Signed 11.2 BN305 HR11.1
Element: Benefit SalaryContains optional user-defined benefit HR11.2 HR511
salary information. PA02.1 PA100
PA102 PA115
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-BEN-DATE-1 Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Ben Date 1 Contains an optional user-defined HR11.2 HR511
benefit date. PA02.1 PA100
PA102 PA115
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-BEN-DATE-2 Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Ben Date 2 Contains an optional user-defined HR11.2 HR511
benefit date. PA02.1 PA100
PA102 PA115
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-BEN-DATE-3 Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Ben Date 3 Contains an optional user-defined HR11.2 HR511
benefit date. PA02.1 PA100
PA102 PA115
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-BEN-DATE-4 Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Ben Date 4 Contains an optional user-defined HR11.2 HR511
benefit date. PA02.1 PA100
PA102 PA115
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-BEN-DATE-5 Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Ben Date 5 Contains an optional user-defined HR11.2 HR511
benefit date. PA02.1 PA100
PA102 PA115
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-SEC-LVL Numeric 1 BN305 HR11.1
Element: Sec Lvl Contains the employee's security level. HR11.2 HR12.1
HR511 PA02.1
PA100 PA102
PA115 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-SEC-LOCATION Alpha 10 BN305 HR11.1
Element: Sec Location Contains the employee's security HR11.2 HR12.1
location. HR511 PA02.1
PA100 PA102
PA115 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-CUR-AGE Derived
Element: Cur Age
PEM-SEX-1 Derived
Element: Sex 1
PEM-EEO-CLASS-1 Derived
Element: Eeo Class 1
PEM-WORK-ZIP Alpha 10 BN305 HR11.1
Element: Work Zip Contains the employee's work postal HR11.2 HR511
code. PA02.1 PA100
PA102 PA115
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-HEIGHT-UNIT Alpha 1 PA15.1
Element: Height Unit Contains unit in which height is
recorded.
1 = Feet
2 = Meters
PEM-WGHT-UNIT Alpha 1 PA15.1
Element: Wght Unit Contains unit in which the employee's
weight is recorded.
1 = Pounds
2 = Stones
3 = Kilograms
PEM-LANGUAGE-CODE Alpha 10 BN305 HR11.1
Element: Language Code Contains employee's language if other HR11.2 HR511
than company's primary language. PA02.1 PA100
PA102 PA115
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-RELIGION Alpha 10 BN305 HR11.1
Element: Religion Contains employee's religion. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-DISABILITY Alpha 10 BN305 HR11.1
Element: Disability Contains type of disability. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-SUPP-PHONE-CNT Alpha 6 BN305 HR11.1
Element: Supp Phone CntContains phone country of supplemental HR11.2 HR511
phone number. PA02.1 PA100
PA102 PA115
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-SUPP-PHONE-NBR Alpha 15 BN305 HR11.1
Element: Supp Phone NbrContains supplemental phone number. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-CONSENT Alpha 1 BN305 HR11.1
Element: Consent N = No HR11.2 HR511
Y = Yes PA02.1 PA100
" " = No PA102 PA115
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-ABORIGINAL Alpha 1 BN305 HR11.1
Element: Aboriginal Designates if an employee is Aboriginal. HR11.2 HR511
N = No PA02.1 PA100
Y = Yes PA102 PA115
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-VISIBLE-MIN Alpha 1 BN305 HR11.1
Element: Visible Min Designates if an employee is a visible HR11.2 HR511
minority. PA02.1 PA100
N = No PA102 PA115
Y = Yes 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-RELATED-EMP Alpha 1 BN305 HR11.1
Element: Related Emp Determines whether or not an employee is HR11.2 HR511
related to the employer. PA02.1 PA100
N = No PA102 PA115
Y = Yes 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-I9-DOC-DESCR Alpha 10 Occurs 2 Times BN305 HR11.1
Element: I9 Doc Descr HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-BILINGUAL Alpha 1 PA96.1
Element: Bilingual N = No
Y = Yes
PEM-SUPP-COUNTY Alpha 25 (Lower Case) BN305 HR11.1
Element: County The county for the company address. HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-STOCK-TRADE Alpha 1 BN305 HR11.1
Element: Stock Trade " " = Not applicable HR11.2 HR511
1 = Insider PA02.1 PA100
2 = SEC Restricted PA102 PA115
3 = Insider & SEC Restricted 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-DATE-ASSIGN Numeric 8 (yyyymmdd) BN305 HR11.1
Element: Date Assign HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-USER-AMOUNT Signed 13.4 BN305 HR11.1
Element: User Amount HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-ESTAB-PATIENT Numeric 1 BN305 HR11.1
Element: Estab Patient 1 = No HR11.2 HR511
2 = Yes PA02.1 PA100
3 = Unknown PA102 PA115
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-PRIOR-COV-MO Numeric 2 BN305 HR11.1
Element: Prior Cov Mo HR11.2 HR511
PA02.1 PA100
PA102 PA115
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-MEDICARE-IND Alpha 1 BN305 HR11.1
Element: Medicare Ind A = Medicare Part A HR11.2 HR511
B = Medicare Part B PA02.1 PA100
C = Medicare Part A and B PA102 PA115
D = Medicare Part Unknown PA13.1 PA13.2
E = No Medicare PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PAEMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEMSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
BN104 BN105
BN106 BN137
BN138 BN140
BN141 BN145
BN150 BN175
BN180 BN230
BN231 BN232
BN233 BN234
BN236 BN237
BN238 BN240
BN242 BN245
BN246 BN248
BN258 BN285
...
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
Veteran HRCTRYCODE Required
When PEM-VETERAN != Spaces
"VS" -> CTC-TYPE
EMP-WORK-COUNTRY -> CTC-COUNTRY-CODE
PEM-VETERAN -> CTC-HRCTRY-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-STOCK-CTF
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
Paencumber PAENCUMBER Delete Restricted
PEM-COMPANY -> PEN-COMPANY
PEM-EMPLOYEE -> PEN-EMPLOYEE
PEN-POSITION
PEN-PROCESS-LEVEL
PEN-DEPARTMENT
PEN-JOB-CODE
PEN-GLT-OBJ-ID
PEN-ATN-OBJ-ID
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
PEM-EMPLOYEE -> PCT-EMPLOYEE
PCT-ACTION-TYPE
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
REV-SEQ-NBR
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
BEG-STOCK-CTF
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
|