IAYEAR – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IAY
Primary key
USER-DIM-NAME
Fields
5
Updated by
1 program
Referenced by
3 programs

IAYEAR is a Lawson Analytic Architect table (prefix IAY); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME (IAYSET1). It is updated by IA85.1 and referenced by IART.1, IATS.1 and IAYR.1. The table has 5 fields, 1 index and 0 documented relations.

About IAYEAR

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the IAY- 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
#IAY-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
#IAY-MBR-PREFIX
MBR_PREFIX		Alpha 5 (Lower Case)This field allows the budget administrator to prefix the budget dimesnion member names with a value for the transformation to the OLAP Data Mart.—
#IAY-BEGINNING-YEAR
BEGINNING_YEAR		Numeric 4—IA85.1
#IAY-ENDING-YEAR
ENDING_YEAR		Numeric 4—IA85.1
#IAY-PRIOR-YR-MBR
PRIOR_YR_MBR		Alpha 50 (Lower Case)—IA85.1

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
IAYSET1
  1. USER-DIM-NAME
Primary, KeyChangeIA85.1, IA85.2, IA85.3, IART.1, IATS.1, IAYR.1

Programs

Updated by (1)

Referenced by (3)