PROFDIMREL – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
PDR
Primary key
DATA-MART-NAME, DATA-MART-GRP, PROFILE-NAME, USER-DIM-NAME
Fields
4
Updated by
1 program
Referenced by
2 programs

PROFDIMREL is a Lawson Analytic Architect table (prefix PDR); no description in the lawson data dictionary. It is indexed by DATA-MART-NAME, DATA-MART-GRP, PROFILE-NAME, USER-DIM-NAME (PDRSET1). It is updated by IA11.3 and referenced by IA150 and IAPF.1. The table has 4 fields, 1 index and 0 documented relations.

About PROFDIMREL

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the PDR- 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
#PDR-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA11.3
#PDR-DATA-MART-GRP PK
DATA_MART_GRP		Alpha 12—IA11.3
#PDR-PROFILE-NAME PK
PROFILE_NAME		Alpha 12 (Lower Case)The Profile name field contains the name of the profile that is defined in the IA11.1 (Information Transfer Profiles) form. Each profile name represents a run option that is used when the data mart is updated. Run options include the name of the calc script, the outline load and data values load options no load, incremental or complete), and the names of the outline dimensions to include in the build. This user-defined field can contain up to 12 characters.IA11.3
#PDR-USER-DIM-NAME PK
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.IA11.3

Indexes (1)

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
PDRSET1
  1. DATA-MART-NAME
  2. DATA-MART-GRP
  3. PROFILE-NAME
  4. USER-DIM-NAME
Primary, KeyChangeIA11.3, IA150, IAPF.1

Programs

Updated by (1)

Referenced by (2)