HCDIMEMP – No description in the Lawson data dictionary
- System
- Compensation D Mart (HC)
- Prefix
HDE- Primary key
EMP-DIMENSION,EMPLOYEE- Fields
- 2
- Updated by
- 1 program
- Referenced by
- 1 program
HCDIMEMP is a Lawson Compensation D Mart table (prefix HDE); no description in the lawson data dictionary. It is indexed by EMP-DIMENSION, EMPLOYEE (HDESET1). It is updated by HCEM.1 and referenced by HCHP.1. The table has 2 fields, 1 index and 0 documented relations.
About HCDIMEMP
No description in the Lawson data dictionary.
Fields (2)
Column = COBOL field name without the HDE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
HDE-EMP-DIMENSION PKEMP_DIMENSION | Alpha 50 (Lower Case) | The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization. | HCEM.1 |
HDE-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. | HCEM.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
HDESET1 | EMP-DIMENSION, EMPLOYEE | Primary | HCEM.1, HCHP.1 |
Programs
Updated by (1)
- HCEM.1 Olap Dimension Retrieval Format
Referenced by (1)
- HCHP.1 Olap Data Load