IAGRPDTL – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
GDL
Primary key
DATA-MART-GRP, DATA-MART-NAME
Fields
3
Updated by
2 programs
Referenced by
1 program

IAGRPDTL is a Lawson Analytic Architect table (prefix GDL); no description in the lawson data dictionary. It is indexed by DATA-MART-GRP, DATA-MART-NAME (GDLSET1); alternate indexes: GDLSET2 and GDLSET3. It is updated by IA03.1 and IA03.2 and referenced by IA150. The table has 3 fields, 3 indexes and 0 documented relations.

About IAGRPDTL

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the GDL- 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
#GDL-DATA-MART-GRP PK
DATA_MART_GRP		Alpha 12—IA03.1
#GDL-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA03.1
#GDL-SEQ-NBR SET2
SEQ_NBR		Numeric 4An automatically assigned sequence number.IA03.1

Indexes (3)

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
GDLSET1
  1. DATA-MART-GRP
  2. DATA-MART-NAME
PrimaryIA03.1, IA150
GDLSET2
  1. DATA-MART-GRP
  2. SEQ-NBR
  3. DATA-MART-NAME
IA03.1
GDLSET3
  1. DATA-MART-NAME
  2. DATA-MART-GRP
IA03.1, IA03.2

Programs

Updated by (2)

Referenced by (1)