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 / column | Type | Description & values | Updated by |
|---|---|---|---|
PEM-COMPANY PKCOMPANY | Numeric 4 | Contains 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 PKEMPLOYEE | Numeric 9 | Contains 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-ADDR1SUPP_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-ADDR2SUPP_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-ADDR3SUPP_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-ADDR4SUPP_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-CITYSUPP_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-STATESUPP_STATE | Alpha 2 | Contains the state of the supplemental address. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-SUPP-ZIPSUPP_ZIP | Alpha 10 | Contains the postal code of the supplemental address. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-SUPP-CNTRY-CDSUPP_CNTRY_CD | Alpha 2 | Contains the country of the supplemental address. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-HM-PHONE-CNTRYHM_PHONE_CNTRY | Alpha 6 | Contains 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-NBRHM_PHONE_NBR | Alpha 15 | Contains the employee's home telephone number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-WK-PHONE-CNTRYWK_PHONE_CNTRY | Alpha 6 | Contains 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-NBRWK_PHONE_NBR | Alpha 15 | Contains the employee's work telephone number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-WK-PHONE-EXTWK_PHONE_EXT | Alpha 5 | Contains 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-CLASSEEO_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-SEXSEX | Alpha 1 | Contains the employee's gender.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-HANDICAP-IDHANDICAP_ID | Alpha 1 | Indicates if the employee is disabled.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-COMP-CODECOMP_CODE | Alpha 4 | Contains miscellaneous data. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-COMP-NBRCOMP_NBR | Alpha 10 | Contains miscellaneous data. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-VETERANVETERAN | Alpha 4 | Indicates the individual is a veteran. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-BIRTHDATEBIRTHDATE | 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-CITYBIRTH_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-STATEBIRTH_STATE | Alpha 2 | Contains 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-CDBIRTH_CNTRY_CD | Alpha 2 | Indicates country where employee was born. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-SENIOR-DATESENIOR_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-NMMAIDEN_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-NMMAIDEN_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-MIMAIDEN_MI | Alpha 1 | Contains the employee's maiden middle initial. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-FORMER-LST-NMFORMER_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-NMFORMER_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-MIFORMER_MI | Alpha 1 | Contains the employee's former middle initial. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-LOCAT-CODELOCAT_CODE | Alpha 10 | Contains 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-SOURCEHIRE_SOURCE | Alpha 10 | Contains 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-CODESECURITY_CODE | Alpha 10 | Contains 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-NBRSECURITY_NBR | Alpha 10 | Contains 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-UNITBARGAIN_UNIT | Alpha 10 | Contains 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-NBRCLOCK_NBR | Alpha 10 | Contains the employee's clock number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-MAIL-GROUPMAIL_GROUP | Alpha 10 | Contains 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-NBRMB_NBR | Alpha 10 | Contains the employee's mail box number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-DRAFT-STATUSDRAFT_STATUS | Alpha 3 | Contains 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-RANKFINAL_RANK | Alpha 3 | Identifies the highest military rank attained by the employee. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-CUR-STATUSCUR_STATUS | Alpha 2 | Indicates if the employee is currently in the Reserves or National Guard.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-LAST-PHYSICALLAST_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-SCHDPHY_SCHD | Alpha 2 | Contains the frequency of the employee's physical examinations.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-NEXT-PHYSICALNEXT_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-FTHEIGHT_FT | Numeric 2 | Contains the employee's height in feet. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-HEIGHT-INHEIGHT_IN | Numeric 2 | Contains the employee's height in inches. 01 11 | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-WGHTWGHT | Signed 5.2 | Contains the employee's weight. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-BLOOD-TYPEBLOOD_TYPE | Alpha 3 | Contains 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-LOTPARKING_LOT | Alpha 10 | Contains 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-SPACEPARKING_SPACE | Alpha 10 | Identifies the parking space assigned to the employee. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-DR-LICENSEDR_LICENSE | Alpha 20 | Contains the employee's driver's license number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-DR-LIC-STDR_LIC_ST | Alpha 2 | Contains 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-DATEEXP_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-CLASSDR_LIC_CLASS | Alpha 3 | Contains 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-SCHEDULEREV_SCHEDULE | Alpha 2 | Identifies the frequency of performance reviews for the employee.
| PA26.1, PA526 |
PEM-NEXT-REVIEWNEXT_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-CODENEXT_REV_CODE | Alpha 10 | Identifies 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-REVIEWLAST_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-SEQLAST_MIL_SEQ | Numeric 4 | Contains 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-SEQLAST_REV_SEQ | Numeric 4 | Contains 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-SEQLAST_COM_SEQ | Numeric 4 | Contains 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-SEQLAST_INT_SEQ | Numeric 4 | Contains 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-SEQLAST_BNF_SEQ | Numeric 4 | Contains 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-NBRLAST_INV_NBR | Numeric 4 | Contains 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-SEQLAST_EPC_SEQ | Numeric 4 | Contains 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-GROUPFNCTN_GROUP | Numeric 2 | Identifies for the EEO-4 report, the type of work the employee does. 01 15 | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-EXCLUDE-FLAGEXCLUDE_FLAG | Alpha 1 | Determines if an employee is included in the EEO-4 report.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-NBR-HL-DEPNBR_HL_DEP | Numeric 3 | Contains 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-DEPNBR_DN_DEP | Numeric 3 | Contains 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-CRLIFE_STYLE_CR | Numeric 2 | Contains 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-PROOFHL_COV_PROOF | Alpha 1 | Indicates if there is proof that the employee is covered by health insurance outside the company.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-DN-COV-PROOFDN_COV_PROOF | Alpha 1 | Indicates if there is proof that the employee is covered by dental insurance outside the company.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-HL-VERIFY-DTHL_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-DTDN_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-EMPSPOUSE_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-ADDR1SP_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-ADDR2SP_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-ADDR3SP_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-ADDR4SP_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-CITYSP_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-STATESP_EMP_STATE | Alpha 2 | Contains 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-ZIPSP_EMP_ZIP | Alpha 10 | Contains 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-COUNTRYSP_EMP_COUNTRY | Alpha 2 | Contains 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-CNTRSP_EMP_PH_CNTR | Alpha 6 | Contains 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-NBRSP_EMP_PH_NBR | Alpha 15 | Contains the spouse's employer's telephone number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-OWNER-FLAGOWNER_FLAG | Alpha 1 | Identifies owners of the company.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-KEY-EMP-FLAGKEY_EMP_FLAG | Alpha 1 | Identifies key employees of the company.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-OFFICEROFFICER | Alpha 1 | Identifies officers of the company.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-HIGH-COMPHIGH_COMP | Alpha 1 | Identifies highly compensated employees for non-discrimination testing in the Lawson Benefits System.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-SMOKERSMOKER | Alpha 1 | Indicates if an employee is a smoker. The Lawson Benefits system uses this information when calculating employee life and disability insurance premiums.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-STATUSI9_STATUS | Alpha 10 | Identifies the employee's immigration status. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-ALIEN-NBRI9_ALIEN_NBR | Alpha 11 | Contains the employee's alien number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-ADMIT-NBRI9_ADMIT_NBR | Alpha 13 | Contains the employee's admission number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-STA-EXP-DTI9_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-NBRI9_DOC_NBR | Alpha 20 Occurs 2 Times ×2 | Contains the document identification number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-DOC-TYPEI9_DOC_TYPE | Alpha 10 Occurs 2 Times ×2 | Identifies the type of document entered. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-DOC-EXP-DTI9_DOC_EXP_DT | Numeric 8 (yyyymmdd) Occurs 2 Times ×2 | Contains the expiration date of the document. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-AUTHORIZEI9_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-STATTRUE_MAR_STAT | Alpha 1 | Contains the employee's true marital status.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more |
PEM-LAST-PAE-SEQLAST_PAE_SEQ | Numeric 4 | Contains 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-CAREPRIMARY_CARE | Alpha 10 | Contains 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-AGGFAMILY_AGG | Numeric 9 | Contains 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-1BEN_SALARY_1 | Signed 11.2 | Contains optional user-defined benefit salary information. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-BEN-SALARY-2BEN_SALARY_2 | Signed 11.2 | Contains optional user-defined benefit salary information. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-BEN-SALARY-3BEN_SALARY_3 | Signed 11.2 | Contains optional user-defined benefit salary information. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-BEN-SALARY-4BEN_SALARY_4 | Signed 11.2 | Contains optional user-defined benefit salary information. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-BEN-SALARY-5BEN_SALARY_5 | Signed 11.2 | Contains optional user-defined benefit salary information. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-BEN-DATE-1BEN_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-2BEN_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-3BEN_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-4BEN_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-5BEN_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-LVLSEC_LVL | Numeric 1 | Contains the employee's security level. | BN305, HR11.1, HR11.2, HR11.4, HR12.1, HR28.1, HR511, LT101 +25 more |
PEM-SEC-LOCATIONSEC_LOCATION | Alpha 10 | Contains the employee's security location. | BN305, HR11.1, HR11.2, HR11.4, HR12.1, HR28.1, HR511, LT101 +25 more |
PEM-CUR-AGECUR_AGE | Derived | — | — |
PEM-SEX-1SEX_1 | Derived | — | — |
PEM-EEO-CLASS-1EEO_CLASS_1 | Derived | — | — |
PEM-WORK-ZIPWORK_ZIP | Alpha 10 | Contains the employee's work postal code. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-HEIGHT-UNITHEIGHT_UNIT | Alpha 1 | Contains unit in which height is recorded.
| PA15.1 |
PEM-WGHT-UNITWGHT_UNIT | Alpha 1 | Contains unit in which the employee's weight is recorded.
| PA15.1 |
PEM-LANGUAGE-CODELANGUAGE_CODE | Alpha 10 | Contains 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-RELIGIONRELIGION | Alpha 10 | Contains employee's religion. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-DISABILITYDISABILITY | Alpha 10 | Contains type of disability. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-SUPP-PHONE-CNTSUPP_PHONE_CNT | Alpha 6 | Contains phone country of supplemental phone number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-SUPP-PHONE-NBRSUPP_PHONE_NBR | Alpha 15 | Contains supplemental phone number. | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-CONSENTCONSENT | Alpha 1 | " " = No
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-ABORIGINALABORIGINAL | Alpha 1 | Designates if an employee is Aboriginal.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-VISIBLE-MINVISIBLE_MIN | Alpha 1 | Designates if an employee is a visible minority.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-RELATED-EMPRELATED_EMP | Alpha 1 | Determines whether or not an employee is related to the employer.
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-I9-DOC-DESCRI9_DOC_DESCR | Alpha 10 Occurs 2 Times ×2 | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-BILINGUALBILINGUAL | Alpha 1 | —
| PA96.1 |
PEM-SUPP-COUNTYSUPP_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-TRADESTOCK_TRADE | Alpha 1 | " " = Not applicable
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-DATE-ASSIGNDATE_ASSIGN | Numeric 8 (yyyymmdd) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-USER-AMOUNTUSER_AMOUNT | Signed 13.4 | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-ESTAB-PATIENTESTAB_PATIENT | Numeric 1 | —
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-PRIOR-COV-MOPRIOR_COV_MO | Numeric 2 | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-MEDICARE-INDMEDICARE_IND | Alpha 1 | —
| BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-TAX-FREQUENCYTAX_FREQUENCY | Numeric 3 | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-EMPLOYEE-TYPEEMPLOYEE_TYPE | Numeric 4 | — | PR13.9 |
PEM-SURVEY-DATESURVEY_DATE | Numeric 8 (yyyymmdd) | — | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more |
PEM-UPDATED-BY-LTMUPDATED_BY_LTM | Alpha 1 | —
| — |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PEMSET1 | COMPANY, EMPLOYEE | Primary | BN100, BN101, BN102, BN103, BN104, BN105, BN106, BN137 +22 more (list truncated in source) | |
PEMSET2 | SURVEY-DATE, COMPANY, EMPLOYEE | KeyChange | — |
Relations
One to one (14) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
| Veteran | HRCTRYCODE | Required | When PEM-VETERAN != Spaces | "VS" → CTC-TYPE, EMP-WORK-COUNTRY → CTC-COUNTRY-CODE, PEM-VETERAN → CTC-HRCTRY-CODE |
One to many (64) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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, → PAC-DATE | |
| Bnempexer | BNEMPEXER | PEM-COMPANY → BXR-COMPANY, PEM-EMPLOYEE → BXR-EMPLOYEE, → BXR-OPT-GRANT-NBR, → BXR-STOCK-CTF, → BXR-EXERCISE-DATE, → BXR-SEQ-NBR | ||
| Ce Comments | PACOMMENTS | Delete Cascades | PEM-COMPANY → PAC-COMPANY, Zeroes → PAC-EMP-APP, "CE" → PAC-CMT-TYPE, PEM-EMPLOYEE → PAC-EMPLOYEE, Spaces → PAC-JOB-CODE, Spaces → PAC-ACTION-CODE, Zeroes → PAC-LN-NBR, → PAC-SEQ-NBR, → PAC-DATE | |
| Certifications | EMPCODES | Delete Cascades | PEM-COMPANY → EPC-COMPANY, "CE" → EPC-TYPE, Zeroes → EPC-EMP-APP, PEM-EMPLOYEE → EPC-EMPLOYEE, → EPC-CODE, → EPC-SUBJECT, → EPC-SEQ-NBR | |
| Co Property | EMPCODES | PEM-COMPANY → EPC-COMPANY, "CP" → EPC-TYPE, Zeroes → EPC-EMP-APP, PEM-EMPLOYEE → EPC-EMPLOYEE, → EPC-CODE, → EPC-SUBJECT, → EPC-SEQ-NBR | ||
| Competency | EMPCODES | Delete Cascades | PEM-COMPANY → EPC-COMPANY, Zeroes → EPC-EMP-APP, PEM-EMPLOYEE → EPC-EMPLOYEE, → EPC-TYPE, → EPC-CODE, → EPC-SUBJECT, → EPC-SEQ-NBR | |
| Contract | EMPCODES | Delete Cascades | PEM-COMPANY → EPC-COMPANY, Zeroes → EPC-EMP-APP, PEM-EMPLOYEE → EPC-EMPLOYEE, "CN" → EPC-TYPE, → EPC-CODE, → EPC-DATE-ACQUIRED, → EPC-SUBJECT, → EPC-SEQ-NBR | |
| Correspondence | HRCORRESP | PEM-COMPANY → HCP-COMPANY, "1" → HCP-REQ-TYPE, PEM-EMPLOYEE → HCP-ID-NBR, → HCP-DEPENDENT, → HCP-SEQ-NBR | ||
| Cp Comments | PACOMMENTS | Delete Cascades | PEM-COMPANY → PAC-COMPANY, Zeroes → PAC-EMP-APP, "CP" → PAC-CMT-TYPE, PEM-EMPLOYEE → PAC-EMPLOYEE, Spaces → PAC-JOB-CODE, Spaces → PAC-ACTION-CODE, Zeroes → PAC-LN-NBR, → PAC-SEQ-NBR, → PAC-DATE | |
| 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, → PAC-DATE | |
| 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, → PAC-DATE | |
| 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, → PAC-DATE | |
| 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, → PAC-DATE | |
| Gri Dis Act St | PAGRDISTEP | PEM-COMPANY → PGI-COMPANY, PEM-EMPLOYEE → PGI-EMPLOYEE, "2" → PGI-TYPE, → PGI-GRIEV-DIS-NBR, → PGI-EFFECT-DATE, → PGI-SEQ-NBR | ||
| Griev Dis Act | PAGRDI | PEM-COMPANY → PAG-COMPANY, PEM-EMPLOYEE → PAG-EMPLOYEE, → PAG-TYPE, → PAG-DATE, → PAG-GRIEV-DIS-NBR | ||
| Griev Steps | PAGRDISTEP | PEM-COMPANY → PGI-COMPANY, PEM-EMPLOYEE → PGI-EMPLOYEE, "1" → PGI-TYPE, → PGI-GRIEV-DIS-NBR, → PGI-EFFECT-DATE, → PGI-SEQ-NBR | ||
| Grievances | PAGRDI | PEM-COMPANY → PAG-COMPANY, PEM-EMPLOYEE → PAG-EMPLOYEE, "1" → PAG-TYPE, → PAG-DATE, → PAG-GRIEV-DIS-NBR | ||
| Hist Err | HISTERR | Delete Cascades | PEM-COMPANY → HER-COMPANY, PEM-EMPLOYEE → HER-EMPLOYEE, → HER-OBJ-ID, → HER-EFFECT-DATE, → HER-ACTION-CODE, → HER-ACTION-NBR, → HER-FLD-NBR, → HER-SEQ-NBR | |
| Hr Cont Nbr | HRCONTNBR | PEM-COMPANY → HCN-COMPANY, "1" → HCN-REQ-TYPE, PEM-EMPLOYEE → HCN-ID-NBR, Zeroes → HCN-DEPENDENT, → HCN-SEQ-NBR | ||
| Incid Followup | PAFOLLOWUP | Delete Cascades | PEM-COMPANY → PAF-COMPANY, PEM-EMPLOYEE → PAF-EMPLOYEE, → PAF-ESTABLISHMENT, → PAF-INCIDENT-NBR, → PAF-EFFECT-DATE, → PAF-SEQ-NBR | |
| Incident Costs | PAINCICOST | Delete Cascades | PEM-COMPANY → PAI-COMPANY, PEM-EMPLOYEE → PAI-EMPLOYEE, → PAI-ESTABLISHMENT, → PAI-INCIDENT-NBR, → PAI-EFFECT-DATE, → PAI-SEQ-NBR | |
| Interviews | INTERVIEW | Delete Cascades | PEM-COMPANY → ITV-COMPANY, Zeroes → ITV-EMP-APP, PEM-EMPLOYEE → ITV-APPLICANT, → ITV-SEQ-NBR | |
| Iv Comments | PACOMMENTS | Delete Cascades | PEM-COMPANY → PAC-COMPANY, Zeroes → PAC-EMP-APP, "IV" → PAC-CMT-TYPE, PEM-EMPLOYEE → PAC-EMPLOYEE, Spaces → PAC-JOB-CODE, Spaces → PAC-ACTION-CODE, → PAC-LN-NBR, → PAC-SEQ-NBR, → PAC-DATE | |
| Job Hist | APPJOBHIST | PEM-COMPANY → AJH-COMPANY, PEM-EMPLOYEE → AJH-EMPLOYEE, → AJH-SEQ-NBR, → AJH-APPLICANT | ||
| Job Interest | PAJOBINTRS | Delete Cascades | PEM-COMPANY → PJI-COMPANY, Zeroes → PJI-EMP-APP, PEM-EMPLOYEE → PJI-EMPLOYEE, → PJI-JOB-CODE, → PJI-POSITION | |
| Jobauth | JOBAUTH | Delete Cascades | PEM-COMPANY → JBA-COMPANY, Zeroes → JBA-EMP-APP, PEM-EMPLOYEE → JBA-EMPLOYEE, → JBA-JOB-CODE, → JBA-POSITION | |
| Md Comments | PACOMMENTS | Delete Cascades | PEM-COMPANY → PAC-COMPANY, Zeroes → PAC-EMP-APP, "MD" → PAC-CMT-TYPE, PEM-EMPLOYEE → PAC-EMPLOYEE, Spaces → PAC-JOB-CODE, Spaces → PAC-ACTION-CODE, Zeroes → PAC-LN-NBR, → PAC-SEQ-NBR, → PAC-DATE | |
| 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, → PAC-DATE | |
| Military | MILITARY | Delete Cascades | PEM-COMPANY → MIL-COMPANY, Zeroes → MIL-EMP-APP, PEM-EMPLOYEE → MIL-EMPLOYEE, → MIL-BR-SERVICE, → MIL-SEQ-NBR | |
| Off Lang | PAOFFLANG | PEM-COMPANY → PLA-COMPANY, PEM-EMPLOYEE → PLA-EMPLOYEE, Spaces → PLA-POSITION, → PLA-REPORT-TYPE, → PLA-SEQ-NBR | ||
| Os Comments | PACOMMENTS | Delete Cascades | PEM-COMPANY → PAC-COMPANY, Zeroes → PAC-EMP-APP, "OS" → PAC-CMT-TYPE, PEM-EMPLOYEE → PAC-EMPLOYEE, Spaces → PAC-JOB-CODE, Spaces → PAC-ACTION-CODE, → PAC-LN-NBR, → PAC-SEQ-NBR, → PAC-DATE | |
| 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, → PAC-DATE | |
| Paencumber | PAENCUMBER | Delete Restricted | PEM-COMPANY → PEN-COMPANY, PEM-EMPLOYEE → PEN-EMPLOYEE, → PEN-POSITION, → PEN-PROCESS-LEVEL, → PEN-DEPARTMENT, → PEN-JOB-CODE, → PEN-GLT-OBJ-ID, → PEN-ATN-OBJ-ID | |
| Painstruct | PAINSTRUCT | PEM-COMPANY → INS-COMPANY, PEM-EMPLOYEE → INS-EMPLOYEE, → INS-LAST-NAME, → INS-FIRST-NAME, → INS-MIDDLE-INIT, → INS-INSTRUCT | ||
| Pending Action | PERSACTION | PEM-COMPANY → PCT-COMPANY, PEM-EMPLOYEE → PCT-EMPLOYEE, → PCT-ACTION-TYPE, → PCT-ACTION-CODE, → PCT-EFFECT-DATE, → PCT-ACTION-NBR | ||
| Race | PAEEEORACE | PEM-COMPANY → EER-COMPANY, PEM-EMPLOYEE → EER-EMPLOYEE, → EER-RACE | ||
| 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, → REV-SEQ-NBR | |
| 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, → PAC-DATE | |
| 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, → PAC-DATE | |
| 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, → PAC-DATE | |
| Stockgrnt | BNEMPGRNT | PEM-COMPANY → BEG-COMPANY, PEM-EMPLOYEE → BEG-EMPLOYEE, → BEG-OPT-GRANT-NBR, → BEG-STOCK-CTF | ||
| Test Exception | PATESTOVER | PEM-COMPANY → PAV-COMPANY, PEM-EMPLOYEE → PAV-EMPLOYEE, → PAV-TEST | ||
| Tracks | PAEMPTRACK | Delete Cascades | PEM-COMPANY → ETR-COMPANY, PEM-EMPLOYEE → ETR-EMPLOYEE, → ETR-TYPE, → ETR-TRACK | |
| Train Costs | PAEMPCOSTS | Delete Cascades | PEM-COMPANY → EMC-COMPANY, PEM-EMPLOYEE → EMC-EMPLOYEE, → EMC-COURSE, → EMC-DATE, → EMC-COST-TYPE, → EMC-COST-CAT | |
| Training | PATRNHIST | Delete Cascades | PEM-COMPANY → TRH-COMPANY, PEM-EMPLOYEE → TRH-EMPLOYEE, → TRH-COURSE, → TRH-DATE-COMPLETED | |
| Training Dates | PATRNHIST | PEM-COMPANY → TRH-COMPANY, PEM-EMPLOYEE → TRH-EMPLOYEE, → TRH-DATE-COMPLETED, → TRH-COURSE | ||
| 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, → PAC-DATE | |
| Visas | EMPVISA | Delete Cascades | PEM-COMPANY → EMV-COMPANY, PEM-EMPLOYEE → EMV-EMPLOYEE, → EMV-DEPENDENT, → EMV-SEQ-NBR | |
| Work Restrict | PAMEDICAL | Delete Restricted | PEM-COMPANY → PMD-COMPANY, PEM-EMPLOYEE → PMD-EMPLOYEE, "WR" → PMD-TYPE, → PMD-CODE, → PMD-SEQ-NBR | |
| Wr Comments | PACOMMENTS | Delete Cascades | PEM-COMPANY → PAC-COMPANY, Zeroes → PAC-EMP-APP, "WR" → PAC-CMT-TYPE, PEM-EMPLOYEE → PAC-EMPLOYEE, Spaces → PAC-JOB-CODE, Spaces → PAC-ACTION-CODE, Zeroes → PAC-LN-NBR, → PAC-SEQ-NBR, → PAC-DATE |
Programs
Updated by (72)
- BN180 Invoice Edit
- BN305 Highly Compensated Employees
- BN47.1 Beneficiaries
- BN547 Beneficiaries Conversion
- BN80.1 Manual Invoice Entry
- BN90.1 Comments
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR12.1 Employee Security
- HR13.1 Dependent
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- HR513 Dependent Conversion
- HR90.1 Comments
- HR90.2 Payment Comments
- HS701 PDI, TalentView Data Update
- HS702 Review Data Update
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA12.1 Emergency Contact
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA14.1 Military Service
- PA15.1 Medical
- PA16.1 Company Property
- PA17.1 Automobile Information
- PA20.1 Education
- PA21.1 Competencies
- PA218 Travel Listing
- PA22.1 Certifications
- PA24.1 Relocation
- PA26.1 Review
- PA27.1 Contracts
- PA34.1 Applicant Education
- PA35.1 Applicant Competencies
- PA36.1 Applicant Certification
- PA38.1 Applicant Relocation
- PA41.1 Interviews
- PA502 Position Conversion
- PA512 Emergency Contact Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PA520 Employee and Applicant Code Conversion
- PA526 Review Conversion
- PA96.1 Official Languages Bilingual Requirements
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR13.1 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR30.2 Employee Automatic Time Record
- PR512 Employee ACH Distribution Interface
- PR530 Time Record Interface CSV
- PR84.1 Seniority Recalculation Inquiry
- TR21.1 Employee Training History
- TR22.1 Session Completion
- TR26.1 Employee Training Competency Maintenance
- TR500 Training Conversion
- ZH510 Update PCP from ZPENDPCP
- ZH535 HR11 Ben Date 3 Recalc-Update
Referenced by (291)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN104 Frequency Table Update
- BN105 Plan Update
- BN106 Benefit Transaction Export
- BN137 Stock Option Purge
- BN140 Savings Bond Update
- BN141 Stock Purchase Update
- BN145 Flex Dollars Calculation
- BN150 Life Insurance Reportable Income
- BN175 Outstanding Invoice Listing
- BN230 Plan Participant Report
- BN231 Employee Benefit Report
- BN232 Benefits Statement
- BN233 COBRA and Retiree Benefit Report
- BN234 Employee Stock Option Listing
- BN236 Participation Report
- BN237 Vesting Report
- BN238 Vacation Hours History
- BN240 Savings Bond Balance Report
- BN242 One Page Benefits Statement
- BN245 Benefit Election Form
- BN246 Flex Missing Benefits Report
- BN248 Savings Bond Sequence Listing
- BN258 Spending Account Balance
- BN260 Employee Benefit Extract
- BN285 Standard Letter Print
- BN300 Key Employees
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN310 Top Heavy Report
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN320 Premium Report
- BN325 Benefit Exception Report
- BN33.1 Employee Stock Option Grant Mass Entry
- BN33.2 Employee Stock Option Grant
- BN33.3 Employee Stock Option Vesting Detail
- BN330 Defined Contribution Plan Contributions
- BN331 HIPAA Certification Report
- BN335 Employee Deferral Report
- BN340 ADP and ACP Tests
- BN345 Percentage Test
- BN35.1 Benefit Change Audit
- BN350 Coverage Test - Classification
- BN36.1 Investment
- BN430 Benefit Purge
- BN45.1 Employee Flex Credits
- BN48.1 Savings Bond Beneficiaries
- BN48.2 Savings Bond Purchase Sequence
- BN531 Batch Benefit Enrollment
- BN533 Employee Stock Option Grant Conversion
- BN55.1 Defined Contribution or Defined Benefit Acct Balance
- BN55.2 Vested Amounts
- BN555 Defined Benefit or Defined Contribution Balance Conv
- BN56.1 Compensation History
- BN57.1 Vesting Hours
- BN65.1 Election Simulation
- BN66.1 Estimated Pay Calculation
- BN70.1 COBRA Participant
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- BS09.1 Employee Annual Enrollment Rules
- BS10.1 Web Enrollment Current Benefit Inquiry
- BS11.1 Web Enrollment Employee Flex Dollar Inquiry
- BS12.1 Web Enrollment Eligible New Plans
- BS13.1 Web Enrollment Coverage Options
- BS14.1 Web Enrollment Coverage Amounts
- BS15.1 Web Enrollment Contribution Limits
- BS32.1 Web Enrollment Stop Benefits Update
- EXI2.1 Invoke for PRTRDPD
- EXI3.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- EXLD.1 Load XM Users
- HAP3.1 Applicant Option 4 Selection Invoke
- HCDL.1 Olap Data Load
- HCEM.1 Olap Dimension Retrieval Format
- HCHP.1 Olap Data Load
- HCRE.1 Action Reason Code Selects
- HEP4.1 Employee Option 4 Selection Invoke
- HLTM.1 Lawson Talent Management Feed
- HPOS.1 Position Selection Invoke
- HPQC.1 Prqcentgrp Select Invoke
- HPRS.1 Process Level Select Invoke
- HR15.1 User Fields
- HR155 Employee Group Update
- HR156 Employee Group Company Update
- HR170 Human Resource Writer Report Request
- HR20.1 Additional Contact Numbers
- HR211 Employee Listing
- HR213 Dependent Listing
- HR217 Work Eligibility Listing
- HR220 Additional Contact Listing
- HR228 Employee Ethnicity Listing
- HR30.1 Correspondence Tracking
- HR515 User Field Conversion
- HR54.1 Employee History Correction
- HR55.2 Employee Groups By Employees
- HR70.1 Human Resource Writer Inquiry
- HRLRD Import Employee Data
- HRS1.1 Select Control
- HRSC.1 Select Control
- HS08.1 Goal Management Tracking
- HS10.1 Direct Report Inquiry
- HS10.2 Direct Report Inquiry
- HS11.1 Web Competency Profile
- HS11.2 Web Competency Profile
- HS12.1 Web Expired Competencies
- HS12.2 Web Expired Competencies
- HS13.1 Web Competency Compliance Rpt
- HS13.2 Web Competency Compliance Rpt
- HS14.1 Web Profsnl Profile-Phys-Nurse
- HS208 Goal Management Report
- HS50.1 Employee Qualification Search
- HS50.2 Employee Qualification Search
- HS703 LPMH Employee and Job Profile Extract
- HS704 LPMH Licensure Extract
- HS705 Emp Work Force Mgmt Extract
- LP100 Employee Absence Plan Update
- LP101 Mass Absence Plan Add
- LP102 Employee Master Update
- LP130 Absence Plan Payout
- LP138 Absence Plan Hours Update
- LP140 Employee Absence Plan Calculation
- LP251 Employee Leave of Absence Report
- LP51.1 Employee Leave of Absence
- LT11.5 HRM User Field Interface
- LT13.1 HRM Employee Interface History
- LT13.5 HRM User Field Interface History
- LT213 Interface Audit Export
- PA10.1 Length of Service
- PA113 Retroactive History Update
- PA149 Update Scheduled Tests
- PA210 Length of Service Report
- PA212 Emergency Contact Listing
- PA214 Military Service Listing
- PA215 Medical Listing
- PA216 Company Property Listing
- PA217 Automobile Listing
- PA220 Education Listing
- PA221 Employee Competency Listing
- PA222 Certification Listing
- PA223 Starters and Leavers Report
- PA224 Relocation Listing
- PA225 Employee Benefits Listing
- PA227 Contract Listing
- PA248 Test Listing
- PA249 Employee and Applicant Test Listing
- PA262 Qualified Employees Listing
- PA272 Budget and Assigned Resource Listing
- PA28.1 Applicant Ethnicity
- PA290 Health and Safety Incident Listing
- PA296 Canadian Language Bilingual Requirements Listing
- PA31.1 Applicant
- PA310 Birthdate Listing
- PA311 Employee Profile
- PA315 Telephone Listing
- PA320 Interoffice Directory
- PA325 Post Office Mailing Listing
- PA330 Interoffice Labels
- PA335 Employee Listing
- PA345 Review Schedule Report
- PA350 Review History Report
- PA355 Active Actions Report
- PA360 Wage Analysis Report
- PA370 Employee Review Document
- PA372 Health and Safety Incident Purge
- PA390 EEO-1 Report
- PA391 EEO-4 Report
- PA392 EEO-5 Report
- PA393 Veterans Employment Report
- PA406 Position Rules Audit Listing
- PA490 OSHA Log, Summary Report
- PA495 IPEDS Report
- PA496 Official Languages Report
- PA53.1 Personnel Action Workflow Override
- PA531 Applicant Conversion
- PA532 Code, Requisitions Exports
- PA533 Job History Conversion
- PA534 e-Recruiting Employee Export
- PA54.1 Personnel Action History Correction
- PA59.1 Grievance and Disciplinary Actions
- PA590 Health and Safety Incident Conversion
- PA594 EECRS CSV Interface
- PA64.1 Employee Job Qualification
- PA64.2 Employee Position Qualification
- PA66.2 Action Inquiry
- PA66.3 Employee Action Detail
- PA90.1 Health and Safety Incident
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR139 Arrears Automation
- PR14.1 Employee Deduction
- PR14.2 Tax Withholding Lock-In
- PR140 Earnings and Deductions Calculation
- PR15.2 Employee Deduction Speed Entry
- PR160 Payment Print
- PR180 Manual Payment Print
- PR188 Payroll Hours Update
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR197 Payroll Close
- PR198 General Ledger Posting
- PR205 Deduction Listing
- PR240 T4-T4A Slips
- PR241 T4-T4A XML
- PR242 T4-T4A Reports
- PR243 Releve Slips
- PR244 Releve Magnetic Media
- PR245 Releve Reports
- PR249 PIER Audit Report
- PR250 1099-R Form Reporting
- PR251 1099-R File Creation
- PR252 United States Territory W-2 Form Printing
- PR253 1099-R Reporting
- PR271 US Affordable Care Act
- PR274 Statistics Canada
- PR282 Canada Record of Employment
- PR29.1 Pension Payment Maintenance
- PR292 Quarterly Unemployment Ins
- PR293 Enumeration Verification
- PR296 New Hire Reporting
- PR297 W-2 Forms
- PR299 EFW2 File Creation
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.2 Manual Payment Print
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR85.1 Bank Account Reconciliation
- PR88.1 Payroll Hours
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- TA147 Canada Vacation Audit
- TR120 Group Session Registration
- TR121 Job Code Session Registration
- TR20.1 Session Registration
- TR20.2 Mass Registration
- TR20.3 Session Registration Override
- TR20.4 Employee Session Registration
- TR207 Instructor Listing
- UK102 Bonus Pay Update
- UK110 Pay Rate Table Update
- ZB01.1 Years Of Service Calculation
- ZB10.1 Coverage Options Calculator
- ZB10.2 Get Benefit Eligibility Dates
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add
- ZE526 Import eReview Evals to PA26
- ZE532 Pos Mgr Master List Interface
- ZH156 Employee Group Company Update
- ZH230 PPH Big Bad Edit
- ZH500 Employee Data Extract
- ZH568 Reed Employee Census Interface
- ZP296 New Hire Reporting
- ZP551 Triad FSA Export Interface
- ZP555 HealthEquity Export Interface
- ZP560 PPH Medical-Dental Interfaces
- ZP562 Sharp Medical Export Interface
- ZP567 Vision Enrollment