EMPALTNAME – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
EAN- Primary key
COMPANY,EMPLOYEE- Fields
- 26
- Updated by
- 6 programs
- Referenced by
- 0 programs
EMPALTNAME is a Lawson Human Resources table (prefix EAN); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE (EANSET1). It is related 1:1 to EMPLOYEE. It is updated by HR11.1, HR40.1, HR40.2, LT101, LT111 and PA115. The table has 26 fields, 1 index and 1 documented relation.
About EMPALTNAME
No description in the Lawson data dictionary.
Fields (26)
Column = COBOL field name without the EAN- 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 |
|---|---|---|---|
#EAN-COMPANY PKCOMPANY | Numeric 4 | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-EMPLOYEE PKEMPLOYEE | Numeric 9 | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-LAST-NAMELAST_NAME | Alpha 30 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-FIRST-NAMEFIRST_NAME | Alpha 15 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-MIDDLE-INITMIDDLE_INIT | Alpha 1 | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-MIDDLE-NAMEMIDDLE_NAME | Alpha 15 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-NICK-NAMENICK_NAME | Alpha 30 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-NAME-PREFIXNAME_PREFIX | Alpha 4 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-NAME-SUFFIXNAME_SUFFIX | Alpha 4 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-LAST-NAME-PRELAST_NAME_PRE | Alpha 30 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-LAST-PRELAST_PRE | Derived | — | — |
#EAN-LAST-SUFLAST_SUF | Derived | — | — |
#EAN-LAST-PRE-SUFLAST_PRE_SUF | Derived | — | — |
#EAN-FIRST-MIFIRST_MI | Derived | — | — |
#EAN-LAST-NAME-EXPLAST_NAME_EXP | Derived | — | — |
#EAN-FIRST-MI-EXPFIRST_MI_EXP | Derived | — | — |
#EAN-FULL-NAMEFULL_NAME | Derived | — | — |
#EAN-SHORT-NAMESHORT_NAME | Derived | — | — |
#EAN-LABEL-NAME-1LABEL_NAME_1 | Derived | — | — |
#EAN-UPDATED-BY-LTMUPDATED_BY_LTM | Alpha 1 | — | — |
#EAN-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-CREATION-DATECREATION_DATE | Numeric 8 (yyyymmdd) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | HR40.1, HR40.2, LT101, LT111 |
#EAN-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | HR40.1, HR40.2, LT101, LT111 |
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 |
|---|---|---|---|---|
EANSET1 |
| Primary | HR11.1, HR40.1, HR40.2, LT101, LT111, PA115 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Employee | EMPLOYEE | Required |
|