Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IATIME


                              IATIME FILE

REFERENCED BY

HCCE.1    HCHE.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                                HCCE.1  HCHE.1
                                                                 IA80.1  IA80.5
                                                                 IA80.6  IA80.8
                                                                 IA80.9  IARP.1
                                                                 IART.1  IATB.1
                                                                 IATM.1  IATS.1