IASECURITY – No description in the Lawson data dictionary
- System
- Analytic Architect (IA)
- Prefix
IAS- Primary key
SECURITY-TYPE,DATA-MART-NAME,DIM-OBJ-ID,DATA-MART-USER- Fields
- 5
- Updated by
- 2 programs
- Referenced by
- 5 programs
IASECURITY is a Lawson Analytic Architect table (prefix IAS); no description in the lawson data dictionary. It is indexed by SECURITY-TYPE, DATA-MART-NAME, DIM-OBJ-ID, DATA-MART-USER (IASSET1); alternate indexes: IASSET2, IASSET3 and IASSET4. It is updated by IA20.2 and IAAP.1 and referenced by IA02.1, IA10.1, IA120, IA125 and IA150. The table has 5 fields, 4 indexes and 0 documented relations.
About IASECURITY
No description in the Lawson data dictionary.
Fields (5)
Column = COBOL field name without the IAS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IAS-SECURITY-TYPE PKSECURITY_TYPE | Alpha 1 | —
| IA20.2 |
IAS-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. | — |
IAS-USER-DIM-NAMEUSER_DIM_NAME | Alpha 50 (Lower Case) | The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization. | — |
IAS-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | IA20.2 |
IAS-DATA-MART-USER PKDATA_MART_USER | Alpha 20 (Lower Case) | — | IA20.2 |
Indexes (4)
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 |
|---|---|---|---|---|
IASSET1 | SECURITY-TYPE, DATA-MART-NAME, DIM-OBJ-ID, DATA-MART-USER | Primary, KeyChange | — | |
IASSET2 | DATA-MART-NAME, DATA-MART-USER | KeyChange, Subset | Where SECURITY-TYPE = "1" | IA10.1, IA120, IA125, IA150, IA20.1, IA20.2 |
IASSET3 | DIM-OBJ-ID, DATA-MART-USER | KeyChange, Subset | Where SECURITY-TYPE = "2" | IA02.1, IAAP.1 |
IASSET4 | USER-DIM-NAME | KeyChange, Subset | Where SECURITY-TYPE = "3" | — |