HRIAMBR – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
HIM- Primary key
DATA-MART-NAME,DIM-TYPE,MEMBER-TYPE,SEQ-NBR- Fields
- 17
- Updated by
- 1 program
- Referenced by
- 0 programs
HRIAMBR is a Lawson Human Resources table (prefix HIM); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME, DIM-TYPE, MEMBER-TYPE, SEQ-NBR (HIMSET1). It is related 1:1 to HRIADIM, OLAPDBM, PAYCLASS and PAYSUMGRP and 1:M to PSGRELATE. It is updated by HC10.1. The table has 17 fields, 1 index and 5 documented relations.
About HRIAMBR
No description in the Lawson data dictionary.
Fields (17)
Column = COBOL field name without the HIM- 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 |
|---|---|---|---|
#HIM-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | — |
#HIM-DIM-TYPE PKDIM_TYPE | Numeric 3 | — | — |
#HIM-MEMBER-TYPE PKMEMBER_TYPE | Numeric 3 | — | — |
#HIM-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | — |
#HIM-MBR-USEMBR_USE | Alpha 1 | — | — |
#HIM-MBR-NAMEMBR_NAME | Alpha 30 (Lower Case) | The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind. | — |
#HIM-MBR-ALIAS-NAMEMBR_ALIAS_NAME | Alpha 30 (Lower Case) | The Actuals Member field contains the user-defined name for the Actuals member of the Scenarios dimension. This name can contain up to 30 characters of any kind. | — |
#HIM-TYPETYPE | Alpha 2 | This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code. | — |
#HIM-PAY-CLASSPAY_CLASS | Alpha 3 | — | — |
#HIM-PAY-SUM-GRPPAY_SUM_GRP | Alpha 3 | — | — |
#HIM-DATE-1DATE_1 | Numeric 8 (yyyymmdd) | — | — |
#HIM-DATE-2DATE_2 | Numeric 8 (yyyymmdd) | — | — |
#HIM-FACTOR-1FACTOR_1 | Signed 7.2 | — | — |
#HIM-SELECTIONSELECTION | Alpha 100 | — | — |
#HIM-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | This field contains the server date (month, date, and year) of the last change to this record. | — |
#HIM-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | — |
#HIM-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | — |
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 |
|---|---|---|---|---|
HIMSET1 |
| Primary | HC10.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Dimension | HRIADIM | Required |
| |||||||
| Olap Db | OLAPDBM | Required |
| |||||||
| Pay Class | PAYCLASS | Required | When HIM-PAY-CLASS != Spaces |
| ||||||
| Pay Sum Grp | PAYSUMGRP | Required | When HIM-PAY-SUM-GRP != Spaces |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pay Classes | PSGRELATE | Valid When HIM-PAY-SUM-GRP != Spaces |
|
Programs
Updated by (1)
- HC10.1 Compensation Data Mart Upgrade