Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            IATIMEWEEK FILE

REFERENCED BY

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
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
Last Closed Year     Contains the fiscal year for the data
                     stored on this record.

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

IWK-MEMBER-NAME      Alpha 50  (Lower Case)                      IA80.1  IA80.9
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
Period Consol                                                    IA80.9

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

IWK-ENDING-DAY       Numeric 4  (mmdd)                           IA80.1  IA80.8
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  IATM.1
          WEEK-NBR

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