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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#LNR-COMPANY PKCOMPANY | Numeric 4 | — | LT12.1, LT13.8 |
#LNR-EMPLOYEE PKEMPLOYEE | Numeric 9 | — | LT12.1, LT13.8 |
#LNR-LTM-DATE-STAMP PKLTM_DATE_STAMP | Numeric 8 (yyyymmdd) | — | LT12.1, LT13.8 |
#LNR-LTM-TIME-STAMP PKLTM_TIME_STAMP | Numeric 8 | — | LT12.1, LT13.8 |
#LNR-STATUSSTATUS | Numeric 1 | — | LT101, LT103, LT111, LT12.1, LT13.8 |
#LNR-ACTION-CODEACTION_CODE | Alpha 10 | — | LT12.1, LT13.8 |
#LNR-LAST-NAME-PRELAST_NAME_PRE | Alpha 30 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-LAST-NAMELAST_NAME | Alpha 30 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-NAME-SUFFIXNAME_SUFFIX | Alpha 4 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-FIRST-NAMEFIRST_NAME | Alpha 15 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-NICK-NAMENICK_NAME | Alpha 30 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-MIDDLE-NAMEMIDDLE_NAME | Alpha 15 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-MIDDLE-INITMIDDLE_INIT | Alpha 1 | — | LT12.1, LT13.8 |
#LNR-NAME-PREFIXNAME_PREFIX | Alpha 4 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-LAST-PRELAST_PRE | Derived | — | — |
#LNR-LAST-SUFLAST_SUF | Derived | — | — |
#LNR-LAST-PRE-SUFLAST_PRE_SUF | Derived | — | — |
#LNR-FIRST-MIFIRST_MI | Derived | — | — |
#LNR-LAST-NAME-EXPLAST_NAME_EXP | Derived | — | — |
#LNR-FIRST-MI-EXPFIRST_MI_EXP | Derived | — | — |
#LNR-FULL-NAMEFULL_NAME | Derived | — | — |
#LNR-FULL-NAME-EXPFULL_NAME_EXP | Derived | — | — |
#LNR-SHORT-NAMESHORT_NAME | Derived | — | — |
#LNR-SHORT-NAME-EXPSHORT_NAME_EXP | Derived | — | — |
#LNR-LABEL-NAME-1LABEL_NAME_1 | Derived | — | — |
#LNR-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | LT12.1, LT13.8 |
#LNR-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | LT12.1, LT13.8 |
#LNR-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | LT12.1, LT13.8 |
#LNR-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | LT101, LT111, LT12.1, LT13.8 |
#LNR-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | LT101, LT111, LT12.1, LT13.8 |
#LNR-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | LT101, LT111, LT12.1, LT13.8 |
#LNR-LTM-OBJ-ID PKLTM_OBJ_ID | Numeric 13 | — | LT12.1, LT13.8 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
LNRSET1 |
| Primary | LT101, LT103, LT111, LT12.1, LT13.8 |