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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LITSET1COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, ACTION-CODE, TYPE, LTM-OBJ-IDPrimaryLT101, LT103, LT111, LT13.6, LT28.1

Programs

Updated by (5)