Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IATIMEWEEK


                            IATIMEWEEK FILE

REFERENCED BY

IATB.1    IATM.1

UPDATED BY

IA80.1    IA80.8    IA80.9

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IWK-USER-DIM-NAME      Alpha 50  (Lower Case)                    IA80.1  IA80.9
Element: User Dim Name 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.


IWK-YEAR               Numeric 4                                 IA80.1  IA80.9
Element: Year          Contains the fiscal year for the data
                       stored on this record.


IWK-WEEK-NBR           Numeric 2                                 IA80.1  IA80.9
Element: Week Nbr

IWK-MEMBER-NAME        Alpha 50  (Lower Case)                    IA80.1  IA80.9
Element: Member Name   This is an override member name for
                       Data Mart dimensions with no association
                       to a Budget dimension.

IWK-PERIOD-CONSOL      Numeric 3                                 IA80.1  IA80.8
Element: Period Consol                                           IA80.9

IWK-ENDING-YEAR        Numeric 4                                 IA80.1  IA80.8
Element: Ending Year                                             IA80.9

IWK-ENDING-DAY         Numeric 4  (mmdd)                         IA80.1  IA80.8
Element: Ending Day                                              IA80.9

                         IATIMEWEEK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IWKSET1   USER-DIM-NAME                                          IA80.1  IA80.8
          YEAR                                                   IA80.9  IATB.1
          WEEK-NBR                                               IATM.1

IWKSET2   USER-DIM-NAME KeyChange                                IATM.1
          YEAR
          PERIOD-CONSOL
          WEEK-NBR

IWKSET3   USER-DIM-NAME                                          IATM.1
          WEEK-NBR
          YEAR

IWKSET4   USER-DIM-NAME KeyChange                                IA80.8
          YEAR
          MEMBER-NAME
          WEEK-NBR