HRIAPERF – No description in the Lawson data dictionary
- System
- Compensation D Mart (HC)
- Prefix
HRF- Primary key
DIMENSION-NAME- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 6 programs
HRIAPERF is a Lawson Compensation D Mart table (prefix HRF); no description in the lawson data dictionary. It is indexed by DIMENSION-NAME (HRFSET1). It is updated by HC03.5 and HC10.1 and referenced by HC01.1, HC02.1, HCCE.1, HCDL.1, HCHP.1 and HCRV.1. The table has 3 fields, 1 index and 0 documented relations.
About HRIAPERF
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the HRF- 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 |
|---|---|---|---|
#HRF-DIMENSION-NAME PKDIMENSION_NAME | Alpha 50 (Lower Case) | The Dimension Name field contains the dimension name that is used by the OLAP database. Valid values are: Year Period Measures Scenario Compton Territory Customer Items | HC03.5, HC10.1 |
#HRF-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. | HC03.5, HC10.1 |
#HRF-ALIAS-OPTALIAS_OPT | Alpha 1 | — | HC03.5, HC10.1 |
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 |
|---|---|---|---|---|
HRFSET1 |
| Primary | HC01.1, HC02.1, HC03.5, HCCE.1, HCDL.1, HCHP.1, HCRV.1 |