PAEMPLOYEE

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
BN149 BN150 BN175 BN230 BN231 BN232
BN233 BN234 BN236 BN237 BN238 BN240
BN242 BN245 BN246 BN248 BN255 BN258
BN285 BN297 BN299 BN31.1 BN31.2 BN310
BN32.1 BN32.2 BN32.3 BN320 BN325 BN33.1
BN33.2 BN33.3 BN330 BN331 BN335 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 BN729 BN990 BN991 BN996 BS09.1
BS10.1 BS11.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 XB500 XB510 XB515 XB520 HCDL.1
HCEM.1 HCHP.1 HLTM.1 HR170 HR20.1 HR211
HR217 HR220 HR30.1 HR70.1 HS08.1 HS10.1
HS10.2 HS208 HS703 HS705 PR521 XH700
XH777 EXI2.1 EXI3.1 EXI4.1 LP102 LP130
LP138 LP140 LP251 LP51.1 HS11.1 HS11.2
HS12.1 HS12.2 HS13.1 HS13.2 HS14.1 HS50.1
HS50.2 HS704 PA10.1 PA113 PA149 PA210
PA216 PA220 PA221 PA222 PA223 PA224
PA225 PA227 PA248 PA249 PA262 PA272
PA290 PA296 PA31.1 PA311 PA335 PA350
PA355 PA360 PA370 PA372 PA406 PA495
PA496 PA53.1 PA531 PA532 PA533 PA534
PA59.1 PA590 PA594 PA64.1 PA64.2 PA66.2
PA66.3 PA90.1 TR120 TR121 TR20.1 TR20.2
TR20.3 TR20.4 TR207 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR139
PR14.1 PR14.2 PR140 PR15.2 PR160 PR180
PR188 PR189 PR195 PR197 PR198 PR205
PR240 PR241 PR242 PR243 PR244 PR245
PR249 PR250 PR251 PR252 PR253 PR271
PR274 PR282 PR29.1 PR292 PR293 PR296
PR297 PR299 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR37.1 PR45.1
PR529 PR560 PR582 PR80.1 PR80.2 PR80.4
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 HS702 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 PA526
PA96.1 TR21.1 TR22.1 TR26.1 TR500 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR530 PR84.1 BN300 BN340 HAP3.1
HCRE.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR15.1
HR155 HR156 HR213 HR515 HR54.1 HR55.2
HRS1.1 HRSC.1 LP100 LP101 PA212 PA214
PA215 PA217 PA310 PA315 PA320 PA325
PA330 PA345 PA390 PA391 PA392 PA393
PA490 PA54.1 PA702

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEM-COMPANY
Element: Company Hr
Numeric 4
Contains the number that represents an established company and is entered on all functions.
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
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
PR13.9
PEM-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. An employee number is assigned to each person employed by the company. The system uses the employee number to correlate all information related to the employee. This number must be valid in the Employee file.
BN305 BN350
HR11.1 HR11.2
HR511 PA02.1
PA100 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 PR13.9
PEM-SUPP-ADDR1
Element: Supplemental Address
Alpha 30 (Lower Case)
Contains the first line of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-SUPP-ADDR2
Supplemental
Address 2
Alpha 30 (Lower Case)
Contains the second line of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-SUPP-ADDR3
Element: Supp Addr3
Alpha 30 (Lower Case)
Contains the third line of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-SUPP-ADDR4
Element: Supp Addr4
Alpha 30 (Lower Case)
Contains the fourth line of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-SUPP-CITY
Supplemental
Address City
Alpha 18 (Lower Case)
Contains the city of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-SUPP-STATE
Suppl. Address
State/Province
Alpha 2
Contains the state of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-SUPP-ZIP
Suppl. Address
Postal Code
Alpha 10
Contains the postal code of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-SUPP-CNTRY-CD
Element: Supp Cntry Cd
Alpha 2
Contains the country of the supplemental address.
BN305 HR11.1
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 PR13.9
PEM-HM-PHONE-CNTRY
Element: Hm Phone Cntry
Alpha 6
Contains the country code of the employee's home telephone number.
BN305 HR11.1
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 PR13.9
PEM-HM-PHONE-NBR
Element: Hm Phone Nbr
Alpha 15
Contains the employee's home telephone number.
BN305 HR11.1
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 PR13.9
PEM-WK-PHONE-CNTRY
Element: Wk Phone Cntry
Alpha 6
Contains the country code of the employee's work telephone number.
BN305 HR11.1
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 PR13.9
PEM-WK-PHONE-NBR
Element: Wk Phone Nbr
Alpha 15
Contains the employee's work telephone number.
BN305 HR11.1
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 PR13.9
PEM-WK-PHONE-EXT
Element: Wk Phone Ext
Alpha 5
Contains the extension of the employee's work telephone number.
BN305 HR11.1
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 PR13.9
PEM-EEO-CLASS
Element: Eeo Class
Alpha 4 (Lower Case)
Contains the employee's ethnic origin.
BN305 HR11.1
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 PR13.9
PEM-SEX
Element: Sex
Alpha 1
Contains the employee's gender.
F = Female
M = Male
BN305 HR11.1
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 PR13.9
PEM-HANDICAP-ID
Element: Handicap Id
Alpha 1
Indicates if the employee is disabled.
Y = Yes
N = No
BN305 HR11.1
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 PR13.9
PEM-COMP-CODE
Element: Comp Code
Alpha 4
Contains miscellaneous data.
BN305 HR11.1
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 PR13.9
PEM-COMP-NBR
Element: Comp Nbr
Alpha 10
Contains miscellaneous data.
BN305 HR11.1
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 PR13.9
PEM-VETERAN
Element: Veteran
Alpha 4
Indicates the individual is a veteran.
BN305 HR11.1
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
PR13.9
PEM-BIRTHDATE
Element: Birthdate
Numeric 8 (yyyymmdd)
Contains the employee's birth date.
BN305 BN350
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 PR13.9
PEM-BIRTH-CITY
Element: Birth Place: City
Alpha 18 (Lower Case)
Contains the city where the employee was born.
BN305 HR11.1
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 PR13.9
PEM-BIRTH-STATE
Birth Place:
State/Province
Alpha 2
Contains the two-character abbreviation of the state where the employee was born.
BN305 HR11.1
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 PR13.9
PEM-BIRTH-CNTRY-CD
Element: Birth Cntry Cd
Alpha 2
Indicates country where employee was born.
BN305 HR11.1
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 PR13.9
PEM-SENIOR-DATE
Element: Senior Date
Numeric 8 (yyyymmdd)
Contains the employee's seniority date.
BN305 HR11.1
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
PR13.9 PR84.1
PEM-MAIDEN-LST-NM
Element: Maiden Lst Nm
Alpha 30 (Lower Case)
Contains the employee's maiden last name.
BN305 HR11.1
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 PR13.9
PEM-MAIDEN-FST-NM
Element: Maiden Fst Nm
Alpha 15 (Lower Case)
Contains the employee's maiden first name.
BN305 HR11.1
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 PR13.9
PEM-MAIDEN-MI
Maiden Name Middle
Initial
Alpha 1
Contains the employee's maiden middle initial.
BN305 HR11.1
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 PR13.9
PEM-FORMER-LST-NM
Element: Former Lst Nm
Alpha 30 (Lower Case)
Contains the employee's former last name.
BN305 HR11.1
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 PR13.9
PEM-FORMER-FST-NM
Element: Former Fst Nm
Alpha 15 (Lower Case)
Contains the employee's former first name.
BN305 HR11.1
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 PR13.9
PEM-FORMER-MI
Former Name Middle
Initial
Alpha 1
Contains the employee's former middle initial.
BN305 HR11.1
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 PR13.9
PEM-LOCAT-CODE
Element: Locat Code
Alpha 10
Contains a user-defined location code that identifies where the employee works. The Human Resource Code file validates this field.
BN305 HR11.1
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
PR13.9
PEM-HIRE-SOURCE
Element: Hire Source
Alpha 10
Contains a user-defined hire source code that identifies the source from which the employee was acquired. This field is validated in the Human Resource Code file.
BN305 HR11.1
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 PR13.9
PEM-SECURITY-CODE
Element: Security Code
Alpha 10
Contains a user-defined badge code assigned to the employee. This field is not associated with Lawson user security.
BN305 HR11.1
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 PR13.9
PEM-SECURITY-NBR
Element: Security Nbr
Alpha 10
Contains an internal security number that is assigned to the employee. This field is not associated with Lawson user security.
BN305 HR11.1
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 PR13.9
XH700 XH777
PEM-BARGAIN-UNIT
Element: Bargain Unit
Alpha 10
Contains a user-defined code that represents the employee's union bargaining unit.
BN305 HR11.1
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 PR13.9
PEM-CLOCK-NBR
Element: Clock Nbr
Alpha 10
Contains the employee's clock number.
BN305 HR11.1
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 PR13.9
PEM-MAIL-GROUP
Element: Mail Group
Alpha 10
Contains a user-defined code that identifies the mail group to which an employee belongs.
BN305 HR11.1
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 PR13.9
PEM-MB-NBR
Element: Mb Nbr
Alpha 10
Contains the employee's mail box number.
BN305 HR11.1
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 PR13.9
PEM-DRAFT-STATUS
Element: Draft Status
Alpha 3
Contains a user-defined code that identifies the employee's draft status.
BN305 HR11.1
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
PR13.9
PEM-FINAL-RANK
Element: Final Rank
Alpha 3
Identifies the highest military rank attained by the employee.
BN305 HR11.1
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
PR13.9
PEM-CUR-STATUS
Element: Cur Status
Alpha 2
Indicates if the employee is currently in the Reserves or National Guard.
NG = National Guard
RE = Reserves
BN305 HR11.1
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
PR13.9
PEM-LAST-PHYSICAL
Element: Last Physical
Numeric 8 (yyyymmdd)
Contains the date of the employee's last physical exam.
BN305 HR11.1
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
PR13.9
PEM-PHY-SCHD
Element: Phy Schd
Alpha 2
Contains the frequency of the employee's physical examinations.
2Y = 2 years
3Y = 3 years
4Y = 4 years
5Y = 5 years
6Y = 6 years
7Y = 7 years
8Y = 8 years
9Y = 9 years
AN = Annual
MO = Monthly
QT = Quarterly
SA = Semi-annual
BN305 HR11.1
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
PR13.9
PEM-NEXT-PHYSICAL
Element: Next Physical
Numeric 8 (yyyymmdd)
Contains the date of the employee's next scheduled physical exam.
BN305 HR11.1
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
PR13.9
PEM-HEIGHT-FT
Element: Height Ft
Numeric 2
Contains the employee's height in feet.
BN305 HR11.1
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
PR13.9
PEM-HEIGHT-IN
Element: Height In
Numeric 2
Contains the employee's height in inches.
01
11
BN305 HR11.1
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
PR13.9
PEM-WGHT
Element: Wght
Signed 5.2
Contains the employee's weight.
BN305 HR11.1
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
PR13.9
PEM-BLOOD-TYPE
Element: Blood Type
Alpha 3
Contains the employee's blood type.
A+
A-
AB+
AB-
B+
B-
O+
O-
BN305 HR11.1
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
PR13.9
PEM-PARKING-LOT
Element: Parking Lot
Alpha 10
Contains a user-defined code that represents the employee's assigned parking lot.
BN305 HR11.1
HR11.2 HR511
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
PR13.9
PEM-PARKING-SPACE
Element: Parking Space
Alpha 10
Identifies the parking space assigned to the employee.
BN305 HR11.1
HR11.2 HR511
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
PR13.9
PEM-DR-LICENSE
Element: Dr License
Alpha 20
Contains the employee's driver's license number.
BN305 HR11.1
HR11.2 HR511
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
PR13.9
PEM-DR-LIC-ST
Element: Dr Lic St
Alpha 2
Contains the abbreviation of the state that issued the employee's driver's license.
BN305 HR11.1
HR11.2 HR511
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
PR13.9
PEM-EXP-DATE
Element: Expiration
Numeric 8 (yyyymmdd)
Contains the expiration date of the employee's driver's license.
BN305 HR11.1
HR11.2 HR511
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
PR13.9
PEM-DR-LIC-CLASS
Element: Dr Lic Class
Alpha 3
Contains the class of the employee's driver's license.
BN305 HR11.1
HR11.2 HR511
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
PR13.9
PEM-REV-SCHEDULE
Element: Rev Schedule
Alpha 2
Identifies the frequency of performance reviews for the employee.
AN = Annual
MO = Monthly
QT = Quarterly
SA = Semi-annual
PA26.1 PA526
PEM-NEXT-REVIEW
Element: Next Review
Numeric 8 (yyyymmdd)
Contains the next scheduled performance review date for the employee.
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA345
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA526 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
PEM-NEXT-REV-CODE
Element: Next Rev Code
Alpha 10
Identifies the review type for the next scheduled review date (for example, salary review).
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA345
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA526 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9
PEM-LAST-REVIEW
Element: Last Review
Numeric 8 (yyyymmdd)
Contains the date of the employee's last review.
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA526
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PEM-LAST-MIL-SEQ
Element: Last Mil Seq
Numeric 4
Contains the last sequence number used to store a military record.
BN305 HR11.1
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
PR13.9
PEM-LAST-REV-SEQ
Element: Last Rev Seq
Numeric 4
Contains the last sequence number used to store a review record.
BN305 HR11.1
HR11.2 HR511
HS701 HS702
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA526
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PEM-LAST-COM-SEQ
Element: Last Com Seq
Numeric 4
Contains the last sequence number used to store a comment record.
BN305 BN90.1
HR11.1 HR11.2
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
PR13.9 PR530
PEM-LAST-INT-SEQ
Element: Last Int Seq
Numeric 4
Contains the last sequence number used to store an interview record.
BN305 HR11.1
HR11.2 HR511
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
PR13.9
PEM-LAST-BNF-SEQ
Element: Last Bnf Seq
Numeric 4
Contains the last sequence number used to store a beneficiary record.
BN305 BN47.1
BN547 HR11.1
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 PR13.9
PEM-LAST-INV-NBR
Element: Last Inv Nbr
Numeric 4
Contains the last sequence number used to store an invoice record.
BN180 BN305
BN80.1 HR11.1
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 PR13.9
PEM-LAST-EPC-SEQ
Element: Last Epc Seq
Numeric 4
Contains the last sequence number used to store HR codes for an employee.
BN305 HR11.1
HR11.2 HR511
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
PR13.9 TR21.1
TR22.1 TR26.1
TR500
PEM-FNCTN-GROUP
Element: Fnctn Group
Numeric 2
Identifies for the EEO-4 report, the type of work the employee does.
01
15
BN305 HR11.1
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 PR13.9
PEM-EXCLUDE-FLAG
Element: Exclude Flag
Alpha 1
Determines if an employee is included in the EEO-4 report.
N = Include on EEO-4 Report
Y = Exclude from EEO-4 Report
BN305 HR11.1
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 PR13.9
PEM-NBR-HL-DEP
Element: Health Dependents
Numeric 3
Contains the number of dependents covered by the employee's health insurance.
BN305 HR11.1
HR11.2 HR13.1
HR511 HR513
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
PR13.9
PEM-NBR-DN-DEP
Element: Dental Dependents
Numeric 3
Contains the number of dependents covered by the employee's dental insurance.
BN305 HR11.1
HR11.2 HR13.1
HR511 HR513
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
PR13.9
PEM-LIFE-STYLE-CR
Element: Life Style Cr
Numeric 2
Contains the number of credits given for a healthy lifestyle. This is used to calculate flex credits.
BN305 HR11.1
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 PR13.9
PEM-HL-COV-PROOF
Element: Spouse Health Plan
Alpha 1
Indicates if there is proof that the employee is covered by health insurance outside the company.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-DN-COV-PROOF
Element: Spouse Dental Plan
Alpha 1
Indicates if there is proof that the employee is covered by dental insurance outside the company.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-HL-VERIFY-DT
Spouse Health Plan
Verify Date
Numeric 8 (yyyymmdd)
Contains the date outside health coverage was verified.
BN305 HR11.1
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 PR13.9
PEM-DN-VERIFY-DT
Spouse Dental Plan
Verify Date
Numeric 8 (yyyymmdd)
Contains the date outside dental coverage was verified.
BN305 HR11.1
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 PR13.9
PEM-SPOUSE-EMP
Element: Spouse Emp
Alpha 30 (Lower Case)
Contains the name of the employee's spouse's employer.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-ADDR1
Spouse Employer
Address 1
Alpha 30 (Lower Case)
Contains the first line of the spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-ADDR2
Spouse Employer
Address 2
Alpha 30 (Lower Case)
Contains the second line of the spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-ADDR3
Element: Sp Emp Addr3
Alpha 30 (Lower Case)
Contains the third line of the spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-ADDR4
Element: Sp Emp Addr4
Alpha 30 (Lower Case)
Contains the fourth line of the spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-CITY
Element: Spouse Employer City
Alpha 18 (Lower Case)
Contains the city of the spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-STATE
Spouse Employer
State/Province
Alpha 2
Contains the state of the spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-ZIP
Spouse Employer
Postal Code
Alpha 10
Contains the postal code of the spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-COUNTRY
Element: Sp Emp Country
Alpha 2
Contains country of spouse's employer's address.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-PH-CNTR
Element: Sp Emp Ph Cntr
Alpha 6
Contains the country code of the spouse's employer's telephone number.
BN305 HR11.1
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 PR13.9
PEM-SP-EMP-PH-NBR
Element: Sp Emp Ph Nbr
Alpha 15
Contains the spouse's employer's telephone number.
BN305 HR11.1
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 PR13.9
PEM-OWNER-FLAG
Element: Owner
Alpha 1
Identifies owners of the company.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-KEY-EMP-FLAG
Element: Key Employee
Alpha 1
Identifies key employees of the company.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-OFFICER
Element: Officer
Alpha 1
Identifies officers of the company.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-HIGH-COMP
Element: Highly Compensated
Alpha 1
Identifies highly compensated employees for non-discrimination testing in the Lawson Benefits System.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-SMOKER
Element: Smoker
Alpha 1
Indicates if an employee is a smoker. The Lawson Benefits system uses this information when calculating employee life and disability insurance premiums.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-I9-STATUS
Element: I9 Status
Alpha 10
Identifies the employee's immigration status.
BN305 HR11.1
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 PR13.9
PEM-I9-ALIEN-NBR
Element: I9 Alien Nbr
Alpha 11
Contains the employee's alien number.
BN305 HR11.1
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 PR13.9
PEM-I9-ADMIT-NBR
Element: I9 Admit Nbr
Alpha 13
Contains the employee's admission number.
BN305 HR11.1
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 PR13.9
PEM-I9-STA-EXP-DT
Element: I9 Sta Exp Dt
Numeric 8 (yyyymmdd)
Contains the expiration date of the employee's work authorization status.
BN305 HR11.1
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 PR13.9
PEM-I9-DOC-NBR
Element: I9 Doc Nbr
Alpha 20 Occurs 2 Times
Contains the document identification number.
BN305 HR11.1
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 PR13.9
PEM-I9-DOC-TYPE
Element: I9 Doc Type
Alpha 10 Occurs 2 Times
Identifies the type of document entered.
BN305 HR11.1
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 PR13.9
PEM-I9-DOC-EXP-DT
Element: I9 Doc Exp Dt
Numeric 8 (yyyymmdd) Occurs 2 Times
Contains the expiration date of the document.
BN305 HR11.1
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 PR13.9
PEM-I9-AUTHORIZE
Element: I9 Authorize
Alpha 30 (Lower Case)
Identifies the person who examined the evidence or documents establishing the employee's identity and employment eligibility.
BN305 HR11.1
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 PR13.9
PEM-TRUE-MAR-STAT
Element: True Mar Stat
Alpha 1
Contains the employee's true marital status.
D = Divorced
M = Married
S = Single
W = Widowed
L = Legally Separated
O = Significant Other
P = Domestic Partner
C = Common Law
R = Separated
U = Unmarried
BN305 HR11.1
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 PR13.9
PEM-LAST-PAE-SEQ
Element: Last Pae Seq
Numeric 4
Contains the last number used to store an emergency contact record for the employee.
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
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 PR13.9
PEM-PRIMARY-CARE
Element: Primary Care
Alpha 10
Contains the code that represents the employee's primary care physician.
BN305 HR11.1
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
PR13.9
PEM-FAMILY-AGG
Element: Family Agg
Numeric 9
Contains the number of the employee defined as the family aggregate employee.
BN305 HR11.1
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 PR13.9
PEM-BEN-SALARY-1
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
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 PR13.9
PEM-BEN-SALARY-2
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
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 PR13.9
PEM-BEN-SALARY-3
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
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 PR13.9
PEM-BEN-SALARY-4
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
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 PR13.9
PEM-BEN-SALARY-5
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
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 PR13.9
PEM-BEN-DATE-1
Element: Ben Date 1
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
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 PR13.9
PEM-BEN-DATE-2
Element: Ben Date 2
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
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 PR13.9
PEM-BEN-DATE-3
Element: Ben Date 3
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
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 PR13.9
PEM-BEN-DATE-4
Element: Ben Date 4
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
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 PR13.9
PEM-BEN-DATE-5
Element: Ben Date 5
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
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 PR13.9
PEM-SEC-LVL
Element: Sec Lvl
Numeric 1
Contains the employee's security level.
BN305 HR11.1
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
PR13.9
PEM-SEC-LOCATION
Element: Sec Location
Alpha 10
Contains the employee's security location.
BN305 HR11.1
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
PR13.9
PEM-CUR-AGE
Element: Cur Age
Derived
PEM-SEX-1
Element: Sex 1
Derived
PEM-EEO-CLASS-1
Element: Eeo Class 1
Derived
PEM-WORK-ZIP
Element: Work Zip
Alpha 10
Contains the employee's work postal code.
BN305 HR11.1
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 PR13.9
PEM-HEIGHT-UNIT
Element: Height Unit
Alpha 1
Contains unit in which height is recorded.
1 = Feet
2 = Meters
PA15.1
PEM-WGHT-UNIT
Element: Wght Unit
Alpha 1
Contains unit in which the employee's weight is recorded.
1 = Pounds
2 = Stones
3 = Kilograms
PA15.1
PEM-LANGUAGE-CODE
Element: Language Code
Alpha 10
Contains employee's language if other than company's primary language.
BN305 HR11.1
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 PR13.9
PEM-RELIGION
Element: Religion
Alpha 10
Contains employee's religion.
BN305 HR11.1
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 PR13.9
PEM-DISABILITY
Element: Disability
Alpha 10
Contains type of disability.
BN305 HR11.1
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 PR13.9
PEM-SUPP-PHONE-CNT
Element: Supp Phone Cnt
Alpha 6
Contains phone country of supplemental phone number.
BN305 HR11.1
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 PR13.9
PEM-SUPP-PHONE-NBR
Element: Supp Phone Nbr
Alpha 15
Contains supplemental phone number.
BN305 HR11.1
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 PR13.9
PEM-CONSENT
Element: Consent
Alpha 1

N = No
Y = Yes
" " = No
BN305 HR11.1
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 PR13.9
PEM-ABORIGINAL
Element: Aboriginal
Alpha 1
Designates if an employee is Aboriginal.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-VISIBLE-MIN
Element: Visible Min
Alpha 1
Designates if an employee is a visible minority.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-RELATED-EMP
Element: Related Emp
Alpha 1
Determines whether or not an employee is related to the employer.
N = No
Y = Yes
BN305 HR11.1
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 PR13.9
PEM-I9-DOC-DESCR
Element: I9 Doc Descr
Alpha 10 Occurs 2 Times
BN305 HR11.1
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 PR13.9
PEM-BILINGUAL
Element: Bilingual
Alpha 1

N = No
Y = Yes
PA96.1
PEM-SUPP-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
BN305 HR11.1
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 PR13.9
PEM-STOCK-TRADE
Element: Stock Trade
Alpha 1

" " = Not applicable
1 = Insider
2 = SEC Restricted
3 = Insider & SEC Restricted
BN305 HR11.1
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 PR13.9
PEM-DATE-ASSIGN
Element: Date Assign
Numeric 8 (yyyymmdd)
BN305 HR11.1
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 PR13.9
PEM-USER-AMOUNT
Element: User Amount
Signed 13.4
BN305 HR11.1
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 PR13.9
PEM-ESTAB-PATIENT
Element: Estab Patient
Numeric 1

1 = No
2 = Yes
3 = Unknown
BN305 HR11.1
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 PR13.9
PEM-PRIOR-COV-MO
Element: Prior Cov Mo
Numeric 2
BN305 HR11.1
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 PR13.9
PEM-MEDICARE-IND
Element: Medicare Ind
Alpha 1

A = Medicare Part A
B = Medicare Part B
C = Medicare Part A and B
D = Medicare Part Unknown
E = No Medicare
BN305 HR11.1
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 PR13.9


PAEMPLOYEE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEMSET1 COMPANY
EMPLOYEE
...
BN100 BN101
BN102 BN103
BN104 BN105
BN106 BN137
BN138 BN140
BN141 BN145
BN149 BN150
BN175 BN180
BN230 BN231
BN232 BN233
BN234 BN236
BN237 BN238
BN240 BN242
BN245 BN246
BN248 BN255


PAEMPLOYEE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Training Dates PATRNHIST
PEM-COMPANY->TRH-COMPANY
PEM-EMPLOYEE->TRH-EMPLOYEE
  TRH-DATE-COMPLETED
  TRH-COURSE
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


File created: Wed Jun 08 20:49:14 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.