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.

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-CONSENT
CONSENT
Alpha 1" " = No
  • N No
  • Y Yes
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-RELATED-EMP
RELATED_EMP
Alpha 1Determines whether or not an employee is related to the employer.
  • 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 ×2BN305, 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.4BN305, 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 2BN305, 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 3BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
PEM-EMPLOYEE-TYPE
EMPLOYEE_TYPE
Numeric 4PR13.9
PEM-SURVEY-DATE
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEMSET1COMPANY, EMPLOYEEPrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN106, BN137 +22 more (list truncated in source)
PEMSET2SURVEY-DATE, COMPANY, EMPLOYEEKeyChange

Relations

One to one (14) — lookups and parents

RelationTableRulesConditionField map
Badge CodePCODESRequiredWhen PEM-SECURITY-CODE != Spaces"SC"PCO-TYPE, PEM-SECURITY-CODEPCO-CODE
Bargain UnitPCODESRequiredWhen PEM-BARGAIN-UNIT != Spaces"BU"PCO-TYPE, PEM-BARGAIN-UNITPCO-CODE
CompanyPRSYSTEMRequiredPEM-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
DisabilityPCODESRequiredWhen PEM-DISABILITY != Spaces"DI"PCO-TYPE, PEM-DISABILITYPCO-CODE
EmployeeEMPLOYEERequiredPEM-COMPANYEMP-COMPANY, PEM-EMPLOYEEEMP-EMPLOYEE
EthnicityHRCTRYCODERequiredWhen PEM-EEO-CLASS != Spaces"ET"CTC-TYPE, EMP-WORK-COUNTRYCTC-COUNTRY-CODE, PEM-EEO-CLASSCTC-HRCTRY-CODE
Family AggEMPLOYEERequiredWhen PEM-FAMILY-AGG != ZeroesPEM-COMPANYEMP-COMPANY, PEM-FAMILY-AGGEMP-EMPLOYEE
Hire SourcePCODESRequiredWhen PEM-HIRE-SOURCE != Spaces"HS"PCO-TYPE, PEM-HIRE-SOURCEPCO-CODE
LocationPCODESRequiredWhen PEM-LOCAT-CODE != Spaces"LO"PCO-TYPE, PEM-LOCAT-CODEPCO-CODE
Mail GroupPCODESRequiredWhen PEM-MAIL-GROUP != Spaces"MG"PCO-TYPE, PEM-MAIL-GROUPPCO-CODE
Primary CarePCODESRequiredWhen PEM-PRIMARY-CARE != Spaces"PC"PCO-TYPE, PEM-PRIMARY-CAREPCO-CODE
ReligionPCODESRequiredWhen PEM-RELIGION != Spaces"RE"PCO-TYPE, PEM-RELIGIONPCO-CODE
Supp CountryINSTCTRYCDRequiredWhen (PEM-SUPP-CNTRY-CD != Spaces)PEM-SUPP-CNTRY-CDINT-COUNTRY-CODE
VeteranHRCTRYCODERequiredWhen PEM-VETERAN != Spaces"VS"CTC-TYPE, EMP-WORK-COUNTRYCTC-COUNTRY-CODE, PEM-VETERANCTC-HRCTRY-CODE

One to many (64) — child tables

RelationTableRulesConditionField map
AccomodationPAMEDICALDelete RestrictedPEM-COMPANYPMD-COMPANY, PEM-EMPLOYEEPMD-EMPLOYEE, "AC"PMD-TYPE, PMD-CODE, PMD-SEQ-NBR
ApplicantAPPLICANTPEM-COMPANYAPL-COMPANY, PEM-EMPLOYEEAPL-EMPLOYEE, APL-APPLICANT
AutomobilesEMPAUTODelete CascadesPEM-COMPANYEAT-COMPANY, PEM-EMPLOYEEEAT-EMPLOYEE, EAT-AUTO-NBR
Bn CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "BN"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
BnempexerBNEMPEXERPEM-COMPANYBXR-COMPANY, PEM-EMPLOYEEBXR-EMPLOYEE, BXR-OPT-GRANT-NBR, BXR-STOCK-CTF, BXR-EXERCISE-DATE, BXR-SEQ-NBR
Ce CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "CE"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
CertificationsEMPCODESDelete CascadesPEM-COMPANYEPC-COMPANY, "CE"EPC-TYPE, ZeroesEPC-EMP-APP, PEM-EMPLOYEEEPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR
Co PropertyEMPCODESPEM-COMPANYEPC-COMPANY, "CP"EPC-TYPE, ZeroesEPC-EMP-APP, PEM-EMPLOYEEEPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR
CompetencyEMPCODESDelete CascadesPEM-COMPANYEPC-COMPANY, ZeroesEPC-EMP-APP, PEM-EMPLOYEEEPC-EMPLOYEE, EPC-TYPE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR
ContractEMPCODESDelete CascadesPEM-COMPANYEPC-COMPANY, ZeroesEPC-EMP-APP, PEM-EMPLOYEEEPC-EMPLOYEE, "CN"EPC-TYPE, EPC-CODE, EPC-DATE-ACQUIRED, EPC-SUBJECT, EPC-SEQ-NBR
CorrespondenceHRCORRESPPEM-COMPANYHCP-COMPANY, "1"HCP-REQ-TYPE, PEM-EMPLOYEEHCP-ID-NBR, HCP-DEPENDENT, HCP-SEQ-NBR
Cp CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "CP"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
DependentsEMDEPENDDelete RestrictedPEM-COMPANYEMD-COMPANY, PEM-EMPLOYEEEMD-EMPLOYEE, EMD-SEQ-NBR
Dis Action StpPAGRDISTEPPEM-COMPANYPGI-COMPANY, PEM-EMPLOYEEPGI-EMPLOYEE, "2"PGI-TYPE, PGI-GRIEV-DIS-NBR, PGI-EFFECT-DATE, PGI-SEQ-NBR
Discpl ActionsPAGRDIPEM-COMPANYPAG-COMPANY, PEM-EMPLOYEEPAG-EMPLOYEE, "2"PAG-TYPE, PAG-DATE, PAG-GRIEV-DIS-NBR
Dp CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "DP"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, PAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Ec CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "EC"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, PAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Ed CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "ED"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
EducationEMPCODESDelete CascadesPEM-COMPANYEPC-COMPANY, "ED"EPC-TYPE, ZeroesEPC-EMP-APP, PEM-EMPLOYEEEPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR
Emerg ContactPAEMERGCNTDelete RestrictedPEM-COMPANYPAE-COMPANY, PEM-EMPLOYEEPAE-EMPLOYEE, PAE-SEQ-NBR
Ge CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "GE"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Gri Dis Act StPAGRDISTEPPEM-COMPANYPGI-COMPANY, PEM-EMPLOYEEPGI-EMPLOYEE, "2"PGI-TYPE, PGI-GRIEV-DIS-NBR, PGI-EFFECT-DATE, PGI-SEQ-NBR
Griev Dis ActPAGRDIPEM-COMPANYPAG-COMPANY, PEM-EMPLOYEEPAG-EMPLOYEE, PAG-TYPE, PAG-DATE, PAG-GRIEV-DIS-NBR
Griev StepsPAGRDISTEPPEM-COMPANYPGI-COMPANY, PEM-EMPLOYEEPGI-EMPLOYEE, "1"PGI-TYPE, PGI-GRIEV-DIS-NBR, PGI-EFFECT-DATE, PGI-SEQ-NBR
GrievancesPAGRDIPEM-COMPANYPAG-COMPANY, PEM-EMPLOYEEPAG-EMPLOYEE, "1"PAG-TYPE, PAG-DATE, PAG-GRIEV-DIS-NBR
Hist ErrHISTERRDelete CascadesPEM-COMPANYHER-COMPANY, PEM-EMPLOYEEHER-EMPLOYEE, HER-OBJ-ID, HER-EFFECT-DATE, HER-ACTION-CODE, HER-ACTION-NBR, HER-FLD-NBR, HER-SEQ-NBR
Hr Cont NbrHRCONTNBRPEM-COMPANYHCN-COMPANY, "1"HCN-REQ-TYPE, PEM-EMPLOYEEHCN-ID-NBR, ZeroesHCN-DEPENDENT, HCN-SEQ-NBR
Incid FollowupPAFOLLOWUPDelete CascadesPEM-COMPANYPAF-COMPANY, PEM-EMPLOYEEPAF-EMPLOYEE, PAF-ESTABLISHMENT, PAF-INCIDENT-NBR, PAF-EFFECT-DATE, PAF-SEQ-NBR
Incident CostsPAINCICOSTDelete CascadesPEM-COMPANYPAI-COMPANY, PEM-EMPLOYEEPAI-EMPLOYEE, PAI-ESTABLISHMENT, PAI-INCIDENT-NBR, PAI-EFFECT-DATE, PAI-SEQ-NBR
InterviewsINTERVIEWDelete CascadesPEM-COMPANYITV-COMPANY, ZeroesITV-EMP-APP, PEM-EMPLOYEEITV-APPLICANT, ITV-SEQ-NBR
Iv CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "IV"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, PAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Job HistAPPJOBHISTPEM-COMPANYAJH-COMPANY, PEM-EMPLOYEEAJH-EMPLOYEE, AJH-SEQ-NBR, AJH-APPLICANT
Job InterestPAJOBINTRSDelete CascadesPEM-COMPANYPJI-COMPANY, ZeroesPJI-EMP-APP, PEM-EMPLOYEEPJI-EMPLOYEE, PJI-JOB-CODE, PJI-POSITION
JobauthJOBAUTHDelete CascadesPEM-COMPANYJBA-COMPANY, ZeroesJBA-EMP-APP, PEM-EMPLOYEEJBA-EMPLOYEE, JBA-JOB-CODE, JBA-POSITION
Md CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "MD"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Medical CodesPAMEDICALDelete RestrictedPEM-COMPANYPMD-COMPANY, PEM-EMPLOYEEPMD-EMPLOYEE, "EM"PMD-TYPE, PMD-CODE, PMD-SEQ-NBR
Mi CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "MI"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
MilitaryMILITARYDelete CascadesPEM-COMPANYMIL-COMPANY, ZeroesMIL-EMP-APP, PEM-EMPLOYEEMIL-EMPLOYEE, MIL-BR-SERVICE, MIL-SEQ-NBR
Off LangPAOFFLANGPEM-COMPANYPLA-COMPANY, PEM-EMPLOYEEPLA-EMPLOYEE, SpacesPLA-POSITION, PLA-REPORT-TYPE, PLA-SEQ-NBR
Os CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "OS"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, PAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
OshaOSHADelete CascadesPEM-COMPANYOSH-COMPANY, PEM-EMPLOYEEOSH-EMPLOYEE, OSH-ESTABLISHMENT, OSH-SEQ-NBR
Pa BenefitsEMPCODESDelete CascadesPEM-COMPANYEPC-COMPANY, "BN"EPC-TYPE, ZeroesEPC-EMP-APP, PEM-EMPLOYEEEPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR
Pa CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "PA"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, PAC-ACTION-CODE, PAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
PaencumberPAENCUMBERDelete RestrictedPEM-COMPANYPEN-COMPANY, PEM-EMPLOYEEPEN-EMPLOYEE, PEN-POSITION, PEN-PROCESS-LEVEL, PEN-DEPARTMENT, PEN-JOB-CODE, PEN-GLT-OBJ-ID, PEN-ATN-OBJ-ID
PainstructPAINSTRUCTPEM-COMPANYINS-COMPANY, PEM-EMPLOYEEINS-EMPLOYEE, INS-LAST-NAME, INS-FIRST-NAME, INS-MIDDLE-INIT, INS-INSTRUCT
Pending ActionPERSACTIONPEM-COMPANYPCT-COMPANY, PEM-EMPLOYEEPCT-EMPLOYEE, PCT-ACTION-TYPE, PCT-ACTION-CODE, PCT-EFFECT-DATE, PCT-ACTION-NBR
RacePAEEEORACEPEM-COMPANYEER-COMPANY, PEM-EMPLOYEEEER-EMPLOYEE, EER-RACE
RegistrationsPAREGISTERPEM-COMPANYREG-COMPANY, PEM-EMPLOYEEREG-EMPLOYEE, REG-COURSE, REG-SESSION, REG-START-DATE
RelocationEMPCODESPEM-COMPANYEPC-COMPANY, "RL"EPC-TYPE, ZeroesEPC-EMP-APP, PEM-EMPLOYEEEPC-EMPLOYEE, EPC-CODE, EPC-SUBJECT, EPC-SEQ-NBR
RequisitionsPAREQAPPDelete CascadesPEM-COMPANYPRA-COMPANY, ZeroesPRA-EMP-APP, PEM-EMPLOYEEPRA-APPLICANT, PRA-REQUISITION
ReviewsREVIEWDelete CascadesPEM-COMPANYREV-COMPANY, PEM-EMPLOYEEREV-EMPLOYEE, REV-SCHED-DATE, REV-CODE, REV-SEQ-NBR
Rl CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "RL"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Rv CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "RV"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, PAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
Sk CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "SK"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
StockgrntBNEMPGRNTPEM-COMPANYBEG-COMPANY, PEM-EMPLOYEEBEG-EMPLOYEE, BEG-OPT-GRANT-NBR, BEG-STOCK-CTF
Test ExceptionPATESTOVERPEM-COMPANYPAV-COMPANY, PEM-EMPLOYEEPAV-EMPLOYEE, PAV-TEST
TracksPAEMPTRACKDelete CascadesPEM-COMPANYETR-COMPANY, PEM-EMPLOYEEETR-EMPLOYEE, ETR-TYPE, ETR-TRACK
Train CostsPAEMPCOSTSDelete CascadesPEM-COMPANYEMC-COMPANY, PEM-EMPLOYEEEMC-EMPLOYEE, EMC-COURSE, EMC-DATE, EMC-COST-TYPE, EMC-COST-CAT
TrainingPATRNHISTDelete CascadesPEM-COMPANYTRH-COMPANY, PEM-EMPLOYEETRH-EMPLOYEE, TRH-COURSE, TRH-DATE-COMPLETED
Training DatesPATRNHISTPEM-COMPANYTRH-COMPANY, PEM-EMPLOYEETRH-EMPLOYEE, TRH-DATE-COMPLETED, TRH-COURSE
Tv CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "TV"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE
VisasEMPVISADelete CascadesPEM-COMPANYEMV-COMPANY, PEM-EMPLOYEEEMV-EMPLOYEE, EMV-DEPENDENT, EMV-SEQ-NBR
Work RestrictPAMEDICALDelete RestrictedPEM-COMPANYPMD-COMPANY, PEM-EMPLOYEEPMD-EMPLOYEE, "WR"PMD-TYPE, PMD-CODE, PMD-SEQ-NBR
Wr CommentsPACOMMENTSDelete CascadesPEM-COMPANYPAC-COMPANY, ZeroesPAC-EMP-APP, "WR"PAC-CMT-TYPE, PEM-EMPLOYEEPAC-EMPLOYEE, SpacesPAC-JOB-CODE, SpacesPAC-ACTION-CODE, ZeroesPAC-LN-NBR, PAC-SEQ-NBR, PAC-DATE

Programs

Updated by (72)

Referenced by (291)