HRPOSRCVR – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
LPV- Primary key
COMPANY,POSITION,LTM-DATE-STAMP,LTM-TIME-STAMP,LTM-OBJ-ID,ACTION-CODE- Fields
- 60
- Updated by
- 6 programs
- Referenced by
- 2 programs
HRPOSRCVR is a Lawson Human Resources table (prefix LPV); no description in the lawson data dictionary. It is indexed by COMPANY, POSITION, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE (LPVSET1); alternate indexes: LPVSET2, LPVSET3, LPVSET4, LPVSET5 and LPVSET6. It is updated by LT01.1, LT101, LT103, LT11.2, LT111 and LT13.2 and referenced by LT22.2 and LT22.7. The table has 60 fields, 6 indexes and 0 documented relations.
About HRPOSRCVR
No description in the Lawson data dictionary.
Fields (60)
Column = COBOL field name without the LPV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
LPV-COMPANY PKCOMPANY | Numeric 4 | — | LT11.2, LT13.2 |
LPV-POSITION PKPOSITION | Alpha 12 | — | LT11.2, LT13.2 |
LPV-LTM-DATE-STAMP PKLTM_DATE_STAMP | Numeric 8 (yyyymmdd) | — | LT11.2, LT13.2 |
LPV-LTM-TIME-STAMP PKLTM_TIME_STAMP | Numeric 8 | — | LT11.2, LT13.2 |
LPV-ACTION-CODE PKACTION_CODE | Alpha 10 | — | LT11.2, LT13.2 |
LPV-ACTION-REASONACTION_REASON | Alpha 20 | — | LT11.2, LT13.2 |
LPV-STATUSSTATUS | Numeric 1 | — | LT01.1, LT101, LT103, LT11.2, LT111, LT13.2 |
LPV-ERROR-FLAGERROR_FLAG | Alpha 1 | — | LT101, LT11.2, LT111, LT13.2 |
LPV-TRAN-TYPETRAN_TYPE | Alpha 1 | — | LT11.2, LT13.2 |
LPV-MESSAGEMESSAGE | Alpha 60 | — | LT101, LT11.2, LT111, LT13.2 |
LPV-DESCRIPTIONDESCRIPTION | Alpha 60 (Lower Case) | — | LT11.2, LT13.2 |
LPV-POSIT-STATUSPOSIT_STATUS | Numeric 1 | — | LT11.2, LT13.2 |
LPV-EFFECT-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | — | LT11.2, LT13.2 |
LPV-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | — | LT11.2, LT13.2 |
LPV-JOB-CODEJOB_CODE | Alpha 9 | — | LT11.2, LT13.2 |
LPV-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | — | LT11.2, LT13.2 |
LPV-DEPARTMENTDEPARTMENT | Alpha 5 | — | LT11.2, LT13.2 |
LPV-USER-LEVELUSER_LEVEL | Alpha 10 | — | LT11.2, LT13.2 |
LPV-EXP-COMPANYEXP_COMPANY | Numeric 4 | — | LT11.2, LT13.2 |
LPV-EXP-ACCT-UNITEXP_ACCT_UNIT | Alpha 15 | — | LT11.2, LT13.2 |
LPV-EXP-ACCOUNTEXP_ACCOUNT | Numeric 6 | — | LT11.2, LT13.2 |
LPV-EXP-SUB-ACCTEXP_SUB_ACCT | Numeric 4 | — | LT11.2, LT13.2 |
LPV-PAY-RATEPAY_RATE | Signed 13.4 | — | LT11.2, LT13.2 |
LPV-SALARY-CLASSSALARY_CLASS | Alpha 1 | — | LT11.2, LT13.2 |
LPV-PAY-FREQUENCYPAY_FREQUENCY | Numeric 1 | — | LT11.2, LT13.2 |
LPV-SCHEDULESCHEDULE | Alpha 9 | — | LT11.2, LT13.2 |
LPV-PAY-GRADEPAY_GRADE | Alpha 3 | — | LT11.2, LT13.2 |
LPV-PAY-STEPPAY_STEP | Numeric 2 | — | LT11.2, LT13.2 |
LPV-SUPERVISORSUPERVISOR | Alpha 10 | — | LT11.2, LT13.2 |
LPV-SHIFTSHIFT | Numeric 1 | — | LT11.2, LT13.2 |
LPV-UPDATE-FLAGUPDATE_FLAG | Alpha 1 | — | LT11.2, LT13.2 |
LPV-LOCAT-CODELOCAT_CODE | Alpha 10 | — | LT11.2, LT13.2 |
LPV-UNION-CODEUNION_CODE | Alpha 10 | — | LT11.2, LT13.2 |
LPV-BARGAIN-UNITBARGAIN_UNIT | Alpha 10 | — | LT11.2, LT13.2 |
LPV-CHG-REASONCHG_REASON | Alpha 10 | — | LT11.2, LT13.2 |
LPV-ACTIVITYACTIVITY | Alpha 15 | — | LT11.2, LT13.2 |
LPV-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | — | LT11.2, LT13.2 |
LPV-OT-PLAN-CODEOT_PLAN_CODE | Alpha 4 | — | LT11.2, LT13.2 |
LPV-SUPERVISOR-INDSUPERVISOR_IND | Alpha 10 | — | LT11.2, LT13.2 |
LPV-SUPERVISOR-LNKSUPERVISOR_LNK | Alpha 10 | — | LT11.2, LT13.2 |
LPV-WORK-SCHEDWORK_SCHED | Alpha 10 | — | LT11.2, LT13.2 |
LPV-EXEMPT-EMPEXEMPT_EMP | Alpha 1 | — | LT11.2, LT13.2 |
LPV-SEC-LVLSEC_LVL | Numeric 1 | — | LT11.2, LT13.2 |
LPV-SEC-LOCATIONSEC_LOCATION | Alpha 10 | — | LT11.2, LT13.2 |
LPV-OBJ-IDOBJ_ID | Numeric 12 | — | LT11.2, LT13.2 |
LPV-ANNUAL-HOURSANNUAL_HOURS | Signed 8.4 | — | LT11.2, LT13.2 |
LPV-CURRENCY-CODECURRENCY_CODE | Alpha 5 | — | LT11.2, LT13.2 |
LPV-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | — | LT11.2, LT13.2 |
LPV-BASE-PAY-RATEBASE_PAY_RATE | Signed 13.4 | — | LT11.2, LT13.2 |
LPV-ENCUMBER-FLAGENCUMBER_FLAG | Alpha 1 | — | LT11.2, LT13.2 |
LPV-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | LT11.2, LT13.2 |
LPV-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | LT11.2, LT13.2 |
LPV-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | LT11.2, LT13.2 |
LPV-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | LT101, LT11.2, LT111, LT13.2 |
LPV-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | LT101, LT11.2, LT111, LT13.2 |
LPV-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | LT101, LT11.2, LT111, LT13.2 |
LPV-LTM-OBJ-ID PKLTM_OBJ_ID | Numeric 13 | — | LT11.2, LT13.2 |
LPV-AUDIT-TRAN-IDAUDIT_TRAN_ID | Alpha 40 | — | LT11.2, LT13.2 |
LPV-FUTR-RESENDFUTR_RESEND | Numeric 1 | —
| LT11.2, LT13.2 |
LPV-HAS-DELTAHAS_DELTA | Numeric 1 | — | — |
Indexes (6)
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 |
|---|---|---|---|---|
LPVSET1 | COMPANY, POSITION, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE | Primary | LT101, LT103, LT11.2, LT111, LT13.2 | |
LPVSET2 | COMPANY, POSITION, STATUS, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ERROR-FLAG, ACTION-CODE | KeyChange | LT01.1, LT101, LT103, LT11.7, LT111, LT13.7, LT22.7 | |
LPVSET3 | COMPANY, STATUS, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ERROR-FLAG, POSITION, ACTION-CODE | KeyChange | LT101, LT111 | |
LPVSET4 | COMPANY, ACTION-CODE, STATUS, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ERROR-FLAG, POSITION | KeyChange | — | |
LPVSET5 | COMPANY, POSITION, AUDIT-TRAN-ID, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE | KeyChange | — | |
LPVSET6 | COMPANY, POSITION, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE | Subset | Where (HAS-DELTA = 1) | LT22.2 |
Programs
Updated by (6)
- LT01.1 HRM Receiver Error View
- LT101 HRM Receiver Update
- LT103 HRM RCVR History Change,Delete
- LT11.2 HRM Position Interface
- LT111 HRM Receiver Update
- LT13.2 HRM Position Interface History