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
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 BN320 BN325 BN330
BN331 BN335 BN340 BN345 BN35.1 BN350
BN36.1 BN430 BN45.1 BN48.1 BN48.2 BN500
BN531 BN55.1 BN55.2 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 HR30.1 HR54.1 HR55.2 HR70.1
HR700 HRS1.1 HRSC.1 HS11.1 HS12.1 HS13.1
HS14.1 PA149 PA212 PA214 PA215 PA216
PA217 PA218 PA220 PA221 PA222 PA224
PA225 PA248 PA249 PA262 PA272 PA290
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 TR120 TR121 TR20.1
TR20.2 TR20.3 TR207 PR14.1 PR15.2 PR199
PR205 PR292 PR293 PR296 PR297 PR298
UK110 UK120
UPDATED BY
BN180 BN47.1 BN80.1 BN90.1 HR11.1 HR12.1
HR13.1 HR511 HR513 HR704 HR90.1 HR90.2
PA02.1 PA100 PA102 PA115 PA12.1 PA13.1
PA13.2 PA14.1 PA15.1 PA16.1 PA17.1 PA18.1
PA20.1 PA21.1 PA22.1 PA24.1 PA26.1 PA34.1
PA35.1 PA36.1 PA38.1 PA41.1 PA502 PA512
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PA520
TR21.1 TR22.1 TR500 PR13.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PEM-COMPANY Numeric 4 HR11.1 HR511
Company Contains the number that represents an PA02.1 PA100
established company and is entered on PA102 PA14.1
all functions. PA15.1 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-EMPLOYEE Numeric 9 HR11.1 HR511
Employee Contains the employee number. An PA02.1 PA100
employee number is assigned to each PA102 PA14.1
person employed by the company. The PA15.1 PA17.1
system uses the employee number to PA502 PA52.1
correlate all information related to the PA52.3 PA52.4
employee. This number must be valid in PA52.5 PR13.1
the Employee file.
PEM-SUPP-ADDR1 Alpha 30 (Lower Case) HR11.1 HR511
Supplemental Address Contains the first line of the PA02.1 PA100
supplemental address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-ADDR2 Alpha 30 (Lower Case) HR11.1 HR511
Supplemental Contains the second line of the PA02.1 PA100
Address 2 supplemental address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-ADDR3 Alpha 30 (Lower Case) HR11.1 HR511
Supp Addr3 Contains the third line of the PA02.1 PA100
supplemental address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-ADDR4 Alpha 30 (Lower Case) HR11.1 HR511
Supp Addr4 Contains the fourth line of the PA02.1 PA100
supplemental address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-CITY Alpha 18 (Lower Case) HR11.1 HR511
Supplemental Contains the city of the supplemental PA02.1 PA100
Address City address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-STATE Alpha 2 HR11.1 HR511
Suppl. Address Contains the state of the supplemental PA02.1 PA100
State/Province address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-ZIP Alpha 10 HR11.1 HR511
Suppl. Address Contains the postal code of the PA02.1 PA100
Postal Code supplemental address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-COUNTRY Alpha 30
Supplemental Contains the country of the
Address Country supplemental address. This field can
contain other information such as an
attention name.
PEM-SUPP-CNTRY-CD Alpha 2 HR11.1 HR511
Supp Cntry Cd Contains the country of the supplemental HR704 PA02.1
address. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-HM-PHONE-CNTRY Alpha 6 HR11.1 HR511
Hm Phone Cntry Contains the country code of the PA02.1 PA100
employee's home telephone number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-HM-PHONE-NBR Alpha 15 HR11.1 HR511
Hm Phone Nbr Contains the employee's home telephone PA02.1 PA100
number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-WK-PHONE-CNTRY Alpha 6 HR11.1 HR511
Work Telephone Contains the country code of the PA02.1 PA100
Country employee's work telephone number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-WK-PHONE-NBR Alpha 15 HR11.1 HR511
Work Telephone Contains the employee's work telephone PA02.1 PA100
number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-WK-PHONE-EXT Alpha 5 HR11.1 HR511
Work Telephone Contains the extension of the PA02.1 PA100
Extension employee's work telephone number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-EEO-CLASS Alpha 4 (Lower Case) HCOP.2 HR11.1
EEO Class Contains the employee's ethnic origin. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-SEX Alpha 1 HCOP.2 HR11.1
Gender Contains the employee's gender. HR511 PA02.1
F = Female PA100 PA102
M = Male PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-HANDICAP-ID Alpha 1 HR11.1 HR511
Disability Indicates if the employee is disabled. PA02.1 PA100
Y = Yes PA102 PA502
N = No PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-COMP-CODE Alpha 4 HR11.1 HR511
Miscellaneous Code Contains miscellaneous data. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-COMP-NBR Alpha 10 HR11.1 HR511
Miscellaneous Number Contains miscellaneous data. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-VETERAN Alpha 1 HR11.1 HR511
Veteran Indicates the individual is a veteran. PA02.1 PA100
1 = Veteran PA102 PA14.1
2 = Disabled Veteran PA502 PA52.1
3 = Vietnam Era Veteran PA52.3 PA52.4
4 = Vietnam Era Disabled Veteran PA52.5 PR13.1
5 = Gulf War Era Veteran
6 = Special Disabled Veteran
N = No
Y = Yes
PEM-BIRTHDATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Birthdate Contains the employee's birthdate. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PA90.1
PR13.1
PEM-BIRTH-CITY Alpha 18 (Lower Case) HR11.1 HR511
Birth Place: City Contains the city where the employee PA02.1 PA100
was born. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BIRTH-STATE Alpha 2 HR11.1 HR511
Birth Place: Contains the two-character abbreviation PA02.1 PA100
State/Province of the state where the employee was PA102 PA502
born. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BIRTH-COUNTRY Alpha 30
Birth Place: Country Indicates the country where the
employee was born.
PEM-BIRTH-CNTRY-CD Alpha 2 HR11.1 HR511
Birth Cntry Cd Indicates country where employee was HR704 PA02.1
born. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-SENIOR-DATE Numeric 8 (yyyymmdd) HCOP.2 HR11.1
Seniority Date Contains the employee's seniority date. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-MAIDEN-LST-NM Alpha 30 (Lower Case) HR11.1 HR511
Maiden Last Name Contains the employee's maiden last PA02.1 PA100
name. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-MAIDEN-FST-NM Alpha 15 (Lower Case) HR11.1 HR511
Maiden First Name Contains the employee's maiden first PA02.1 PA100
name. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-MAIDEN-MI Alpha 1 HR11.1 HR511
Maiden Name Middle Contains the employee's maiden middle PA02.1 PA100
Initial initial. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-FORMER-LST-NM Alpha 30 (Lower Case) HR11.1 HR511
Former Last Name Contains the employee's former last PA02.1 PA100
name. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-FORMER-FST-NM Alpha 15 (Lower Case) HR11.1 HR511
Former First Name Contains the employee's former first PA02.1 PA100
name. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-FORMER-MI Alpha 1 HR11.1 HR511
Former Name Middle Contains the employee's former middle PA02.1 PA100
Initial initial. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-LOCAT-CODE Alpha 10 HCOP.2 HR11.1
Location Contains a user-defined location code HR511 PA02.1
that identifies where the employee PA100 PA102
works. The Human Resource Code file PA13.1 PA13.2
validates this field. PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-HIRE-SOURCE Alpha 10 HR11.1 HR511
Hire Source Contains a user-defined hire source PA02.1 PA100
code that identifies the source from PA102 PA502
which the employee was acquired. This PA52.1 PA52.3
field is validated in the Human Resource PA52.4 PA52.5
Code file. PR13.1
PEM-SECURITY-CODE Alpha 10 HR11.1 HR511
Badge Code Contains a user-defined badge code PA02.1 PA100
assigned to the employee. This field is PA102 PA502
not associated with Lawson user PA52.1 PA52.3
security. PA52.4 PA52.5
PR13.1
PEM-SECURITY-NBR Alpha 10 HR11.1 HR511
Badge Number Contains an internal security number PA02.1 PA100
that is assigned to the employee. This PA102 PA502
field is not associated with Lawson user PA52.1 PA52.3
security. PA52.4 PA52.5
PR13.1
PEM-BARGAIN-UNIT Alpha 10 HR11.1 HR511
Bargaining Unit Contains a user-defined code that PA02.1 PA100
represents the employee's union PA102 PA502
bargaining unit. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-CLOCK-NBR Alpha 10 HR11.1 HR511
Clock Number Contains the employee's clock number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-MAIL-GROUP Alpha 10 HR11.1 HR511
Mail Group Contains a user-defined code that PA02.1 PA100
identifies the mail group to which an PA102 PA502
employee belongs. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-MB-NBR Alpha 10 HR11.1 HR511
Mail Box Number Contains the employee's mail box number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-DRAFT-STATUS Alpha 3 HR11.1 HR511
Bill of Exchange Contains a user-defined code that PA02.1 PA100
Status identifies the employee's draft status. PA102 PA14.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-FINAL-RANK Alpha 3 HR11.1 HR511
Final Military Rank Identifies the highest military rank PA02.1 PA100
attained by the employee. PA102 PA14.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-CUR-STATUS Alpha 2 HR11.1 HR511
Current Status Indicates if the employee is currently PA02.1 PA100
in the Reserves or National Guard. PA102 PA14.1
NG = National Guard PA502 PA52.1
RE = Reserves PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-PHYSICAL Numeric 8 (yyyymmdd) HR11.1 HR511
Last Physical Date Contains the date of the employee's PA02.1 PA100
last physical exam. PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-PHY-SCHD Alpha 2 HR11.1 HR511
Physical Schedule Contains the frequency of the PA02.1 PA100
employee's physical examinations. PA102 PA15.1
2Y = 2 years PA502 PA52.1
3Y = 3 years PA52.3 PA52.4
4Y = 4 years PA52.5 PR13.1
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) HR11.1 HR511
Next Physical Date Contains the date of the employee's PA02.1 PA100
next scheduled physical exam. PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-HEIGHT-FT Numeric 2 HR11.1 HR511
Height - Feet Contains the employee's height in feet. PA02.1 PA100
PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-HEIGHT-IN Numeric 2 HR11.1 HR511
Height - Inches Contains the employee's height in PA02.1 PA100
inches. PA102 PA15.1
01 PA502 PA52.1
11 PA52.3 PA52.4
PA52.5 PR13.1
PEM-WGHT Signed 5.2 HR11.1 HR511
Weight Contains the employee's weight. PA02.1 PA100
PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-BLOOD-TYPE Alpha 3 HR11.1 HR511
Blood Type Contains the employee's blood type. PA02.1 PA100
A+ PA102 PA15.1
A- PA502 PA52.1
AB+ PA52.3 PA52.4
AB- PA52.5 PR13.1
B+
B-
O+
O-
PEM-PARKING-LOT Alpha 10 HR11.1 HR511
Parking Lot Code Contains a user-defined code that PA02.1 PA100
represents the employee's assigned PA102 PA17.1
parking lot. PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-PARKING-SPACE Alpha 10 HR11.1 HR511
Parking Space Identifies the parking space assigned PA02.1 PA100
to the employee. PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-DR-LICENSE Alpha 20 HR11.1 HR511
Driver License Contains the employee's driver's PA02.1 PA100
Number license number. PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-DR-LIC-ST Alpha 2 HR11.1 HR511
Driver License State Contains the abbreviation of the state PA02.1 PA100
that issued the employee's driver's PA102 PA17.1
license. PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-EXP-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Expiration Contains the expiration date of the PA02.1 PA100
employee's driver's license. PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-DR-LIC-CLASS Alpha 3 HR11.1 HR511
Driver License Class Contains the class of the employee's PA02.1 PA100
driver's license. PA102 PA17.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-PASSPORT-NBR Alpha 30 HR11.1 HR511
Passport Number Contains the employee's passport number. PA02.1 PA100
PA102 PA18.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-PASS-EXP-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Passport Expiration Contains the expiration date of the PA02.1 PA100
Date employee's passport. PA102 PA18.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-CITIZEN-CNTRY Alpha 30
Country of Contains the employee's country of
Citizenship citizenship.
PEM-CITZN-CNTRY-CD Alpha 2 HR11.1 HR511
Citzn Cntry Cd Contains employee's country of HR704 PA02.1
citizenship. PA100 PA102
PA18.1 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-REV-SCHEDULE Alpha 2 HR11.1 HR511
Review Schedule Identifies the frequency of performance PA02.1 PA100
reviews for the employee. PA102 PA26.1
AN = Annual PA502 PA52.1
MO = Monthly PA52.3 PA52.4
QT = Quarterly PA52.5 PR13.1
SA = Semi-annual
PEM-NEXT-REVIEW Numeric 8 (yyyymmdd) HR11.1 HR511
Next Review Date Contains the next scheduled performance PA02.1 PA100
review date for the employee. PA102 PA26.1
PA345 PA370
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-NEXT-REV-CODE Alpha 10 HR11.1 HR511
Next Review Code Identifies the review type for the next PA02.1 PA100
scheduled review date (for example, PA102 PA26.1
salary review). PA345 PA370
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-REVIEW Numeric 8 (yyyymmdd) HR11.1 HR511
Last Review Date Contains the date of the employee's PA02.1 PA100
last review. PA102 PA26.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-MIL-SEQ Numeric 4 HR11.1 HR511
Last Military Contains the last sequence number used PA02.1 PA100
Sequence Number to store a military record. PA102 PA14.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-REV-SEQ Numeric 4 HR11.1 HR511
Last Review Contains the last sequence number used PA02.1 PA100
Sequence Number to store a review record. PA102 PA26.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-COM-SEQ Numeric 4 BN90.1 HR11.1
Last Comment Contains the last sequence number used HR511 HR90.1
Sequence Number to store a comment record. HR90.2 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-INT-SEQ Numeric 4 HR11.1 HR511
Last Interview Contains the last sequence number used PA02.1 PA100
Sequence Number to store an interview record. PA102 PA41.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-BNF-SEQ Numeric 4 BN47.1 HR11.1
Last Beneficiary Contains the last sequence number used HR511 PA02.1
Sequence Nbr to store a beneficiary record. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-LAST-INV-NBR Numeric 4 BN180 BN80.1
Last Invoice Number Contains the last sequence number used HR11.1 HR511
to store an invoice record. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-LAST-EPC-SEQ Numeric 4 HR11.1 HR511
Last Emp Code Contains the last sequence number used PA02.1 PA100
Sequence Number to store HR codes for an employee. PA102 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA34.1 PA35.1
PA36.1 PA38.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PA520
PR13.1 TR21.1
TR22.1 TR500
PEM-FNCTN-GROUP Numeric 2 HCOP.2 HR11.1
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 PR13.1
PEM-EXCLUDE-FLAG Alpha 1 HR11.1 HR511
Exclude From EEO-4 Determines if an employee is included PA02.1 PA100
in the EEO-4 report. PA102 PA502
N = Include on EEO-4 Report PA52.1 PA52.3
Y = Exclude from EEO-4 Report PA52.4 PA52.5
PR13.1
PEM-NBR-HL-DEP Numeric 3 HR11.1 HR13.1
Health Dependents Contains the number of dependents HR511 HR513
covered by the employee's health PA02.1 PA100
insurance. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-NBR-DN-DEP Numeric 3 HR11.1 HR13.1
Dental Dependents Contains the number of dependents HR511 HR513
covered by the employee's dental PA02.1 PA100
insurance. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-LIFE-STYLE-CR Numeric 2 HR11.1 HR511
Life Style Cr Contains the number of credits given PA02.1 PA100
for a healthy lifestyle. This is used to PA102 PA502
calculate flex credits. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-HL-COV-PROOF Alpha 1 HR11.1 HR511
Spouse Health Plan Indicates if there is proof that the PA02.1 PA100
employee is covered by health insurance PA102 PA502
outside the company. PA52.1 PA52.3
N = No PA52.4 PA52.5
Y = Yes PR13.1
PEM-DN-COV-PROOF Alpha 1 HR11.1 HR511
Spouse Dental Plan Indicates if there is proof that the PA02.1 PA100
employee is covered by dental insurance PA102 PA502
outside the company. PA52.1 PA52.3
N = No PA52.4 PA52.5
Y = Yes PR13.1
PEM-HL-VERIFY-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Spouse Health Plan Contains the date outside health PA02.1 PA100
Verify Date coverage was verified. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-DN-VERIFY-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Spouse Dental Plan Contains the date outside dental PA02.1 PA100
Verify Date coverage was verified. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SPOUSE-EMP Alpha 30 (Lower Case) HR11.1 HR511
Spouse Employer Name Contains the name of the employee's PA02.1 PA100
spouse's employer. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-ADDR1 Alpha 30 (Lower Case) HR11.1 HR511
Spouse Employer Contains the first line of the spouse's PA02.1 PA100
Address 1 employer's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-ADDR2 Alpha 30 (Lower Case) HR11.1 HR511
Spouse Employer Contains the second line of the PA02.1 PA100
Address 2 spouse's employer's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-ADDR3 Alpha 30 (Lower Case) HR11.1 HR511
Sp Emp Addr3 Contains the third line of the spouse's PA02.1 PA100
employer's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-ADDR4 Alpha 30 (Lower Case) HR11.1 HR511
Sp Emp Addr4 Contains the fourth line of the PA02.1 PA100
spouse's employer's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-CITY Alpha 18 (Lower Case) HR11.1 HR511
Spouse Employer City Contains the city of the spouse's PA02.1 PA100
employer's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-STATE Alpha 2 HR11.1 HR511
Spouse Employer Contains the state of the spouse's PA02.1 PA100
State/Province employer's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-ZIP Alpha 10 HR11.1 HR511
Spouse Employer Contains the postal code of the PA02.1 PA100
Postal Code spouse's employer's address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-COUNTRY Alpha 2 HR11.1 HR511
Sp Emp Country Contains country of spounse's employer's PA02.1 PA100
address. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-PH-CNTR Alpha 6 HR11.1 HR511
Sp Emp Ph Cntr Contains the country code of the PA02.1 PA100
spouse's employer's telephone number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SP-EMP-PH-NBR Alpha 15 HR11.1 HR511
Sp Emp Ph Nbr Contains the spouse's employer's PA02.1 PA100
telephone number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-OWNER-FLAG Alpha 1 HR11.1 HR511
Owner Identifies owners of the company. PA02.1 PA100
N = No PA102 PA502
Y = Yes PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-KEY-EMP-FLAG Alpha 1 HR11.1 HR511
Key Employee Identifies key employees of the PA02.1 PA100
company. PA102 PA502
N = No PA52.1 PA52.3
Y = Yes PA52.4 PA52.5
PR13.1
PEM-OFFICER Alpha 1 HR11.1 HR511
Officer Identifies officers of the company. PA02.1 PA100
N = No PA102 PA502
Y = Yes PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-HIGH-COMP Alpha 1 HR11.1 HR511
Highly Compensated Identifies highly compensated employees PA02.1 PA100
for non-discrimination testing in the PA102 PA502
Lawson Benefits System. PA52.1 PA52.3
N = No PA52.4 PA52.5
Y = Yes PR13.1
PEM-SMOKER Alpha 1 HR11.1 HR511
Smoker Indicates if an employee is a smoker. PA02.1 PA100
The Lawson Benefits system uses this PA102 PA502
information when calculating employee PA52.1 PA52.3
life and disability insurance premiums. PA52.4 PA52.5
N = No PR13.1
Y = Yes
PEM-I9-STATUS Alpha 1 HR11.1 HR511
Eligibility Status Identifies the employee's immigration PA02.1 PA100
status. PA102 PA502
C = Citizen or National PA52.1 PA52.3
P = Permanent Resident - Alien PA52.4 PA52.5
W = Authorized to Work in U.S. PR13.1
PEM-I9-ALIEN-NBR Alpha 11 HR11.1 HR511
Alien Number Contains the employee's alien number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-I9-ADMIT-NBR Alpha 13 HR11.1 HR511
Admission Number Contains the employee's admission PA02.1 PA100
number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-I9-STA-EXP-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Expiration Date Contains the expiration date of the PA02.1 PA100
employee's work authorization status. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-I9-DOC-NBR Alpha 20 Occurs 2 Times HR11.1 HR511
Document Number Contains the document identification PA02.1 PA100
number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-I9-DOC-DESC Alpha 30 (Lower Case) HR11.1 HR511
Document Description Occurs 2 Times PA02.1 PA100
Contains the description of the PA102 PA502
document. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-I9-DOC-TYPE Alpha 1 Occurs 2 Times HR11.1 HR511
Document Type Identifies the type of document entered. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-I9-DOC-EXP-DT Numeric 8 (yyyymmdd) Occurs 2 Times HR11.1 HR511
Document Expiration Contains the expiration date of the PA02.1 PA100
Date document. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-I9-AUTHORIZE Alpha 30 (Lower Case) HR11.1 HR511
Authorization Identifies the person who examined the PA02.1 PA100
evidence or documents establishing the PA102 PA502
employee's identity and employment PA52.1 PA52.3
eligibility. PA52.4 PA52.5
PR13.1
PEM-TRUE-MAR-STAT Alpha 1 HR11.1 HR511
True Marital Status Contains the employee's true marital PA02.1 PA100
status. PA102 PA502
D = Divorced PA52.1 PA52.3
M = Married PA52.4 PA52.5
S = Single PR13.1
W = Widowed
PEM-LAST-PAE-SEQ Numeric 4 HR11.1 HR511
Last Pae Seq Contains the last number used to store PA02.1 PA100
an emergency contact record for the PA102 PA12.1
employee. PA502 PA512
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-PRIMARY-CARE Alpha 10 HR11.1 HR511
Primary Care Contains the code that represents the PA02.1 PA100
Physician employee's primary care physician. PA102 PA15.1
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-FAMILY-AGG Numeric 9 HR11.1 HR511
Family Agg Contains the number of the employee PA02.1 PA100
defined as the family aggregate PA102 PA502
employee. PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-SALARY-1 Signed 11.2 HR11.1 HR511
Ben Salary 1 Contains optional user-defined benefit PA02.1 PA100
salary information. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-SALARY-2 Signed 11.2 HR11.1 HR511
Ben Salary 2 Contains optional user-defined benefit PA02.1 PA100
salary information. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-SALARY-3 Signed 11.2 HR11.1 HR511
Ben Salary 3 Contains optional user-defined benefit PA02.1 PA100
salary information. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-SALARY-4 Signed 11.2 HR11.1 HR511
Ben Salary 4 Contains optional user-defined benefit PA02.1 PA100
salary information. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-SALARY-5 Signed 11.2 HR11.1 HR511
Ben Salary 5 Contains optional user-defined benefit PA02.1 PA100
salary information. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-DATE-1 Numeric 8 (yyyymmdd) HR11.1 HR511
Ben Date 1 Contains an optional user-defined PA02.1 PA100
benefit date. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-DATE-2 Numeric 8 (yyyymmdd) HR11.1 HR511
Ben Date 2 Contains an optional user-defined PA02.1 PA100
benefit date. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-DATE-3 Numeric 8 (yyyymmdd) HR11.1 HR511
Ben Date 3 Contains an optional user-defined PA02.1 PA100
benefit date. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-DATE-4 Numeric 8 (yyyymmdd) HR11.1 HR511
Ben Date 4 Contains an optional user-defined PA02.1 PA100
benefit date. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-BEN-DATE-5 Numeric 8 (yyyymmdd) HR11.1 HR511
Ben Date 5 Contains an optional user-defined PA02.1 PA100
benefit date. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SEC-LVL Numeric 1 HR11.1 HR12.1
Sec Lvl Contains the employee's security level. HR511 PA02.1
PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-SEC-LOCATION Alpha 10 HR11.1 HR12.1
Sec Location Contains the employee's security HR511 PA02.1
location. PA100 PA102
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PEM-CUR-AGE Derived
Age
PEM-SEX-1 Derived
Gender
PEM-EEO-CLASS-1 Derived
Eeo Class 1
PEM-WORK-ZIP Alpha 10 HR11.1 HR511
Work Zip Contains the employee's work postal PA02.1 PA100
code. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-HEIGHT-UNIT Alpha 1 PA15.1
Height Unit Contains unit in which height is
recoreded.
1 = Feet
2 = Meters
PEM-WGHT-UNIT Alpha 1 PA15.1
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 HR511
Language Code Contains employee's language if other PA02.1 PA100
than company's primary language. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-RELIGION Alpha 10 HR11.1 HR511
Religion Contains employee's religion. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-DISABILITY Alpha 10 HR11.1 HR511
Disability Contains type of disability. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-PHONE-CNT Alpha 6 HR11.1 HR511
Supp Phone Cnt Contains phone country of supplemental PA02.1 PA100
phone number. PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-SUPP-PHONE-NBR Alpha 15 HR11.1 HR511
Supp Phone Nbr Contains supplemental phone number. PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PEM-CONSENT Alpha 1 HR11.1 HR511
Consent N = No PA02.1 PA100
Y = Yes PA102 PA502
" " = No PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
PAEMPLOYEE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PEMSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
BN104 BN105
BN138 BN140
BN141 BN145
BN150 BN175
BN180 BN231
BN232 BN233
BN236 BN237
BN238 BN240
BN242 BN245
BN246 BN248
BN258 BN285
BN300 BN305
BN31.1 BN31.2
...
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
Correspondence HRCORRESP
PEM-COMPANY -> HCP-COMPANY
"1" -> HCP-REQ-TYPE
PEM-EMPLOYEE -> HCP-ID-NBR
Zeroes -> 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
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
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
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
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
Skills EMPCODES Delete Cascades
PEM-COMPANY -> EPC-COMPANY
"SK" -> EPC-TYPE
Zeroes -> EPC-EMP-APP
PEM-EMPLOYEE -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-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-VISA-NUMBER
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
|