HRETHRCVR – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LIT
Primary key
COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, ACTION-CODE, TYPE, LTM-OBJ-ID
Fields
18
Updated by
5 programs
Referenced by
0 programs

HRETHRCVR is a Lawson Human Resources table (prefix LIT); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, ACTION-CODE, TYPE, LTM-OBJ-ID (LITSET1). It is updated by LT101, LT103, LT111, LT13.6 and LT28.1. The table has 18 fields, 1 index and 0 documented relations.

About HRETHRCVR

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the LIT- 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
#LIT-COMPANY PK
COMPANY		Numeric 4—LT13.6, LT28.1
#LIT-EMPLOYEE PK
EMPLOYEE		Numeric 9—LT13.6, LT28.1
#LIT-APPLICANT
APPLICANT		Numeric 9—LT101, LT111
#LIT-LTM-DATE-STAMP PK
LTM_DATE_STAMP		Numeric 8 (yyyymmdd)—LT13.6, LT28.1
#LIT-LTM-TIME-STAMP PK
LTM_TIME_STAMP		Numeric 8—LT13.6, LT28.1
#LIT-ACTION-CODE PK
ACTION_CODE		Alpha 10—LT13.6, LT28.1
#LIT-STATUS
STATUS		Numeric 1—
  • 1 Unprocessed
  • 9 Processed
LT101, LT103, LT111, LT13.6, LT28.1
#LIT-ERROR-FLAG
ERROR_FLAG		Alpha 1—LT101, LT111, LT13.6, LT28.1
#LIT-MESSAGE
MESSAGE		Alpha 60—LT101, LT111, LT13.6, LT28.1
#LIT-ETHNICITY
ETHNICITY		Alpha 4 (Lower Case)Occurs 10 TimesLT13.6, LT28.1
#LIT-TYPE PK
TYPE		Alpha 2—
  • AP Applicant
  • EM Employee
LT13.6, LT28.1
#LIT-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—LT13.6, LT28.1
#LIT-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—LT13.6, LT28.1
#LIT-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—LT13.6, LT28.1
#LIT-USER-ID
USER_ID		Alpha 10 (Lower Case)—LT101, LT111, LT13.6, LT28.1
#LIT-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—LT101, LT111, LT13.6, LT28.1
#LIT-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—LT101, LT111, LT13.6, LT28.1
#LIT-LTM-OBJ-ID PK
LTM_OBJ_ID		Numeric 13—LT13.6, LT28.1

Indexes (1)

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
LITSET1
  1. COMPANY
  2. EMPLOYEE
  3. LTM-DATE-STAMP
  4. LTM-TIME-STAMP
  5. ACTION-CODE
  6. TYPE
  7. LTM-OBJ-ID
PrimaryLT101, LT103, LT111, LT13.6, LT28.1

Programs

Updated by (5)