Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             IATIMEPRD FILE

REFERENCED BY

IATM.1    IATS.1

UPDATED BY

IA80.1    IA80.5    IA80.6    IA80.9

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IPD-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.


IPD-YEAR             Numeric 4                                   IA80.1  IA80.9
Last Closed Year     Contains the fiscal year for the data
                     stored on this record.

IPD-PERIOD-NBR       Numeric 3                                   IA80.1  IA80.9
Period Nbr

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

IPD-QUARTER-CONSOL   Numeric 1                                   IA80.1  IA80.5
Quarter Consol                                                   IA80.9

IPD-ENDING-WEEK      Numeric 2
Ending Week

IPD-ENDING-DAY       Numeric 4  (mmdd)                           IA80.1  IA80.6
Ending Day                                                       IA80.9

IPD-ENDING-YEAR      Numeric 4                                   IA80.1  IA80.6
Ending Year                                                      IA80.9

                         IATIMEPRD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IPDSET1   USER-DIM-NAME KeyChange                                IA80.1  IA80.5
          YEAR                                                   IA80.6  IA80.9
          PERIOD-NBR                                             IATM.1  IATS.1

IPDSET2   USER-DIM-NAME KeyChange                                IATM.1
          YEAR
          QUARTER-CONSOL
          PERIOD-NBR

IPDSET3   USER-DIM-NAME KeyChange                                IA80.5  IATM.1
          PERIOD-NBR
          YEAR

IPDSET4   USER-DIM-NAME KeyChange                                IA80.5
          YEAR
          MEMBER-NAME
          PERIOD-NBR