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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#LPV-COMPANY PK
COMPANY		Numeric 4—LT11.2, LT13.2
#LPV-POSITION PK
POSITION		Alpha 12—LT11.2, LT13.2
#LPV-LTM-DATE-STAMP PK
LTM_DATE_STAMP		Numeric 8 (yyyymmdd)—LT11.2, LT13.2
#LPV-LTM-TIME-STAMP PK
LTM_TIME_STAMP		Numeric 8—LT11.2, LT13.2
#LPV-ACTION-CODE PK
ACTION_CODE		Alpha 10—LT11.2, LT13.2
#LPV-ACTION-REASON
ACTION_REASON		Alpha 20—LT11.2, LT13.2
#LPV-STATUS SET2 SET3 SET4
STATUS		Numeric 1—LT01.1, LT101, LT103, LT11.2, LT111, LT13.2
#LPV-ERROR-FLAG SET2 SET3 SET4
ERROR_FLAG		Alpha 1—LT101, LT11.2, LT111, LT13.2
#LPV-TRAN-TYPE
TRAN_TYPE		Alpha 1—LT11.2, LT13.2
#LPV-MESSAGE
MESSAGE		Alpha 60—LT101, LT11.2, LT111, LT13.2
#LPV-DESCRIPTION
DESCRIPTION		Alpha 60 (Lower Case)—LT11.2, LT13.2
#LPV-POSIT-STATUS
POSIT_STATUS		Numeric 1—LT11.2, LT13.2
#LPV-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)—LT11.2, LT13.2
#LPV-END-DATE
END_DATE		Numeric 8 (yyyymmdd)—LT11.2, LT13.2
#LPV-JOB-CODE
JOB_CODE		Alpha 9—LT11.2, LT13.2
#LPV-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5—LT11.2, LT13.2
#LPV-DEPARTMENT
DEPARTMENT		Alpha 5—LT11.2, LT13.2
#LPV-USER-LEVEL
USER_LEVEL		Alpha 10—LT11.2, LT13.2
#LPV-EXP-COMPANY
EXP_COMPANY		Numeric 4—LT11.2, LT13.2
#LPV-EXP-ACCT-UNIT
EXP_ACCT_UNIT		Alpha 15—LT11.2, LT13.2
#LPV-EXP-ACCOUNT
EXP_ACCOUNT		Numeric 6—LT11.2, LT13.2
#LPV-EXP-SUB-ACCT
EXP_SUB_ACCT		Numeric 4—LT11.2, LT13.2
#LPV-PAY-RATE
PAY_RATE		Signed 13.4—LT11.2, LT13.2
#LPV-SALARY-CLASS
SALARY_CLASS		Alpha 1—LT11.2, LT13.2
#LPV-PAY-FREQUENCY
PAY_FREQUENCY		Numeric 1—LT11.2, LT13.2
#LPV-SCHEDULE
SCHEDULE		Alpha 9—LT11.2, LT13.2
#LPV-PAY-GRADE
PAY_GRADE		Alpha 3—LT11.2, LT13.2
#LPV-PAY-STEP
PAY_STEP		Numeric 2—LT11.2, LT13.2
#LPV-SUPERVISOR
SUPERVISOR		Alpha 10—LT11.2, LT13.2
#LPV-SHIFT
SHIFT		Numeric 1—LT11.2, LT13.2
#LPV-UPDATE-FLAG
UPDATE_FLAG		Alpha 1—LT11.2, LT13.2
#LPV-LOCAT-CODE
LOCAT_CODE		Alpha 10—LT11.2, LT13.2
#LPV-UNION-CODE
UNION_CODE		Alpha 10—LT11.2, LT13.2
#LPV-BARGAIN-UNIT
BARGAIN_UNIT		Alpha 10—LT11.2, LT13.2
#LPV-CHG-REASON
CHG_REASON		Alpha 10—LT11.2, LT13.2
#LPV-ACTIVITY
ACTIVITY		Alpha 15—LT11.2, LT13.2
#LPV-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5—LT11.2, LT13.2
#LPV-OT-PLAN-CODE
OT_PLAN_CODE		Alpha 4—LT11.2, LT13.2
#LPV-SUPERVISOR-IND
SUPERVISOR_IND		Alpha 10—LT11.2, LT13.2
#LPV-SUPERVISOR-LNK
SUPERVISOR_LNK		Alpha 10—LT11.2, LT13.2
#LPV-WORK-SCHED
WORK_SCHED		Alpha 10—LT11.2, LT13.2
#LPV-EXEMPT-EMP
EXEMPT_EMP		Alpha 1—LT11.2, LT13.2
#LPV-SEC-LVL
SEC_LVL		Numeric 1—LT11.2, LT13.2
#LPV-SEC-LOCATION
SEC_LOCATION		Alpha 10—LT11.2, LT13.2
#LPV-OBJ-ID
OBJ_ID		Numeric 12—LT11.2, LT13.2
#LPV-ANNUAL-HOURS
ANNUAL_HOURS		Signed 8.4—LT11.2, LT13.2
#LPV-CURRENCY-CODE
CURRENCY_CODE		Alpha 5—LT11.2, LT13.2
#LPV-BASE-CURRENCY
BASE_CURRENCY		Alpha 5—LT11.2, LT13.2
#LPV-BASE-PAY-RATE
BASE_PAY_RATE		Signed 13.4—LT11.2, LT13.2
#LPV-ENCUMBER-FLAG
ENCUMBER_FLAG		Alpha 1—LT11.2, LT13.2
#LPV-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—LT11.2, LT13.2
#LPV-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—LT11.2, LT13.2
#LPV-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—LT11.2, LT13.2
#LPV-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—LT101, LT11.2, LT111, LT13.2
#LPV-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—LT101, LT11.2, LT111, LT13.2
#LPV-USER-ID
USER_ID		Alpha 10 (Lower Case)—LT101, LT11.2, LT111, LT13.2
#LPV-LTM-OBJ-ID PK
LTM_OBJ_ID		Numeric 13—LT11.2, LT13.2
#LPV-AUDIT-TRAN-ID SET5
AUDIT_TRAN_ID		Alpha 40—LT11.2, LT13.2
#LPV-FUTR-RESEND
FUTR_RESEND		Numeric 1—
  • 0 No Resend
  • 1 Yes Resend
LT11.2, LT13.2
#LPV-HAS-DELTA
HAS_DELTA		Numeric 1——

Indexes (6)

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

IndexKeysFlagsConditionUsed in
LPVSET1
  1. COMPANY
  2. POSITION
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ACTION-CODE
PrimaryLT101, LT103, LT11.2, LT111, LT13.2
LPVSET2
  1. COMPANY
  2. POSITION
  3. STATUS
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ERROR-FLAG
  8. ACTION-CODE
KeyChangeLT01.1, LT101, LT103, LT11.7, LT111, LT13.7, LT22.7
LPVSET3
  1. COMPANY
  2. STATUS
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ERROR-FLAG
  7. POSITION
  8. ACTION-CODE
KeyChangeLT101, LT111
LPVSET4
  1. COMPANY
  2. ACTION-CODE
  3. STATUS
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ERROR-FLAG
  8. POSITION
KeyChange—
LPVSET5
  1. COMPANY
  2. POSITION
  3. AUDIT-TRAN-ID
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ACTION-CODE
KeyChange—
LPVSET6
  1. COMPANY
  2. POSITION
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ACTION-CODE
SubsetWhere (HAS-DELTA = 1)LT22.2

Programs

Updated by (6)

Referenced by (2)