IAYEARYR – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IYY
Primary key
USER-DIM-NAME, YEAR
Fields
3
Updated by
2 programs
Referenced by
2 programs

IAYEARYR is a Lawson Analytic Architect table (prefix IYY); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME, YEAR (IYYSET1); alternate indexes: IYYSET2. It is updated by IA85.1 and IA85.2 and referenced by IATS.1 and IAYR.1. The table has 3 fields, 2 indexes and 0 documented relations.

About IAYEARYR

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the IYY- 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
#IYY-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.IA85.1
#IYY-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.IA85.1
#IYY-MEMBER-NAME SET2
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.IA85.1, IA85.2

Indexes (2)

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
IYYSET1
  1. USER-DIM-NAME
  2. YEAR
PrimaryIA85.1, IA85.2, IA85.3, IATS.1, IAYR.1
IYYSET2
  1. USER-DIM-NAME
  2. MEMBER-NAME
KeyChange—

Programs

Updated by (2)

Referenced by (2)