MBRAUDIT – Member Audit
- System
- Analytic Architect (IA)
- Prefix
MBA- Primary key
DATA-MART-NAME,DIM-OBJ-ID- Fields
- 5
- Updated by
- 3 programs
- Referenced by
- 0 programs
MBRAUDIT is the Member Audit table in Lawson Analytic Architect (prefix MBA). It is indexed by DATA-MART-NAME, DIM-OBJ-ID (MBASET1). It is updated by IA120, IA150 and IAMB.1. The table has 5 fields, 1 index and 0 documented relations.
About MBRAUDIT
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the MBA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MBA-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | IA120, IA150 |
MBA-DIM-OBJ-ID PKDIM_OBJ_ID | Numeric 12 | The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records. | IA120, IA150 |
MBA-AUDIT-FILEAUDIT_FILE | Alpha 100 (Lower Case) | The Audit File field contains the name of the audit file containing all member names that are loaded to the data mart. These member names are also added to the Analytic Architect system and are used by the performance indicator mapping feature. | IA120 |
MBA-ATTR-FILEATTR_FILE | Alpha 100 (Lower Case) | — | IA120 |
MBA-XML-FILEXML_FILE | Alpha 100 (Lower Case) | — | IA150 |
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 |
|---|---|---|---|---|
MBASET1 | DATA-MART-NAME, DIM-OBJ-ID | Primary, KeyChange | IA120, IA150, IAMB.1 |