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