HRSUPRCVR – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LSU
Primary key
COMPANY, SUPERVISOR, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE
Fields
31
Updated by
6 programs
Referenced by
1 program

HRSUPRCVR is a Lawson Human Resources table (prefix LSU); no description in the lawson data dictionary. It is indexed by COMPANY, SUPERVISOR, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID, ACTION-CODE (LSUSET1); alternate indexes: LSUSET2, LSUSET3, LSUSET4, LSUSET5 and LSUSET6. It is updated by LT01.1, LT101, LT103, LT11.4, LT111 and LT13.4 and referenced by LT22.4. The table has 31 fields, 6 indexes and 0 documented relations.

About HRSUPRCVR

No description in the Lawson data dictionary.

Fields (31)

Column = COBOL field name without the LSU- 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
#LSU-COMPANY PK
COMPANY		Numeric 4—LT11.4, LT13.4
#LSU-SUPERVISOR PK
SUPERVISOR		Alpha 10—LT101, LT11.4, LT111, LT13.4
#LSU-LTM-DATE-STAMP PK
LTM_DATE_STAMP		Numeric 8 (yyyymmdd)—LT11.4, LT13.4
#LSU-LTM-TIME-STAMP PK
LTM_TIME_STAMP		Numeric 8—LT11.4, LT13.4
#LSU-ACTION-CODE PK
ACTION_CODE		Alpha 10—LT11.4, LT13.4
#LSU-ACTION-REASON
ACTION_REASON		Alpha 20—LT11.4, LT13.4
#LSU-STATUS SET2 SET3 SET4
STATUS		Numeric 1—LT01.1, LT101, LT103, LT11.4, LT111, LT13.4
#LSU-ERROR-FLAG SET2 SET3 SET4
ERROR_FLAG		Alpha 1—LT101, LT11.4, LT111, LT13.4
#LSU-TRAN-TYPE
TRAN_TYPE		Alpha 1—LT11.4, LT13.4
#LSU-MESSAGE
MESSAGE		Alpha 60—LT101, LT11.4, LT111, LT13.4
#LSU-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—LT11.4, LT13.4
#LSU-EMPLOYEE
EMPLOYEE		Numeric 9—LT11.4, LT13.4
#LSU-OBJ-ID
OBJ_ID		Numeric 12—LT11.4, LT13.4
#LSU-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)—LT11.4, LT13.4
#LSU-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1—LT101, LT11.4, LT111, LT13.4
#LSU-SUPER-RPTS-TO
SUPER_RPTS_TO		Alpha 10—LT11.4, LT13.4
#LSU-USER1
USER1		Alpha 10—LT11.4, LT13.4
#LSU-USER2
USER2		Alpha 10—LT11.4, LT13.4
#LSU-USER3
USER3		Alpha 10—LT11.4, LT13.4
#LSU-USER4
USER4		Alpha 10—LT11.4, LT13.4
#LSU-USER5
USER5		Alpha 10—LT11.4, LT13.4
#LSU-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—LT11.4, LT13.4
#LSU-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—LT11.4, LT13.4
#LSU-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—LT11.4, LT13.4
#LSU-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—LT101, LT11.4, LT111, LT13.4
#LSU-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—LT101, LT11.4, LT111, LT13.4
#LSU-USER-ID
USER_ID		Alpha 10 (Lower Case)—LT101, LT11.4, LT111, LT13.4
#LSU-LTM-OBJ-ID PK
LTM_OBJ_ID		Numeric 13—LT11.4, LT13.4
#LSU-AUDIT-TRAN-ID SET5
AUDIT_TRAN_ID		Alpha 40—LT11.4, LT13.4
#LSU-FUTR-RESEND
FUTR_RESEND		Numeric 1—LT11.4, LT13.4
#LSU-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
LSUSET1
  1. COMPANY
  2. SUPERVISOR
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ACTION-CODE
PrimaryLT101, LT103, LT11.4, LT111, LT13.4
LSUSET2
  1. COMPANY
  2. SUPERVISOR
  3. STATUS
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ERROR-FLAG
  8. ACTION-CODE
KeyChangeLT01.1, LT101, LT103, LT111
LSUSET3
  1. COMPANY
  2. STATUS
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ERROR-FLAG
  7. SUPERVISOR
  8. ACTION-CODE
KeyChangeLT101, LT111
LSUSET4
  1. COMPANY
  2. ACTION-CODE
  3. STATUS
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ERROR-FLAG
  8. SUPERVISOR
KeyChange—
LSUSET5
  1. COMPANY
  2. SUPERVISOR
  3. AUDIT-TRAN-ID
  4. LTM-DATE-STAMP
  5. LTM-TIME-STAMP
  6. LTM-OBJ-ID
  7. ACTION-CODE
KeyChange—
LSUSET6
  1. COMPANY
  2. SUPERVISOR
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. LTM-OBJ-ID
  6. ACTION-CODE
SubsetWhere (HAS-DELTA = 1)LT22.4

Programs

Updated by (6)

Referenced by (1)