Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IATIMEPRD


                             IATIMEPRD FILE

REFERENCED BY

IARP.1    IATB.1    IATM.1    IATS.1    POA1.1    HCCE.1
HCDL.1    HCHE.1    HCHP.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
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.


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


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

IPD-MEMBER-NAME        Alpha 50  (Lower Case)                    IA80.1  IA80.5
Element: 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
Element: Quarter Consol                                          IA80.9

IPD-ENDING-WEEK        Numeric 2
Element: Ending Week

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

IPD-ENDING-YEAR        Numeric 4                                 IA80.1  IA80.6
Element: 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                                             IARP.1  IATB.1
                                                                 IATM.1  IATS.1
                                                                 POA1.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

IPDSET5   USER-DIM-NAME                                          HCCE.1  HCDL.1
          ENDING-YEAR                                            HCHE.1  HCHP.1
          ENDING-DAY
          YEAR
          PERIOD-NBR