PAEMPLOYEE – Employee Personnel Information

System
Human Resources (HR)
Prefix
PEM
Primary key
COMPANY, EMPLOYEE
Fields
144
Updated by
72 programs
Referenced by
291 programs

PAEMPLOYEE is the Employee Personnel Information table in Lawson Human Resources (prefix PEM). It is indexed by COMPANY, EMPLOYEE (PEMSET1); alternate indexes: PEMSET2. It is related 1:1 to PCODES, PRSYSTEM, EMPLOYEE, HRCTRYCODE and INSTCTRYCD and 1:M to PAMEDICAL, APPLICANT, EMPAUTO, PACOMMENTS, BNEMPEXER, EMPCODES, HRCORRESP, EMDEPEND and 27 more. It is updated by BN180, BN305, BN47.1, BN547, BN80.1, BN90.1, HR11.1, HR11.2 and 64 more and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN106, BN137 and 283 more. The table has 144 fields, 2 indexes and 78 documented relations.

About PAEMPLOYEE

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.

Fields (144)

Column = COBOL field name without the PEM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PEM-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company and is entered on all functions.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
#PEM-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. An employee number is assigned to each person employed by the company. The system uses the employee number to correlate all information related to the employee. This number must be valid in the Employee file.BN305, BN350, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +29 more
#PEM-SUPP-ADDR1
SUPP_ADDR1		Alpha 57 (Lower Case)Contains the first line of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-ADDR2
SUPP_ADDR2		Alpha 30 (Lower Case)Contains the second line of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-ADDR3
SUPP_ADDR3		Alpha 30 (Lower Case)Contains the third line of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-ADDR4
SUPP_ADDR4		Alpha 30 (Lower Case)Contains the fourth line of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-CITY
SUPP_CITY		Alpha 58 (Lower Case)Contains the city of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-STATE
SUPP_STATE		Alpha 2Contains the state of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-ZIP
SUPP_ZIP		Alpha 10Contains the postal code of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-CNTRY-CD
SUPP_CNTRY_CD		Alpha 2Contains the country of the supplemental address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-HM-PHONE-CNTRY
HM_PHONE_CNTRY		Alpha 6Contains the country code of the employee's home telephone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-HM-PHONE-NBR
HM_PHONE_NBR		Alpha 15Contains the employee's home telephone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-WK-PHONE-CNTRY
WK_PHONE_CNTRY		Alpha 6Contains the country code of the employee's work telephone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-WK-PHONE-NBR
WK_PHONE_NBR		Alpha 15Contains the employee's work telephone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5Contains the extension of the employee's work telephone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-EEO-CLASS
EEO_CLASS		Alpha 4 (Lower Case)Contains the employee's ethnic origin.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +28 more
#PEM-SEX
SEX		Alpha 1Contains the employee's gender.
  • F Female
  • M Male
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-HANDICAP-ID
HANDICAP_ID		Alpha 1Indicates if the employee is disabled.
  • Y Yes
  • N No
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-COMP-CODE
COMP_CODE		Alpha 4Contains miscellaneous data.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-COMP-NBR
COMP_NBR		Alpha 10Contains miscellaneous data.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-VETERAN
VETERAN		Alpha 4Indicates the individual is a veteran.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-BIRTHDATE
BIRTHDATE		Numeric 8 (yyyymmdd)Contains the employee's birth date.BN305, BN350, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +27 more
#PEM-BIRTH-CITY
BIRTH_CITY		Alpha 58 (Lower Case)Contains the city where the employee was born.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BIRTH-STATE
BIRTH_STATE		Alpha 2Contains the two-character abbreviation of the state where the employee was born.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BIRTH-CNTRY-CD
BIRTH_CNTRY_CD		Alpha 2Indicates country where employee was born.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SENIOR-DATE
SENIOR_DATE		Numeric 8 (yyyymmdd)Contains the employee's seniority date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
#PEM-MAIDEN-LST-NM
MAIDEN_LST_NM		Alpha 30 (Lower Case)Contains the employee's maiden last name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-MAIDEN-FST-NM
MAIDEN_FST_NM		Alpha 15 (Lower Case)Contains the employee's maiden first name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-MAIDEN-MI
MAIDEN_MI		Alpha 1Contains the employee's maiden middle initial.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-FORMER-LST-NM
FORMER_LST_NM		Alpha 30 (Lower Case)Contains the employee's former last name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-FORMER-FST-NM
FORMER_FST_NM		Alpha 15 (Lower Case)Contains the employee's former first name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-FORMER-MI
FORMER_MI		Alpha 1Contains the employee's former middle initial.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-LOCAT-CODE
LOCAT_CODE		Alpha 10Contains a user-defined location code that identifies where the employee works. The Human Resource Code file validates this field.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +26 more
#PEM-HIRE-SOURCE
HIRE_SOURCE		Alpha 10Contains a user-defined hire source code that identifies the source from which the employee was acquired. This field is validated in the Human Resource Code file.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SECURITY-CODE
SECURITY_CODE		Alpha 10Contains a user-defined badge code assigned to the employee. This field is not associated with Lawson user security.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SECURITY-NBR
SECURITY_NBR		Alpha 10Contains an internal security number that is assigned to the employee. This field is not associated with Lawson user security.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-BARGAIN-UNIT
BARGAIN_UNIT		Alpha 10Contains a user-defined code that represents the employee's union bargaining unit.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-CLOCK-NBR
CLOCK_NBR		Alpha 10Contains the employee's clock number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-MAIL-GROUP
MAIL_GROUP		Alpha 10Contains a user-defined code that identifies the mail group to which an employee belongs.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-MB-NBR
MB_NBR		Alpha 10Contains the employee's mail box number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-DRAFT-STATUS
DRAFT_STATUS		Alpha 3Contains a user-defined code that identifies the employee's draft status.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-FINAL-RANK
FINAL_RANK		Alpha 3Identifies the highest military rank attained by the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-CUR-STATUS
CUR_STATUS		Alpha 2Indicates if the employee is currently in the Reserves or National Guard.
  • NG National Guard
  • RE Reserves
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-LAST-PHYSICAL
LAST_PHYSICAL		Numeric 8 (yyyymmdd)Contains the date of the employee's last physical exam.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-PHY-SCHD
PHY_SCHD		Alpha 2Contains the frequency of the employee's physical examinations.
  • 2Y 2 years
  • 3Y 3 years
  • 4Y 4 years
  • 5Y 5 years
  • 6Y 6 years
  • 7Y 7 years
  • 8Y 8 years
  • 9Y 9 years
  • AN Annual
  • MO Monthly
  • QT Quarterly
  • SA Semi-annual
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-NEXT-PHYSICAL
NEXT_PHYSICAL		Numeric 8 (yyyymmdd)Contains the date of the employee's next scheduled physical exam.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +26 more
#PEM-HEIGHT-FT
HEIGHT_FT		Numeric 2Contains the employee's height in feet.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-HEIGHT-IN
HEIGHT_IN		Numeric 2Contains the employee's height in inches. 01 11BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-WGHT
WGHT		Signed 5.2Contains the employee's weight.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-BLOOD-TYPE
BLOOD_TYPE		Alpha 3Contains the employee's blood type. A+ A- AB+ AB- B+ B- O+ O-BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-PARKING-LOT
PARKING_LOT		Alpha 10Contains a user-defined code that represents the employee's assigned parking lot.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-PARKING-SPACE
PARKING_SPACE		Alpha 10Identifies the parking space assigned to the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-DR-LICENSE
DR_LICENSE		Alpha 20Contains the employee's driver's license number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-DR-LIC-ST
DR_LIC_ST		Alpha 2Contains the abbreviation of the state that issued the employee's driver's license.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-EXP-DATE
EXP_DATE		Numeric 8 (yyyymmdd)Contains the expiration date of the employee's driver's license.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-DR-LIC-CLASS
DR_LIC_CLASS		Alpha 3Contains the class of the employee's driver's license.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-REV-SCHEDULE
REV_SCHEDULE		Alpha 2Identifies the frequency of performance reviews for the employee.
  • AN Annual
  • MO Monthly
  • QT Quarterly
  • SA Semi-annual
PA26.1, PA526
#PEM-NEXT-REVIEW
NEXT_REVIEW		Numeric 8 (yyyymmdd)Contains the next scheduled performance review date for the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +28 more
#PEM-NEXT-REV-CODE
NEXT_REV_CODE		Alpha 10Identifies the review type for the next scheduled review date (for example, salary review).BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +27 more
#PEM-LAST-REVIEW
LAST_REVIEW		Numeric 8 (yyyymmdd)Contains the date of the employee's last review.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +26 more
#PEM-LAST-MIL-SEQ
LAST_MIL_SEQ		Numeric 4Contains the last sequence number used to store a military record.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-LAST-REV-SEQ
LAST_REV_SEQ		Numeric 4Contains the last sequence number used to store a review record.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HS701, HS702 +28 more
#PEM-LAST-COM-SEQ
LAST_COM_SEQ		Numeric 4Contains the last sequence number used to store a comment record.BN305, BN90.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, HR90.1 +28 more
#PEM-LAST-INT-SEQ
LAST_INT_SEQ		Numeric 4Contains the last sequence number used to store an interview record.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-LAST-BNF-SEQ
LAST_BNF_SEQ		Numeric 4Contains the last sequence number used to store a beneficiary record.BN305, BN47.1, BN547, HR11.1, HR11.2, HR11.4, HR28.1, HR511 +26 more
#PEM-LAST-INV-NBR
LAST_INV_NBR		Numeric 4Contains the last sequence number used to store an invoice record.BN180, BN305, BN80.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 +26 more
#PEM-LAST-EPC-SEQ
LAST_EPC_SEQ		Numeric 4Contains the last sequence number used to store HR codes for an employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +39 more
#PEM-FNCTN-GROUP
FNCTN_GROUP		Numeric 2Identifies for the EEO-4 report, the type of work the employee does. 01 15BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-EXCLUDE-FLAG
EXCLUDE_FLAG		Alpha 1Determines if an employee is included in the EEO-4 report.
  • N Include on EEO-4 Report
  • Y Exclude from EEO-4 Report
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-NBR-HL-DEP
NBR_HL_DEP		Numeric 3Contains the number of dependents covered by the employee's health insurance.BN305, HR11.1, HR11.2, HR11.4, HR13.1, HR28.1, HR511, HR513 +27 more
#PEM-NBR-DN-DEP
NBR_DN_DEP		Numeric 3Contains the number of dependents covered by the employee's dental insurance.BN305, HR11.1, HR11.2, HR11.4, HR13.1, HR28.1, HR511, HR513 +27 more
#PEM-LIFE-STYLE-CR
LIFE_STYLE_CR		Numeric 2Contains the number of credits given for a healthy lifestyle. This is used to calculate flex credits.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-HL-COV-PROOF
HL_COV_PROOF		Alpha 1Indicates if there is proof that the employee is covered by health insurance outside the company.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-DN-COV-PROOF
DN_COV_PROOF		Alpha 1Indicates if there is proof that the employee is covered by dental insurance outside the company.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-HL-VERIFY-DT
HL_VERIFY_DT		Numeric 8 (yyyymmdd)Contains the date outside health coverage was verified.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-DN-VERIFY-DT
DN_VERIFY_DT		Numeric 8 (yyyymmdd)Contains the date outside dental coverage was verified.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SPOUSE-EMP
SPOUSE_EMP		Alpha 30 (Lower Case)Contains the name of the employee's spouse's employer.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-ADDR1
SP_EMP_ADDR1		Alpha 30 (Lower Case)Contains the first line of the spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-ADDR2
SP_EMP_ADDR2		Alpha 30 (Lower Case)Contains the second line of the spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-ADDR3
SP_EMP_ADDR3		Alpha 30 (Lower Case)Contains the third line of the spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-ADDR4
SP_EMP_ADDR4		Alpha 30 (Lower Case)Contains the fourth line of the spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-CITY
SP_EMP_CITY		Alpha 58 (Lower Case)Contains the city of the spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-STATE
SP_EMP_STATE		Alpha 2Contains the state of the spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-ZIP
SP_EMP_ZIP		Alpha 10Contains the postal code of the spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-COUNTRY
SP_EMP_COUNTRY		Alpha 2Contains country of spouse's employer's address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-PH-CNTR
SP_EMP_PH_CNTR		Alpha 6Contains the country code of the spouse's employer's telephone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SP-EMP-PH-NBR
SP_EMP_PH_NBR		Alpha 15Contains the spouse's employer's telephone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-OWNER-FLAG
OWNER_FLAG		Alpha 1Identifies owners of the company.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-KEY-EMP-FLAG
KEY_EMP_FLAG		Alpha 1Identifies key employees of the company.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-OFFICER
OFFICER		Alpha 1Identifies officers of the company.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-HIGH-COMP
HIGH_COMP		Alpha 1Identifies highly compensated employees for non-discrimination testing in the Lawson Benefits System.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SMOKER
SMOKER		Alpha 1Indicates if an employee is a smoker. The Lawson Benefits system uses this information when calculating employee life and disability insurance premiums.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-STATUS
I9_STATUS		Alpha 10Identifies the employee's immigration status.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-ALIEN-NBR
I9_ALIEN_NBR		Alpha 11Contains the employee's alien number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-ADMIT-NBR
I9_ADMIT_NBR		Alpha 13Contains the employee's admission number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-STA-EXP-DT
I9_STA_EXP_DT		Numeric 8 (yyyymmdd)Contains the expiration date of the employee's work authorization status.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-DOC-NBR
I9_DOC_NBR		Alpha 20 Occurs 2 Times ×2Contains the document identification number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-DOC-TYPE
I9_DOC_TYPE		Alpha 10 Occurs 2 Times ×2Identifies the type of document entered.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-DOC-EXP-DT
I9_DOC_EXP_DT		Numeric 8 (yyyymmdd) Occurs 2 Times ×2Contains the expiration date of the document.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-AUTHORIZE
I9_AUTHORIZE		Alpha 30 (Lower Case)Identifies the person who examined the evidence or documents establishing the employee's identity and employment eligibility.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-TRUE-MAR-STAT
TRUE_MAR_STAT		Alpha 1Contains the employee's true marital status.
  • D Divorced
  • M Married
  • S Single
  • W Widowed
  • L Legally Separated
  • O Significant Other
  • P Domestic Partner
  • C Common Law
  • R Separated
  • U Unmarried
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-LAST-PAE-SEQ
LAST_PAE_SEQ		Numeric 4Contains the last number used to store an emergency contact record for the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +26 more
#PEM-PRIMARY-CARE
PRIMARY_CARE		Alpha 10Contains the code that represents the employee's primary care physician.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-FAMILY-AGG
FAMILY_AGG		Numeric 9Contains the number of the employee defined as the family aggregate employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-SALARY-1
BEN_SALARY_1		Signed 11.2Contains optional user-defined benefit salary information.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-SALARY-2
BEN_SALARY_2		Signed 11.2Contains optional user-defined benefit salary information.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-SALARY-3
BEN_SALARY_3		Signed 11.2Contains optional user-defined benefit salary information.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-SALARY-4
BEN_SALARY_4		Signed 11.2Contains optional user-defined benefit salary information.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-SALARY-5
BEN_SALARY_5		Signed 11.2Contains optional user-defined benefit salary information.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-DATE-1
BEN_DATE_1		Numeric 8 (yyyymmdd)Contains an optional user-defined benefit date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-DATE-2
BEN_DATE_2		Numeric 8 (yyyymmdd)Contains an optional user-defined benefit date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-DATE-3
BEN_DATE_3		Numeric 8 (yyyymmdd)Contains an optional user-defined benefit date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#PEM-BEN-DATE-4
BEN_DATE_4		Numeric 8 (yyyymmdd)Contains an optional user-defined benefit date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BEN-DATE-5
BEN_DATE_5		Numeric 8 (yyyymmdd)Contains an optional user-defined benefit date.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SEC-LVL
SEC_LVL		Numeric 1Contains the employee's security level.BN305, HR11.1, HR11.2, HR11.4, HR12.1, HR28.1, HR511, LT101 +25 more
#PEM-SEC-LOCATION
SEC_LOCATION		Alpha 10Contains the employee's security location.BN305, HR11.1, HR11.2, HR11.4, HR12.1, HR28.1, HR511, LT101 +25 more
#PEM-CUR-AGE
CUR_AGE		Derived——
#PEM-SEX-1
SEX_1		Derived——
#PEM-EEO-CLASS-1
EEO_CLASS_1		Derived——
#PEM-WORK-ZIP
WORK_ZIP		Alpha 10Contains the employee's work postal code.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-HEIGHT-UNIT
HEIGHT_UNIT		Alpha 1Contains unit in which height is recorded.
  • 1 Feet
  • 2 Meters
PA15.1
#PEM-WGHT-UNIT
WGHT_UNIT		Alpha 1Contains unit in which the employee's weight is recorded.
  • 1 Pounds
  • 2 Stones
  • 3 Kilograms
PA15.1
#PEM-LANGUAGE-CODE
LANGUAGE_CODE		Alpha 10Contains employee's language if other than company's primary language.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-RELIGION
RELIGION		Alpha 10Contains employee's religion.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-DISABILITY
DISABILITY		Alpha 10Contains type of disability.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-PHONE-CNT
SUPP_PHONE_CNT		Alpha 6Contains phone country of supplemental phone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-SUPP-PHONE-NBR
SUPP_PHONE_NBR		Alpha 15Contains supplemental phone number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-ABORIGINAL
ABORIGINAL		Alpha 1Designates if an employee is Aboriginal.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-VISIBLE-MIN
VISIBLE_MIN		Alpha 1Designates if an employee is a visible minority.
  • N No
  • Y Yes
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-I9-DOC-DESCR
I9_DOC_DESCR		Alpha 10 Occurs 2 Times ×2—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-BILINGUAL
BILINGUAL		Alpha 1—
  • N No
  • Y Yes
PA96.1
#PEM-SUPP-COUNTY
SUPP_COUNTY		Alpha 25 (Lower Case)The county for the company address.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-STOCK-TRADE
STOCK_TRADE		Alpha 1" " = Not applicable
  • 1 Insider
  • 2 SEC Restricted
  • 3 Insider & SEC Restricted
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-DATE-ASSIGN
DATE_ASSIGN		Numeric 8 (yyyymmdd)—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-USER-AMOUNT
USER_AMOUNT		Signed 13.4—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-ESTAB-PATIENT
ESTAB_PATIENT		Numeric 1—
  • 1 No
  • 2 Yes
  • 3 Unknown
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-PRIOR-COV-MO
PRIOR_COV_MO		Numeric 2—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-MEDICARE-IND
MEDICARE_IND		Alpha 1—
  • A Medicare Part A
  • B Medicare Part B
  • C Medicare Part A and B
  • D Medicare Part Unknown
  • E No Medicare
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-TAX-FREQUENCY
TAX_FREQUENCY		Numeric 3—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-EMPLOYEE-TYPE
EMPLOYEE_TYPE		Numeric 4—PR13.9
#PEM-SURVEY-DATE SET2
SURVEY_DATE		Numeric 8 (yyyymmdd)—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PEM-UPDATED-BY-LTM
UPDATED_BY_LTM		Alpha 1—
  • Y Yes
  • N No
—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEMSET1
  1. COMPANY
  2. EMPLOYEE
PrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN106, BN137 +22 more (list truncated in source)
PEMSET2
  1. SURVEY-DATE
  2. COMPANY
  3. EMPLOYEE
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PCODESPRSYSTEMEMPLOYEEHRCTRYCODEINSTCTRYCDPAMEDICALAPPLICANTEMPAUTOPACOMMENTSBNEMPEXEREMPCODESHRCORRESPEMDEPENDPAGRDISTEPPAGRDIPAEMERGCNTHISTERRHRCONTNBRPAFOLLOWUP+21 more belowPAEMPLOYEE

One to one (14) — lookups and parents

RelationTableRulesConditionField map
Badge CodePCODESRequiredWhen PEM-SECURITY-CODE != Spaces
"SC"→PCO-TYPE
PEM-SECURITY-CODE→PCO-CODE
Bargain UnitPCODESRequiredWhen PEM-BARGAIN-UNIT != Spaces
"BU"→PCO-TYPE
PEM-BARGAIN-UNIT→PCO-CODE
CompanyPRSYSTEMRequired
PEM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DisabilityPCODESRequiredWhen PEM-DISABILITY != Spaces
"DI"→PCO-TYPE
PEM-DISABILITY→PCO-CODE
EmployeeEMPLOYEERequired
PEM-COMPANY→EMP-COMPANY
PEM-EMPLOYEE→EMP-EMPLOYEE
EthnicityHRCTRYCODERequiredWhen PEM-EEO-CLASS != Spaces
"ET"→CTC-TYPE
EMP-WORK-COUNTRY→CTC-COUNTRY-CODE
PEM-EEO-CLASS→CTC-HRCTRY-CODE
Family AggEMPLOYEERequiredWhen PEM-FAMILY-AGG != Zeroes
PEM-COMPANY→EMP-COMPANY
PEM-FAMILY-AGG→EMP-EMPLOYEE
Hire SourcePCODESRequiredWhen PEM-HIRE-SOURCE != Spaces
"HS"→PCO-TYPE
PEM-HIRE-SOURCE→PCO-CODE
LocationPCODESRequiredWhen PEM-LOCAT-CODE != Spaces
"LO"→PCO-TYPE
PEM-LOCAT-CODE→PCO-CODE
Mail GroupPCODESRequiredWhen PEM-MAIL-GROUP != Spaces
"MG"→PCO-TYPE
PEM-MAIL-GROUP→PCO-CODE
Primary CarePCODESRequiredWhen PEM-PRIMARY-CARE != Spaces
"PC"→PCO-TYPE
PEM-PRIMARY-CARE→PCO-CODE
ReligionPCODESRequiredWhen PEM-RELIGION != Spaces
"RE"→PCO-TYPE
PEM-RELIGION→PCO-CODE
Supp CountryINSTCTRYCDRequiredWhen (PEM-SUPP-CNTRY-CD != Spaces)
PEM-SUPP-CNTRY-CD→INT-COUNTRY-CODE
VeteranHRCTRYCODERequiredWhen PEM-VETERAN != Spaces
"VS"→CTC-TYPE
EMP-WORK-COUNTRY→CTC-COUNTRY-CODE
PEM-VETERAN→CTC-HRCTRY-CODE

One to many (64) — child tables

RelationTableRulesConditionField map
AccomodationPAMEDICALDelete Restricted
PEM-COMPANY→PMD-COMPANY
PEM-EMPLOYEE→PMD-EMPLOYEE
"AC"→PMD-TYPE
—→PMD-CODE
—→PMD-SEQ-NBR
ApplicantAPPLICANT
PEM-COMPANY→APL-COMPANY
PEM-EMPLOYEE→APL-EMPLOYEE
—→APL-APPLICANT
AutomobilesEMPAUTODelete Cascades
PEM-COMPANY→EAT-COMPANY
PEM-EMPLOYEE→EAT-EMPLOYEE
—→EAT-AUTO-NBR
Bn CommentsPACOMMENTSDelete 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
—→PAC-DATE
BnempexerBNEMPEXER
PEM-COMPANY→BXR-COMPANY
PEM-EMPLOYEE→BXR-EMPLOYEE
—→BXR-OPT-GRANT-NBR
—→BXR-STOCK-CTF
—→BXR-EXERCISE-DATE
—→BXR-SEQ-NBR
Ce CommentsPACOMMENTSDelete 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
—→PAC-DATE
CertificationsEMPCODESDelete Cascades
PEM-COMPANY→EPC-COMPANY
"CE"→EPC-TYPE
Zeroes→EPC-EMP-APP
PEM-EMPLOYEE→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
Co PropertyEMPCODES
PEM-COMPANY→EPC-COMPANY
"CP"→EPC-TYPE
Zeroes→EPC-EMP-APP
PEM-EMPLOYEE→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
CompetencyEMPCODESDelete Cascades
PEM-COMPANY→EPC-COMPANY
Zeroes→EPC-EMP-APP
PEM-EMPLOYEE→EPC-EMPLOYEE
—→EPC-TYPE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
ContractEMPCODESDelete 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
CorrespondenceHRCORRESP
PEM-COMPANY→HCP-COMPANY
"1"→HCP-REQ-TYPE
PEM-EMPLOYEE→HCP-ID-NBR
—→HCP-DEPENDENT
—→HCP-SEQ-NBR
Cp CommentsPACOMMENTSDelete 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
—→PAC-DATE
DependentsEMDEPENDDelete Restricted
PEM-COMPANY→EMD-COMPANY
PEM-EMPLOYEE→EMD-EMPLOYEE
—→EMD-SEQ-NBR
Dis Action StpPAGRDISTEP
PEM-COMPANY→PGI-COMPANY
PEM-EMPLOYEE→PGI-EMPLOYEE
"2"→PGI-TYPE
—→PGI-GRIEV-DIS-NBR
—→PGI-EFFECT-DATE
—→PGI-SEQ-NBR
Discpl ActionsPAGRDI
PEM-COMPANY→PAG-COMPANY
PEM-EMPLOYEE→PAG-EMPLOYEE
"2"→PAG-TYPE
—→PAG-DATE
—→PAG-GRIEV-DIS-NBR
Dp CommentsPACOMMENTSDelete 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
—→PAC-DATE
Ec CommentsPACOMMENTSDelete 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
—→PAC-DATE
Ed CommentsPACOMMENTSDelete 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
—→PAC-DATE
EducationEMPCODESDelete Cascades
PEM-COMPANY→EPC-COMPANY
"ED"→EPC-TYPE
Zeroes→EPC-EMP-APP
PEM-EMPLOYEE→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
Emerg ContactPAEMERGCNTDelete Restricted
PEM-COMPANY→PAE-COMPANY
PEM-EMPLOYEE→PAE-EMPLOYEE
—→PAE-SEQ-NBR
Ge CommentsPACOMMENTSDelete 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
—→PAC-DATE
Gri Dis Act StPAGRDISTEP
PEM-COMPANY→PGI-COMPANY
PEM-EMPLOYEE→PGI-EMPLOYEE
"2"→PGI-TYPE
—→PGI-GRIEV-DIS-NBR
—→PGI-EFFECT-DATE
—→PGI-SEQ-NBR
Griev Dis ActPAGRDI
PEM-COMPANY→PAG-COMPANY
PEM-EMPLOYEE→PAG-EMPLOYEE
—→PAG-TYPE
—→PAG-DATE
—→PAG-GRIEV-DIS-NBR
Griev StepsPAGRDISTEP
PEM-COMPANY→PGI-COMPANY
PEM-EMPLOYEE→PGI-EMPLOYEE
"1"→PGI-TYPE
—→PGI-GRIEV-DIS-NBR
—→PGI-EFFECT-DATE
—→PGI-SEQ-NBR
GrievancesPAGRDI
PEM-COMPANY→PAG-COMPANY
PEM-EMPLOYEE→PAG-EMPLOYEE
"1"→PAG-TYPE
—→PAG-DATE
—→PAG-GRIEV-DIS-NBR
Hist ErrHISTERRDelete 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 NbrHRCONTNBR
PEM-COMPANY→HCN-COMPANY
"1"→HCN-REQ-TYPE
PEM-EMPLOYEE→HCN-ID-NBR
Zeroes→HCN-DEPENDENT
—→HCN-SEQ-NBR
Incid FollowupPAFOLLOWUPDelete Cascades
PEM-COMPANY→PAF-COMPANY
PEM-EMPLOYEE→PAF-EMPLOYEE
—→PAF-ESTABLISHMENT
—→PAF-INCIDENT-NBR
—→PAF-EFFECT-DATE
—→PAF-SEQ-NBR
Incident CostsPAINCICOSTDelete Cascades
PEM-COMPANY→PAI-COMPANY
PEM-EMPLOYEE→PAI-EMPLOYEE
—→PAI-ESTABLISHMENT
—→PAI-INCIDENT-NBR
—→PAI-EFFECT-DATE
—→PAI-SEQ-NBR
InterviewsINTERVIEWDelete Cascades
PEM-COMPANY→ITV-COMPANY
Zeroes→ITV-EMP-APP
PEM-EMPLOYEE→ITV-APPLICANT
—→ITV-SEQ-NBR
Iv CommentsPACOMMENTSDelete 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
—→PAC-DATE
Job HistAPPJOBHIST
PEM-COMPANY→AJH-COMPANY
PEM-EMPLOYEE→AJH-EMPLOYEE
—→AJH-SEQ-NBR
—→AJH-APPLICANT
Job InterestPAJOBINTRSDelete Cascades
PEM-COMPANY→PJI-COMPANY
Zeroes→PJI-EMP-APP
PEM-EMPLOYEE→PJI-EMPLOYEE
—→PJI-JOB-CODE
—→PJI-POSITION
JobauthJOBAUTHDelete Cascades
PEM-COMPANY→JBA-COMPANY
Zeroes→JBA-EMP-APP
PEM-EMPLOYEE→JBA-EMPLOYEE
—→JBA-JOB-CODE
—→JBA-POSITION
Md CommentsPACOMMENTSDelete 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
—→PAC-DATE
Medical CodesPAMEDICALDelete Restricted
PEM-COMPANY→PMD-COMPANY
PEM-EMPLOYEE→PMD-EMPLOYEE
"EM"→PMD-TYPE
—→PMD-CODE
—→PMD-SEQ-NBR
Mi CommentsPACOMMENTSDelete 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
—→PAC-DATE
MilitaryMILITARYDelete Cascades
PEM-COMPANY→MIL-COMPANY
Zeroes→MIL-EMP-APP
PEM-EMPLOYEE→MIL-EMPLOYEE
—→MIL-BR-SERVICE
—→MIL-SEQ-NBR
Off LangPAOFFLANG
PEM-COMPANY→PLA-COMPANY
PEM-EMPLOYEE→PLA-EMPLOYEE
Spaces→PLA-POSITION
—→PLA-REPORT-TYPE
—→PLA-SEQ-NBR
Os CommentsPACOMMENTSDelete 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
—→PAC-DATE
OshaOSHADelete Cascades
PEM-COMPANY→OSH-COMPANY
PEM-EMPLOYEE→OSH-EMPLOYEE
—→OSH-ESTABLISHMENT
—→OSH-SEQ-NBR
Pa BenefitsEMPCODESDelete Cascades
PEM-COMPANY→EPC-COMPANY
"BN"→EPC-TYPE
Zeroes→EPC-EMP-APP
PEM-EMPLOYEE→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
Pa CommentsPACOMMENTSDelete 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
—→PAC-DATE
PaencumberPAENCUMBERDelete 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
PainstructPAINSTRUCT
PEM-COMPANY→INS-COMPANY
PEM-EMPLOYEE→INS-EMPLOYEE
—→INS-LAST-NAME
—→INS-FIRST-NAME
—→INS-MIDDLE-INIT
—→INS-INSTRUCT
Pending ActionPERSACTION
PEM-COMPANY→PCT-COMPANY
PEM-EMPLOYEE→PCT-EMPLOYEE
—→PCT-ACTION-TYPE
—→PCT-ACTION-CODE
—→PCT-EFFECT-DATE
—→PCT-ACTION-NBR
RacePAEEEORACE
PEM-COMPANY→EER-COMPANY
PEM-EMPLOYEE→EER-EMPLOYEE
—→EER-RACE
RegistrationsPAREGISTER
PEM-COMPANY→REG-COMPANY
PEM-EMPLOYEE→REG-EMPLOYEE
—→REG-COURSE
—→REG-SESSION
—→REG-START-DATE
RelocationEMPCODES
PEM-COMPANY→EPC-COMPANY
"RL"→EPC-TYPE
Zeroes→EPC-EMP-APP
PEM-EMPLOYEE→EPC-EMPLOYEE
—→EPC-CODE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
RequisitionsPAREQAPPDelete Cascades
PEM-COMPANY→PRA-COMPANY
Zeroes→PRA-EMP-APP
PEM-EMPLOYEE→PRA-APPLICANT
—→PRA-REQUISITION
ReviewsREVIEWDelete Cascades
PEM-COMPANY→REV-COMPANY
PEM-EMPLOYEE→REV-EMPLOYEE
—→REV-SCHED-DATE
—→REV-CODE
—→REV-SEQ-NBR
Rl CommentsPACOMMENTSDelete 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
—→PAC-DATE
Rv CommentsPACOMMENTSDelete 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
—→PAC-DATE
Sk CommentsPACOMMENTSDelete 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
—→PAC-DATE
StockgrntBNEMPGRNT
PEM-COMPANY→BEG-COMPANY
PEM-EMPLOYEE→BEG-EMPLOYEE
—→BEG-OPT-GRANT-NBR
—→BEG-STOCK-CTF
Test ExceptionPATESTOVER
PEM-COMPANY→PAV-COMPANY
PEM-EMPLOYEE→PAV-EMPLOYEE
—→PAV-TEST
TracksPAEMPTRACKDelete Cascades
PEM-COMPANY→ETR-COMPANY
PEM-EMPLOYEE→ETR-EMPLOYEE
—→ETR-TYPE
—→ETR-TRACK
Train CostsPAEMPCOSTSDelete Cascades
PEM-COMPANY→EMC-COMPANY
PEM-EMPLOYEE→EMC-EMPLOYEE
—→EMC-COURSE
—→EMC-DATE
—→EMC-COST-TYPE
—→EMC-COST-CAT
TrainingPATRNHISTDelete Cascades
PEM-COMPANY→TRH-COMPANY
PEM-EMPLOYEE→TRH-EMPLOYEE
—→TRH-COURSE
—→TRH-DATE-COMPLETED
Training DatesPATRNHIST
PEM-COMPANY→TRH-COMPANY
PEM-EMPLOYEE→TRH-EMPLOYEE
—→TRH-DATE-COMPLETED
—→TRH-COURSE
Tv CommentsPACOMMENTSDelete 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
—→PAC-DATE
VisasEMPVISADelete Cascades
PEM-COMPANY→EMV-COMPANY
PEM-EMPLOYEE→EMV-EMPLOYEE
—→EMV-DEPENDENT
—→EMV-SEQ-NBR
Work RestrictPAMEDICALDelete Restricted
PEM-COMPANY→PMD-COMPANY
PEM-EMPLOYEE→PMD-EMPLOYEE
"WR"→PMD-TYPE
—→PMD-CODE
—→PMD-SEQ-NBR
Wr CommentsPACOMMENTSDelete 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
—→PAC-DATE

Programs

Updated by (72)

Referenced by (291)