MBRSHARES – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
MBS
Primary key
MBR-OBJ-ID, PARENT-OBJ-ID
Fields
6
Updated by
4 programs
Referenced by
0 programs

MBRSHARES is a Lawson Analytic Architect table (prefix MBS); no description in the lawson data dictionary. It is indexed by MBR-OBJ-ID, PARENT-OBJ-ID (MBSSET1); alternate indexes: MBSSET2. It is updated by IA120, IA15.1, IA300 and IAMB.1. The table has 6 fields, 2 indexes and 0 documented relations.

About MBRSHARES

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the MBS- 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 / columnTypeDescription & valuesUpdated by
#MBS-MBR-OBJ-ID PK
MBR_OBJ_ID		Numeric 12The Member Object Identifier field contains a unique numeric identifier assigned to a member, which associates this record to the appropriate MEMBER file record.IAMB.1
#MBS-PARENT-OBJ-ID PK
PARENT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.IAMB.1
#MBS-LAST-UPD-DATE SET2
LAST_UPD_DATE		Numeric 8 (yyyymmdd)The Last Update Date field contains the date the member was last updated.IAMB.1
#MBS-LAST-UPD-TIME SET2
LAST_UPD_TIME		Numeric 6 (hhmmss)The Last Update Time field contains the time the member was last updated.IAMB.1
#MBS-DATA-MART-NAME
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IAMB.1
#MBS-DIM-OBJ-ID SET2
DIM_OBJ_ID		Numeric 12The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.IAMB.1

Indexes (2)

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.

IndexKeysFlagsConditionUsed in
MBSSET1
  1. MBR-OBJ-ID
  2. PARENT-OBJ-ID
Primary, KeyChangeIA120, IA15.1, IA300, IAMB.1
MBSSET2
  1. DIM-OBJ-ID
  2. LAST-UPD-DATE
  3. LAST-UPD-TIME
  4. MBR-OBJ-ID
  5. PARENT-OBJ-ID
KeyChangeIA120

Programs

Updated by (4)