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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#IAS-SECURITY-TYPE PK
SECURITY_TYPE		Alpha 1—
  • 1 Data Mart Security
  • 2 Dimension Security
  • 3 Administrators
IA20.2
#IAS-DIM-OBJ-ID PK
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.—
#IAS-USER-DIM-NAME SET4
USER_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 PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA20.2
#IAS-DATA-MART-USER PK
DATA_MART_USER		Alpha 20 (Lower Case)—IA20.2

Indexes (4)

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
IASSET1
  1. SECURITY-TYPE
  2. DATA-MART-NAME
  3. DIM-OBJ-ID
  4. DATA-MART-USER
Primary, KeyChange—
IASSET2
  1. DATA-MART-NAME
  2. DATA-MART-USER
KeyChange, SubsetWhere SECURITY-TYPE = "1"IA10.1, IA120, IA125, IA150, IA20.1, IA20.2
IASSET3
  1. DIM-OBJ-ID
  2. DATA-MART-USER
KeyChange, SubsetWhere SECURITY-TYPE = "2"IA02.1, IAAP.1
IASSET4
  1. USER-DIM-NAME
KeyChange, SubsetWhere SECURITY-TYPE = "3"—

Programs

Updated by (2)

Referenced by (5)