HDTDIM – The HDTDIM data file contains the data mart, dimension, and Years of Service member names for the Compensation and…
- System
- Compensation D Mart (HC)
- Prefix
HCA- Primary key
DATA-MART-NAME- Fields
- 17
- Updated by
- 2 programs
- Referenced by
- 2 programs
HDTDIM is the The HDTDIM data file contains the data mart, dimension, and Years of Service member names for the Compensation and… table in Lawson Compensation D Mart (prefix HCA). It is indexed by DATA-MART-NAME (HCASET1). It is updated by HC01.1 and HC10.1 and referenced by HCCE.1 and HCDL.1. The table has 17 fields, 1 index and 0 documented relations.
About HDTDIM
The HDTDIM data file contains the data mart, dimension, and Years of Service member names for the Compensation and Headcount and Turnover data marts.
Fields (17)
Column = COBOL field name without the HCA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
HCA-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | HC01.1, HC10.1 |
HCA-EMP-DIMENSIONEMP_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.1, HC10.1 |
HCA-MEAS-DIMENSIONMEAS_DIMENSION | Alpha 50 (Lower Case) | The Measures Dimension Name field contains the user-defined name for the Measures dimension. This name can contain up to 50 characters of any kind. | HC01.1, HC10.1 |
HCA-ORG-DIMENSIONORG_DIMENSION | Alpha 50 (Lower Case) | The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 50 characters of any kind. | HC01.1, HC10.1 |
HCA-GL-DIMENSIONGL_DIMENSION | Alpha 50 (Lower Case) | — | HC01.1, HC10.1 |
HCA-TIME-DIMENSIONTIME_DIMENSION | Alpha 50 (Lower Case) | The Time Dimension Name field contains the user-defined name of the Time dimension. This name can contain up to 50 characters of any kind. | HC01.1, HC10.1 |
HCA-POS-DIMENSIONPOS_DIMENSION | Alpha 50 (Lower Case) | The Position Dimension Name field contains the user-defined name for the Position dimension. This name can contain up to 50 characters of any kind. | HC01.1, HC10.1 |
HCA-JOB-DIMENSIONJOB_DIMENSION | Alpha 50 (Lower Case) | The Job Dimension Name field contains the user-defined name for the Job dimension. This name can contain up to 50 characters of any kind. | HC01.1, HC10.1 |
HCA-SUP-DIMENSIONSUP_DIMENSION | Alpha 50 (Lower Case) | The Supervisor Dimension Name field contains the user-defined name for the Supervisor dimension. This name can contain up to 50 characters of any kind. | HC01.1, HC10.1 |
HCA-SCH-DIMENSIONSCH_DIMENSION | Alpha 50 (Lower Case) | The Schedule Dimension Name field contains the user-defined name of the Schedule dimension. The name can contain up to 50 characters of any kind. | HC01.1, HC10.1 |
HCA-YRS-DIMENSIONYRS_DIMENSION | Alpha 50 (Lower Case) | — | HC01.1, HC10.1 |
HCA-AGE-DIMENSIONAGE_DIMENSION | Alpha 50 (Lower Case) | — | HC01.1, HC10.1 |
HCA-PRF-DIMENSIONPRF_DIMENSION | Alpha 50 (Lower Case) | — | HC01.1, HC10.1 |
HCA-MAINT-DATEMAINT_DATE | Numeric 8 (yyyymmdd) | The date last changed. | HC01.1, HC10.1 |
HCA-MAINT-TIMEMAINT_TIME | Numeric 6 (hhmmss) | — | HC01.1, HC10.1 |
HCA-TIME-INDICATORTIME_INDICATOR | Alpha 1 | — | HC01.1, HC10.1 |
HCA-FIXED-DATEFIXED_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | HC01.1, HC10.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 |
|---|---|---|---|---|
HCASET1 | DATA-MART-NAME | Primary | HC01.1, HCCE.1, HCDL.1 |