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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IWK-USER-DIM-NAME PKUSER_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 PKYEAR | Numeric 4 | Contains the fiscal year for the data stored on this record. | IA80.1, IA80.9 |
IWK-WEEK-NBR PKWEEK_NBR | Numeric 2 | — | IA80.1, IA80.9 |
IWK-MEMBER-NAMEMEMBER_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-CONSOLPERIOD_CONSOL | Numeric 3 | — | IA80.1, IA80.8, IA80.9 |
IWK-ENDING-YEARENDING_YEAR | Numeric 4 | — | IA80.1, IA80.8, IA80.9 |
IWK-ENDING-DAYENDING_DAY | Numeric 4 (mmdd) | — | IA80.1, IA80.8, IA80.9 |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IWKSET1 | USER-DIM-NAME, YEAR, WEEK-NBR | Primary | IA80.1, IA80.8, IA80.9, IATB.1, IATM.1 | |
IWKSET2 | USER-DIM-NAME, YEAR, PERIOD-CONSOL, WEEK-NBR | KeyChange | IATM.1 | |
IWKSET3 | USER-DIM-NAME, WEEK-NBR, YEAR | IATM.1 | ||
IWKSET4 | USER-DIM-NAME, YEAR, MEMBER-NAME, WEEK-NBR | KeyChange | IA80.8 |