Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IATIME


                              IATIME FILE

REFERENCED BY

CBDM.1    CBOP.1    HCCE.1    HCDL.1    HCHE.1    HCHP.1
IARP.1    IART.1    IATB.1    IATM.1    IATS.1

UPDATED BY

IA80.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TIM-USER-DIM-NAME      Alpha 50  (Lower Case)                    IA80.1
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.


TIM-TIME-DEPTH         Alpha 1
Element: Time Depth    Q = Quarters
                       P = Periods
                       D = Days

TIM-YEARS-INCLUDED     Alpha 1                                   IA80.1
Element: Years IncludedY = Yes
                       N = No

TIM-QTRS-INCLUDED      Alpha 1                                   IA80.1
Element: Qtrs Included Y = Yes
                       N = No

TIM-PERS-INCLUDED      Alpha 1                                   IA80.1
Element: Pers Included Y = Yes
                       N = No

TIM-WEEKS-INCLUDED     Alpha 1                                   IA80.1
Element: Weeks IncludedY = Yes
                       N = No

TIM-DAYS-INCLUDED      Alpha 1                                   IA80.1
Element: Days Included Y = Yes
                       N = No

TIM-YR-IDENTIFIER      Alpha 1                                   IA80.1
Element: Yr Identifier

TIM-YR-SEPARATOR       Alpha 1  (Lower Case)                     IA80.1
Element: Yr Separator

TIM-BEGINNING-YEAR     Numeric 4                                 IA80.1
Element: Beginning Year

TIM-ENDING-YEAR        Numeric 4                                 IA80.1
Element: Ending Year

TIM-UNIQUE-MEMBERS     Alpha 1                                   IA80.1
Element: Unique MembersY = Yes
                       N = No

TIM-PRIOR-YR-MBR       Alpha 50  (Lower Case)                    IA80.1
Element: Prior Yr Mbr

TIM-DAY-NAMING-OPT     Alpha 1
Element: Day Naming Opt

TIM-NBR-OF-PERIODS     Numeric 3                                 IA80.1
Element: Nbr Of Periods

TIM-BEG-MONTH-DAY      Numeric 4  (mmdd)
Element: Beg Month Day

TIM-END-MONTH-DAY      Numeric 4  (mmdd)
Element: End Month Day

TIM-BEGIN-BAL-MBR      Alpha 50  (Lower Case)                    IA80.1
Element: Begin Bal Mbr

TIM-BB-DEPTH           Alpha 1
Element: Bb Depth      A = Annual
                       Q = Quarter
                       P = Period
                       W = Week
                       D = Day

TIM-QUARTER-NAMES      Alpha 50  (Lower Case)                    IA80.1
Element: Quarter Names Occurs 4 Times

TIM-LOCK-CHANGES       Alpha 1
Element: Lock Changes

TIM-STARTING-WKDAY     Numeric 1                                 IA80.1
Element: Starting Wkday

TIM-ADJUST-PERIOD      Alpha 1
Element: Adjust Period The Adjustment Period field determines
                       whether or not the last period is used
                       as an adjustment period. If Y is
                       selected, the adjustment period is not
                       rolled up into any Quarter member.
                       Instead, the adjustment period is rolled
                       up into the Period member.

                       Valid values are:
                       Y = Yes
                       N = No; Default value.


TIM-DAY-OF-WK-ATT      Alpha 1                                   IA80.1
Element: Day Of Wk Att

TIM-WEEKDAY-MBR        Alpha 50  (Lower Case)                    IA80.1
Element: Weekday Mbr

                         IATIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TIMSET1   USER-DIM-NAME KeyChange                                CBDM.1  CBOP.1
                                                                 HCCE.1  HCDL.1
                                                                 HCHE.1  HCHP.1
                                                                 IA80.1  IA80.5
                                                                 IA80.6  IA80.8
                                                                 IA80.9  IARP.1
                                                                 IART.1  IATB.1
                                                                 IATM.1  IATS.1