HREMPDIM – The HREMPDIM file contains the information used when building the Employee dimension.
- System
- Compensation D Mart (HC)
- Prefix
HRE- Primary key
EMP-DIMENSION- Fields
- 16
- Updated by
- 2 programs
- Referenced by
- 6 programs
HREMPDIM is the The HREMPDIM file contains the information used when building the Employee dimension. table in Lawson Compensation D Mart (prefix HRE). It is indexed by EMP-DIMENSION (HRESET1). It is updated by HC01.2 and HC10.1 and referenced by HC02.1, HCCE.1, HCDL.1, HCEM.1, HCHE.1 and HCHP.1. The table has 16 fields, 1 index and 0 documented relations.
About HREMPDIM
The HREMPDIM file contains the information used when building the Employee dimension.
Fields (16)
Column = COBOL field name without the HRE- 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 |
|---|---|---|---|
#HRE-EMP-DIMENSION PKEMP_DIMENSION | Alpha 50 (Lower Case) | The Employee Dimension Name field contains the user-defined name for the Employee dimension. This name can contain up to 50 characters of any kind. | HC01.2, HC10.1 |
#HRE-MEMBER-PREFIXMEMBER_PREFIX | Alpha 5 (Lower Case) | The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind. | HC01.2, HC10.1 |
#HRE-ALIAS-OPTIONALIAS_OPTION | Alpha 1 | The Alias Option field contains the alias name option that has been specified for the Employee dimension. Valid values are:
| HC01.2, HC10.1 |
#HRE-COMPANYCOMPANY | Numeric 4 | The Company field contains the company number. | HC01.2, HC10.1 |
#HRE-GROUP-NAMEGROUP_NAME | Alpha 10 | The Group Name field contains the name of the company group. | HC01.2, HC10.1 |
#HRE-PROC-LEVELPROC_LEVEL | Alpha 5 Occurs 5 Times ×5 | The Process Level field contains the process level name. Process level is one reporting level below company. This field can contain up to five process levels. | HC01.2, HC10.1 |
#HRE-EMP-STATUSEMP_STATUS | Alpha 2 Occurs 9 Times ×9 | The Employee Status field contains a valid employee status value. This field can contain up to nine valid employee status values. | HC01.2, HC10.1 |
#HRE-EMP-DATE1EMP_DATE1 | Numeric 8 (yyyymmdd) | The Employment Date1 field contains the first date in the termination date range, if employees with a terminated status are included in the data mart. | HC01.2, HC10.1 |
#HRE-EMP-DATE2EMP_DATE2 | Numeric 8 (yyyymmdd) | The Employment Date2 field contains the final date in the termination date range if employees with a terminated status are included in the data mart. | HC01.2, HC10.1 |
#HRE-ALL-POS-LEVELALL_POS_LEVEL | Alpha 1 | The All Positions and Job Levels field specifies whether all positions and jobs are included for the employee. Valid values are:
| HC01.2, HC10.1 |
#HRE-CHECK-HISTORYCHECK_HISTORY | Alpha 1 | The Check History field specifies whether the Headcount and Turnover data mart should also include historical data. Valid values are:
| HC01.2, HC10.1 |
#HRE-AS-OF-DATEAS_OF_DATE | Numeric 8 (yyyymmdd) | — | HC01.2, HC10.1 |
#HRE-YRS-JOB-CODEYRS_JOB_CODE | Numeric 1 | — | HC01.2, HC10.1 |
#HRE-YRS-GRADEYRS_GRADE | Numeric 1 | — | HC01.2, HC10.1 |
#HRE-YRS-COMPANYYRS_COMPANY | Numeric 1 | — | HC01.2, HC10.1 |
#HRE-HIERARCHYHIERARCHY | Alpha 1 | — | HC01.2 |
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 |
|---|---|---|---|---|
HRESET1 |
| Primary | HC01.1, HC01.2, HC01.3, HC02.1, HCCE.1, HCDL.1, HCEM.1, HCHE.1 +1 more |