HRNAMERCVR – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
LNR
Primary key
COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID
Fields
32
Updated by
5 programs
Referenced by
0 programs

HRNAMERCVR is a Lawson Human Resources table (prefix LNR); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-ID (LNRSET1). It is updated by LT101, LT103, LT111, LT12.1 and LT13.8. The table has 32 fields, 1 index and 0 documented relations.

About HRNAMERCVR

No description in the Lawson data dictionary.

Fields (32)

Column = COBOL field name without the LNR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
LNR-COMPANY PK
COMPANY
Numeric 4LT12.1, LT13.8
LNR-EMPLOYEE PK
EMPLOYEE
Numeric 9LT12.1, LT13.8
LNR-LTM-DATE-STAMP PK
LTM_DATE_STAMP
Numeric 8 (yyyymmdd)LT12.1, LT13.8
LNR-LTM-TIME-STAMP PK
LTM_TIME_STAMP
Numeric 8LT12.1, LT13.8
LNR-STATUS
STATUS
Numeric 1LT101, LT103, LT111, LT12.1, LT13.8
LNR-ACTION-CODE
ACTION_CODE
Alpha 10LT12.1, LT13.8
LNR-LAST-NAME-PRE
LAST_NAME_PRE
Alpha 30 (Lower Case)LT12.1, LT13.8
LNR-LAST-NAME
LAST_NAME
Alpha 30 (Lower Case)LT12.1, LT13.8
LNR-NAME-SUFFIX
NAME_SUFFIX
Alpha 4 (Lower Case)LT12.1, LT13.8
LNR-FIRST-NAME
FIRST_NAME
Alpha 15 (Lower Case)LT12.1, LT13.8
LNR-NICK-NAME
NICK_NAME
Alpha 30 (Lower Case)LT12.1, LT13.8
LNR-MIDDLE-NAME
MIDDLE_NAME
Alpha 15 (Lower Case)LT12.1, LT13.8
LNR-MIDDLE-INIT
MIDDLE_INIT
Alpha 1LT12.1, LT13.8
LNR-NAME-PREFIX
NAME_PREFIX
Alpha 4 (Lower Case)LT12.1, LT13.8
LNR-LAST-PRE
LAST_PRE
Derived
LNR-LAST-SUF
LAST_SUF
Derived
LNR-LAST-PRE-SUF
LAST_PRE_SUF
Derived
LNR-FIRST-MI
FIRST_MI
Derived
LNR-LAST-NAME-EXP
LAST_NAME_EXP
Derived
LNR-FIRST-MI-EXP
FIRST_MI_EXP
Derived
LNR-FULL-NAME
FULL_NAME
Derived
LNR-FULL-NAME-EXP
FULL_NAME_EXP
Derived
LNR-SHORT-NAME
SHORT_NAME
Derived
LNR-SHORT-NAME-EXP
SHORT_NAME_EXP
Derived
LNR-LABEL-NAME-1
LABEL_NAME_1
Derived
LNR-CREATE-USER-ID
CREATE_USER_ID
Alpha 10 (Lower Case)LT12.1, LT13.8
LNR-CREATE-DATE
CREATE_DATE
Numeric 8 (yyyymmdd)LT12.1, LT13.8
LNR-CREATE-TIME
CREATE_TIME
Numeric 6 (hhmmss)LT12.1, LT13.8
LNR-USER-ID
USER_ID
Alpha 10 (Lower Case)LT101, LT111, LT12.1, LT13.8
LNR-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)LT101, LT111, LT12.1, LT13.8
LNR-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)LT101, LT111, LT12.1, LT13.8
LNR-LTM-OBJ-ID PK
LTM_OBJ_ID
Numeric 13LT12.1, LT13.8

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LNRSET1COMPANY, EMPLOYEE, LTM-DATE-STAMP, LTM-TIME-STAMP, LTM-OBJ-IDPrimaryLT101, LT103, LT111, LT12.1, LT13.8

Programs

Updated by (5)