HREMPRCVR – No description in the Lawson data dictionary

System: Human Resources (HR)
Prefix: LEM
Primary key: COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, WORKASSIGNMENT, ACTION-CODE
Fields: 247
Updated by: 9 programs
Referenced by: 71 programs

HREMPRCVR is a Lawson Human Resources table (prefix LEM); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, WORKASSIGNMENT, ACTION-CODE (LEMSET1); alternate indexes: LEMSET2, LEMSET3, LEMSET4, LEMSET5, LEMSET6, LEMSET7 and LEMSET8. It is updated by LT01.1, LT101, LT103, LT11.1, LT111, LT13.1, LT213, PA52.1 and 1 more and referenced by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 63 more. The table has 247 fields, 8 indexes and 0 documented relations.

About HREMPRCVR

No description in the Lawson data dictionary.

Fields (247)

Column = COBOL field name without the LEM- 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 / column	Type	Description & values	Updated by
#`LEM-COMPANY` PK COMPANY	Numeric 4	—	LT11.1, LT13.1
#`LEM-EMPLOYEE` PK EMPLOYEE	Numeric 9	—	LT11.1, LT13.1
#`LEM-LTM-DATE-STAMP` PK LTM_DATE_STAMP	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-LTM-TIME-STAMP` PK LTM_TIME_STAMP	Numeric 8	—	LT11.1, LT13.1
#`LEM-ACTION-CODE` PK ACTION_CODE	Alpha 10	—	LT11.1, LT13.1
#`LEM-ACTION-REASON` ACTION_REASON	Alpha 20	—	LT11.1, LT13.1
#`LEM-STATUS` SET2 SET3 SET4 SET5 SET7 STATUS	Numeric 1	0 2 3 4 `1` Unprocessed `5` Historical `6` Don't Use `7` Skipped `8` User Field Error `9` Processed	LT01.1, LT101, LT103, LT11.1, LT111, LT13.1, PA52.1, PA52.5
#`LEM-ERROR-FLAG` SET2 SET3 SET4 SET5 ERROR_FLAG	Alpha 1	—	LT101, LT11.1, LT111, LT13.1
#`LEM-TRAN-TYPE` TRAN_TYPE	Alpha 1	—	LT11.1, LT13.1
#`LEM-WORKASSIGNMENT` PK WORKASSIGNMENT	Numeric 4	—	LT11.1, LT13.1
#`LEM-IS-PRIMARY` IS_PRIMARY	Numeric 1	—	—
#`LEM-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	—	—
#`LEM-MESSAGE` MESSAGE	Alpha 60	—	LT101, LT11.1, LT111, LT13.1
#`LEM-LAST-NAME` LAST_NAME	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-FIRST-NAME` FIRST_NAME	Alpha 15 (Lower Case)	—	LT11.1, LT13.1
#`LEM-MIDDLE-INIT` MIDDLE_INIT	Alpha 1	—	LT11.1, LT13.1
#`LEM-MIDDLE-NAME` MIDDLE_NAME	Alpha 15 (Lower Case)	—	LT11.1, LT13.1
#`LEM-NICK-NAME` NICK_NAME	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-ADDR1` ADDR1	Alpha 57 (Lower Case)	—	LT11.1, LT13.1
#`LEM-ADDR2` ADDR2	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-ADDR3` ADDR3	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-ADDR4` ADDR4	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-CITY` CITY	Alpha 18 (Lower Case)	—	LT11.1, LT13.1
#`LEM-STATE` STATE	Alpha 2	—	LT11.1, LT13.1
#`LEM-ZIP` ZIP	Alpha 10	—	LT11.1, LT13.1
#`LEM-EMP-STATUS` EMP_STATUS	Alpha 2	—	LT11.1, LT13.1
#`LEM-FICA-NBR` FICA_NBR	Alpha 20	—	LT101, LT11.1, LT111, LT13.1, LT213
#`LEM-EIC-STATUS` EIC_STATUS	Numeric 1	—	LT11.1, LT13.1
#`LEM-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	—	LT11.1, LT13.1
#`LEM-DEPARTMENT` DEPARTMENT	Alpha 5	—	LT11.1, LT13.1
#`LEM-USER-LEVEL` USER_LEVEL	Alpha 10	—	LT11.1, LT13.1
#`LEM-HM-DIST-CO` HM_DIST_CO	Numeric 4	—	LT11.1, LT13.1
#`LEM-HM-ACCT-UNIT` HM_ACCT_UNIT	Alpha 15	—	LT11.1, LT13.1
#`LEM-HM-ACCOUNT` HM_ACCOUNT	Numeric 6	—	LT11.1, LT13.1
#`LEM-HM-SUB-ACCT` HM_SUB_ACCT	Numeric 4	—	LT11.1, LT13.1
#`LEM-JOB-CODE` JOB_CODE	Alpha 9	—	LT11.1, LT13.1
#`LEM-UNION-CODE` UNION_CODE	Alpha 10	—	LT11.1, LT13.1
#`LEM-SUPERVISOR` SUPERVISOR	Alpha 10	—	LT11.1, LT13.1
#`LEM-DATE-HIRED` DATE_HIRED	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-PAY-FREQUENCY` PAY_FREQUENCY	Numeric 1	—	LT11.1, LT13.1
#`LEM-SHIFT` SHIFT	Numeric 1	—	LT11.1, LT13.1
#`LEM-SALARY-CLASS` SALARY_CLASS	Alpha 1	—	LT11.1, LT13.1
#`LEM-EXEMPT-EMP` EXEMPT_EMP	Alpha 1	—	LT11.1, LT13.1
#`LEM-PAY-RATE` PAY_RATE	Signed 13.4	—	LT11.1, LT13.1
#`LEM-STAND-HOURS` STAND_HOURS	Signed 7.2	—	LT11.1, LT13.1
#`LEM-STAND-AMT` STAND_AMT	Signed 11.3	—	LT11.1, LT13.1
#`LEM-WARN-FLAG` WARN_FLAG	Alpha 1	—	LT11.1, LT13.1
#`LEM-RPT-INS-COST` RPT_INS_COST	Signed 11.2	—	LT11.1, LT13.1
#`LEM-AUTO-TIME-REC` AUTO_TIME_REC	Alpha 1	—	LT11.1, LT13.1
#`LEM-AUTO-DEPOSIT` AUTO_DEPOSIT	Alpha 1	—	LT11.1, LT13.1
#`LEM-ADJ-HIRE-DATE` ADJ_HIRE_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-ANNIVERS-DATE` ANNIVERS_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-TERM-DATE` TERM_DATE	Numeric 8 (yyyymmdd)	—	LT101, LT11.1, LT111, LT13.1
#`LEM-PENSION-PLAN` PENSION_PLAN	Alpha 1	—	LT11.1, LT13.1
#`LEM-PAY-STEP` PAY_STEP	Numeric 2	—	LT11.1, LT13.1
#`LEM-PAY-GRADE` PAY_GRADE	Alpha 3	—	LT11.1, LT13.1
#`LEM-SCHEDULE` SCHEDULE	Alpha 9	—	LT11.1, LT13.1
#`LEM-EBE-AMOUNT` EBE_AMOUNT	Signed 9.2	—	LT11.1, LT13.1
#`LEM-SICK-PAY` SICK_PAY	Signed 11.2	—	LT11.1, LT13.1
#`LEM-OT-PLAN-CODE` OT_PLAN_CODE	Alpha 4	—	LT11.1, LT13.1
#`LEM-DECEASED` DECEASED	Alpha 1	—	LT11.1, LT13.1
#`LEM-BSI-GROUP` BSI_GROUP	Alpha 11	—	LT11.1
#`LEM-WORK-STATE` WORK_STATE	Alpha 2	—	LT11.1, LT13.1
#`LEM-TAX-STATE` TAX_STATE	Alpha 2	—	LT11.1, LT13.1
#`LEM-TAX-PROVINCE` TAX_PROVINCE	Alpha 2	—	LT11.1, LT13.1
#`LEM-WC-STATE` WC_STATE	Alpha 2	—	LT11.1, LT13.1
#`LEM-TAX-COUNTY` TAX_COUNTY	Alpha 10	—	LT11.1, LT13.1
#`LEM-TAX-CITY` TAX_CITY	Alpha 10	—	LT11.1, LT13.1
#`LEM-MOVING-EXP` MOVING_EXP	Signed 11.2	—	LT11.1, LT13.1
#`LEM-PIN` PIN	Alpha 10 (Lower Case)	—	LT11.1, LT13.1
#`LEM-TIPPED` TIPPED	Alpha 1	—	LT11.1, LT13.1
#`LEM-EMAIL-ADDRESS` EMAIL_ADDRESS	Alpha 60 (Lower Case)	—	LT11.1, LT13.1
#`LEM-ACTIVITY` ACTIVITY	Alpha 15	—	LT11.1, LT13.1
#`LEM-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	—	LT11.1, LT13.1
#`LEM-MAX-LIMIT-OVRD` MAX_LIMIT_OVRD	Alpha 1	—	LT11.1, LT13.1
#`LEM-SEC-LVL` SEC_LVL	Numeric 1	—	LT11.1, LT13.1
#`LEM-SEC-LOCATION` SEC_LOCATION	Alpha 10	—	LT11.1, LT13.1
#`LEM-POSITION` POSITION	Alpha 12	—	LT11.1, LT13.1
#`LEM-WORK-SCHED` WORK_SCHED	Alpha 10	—	LT11.1, LT13.1
#`LEM-SUPERVISOR-IND` SUPERVISOR_IND	Alpha 10	—	LT11.1, LT13.1
#`LEM-ANNUAL-HOURS` ANNUAL_HOURS	Signed 8.4	—	LT11.1, LT13.1
#`LEM-WORK-COUNTY` WORK_COUNTY	Alpha 10	—	LT11.1, LT13.1
#`LEM-WORK-CITY` WORK_CITY	Alpha 10	—	LT11.1, LT13.1
#`LEM-WORK-SCHOOL` WORK_SCHOOL	Alpha 10	—	LT11.1, LT13.1
#`LEM-WORK-TRANSPORT` WORK_TRANSPORT	Alpha 10	—	LT11.1, LT13.1
#`LEM-TAX-SCHOOL` TAX_SCHOOL	Alpha 10	—	LT11.1, LT13.1
#`LEM-TAX-TRANSPORT` TAX_TRANSPORT	Alpha 10	—	LT11.1, LT13.1
#`LEM-NEW-HIRE-DATE` NEW_HIRE_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	—	LT11.1, LT13.1
#`LEM-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	—	LT11.1, LT13.1
#`LEM-NAME-PREFIX` NAME_PREFIX	Alpha 4 (Lower Case)	—	LT11.1, LT13.1
#`LEM-NAME-SUFFIX` NAME_SUFFIX	Alpha 4 (Lower Case)	—	LT11.1, LT13.1
#`LEM-WORK-COUNTRY` WORK_COUNTRY	Alpha 2	—	LT11.1, LT13.1
#`LEM-LAST-NAME-PRE` LAST_NAME_PRE	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-EST-REMUN` EST_REMUN	Signed 11.2	—	LT11.1, LT13.1
#`LEM-EST-EXPENSE` EST_EXPENSE	Signed 11.2	—	LT11.1, LT13.1
#`LEM-BUS-NBR-GRP` BUS_NBR_GRP	Alpha 4	—	LT11.1, LT13.1
#`LEM-QC-ENT-NBR-GRP` QC_ENT_NBR_GRP	Alpha 4	—	LT11.1, LT13.1
#`LEM-WC-PROVINCE` WC_PROVINCE	Alpha 2	—	LT11.1, LT13.1
#`LEM-COUNTY` COUNTY	Alpha 25 (Lower Case)	—	LT11.1, LT13.1
#`LEM-RAILROAD-CODE` RAILROAD_CODE	Numeric 1	—	LT11.1, LT13.1
#`LEM-FST-DAY-WORKED` FST_DAY_WORKED	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-LAST-DAY-PAID` LAST_DAY_PAID	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-LAB-DIST-FLAG` LAB_DIST_FLAG	Alpha 1	—	LT11.1, LT13.1
#`LEM-ENCUMBER-FLAG` ENCUMBER_FLAG	Alpha 1	—	LT11.1, LT13.1
#`LEM-EFFORT-FLAG` EFFORT_FLAG	Alpha 1	—	LT11.1, LT13.1
#`LEM-RPT-CURR` RPT_CURR	Alpha 5	—	LT11.1, LT13.1
#`LEM-PRMCERT-ID` PRMCERT_ID	Numeric 9	—	LT11.1, LT13.1
#`LEM-SNDCERT-ID` SNDCERT_ID	Numeric 9	—	LT11.1, LT13.1
#`LEM-FRNG-RATE` FRNG_RATE	Signed 12.6	—	LT11.1, LT13.1
#`LEM-FRNG-ACCT-CAT` FRNG_ACCT_CAT	Alpha 5	—	LT11.1, LT13.1
#`LEM-FRNG-ACCOUNT` FRNG_ACCOUNT	Numeric 6	—	LT11.1, LT13.1
#`LEM-FRNG-SUB-ACCT` FRNG_SUB_ACCT	Numeric 4	—	LT11.1, LT13.1
#`LEM-DEATH-DATE` DEATH_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-TAX-FILTER` TAX_FILTER	Numeric 1	—	LT11.1, LT13.1
#`LEM-REMOTE` REMOTE	Numeric 1	—	LT11.1, LT13.1
#`LEM-PUB-SEC-RETIRE` PUB_SEC_RETIRE	Numeric 4	—	LT11.1, LT13.1
#`LEM-PRMCERT-COMP` PRMCERT_COMP	Numeric 4	—	LT11.1, LT13.1
#`LEM-SNDCERT-COMP` SNDCERT_COMP	Numeric 4	—	LT11.1, LT13.1
#`LEM-SUPP-ADDR1` SUPP_ADDR1	Alpha 57 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SUPP-ADDR2` SUPP_ADDR2	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SUPP-ADDR3` SUPP_ADDR3	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SUPP-ADDR4` SUPP_ADDR4	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SUPP-CITY` SUPP_CITY	Alpha 58 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SUPP-STATE` SUPP_STATE	Alpha 2	—	LT11.1, LT13.1
#`LEM-SUPP-ZIP` SUPP_ZIP	Alpha 10	—	LT11.1, LT13.1
#`LEM-SUPP-CNTRY-CD` SUPP_CNTRY_CD	Alpha 2	—	LT11.1, LT13.1
#`LEM-HM-PHONE-CNTRY` HM_PHONE_CNTRY	Alpha 6	—	LT11.1, LT13.1
#`LEM-HM-PHONE-NBR` HM_PHONE_NBR	Alpha 15	—	LT11.1, LT13.1
#`LEM-WK-PHONE-CNTRY` WK_PHONE_CNTRY	Alpha 6	—	LT11.1, LT13.1
#`LEM-WK-PHONE-NBR` WK_PHONE_NBR	Alpha 15	—	LT11.1, LT13.1
#`LEM-WK-PHONE-EXT` WK_PHONE_EXT	Alpha 5	—	LT11.1, LT13.1
#`LEM-EEO-CLASS` EEO_CLASS	Alpha 4 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SEX` SEX	Alpha 1	—	LT11.1, LT13.1
#`LEM-HANDICAP-ID` HANDICAP_ID	Alpha 1	—	LT11.1, LT13.1
#`LEM-VETERAN` VETERAN	Alpha 4	—	LT11.1, LT13.1
#`LEM-BIRTHDATE` BIRTHDATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-BIRTH-CITY` BIRTH_CITY	Alpha 58 (Lower Case)	—	LT11.1, LT13.1
#`LEM-BIRTH-STATE` BIRTH_STATE	Alpha 2	—	LT11.1, LT13.1
#`LEM-BIRTH-CNTRY-CD` BIRTH_CNTRY_CD	Alpha 2	—	LT11.1, LT13.1
#`LEM-SENIOR-DATE` SENIOR_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-MAIDEN-LST-NM` MAIDEN_LST_NM	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-MAIDEN-FST-NM` MAIDEN_FST_NM	Alpha 15 (Lower Case)	—	LT11.1, LT13.1
#`LEM-MAIDEN-MI` MAIDEN_MI	Alpha 1	—	LT11.1, LT13.1
#`LEM-FORMER-LST-NM` FORMER_LST_NM	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-FORMER-FST-NM` FORMER_FST_NM	Alpha 15 (Lower Case)	—	LT11.1, LT13.1
#`LEM-FORMER-MI` FORMER_MI	Alpha 1	—	LT11.1, LT13.1
#`LEM-LOCAT-CODE` LOCAT_CODE	Alpha 10	—	LT11.1, LT13.1
#`LEM-HIRE-SOURCE` HIRE_SOURCE	Alpha 10	—	LT11.1, LT13.1
#`LEM-SECURITY-CODE` SECURITY_CODE	Alpha 10	—	LT11.1, LT13.1
#`LEM-SECURITY-NBR` SECURITY_NBR	Alpha 10	—	LT11.1, LT13.1
#`LEM-BARGAIN-UNIT` BARGAIN_UNIT	Alpha 10	—	LT11.1, LT13.1
#`LEM-CLOCK-NBR` CLOCK_NBR	Alpha 10	—	LT11.1, LT13.1
#`LEM-MAIL-GROUP` MAIL_GROUP	Alpha 10	—	LT11.1, LT13.1
#`LEM-MB-NBR` MB_NBR	Alpha 10	—	LT11.1, LT13.1
#`LEM-DRAFT-STATUS` DRAFT_STATUS	Alpha 3	—	LT11.1, LT13.1
#`LEM-FINAL-RANK` FINAL_RANK	Alpha 3	—	LT11.1, LT13.1
#`LEM-CUR-STATUS` CUR_STATUS	Alpha 2	—	LT11.1, LT13.1
#`LEM-PARKING-LOT` PARKING_LOT	Alpha 10	—	LT11.1, LT13.1
#`LEM-PARKING-SPACE` PARKING_SPACE	Alpha 10	—	LT11.1, LT13.1
#`LEM-DR-LICENSE` DR_LICENSE	Alpha 20	—	LT11.1, LT13.1
#`LEM-DR-LIC-ST` DR_LIC_ST	Alpha 2	—	LT11.1, LT13.1
#`LEM-EXP-DATE` EXP_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-DR-LIC-CLASS` DR_LIC_CLASS	Alpha 3	—	LT11.1, LT13.1
#`LEM-FNCTN-GROUP` FNCTN_GROUP	Numeric 2	—	LT11.1, LT13.1
#`LEM-EXCLUDE-FLAG` EXCLUDE_FLAG	Alpha 1	—	LT11.1, LT13.1
#`LEM-NBR-HL-DEP` NBR_HL_DEP	Numeric 3	—	LT11.1, LT13.1
#`LEM-NBR-DN-DEP` NBR_DN_DEP	Numeric 3	—	LT11.1, LT13.1
#`LEM-LIFE-STYLE-CR` LIFE_STYLE_CR	Numeric 2	—	LT11.1, LT13.1
#`LEM-HL-COV-PROOF` HL_COV_PROOF	Alpha 1	—	LT11.1, LT13.1
#`LEM-DN-COV-PROOF` DN_COV_PROOF	Alpha 1	—	LT11.1, LT13.1
#`LEM-HL-VERIFY-DT` HL_VERIFY_DT	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-DN-VERIFY-DT` DN_VERIFY_DT	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-SPOUSE-EMP` SPOUSE_EMP	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SP-EMP-ADDR1` SP_EMP_ADDR1	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SP-EMP-ADDR2` SP_EMP_ADDR2	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SP-EMP-ADDR3` SP_EMP_ADDR3	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SP-EMP-ADDR4` SP_EMP_ADDR4	Alpha 30 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SP-EMP-CITY` SP_EMP_CITY	Alpha 58 (Lower Case)	—	LT11.1, LT13.1
#`LEM-SP-EMP-STATE` SP_EMP_STATE	Alpha 2	—	—
#`LEM-SP-EMP-ZIP` SP_EMP_ZIP	Alpha 10	—	LT11.1, LT13.1
#`LEM-SP-EMP-COUNTRY` SP_EMP_COUNTRY	Alpha 2	—	LT11.1, LT13.1
#`LEM-SP-EMP-PH-CNTR` SP_EMP_PH_CNTR	Alpha 6	—	LT11.1, LT13.1
#`LEM-SP-EMP-PH-NBR` SP_EMP_PH_NBR	Alpha 15	—	LT11.1, LT13.1
#`LEM-HIGH-COMP` HIGH_COMP	Alpha 1	—	LT11.1, LT13.1
#`LEM-SMOKER` SMOKER	Alpha 1	—	LT11.1, LT13.1
#`LEM-TRUE-MAR-STAT` TRUE_MAR_STAT	Alpha 1	—	LT11.1, LT13.1
#`LEM-PRIMARY-CARE` PRIMARY_CARE	Alpha 10	—	LT11.1, LT13.1
#`LEM-BEN-SALARY-1` BEN_SALARY_1	Signed 11.2	—	LT11.1, LT13.1
#`LEM-BEN-SALARY-2` BEN_SALARY_2	Signed 11.2	—	LT11.1, LT13.1
#`LEM-BEN-SALARY-3` BEN_SALARY_3	Signed 11.2	—	LT11.1, LT13.1
#`LEM-BEN-SALARY-4` BEN_SALARY_4	Signed 11.2	—	LT11.1, LT13.1
#`LEM-BEN-SALARY-5` BEN_SALARY_5	Signed 11.2	—	LT11.1, LT13.1
#`LEM-BEN-DATE-1` BEN_DATE_1	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-BEN-DATE-2` BEN_DATE_2	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-BEN-DATE-3` BEN_DATE_3	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-BEN-DATE-4` BEN_DATE_4	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-BEN-DATE-5` BEN_DATE_5	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-WORK-ZIP` WORK_ZIP	Alpha 10	—	LT11.1, LT13.1
#`LEM-LANGUAGE-CODE` LANGUAGE_CODE	Alpha 10	—	LT11.1, LT13.1
#`LEM-RELIGION` RELIGION	Alpha 10	—	LT11.1, LT13.1
#`LEM-DISABILITY` DISABILITY	Alpha 10	—	LT11.1, LT13.1
#`LEM-SUPP-PHONE-CNT` SUPP_PHONE_CNT	Alpha 6	—	LT11.1, LT13.1
#`LEM-SUPP-PHONE-NBR` SUPP_PHONE_NBR	Alpha 15	—	LT11.1, LT13.1
#`LEM-CONSENT` CONSENT	Alpha 1	—	LT11.1, LT13.1
#`LEM-ABORIGINAL` ABORIGINAL	Alpha 1	—	LT11.1, LT13.1
#`LEM-VISIBLE-MIN` VISIBLE_MIN	Alpha 1	—	LT11.1, LT13.1
#`LEM-RELATED-EMP` RELATED_EMP	Alpha 1	—	LT11.1, LT13.1
#`LEM-BILINGUAL` BILINGUAL	Alpha 1	—	LT11.1, LT13.1
#`LEM-SUPP-COUNTY` SUPP_COUNTY	Alpha 25 (Lower Case)	—	LT11.1, LT13.1
#`LEM-STOCK-TRADE` STOCK_TRADE	Alpha 1	—	LT11.1, LT13.1
#`LEM-DATE-ASSIGN` DATE_ASSIGN	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-USER-AMOUNT` USER_AMOUNT	Signed 13.4	—	LT11.1, LT13.1
#`LEM-ESTAB-PATIENT` ESTAB_PATIENT	Numeric 1	—	LT11.1, LT13.1
#`LEM-PRIOR-COV-MO` PRIOR_COV_MO	Numeric 2	—	LT11.1, LT13.1
#`LEM-MEDICARE-IND` MEDICARE_IND	Alpha 1	—	LT11.1, LT13.1
#`LEM-POS-LEVEL` POS_LEVEL	Numeric 2	—	LT101, LT11.1, LT111, LT13.1
#`LEM-FTE` FTE	Signed 11.6	—	LT11.1, LT13.1
#`LEM-EFFECT-DATE` SET7 EFFECT_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	—	LT101, LT11.1, LT111, LT13.1
#`LEM-EXP-COMPANY` EXP_COMPANY	Numeric 4	—	LT11.1, LT13.1
#`LEM-EXP-ACCT-UNIT` EXP_ACCT_UNIT	Alpha 15	—	LT11.1, LT13.1
#`LEM-EXP-ACCOUNT` EXP_ACCOUNT	Numeric 6	—	LT11.1, LT13.1
#`LEM-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	—	LT11.1, LT13.1
#`LEM-APPLICANT` SET4 SET5 APPLICANT	Numeric 9	—	LT101, LT11.1, LT111, LT13.1
#`LEM-DATE-APPLIED` DATE_APPLIED	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-CANDIDATE-ID` CANDIDATE_ID	Numeric 10	—	LT11.1, LT13.1
#`LEM-ORG-UNIT` ORG_UNIT	Numeric 6	—	LT11.1, LT13.1
#`LEM-JOBAPPLICATION` JOBAPPLICATION	Numeric 4	—	LT11.1, LT13.1
#`LEM-JOBREQUISITION` JOBREQUISITION	Numeric 9	—	LT11.1, LT13.1
#`LEM-PRIMARY-WA` PRIMARY_WA	Numeric 4	—	LT11.1, LT13.1
#`LEM-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	LT11.1, LT13.1
#`LEM-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	LT11.1, LT13.1
#`LEM-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	LT11.1, LT13.1
#`LEM-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	LT101, LT11.1, LT111, LT13.1
#`LEM-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	LT101, LT11.1, LT111, LT13.1
#`LEM-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LT101, LT11.1, LT111, LT13.1
#`LEM-POS-EFF-DT` POS_EFF_DT	Numeric 8 (yyyymmdd)	—	—
#`LEM-ACT-OBJ-ID` ACT_OBJ_ID	Numeric 12	—	LT101, LT111
#`LEM-ADD-ALLOW-PER` ADD_ALLOW_PER	Signed 7.3	—	LT11.1
#`LEM-ADD-ALLOW-HRS` ADD_ALLOW_HRS	Signed 7.2	—	LT11.1
#`LEM-ADD-ALLOW-AMT` ADD_ALLOW_AMT	Numeric 9	—	LT11.1
#`LEM-LTM-OBJ-ID` PK LTM_OBJ_ID	Numeric 13	—	LT11.1, LT13.1
#`LEM-AUDIT-TRAN-ID` SET6 AUDIT_TRAN_ID	Alpha 40	—	LT11.1, LT13.1
#`LEM-FUTR-RESEND` FUTR_RESEND	Numeric 1	—	LT11.1, LT13.1
#`LEM-RESEND-MATCHED` RESEND_MATCHED	Numeric 1	—	LT101
#`LEM-HAS-DELTA` HAS_DELTA	Numeric 1	—	LT11.1

Indexes (8)

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.

Index	Keys	Flags	Condition	Used in
`LEMSET1`	`COMPANY` `EMPLOYEE` `LTM-DATE-STAMP` `LTM-TIME-STAMP` `LTM-OBJ-ID` `WORKASSIGNMENT` `ACTION-CODE`	Primary		LT101, LT103, LT11.1, LT111, LT13.1, LT13.6, LT28.1
`LEMSET2`	`COMPANY` `EMPLOYEE` `STATUS` `LTM-DATE-STAMP` `LTM-TIME-STAMP` `LTM-OBJ-ID` `ERROR-FLAG` `WORKASSIGNMENT` `ACTION-CODE`	KeyChange		BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`LEMSET3`	`COMPANY` `STATUS` `LTM-DATE-STAMP` `LTM-TIME-STAMP` `LTM-OBJ-ID` `ERROR-FLAG` `EMPLOYEE` `WORKASSIGNMENT` `ACTION-CODE`	KeyChange		LT101, LT111, LT213
`LEMSET4`	`COMPANY` `ACTION-CODE` `STATUS` `EMPLOYEE` `APPLICANT` `LTM-DATE-STAMP` `LTM-TIME-STAMP` `LTM-OBJ-ID` `WORKASSIGNMENT` `ERROR-FLAG`	KeyChange		LT101, LT111
`LEMSET5`	`COMPANY` `EMPLOYEE` `APPLICANT` `STATUS` `LTM-DATE-STAMP` `LTM-TIME-STAMP` `LTM-OBJ-ID` `ERROR-FLAG` `WORKASSIGNMENT` `ACTION-CODE`	KeyChange		LT101, LT111, PA100, PA28.1, PA31.1, PA52.4, PA531
`LEMSET6`	`COMPANY` `EMPLOYEE` `WORKASSIGNMENT` `AUDIT-TRAN-ID` `LTM-DATE-STAMP` `LTM-TIME-STAMP` `LTM-OBJ-ID` `ACTION-CODE`	KeyChange		LT101
`LEMSET7`	`COMPANY` `STATUS` `EMPLOYEE` `EFFECT-DATE` ↓ `LTM-DATE-STAMP` ↓ `LTM-TIME-STAMP` ↓ `LTM-OBJ-ID` `WORKASSIGNMENT` `ACTION-CODE`	KeyChange		LT101
`LEMSET8`	`COMPANY` `EMPLOYEE` `LTM-DATE-STAMP` `LTM-TIME-STAMP` `LTM-OBJ-ID` `WORKASSIGNMENT` `ACTION-CODE`	Subset	Where (HAS-DELTA = 1)	LT111, LT22.1

Programs

Updated by (9)

LT01.1 HRM Receiver Error View
LT101 HRM Receiver Update
LT103 HRM RCVR History Change,Delete
LT11.1 HRM Employee Interface
LT111 HRM Receiver Update
LT13.1 HRM Employee Interface History
LT213 Interface Audit Export
PA52.1 Individual Action
PA52.5 Position and Job Action

Referenced by (71)

BN305 Highly Compensated Employees
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR15.1 User Fields
HR155 Employee Group Update
HR156 Employee Group Company Update
HR170 Human Resource Writer Report Request
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HR55.2 Employee Groups By Employees
HR70.1 Human Resource Writer Inquiry
HRS1.1 Select Control
HRSC.1 Select Control
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LT22.1 HRM Employee Interface
LT22.5 HRM Employee User Field Interface
LT28.1 HRM Ethnicity Interface
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA113 Retroactive History Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA16.1 Company Property
PA20.1 Education
PA21.1 Competencies
PA22.1 Certifications
PA24.1 Relocation
PA27.1 Contracts
PA272 Budget and Assigned Resource Listing
PA28.1 Applicant Ethnicity
PA31.1 Applicant
PA34.1 Applicant Education
PA35.1 Applicant Competencies
PA36.1 Applicant Certification
PA38.1 Applicant Relocation
PA502 Position Conversion
PA513 Position and Job Conversion
PA520 Employee and Applicant Code Conversion
PA53.1 Personnel Action Workflow Override
PA531 Applicant Conversion
PA54.1 Personnel Action History Correction
PA66.3 Employee Action Detail
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
TR21.1 Employee Training History
TR22.1 Session Completion
TR26.1 Employee Training Competency Maintenance
TR500 Training Conversion
ZH156 Employee Group Company Update
ZH510 Update PCP from ZPENDPCP

HREMPRCVR – No description in the Lawson data dictionary

About HREMPRCVR

Fields (247) Copy as SQL

Indexes (8)

Programs

Updated by (9)

Referenced by (71)

Fields (247)