Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              IATIME FILE

REFERENCED BY

IART.1    IATS.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TIM-USER-DIM-NAME    Alpha 50  (Lower Case)
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
Time Depth           Q = Quarters
                     P = Periods
                     D = Days

TIM-YEARS-INCLUDED   Alpha 1
Years Included       Y = Yes
                     N = No

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

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

TIM-WEEKS-INCLUDED   Alpha 1
Weeks Included       Y = Yes
                     N = No

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

TIM-YR-IDENTIFIER    Alpha 1
Yr Identifier

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

TIM-BEGINNING-YEAR   Numeric 4
Beginning Year

TIM-ENDING-YEAR      Numeric 4
Ending Year

TIM-UNIQUE-MEMBERS   Alpha 1
Unique Members       Y = Yes
                     N = No

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

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

TIM-NBR-OF-PERIODS   Numeric 3
Nbr Of Periods

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

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

TIM-BEGIN-BAL-MBR    Alpha 50  (Lower Case)
Begin Bal Mbr

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

TIM-QUARTER-NAMES    Alpha 50  (Lower Case)
Quarter Names        Occurs 4 Times

TIM-LOCK-CHANGES     Alpha 1
Lock Changes

TIM-STARTING-WKDAY   Numeric 1
Starting Wkday

TIM-ADJUST-PERIOD    Alpha 1
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
Day Of Wk Att

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

                         IATIME FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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