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