Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IATIME


                              IATIME FILE

REFERENCED BY

IART.1    IATS.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TIM-USER-DIM-NAME      Alpha 50  (Lower Case)
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
Element: Years IncludedY = Yes
                       N = No

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

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

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

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

TIM-YR-IDENTIFIER      Alpha 1
Element: Yr Identifier

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

TIM-BEGINNING-YEAR     Numeric 4
Element: Beginning Year

TIM-ENDING-YEAR        Numeric 4
Element: Ending Year

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

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

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

TIM-NBR-OF-PERIODS     Numeric 3
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)
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)
Element: Quarter Names Occurs 4 Times

TIM-LOCK-CHANGES       Alpha 1
Element: Lock Changes

TIM-STARTING-WKDAY     Numeric 1
Element: Starting Wkday

TIM-ADJUST-PERIOD      Alpha 1
Element: All Flag

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

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

                         IATIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TIMSET1   USER-DIM-NAME KeyChange                                IART.1  IATS.1