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 BN138 BN140 BN141 BN145 BN150
BN175 BN230 BN231 BN232 BN233 BN234
BN236 BN237 BN238 BN240 BN242 BN245
BN246 BN248 BN258 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 BS09.1 BS10.1 BS11.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 ZB01.1 ZB10.1 ZB10.2
ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3 HCDL.1
HCEM.1 HLTM.1 HR170 HR20.1 HR211 HR217
HR220 HR228 HR30.1 HR70.1 HS08.1 HS10.1
HS10.2 HS208 HS703 HS705 LT11.5 PR521
ZH230 ZH500 ZH502 ZH503 ZH561 ZH568
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 PA28.1
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 ZE522 ZE526 ZE532
MR551 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 ZP296 ZP550 ZP551 ZP555 ZP560
ZP561 ZP562 ZP567 ZP574 ZP576 ZP577
TA147 WAOP.1 HRLRD BN137 BN285 HCHP.1


UPDATED BY
BN180 BN300 BN305 BN340 BN47.1 BN547
BN80.1 BN90.1 HAP3.1 HCRE.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR11.1 HR11.2 HR12.1 HR13.1
HR15.1 HR155 HR156 HR213 HR28.1 HR511
HR513 HR515 HR54.1 HR55.2 HR90.1 HR90.2
HRS1.1 HRSC.1 LT101 ZH156 ZH510 ZH535
LP100 LP101 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 PA212
PA214 PA215 PA217 PA218 PA22.1 PA24.1
PA26.1 PA27.1 PA310 PA315 PA320 PA325
PA330 PA34.1 PA345 PA35.1 PA36.1 PA38.1
PA390 PA391 PA392 PA393 PA41.1 PA490
PA502 PA512 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA520 PA526 PA54.1 PA702 PA96.1
TR21.1 TR22.1 TR26.1 TR500 ZE521 ZE531
ZE540 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2 PR530
PR84.1 ZP530

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 HR28.1
HR511 LT101
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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
HR28.1 HR511
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510 ZH535
PEM-SUPP-ADDR1
Element: Supplemental Address
Alpha 30 (Lower Case)
Contains the first line of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-ADDR2
Supplemental
Address 2
Alpha 30 (Lower Case)
Contains the second line of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-ADDR3
Element: Supp Addr3
Alpha 30 (Lower Case)
Contains the third line of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-ADDR4
Element: Supp Addr4
Alpha 30 (Lower Case)
Contains the fourth line of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-CITY
Supplemental
Address City
Alpha 18 (Lower Case)
Contains the city of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-STATE
Suppl. Address
State/Province
Alpha 2
Contains the state of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-ZIP
Suppl. Address
Postal Code
Alpha 10
Contains the postal code of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-CNTRY-CD
Element: Supp Cntry Cd
Alpha 2
Contains the country of the supplemental address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-HM-PHONE-NBR
Element: Hm Phone Nbr
Alpha 15
Contains the employee's home telephone number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH500 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-WK-PHONE-NBR
Element: Wk Phone Nbr
Alpha 15
Contains the employee's work telephone number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-EEO-CLASS
Element: Eeo Class
Alpha 4 (Lower Case)
Contains the employee's ethnic origin.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA391 PA392
PA495 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH500
ZH510
PEM-SEX
Element: Sex
Alpha 1
Contains the employee's gender.
F = Female
M = Male
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH500 ZH510
PEM-HANDICAP-ID
Element: Handicap Id
Alpha 1
Indicates if the employee is disabled.
Y = Yes
N = No
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-COMP-CODE
Element: Comp Code
Alpha 4
Contains miscellaneous data.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-COMP-NBR
Element: Comp Nbr
Alpha 10
Contains miscellaneous data.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-VETERAN
Element: Veteran
Alpha 4
Indicates the individual is a veteran.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-BIRTHDATE
Element: Birthdate
Numeric 8 (yyyymmdd)
Contains the employee's birth date.
BN305 BN350
HR11.1 HR11.2
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA90.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH500 ZH510
PEM-BIRTH-CITY
Element: Birth Place: City
Alpha 18 (Lower Case)
Contains the city where the employee was born.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BIRTH-CNTRY-CD
Element: Birth Cntry Cd
Alpha 2
Indicates country where employee was born.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SENIOR-DATE
Element: Senior Date
Numeric 8 (yyyymmdd)
Contains the employee's seniority date.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA10.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR84.1
ZH500 ZH510
PEM-MAIDEN-LST-NM
Element: Maiden Lst Nm
Alpha 30 (Lower Case)
Contains the employee's maiden last name.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-MAIDEN-FST-NM
Element: Maiden Fst Nm
Alpha 15 (Lower Case)
Contains the employee's maiden first name.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-MAIDEN-MI
Maiden Name Middle
Initial
Alpha 1
Contains the employee's maiden middle initial.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-FORMER-LST-NM
Element: Former Lst Nm
Alpha 30 (Lower Case)
Contains the employee's former last name.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-FORMER-FST-NM
Element: Former Fst Nm
Alpha 15 (Lower Case)
Contains the employee's former first name.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-FORMER-MI
Former Name Middle
Initial
Alpha 1
Contains the employee's former middle initial.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA10.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH500
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH500 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-CLOCK-NBR
Element: Clock Nbr
Alpha 10
Contains the employee's clock number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-MB-NBR
Element: Mb Nbr
Alpha 10
Contains the employee's mail box number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-FINAL-RANK
Element: Final Rank
Alpha 3
Identifies the highest military rank attained by the employee.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-LAST-PHYSICAL
Element: Last Physical
Numeric 8 (yyyymmdd)
Contains the date of the employee's last physical exam.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH500
ZH510
PEM-HEIGHT-FT
Element: Height Ft
Numeric 2
Contains the employee's height in feet.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-HEIGHT-IN
Element: Height In
Numeric 2
Contains the employee's height in inches.
01
11
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-WGHT
Element: Wght
Signed 5.2
Contains the employee's weight.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-PARKING-SPACE
Element: Parking Space
Alpha 10
Identifies the parking space assigned to the employee.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-DR-LICENSE
Element: Dr License
Alpha 20
Contains the employee's driver's license number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-EXP-DATE
Element: Expiration
Numeric 8 (yyyymmdd)
Contains the expiration date of the employee's driver's license.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA17.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH500
ZH510
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 HR28.1
HR511 LT101
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-LAST-REVIEW
Element: Last Review
Numeric 8 (yyyymmdd)
Contains the date of the employee's last review.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA526
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA14.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 HS701
HS702 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA26.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA526
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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
HR28.1 HR511
HR90.1 HR90.2
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR530
ZH510 ZP530
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA41.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
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 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 TR21.1
TR22.1 TR26.1
TR500 ZE521
ZE531 ZE540
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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
HR28.1 HR511
HR513 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA218 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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
HR28.1 HR511
HR513 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA218 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SP-EMP-COUNTRY
Element: Sp Emp Country
Alpha 2
Contains country of spouse's employer's address.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-OWNER-FLAG
Element: Owner
Alpha 1
Identifies owners of the company.
N = No
Y = Yes
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-KEY-EMP-FLAG
Element: Key Employee
Alpha 1
Identifies key employees of the company.
N = No
Y = Yes
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-OFFICER
Element: Officer
Alpha 1
Identifies officers of the company.
N = No
Y = Yes
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-I9-STATUS
Element: I9 Status
Alpha 10
Identifies the employee's immigration status.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-I9-ALIEN-NBR
Element: I9 Alien Nbr
Alpha 11
Contains the employee's alien number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-I9-ADMIT-NBR
Element: I9 Admit Nbr
Alpha 13
Contains the employee's admission number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-I9-DOC-NBR
Element: I9 Doc Nbr
Alpha 20 Occurs 2 Times
Contains the document identification number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-I9-DOC-TYPE
Element: I9 Doc Type
Alpha 10 Occurs 2 Times
Identifies the type of document entered.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH500 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA12.1 PA13.1
PA13.2 PA502
PA512 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-PRIMARY-CARE
Element: Primary Care
Alpha 10
Contains the code that represents the employee's primary care physician.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA15.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-SALARY-1
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-SALARY-2
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-SALARY-3
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-SALARY-4
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-SALARY-5
Element: Benefit Salary
Signed 11.2
Contains optional user-defined benefit salary information.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-DATE-1
Element: Ben Date 1
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-DATE-2
Element: Ben Date 2
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-DATE-3
Element: Ben Date 3
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510 ZH535
PEM-BEN-DATE-4
Element: Ben Date 4
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-BEN-DATE-5
Element: Ben Date 5
Numeric 8 (yyyymmdd)
Contains an optional user-defined benefit date.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SEC-LVL
Element: Sec Lvl
Numeric 1
Contains the employee's security level.
BN305 HR11.1
HR11.2 HR12.1
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
PEM-SEC-LOCATION
Element: Sec Location
Alpha 10
Contains the employee's security location.
BN305 HR11.1
HR11.2 HR12.1
HR28.1 HR511
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-RELIGION
Element: Religion
Alpha 10
Contains employee's religion.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-DISABILITY
Element: Disability
Alpha 10
Contains type of disability.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-PHONE-CNT
Element: Supp Phone Cnt
Alpha 6
Contains phone country of supplemental phone number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-SUPP-PHONE-NBR
Element: Supp Phone Nbr
Alpha 15
Contains supplemental phone number.
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-CONSENT
Element: Consent
Alpha 1

N = No
Y = Yes
" " = No
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-ABORIGINAL
Element: Aboriginal
Alpha 1
Designates if an employee is Aboriginal.
N = No
Y = Yes
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-I9-DOC-DESCR
Element: I9 Doc Descr
Alpha 10 Occurs 2 Times
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-STOCK-TRADE
Element: Stock Trade
Alpha 1

" " = Not applicable
1 = Insider
2 = SEC Restricted
3 = Insider & SEC Restricted
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-DATE-ASSIGN
Element: Date Assign
Numeric 8 (yyyymmdd)
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-USER-AMOUNT
Element: User Amount
Signed 13.4
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-ESTAB-PATIENT
Element: Estab Patient
Numeric 1

1 = No
2 = Yes
3 = Unknown
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PEM-PRIOR-COV-MO
Element: Prior Cov Mo
Numeric 2
BN305 HR11.1
HR11.2 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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 HR28.1
HR511 LT101
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510


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
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
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: Thu Jun 09 11:15:21 2016

Home
Contact Us



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