IATIMEWEEK – No description in the Lawson data dictionary

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

IATIMEWEEK is a Lawson Analytic Architect table (prefix IWK); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME, YEAR, WEEK-NBR (IWKSET1); alternate indexes: IWKSET2, IWKSET3 and IWKSET4. It is updated by IA80.1, IA80.8 and IA80.9 and referenced by IATB.1 and IATM.1. The table has 7 fields, 4 indexes and 0 documented relations.

About IATIMEWEEK

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the IWK- 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
#IWK-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.IA80.1, IA80.9
#IWK-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.IA80.1, IA80.9
#IWK-WEEK-NBR PK
WEEK_NBR		Numeric 2—IA80.1, IA80.9
#IWK-MEMBER-NAME SET4
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.IA80.1, IA80.9
#IWK-PERIOD-CONSOL SET2
PERIOD_CONSOL		Numeric 3—IA80.1, IA80.8, IA80.9
#IWK-ENDING-YEAR
ENDING_YEAR		Numeric 4—IA80.1, IA80.8, IA80.9
#IWK-ENDING-DAY
ENDING_DAY		Numeric 4 (mmdd)—IA80.1, IA80.8, IA80.9

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
IWKSET1
  1. USER-DIM-NAME
  2. YEAR
  3. WEEK-NBR
PrimaryIA80.1, IA80.8, IA80.9, IATB.1, IATM.1
IWKSET2
  1. USER-DIM-NAME
  2. YEAR
  3. PERIOD-CONSOL
  4. WEEK-NBR
KeyChangeIATM.1
IWKSET3
  1. USER-DIM-NAME
  2. WEEK-NBR
  3. YEAR
IATM.1
IWKSET4
  1. USER-DIM-NAME
  2. YEAR
  3. MEMBER-NAME
  4. WEEK-NBR
KeyChangeIA80.8

Programs

Updated by (3)

Referenced by (2)