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
|
