IATIME FILE
REFERENCED BY
IART.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
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 IA80.1
Years Included Y = Yes
N = No
TIM-QTRS-INCLUDED Alpha 1 IA80.1
Qtrs Included Y = Yes
N = No
TIM-PERS-INCLUDED Alpha 1 IA80.1
Pers Included Y = Yes
N = No
TIM-WEEKS-INCLUDED Alpha 1 IA80.1
Weeks Included Y = Yes
N = No
TIM-DAYS-INCLUDED Alpha 1 IA80.1
Days Included Y = Yes
N = No
TIM-YR-IDENTIFIER Alpha 1 IA80.1
Yr Identifier
TIM-YR-SEPARATOR Alpha 1 (Lower Case) IA80.1
Yr Separator
TIM-BEGINNING-YEAR Numeric 4 IA80.1
Beginning Year
TIM-ENDING-YEAR Numeric 4 IA80.1
Ending Year
TIM-UNIQUE-MEMBERS Alpha 1 IA80.1
Unique Members Y = Yes
N = No
TIM-PRIOR-YR-MBR Alpha 50 (Lower Case) IA80.1
Prior Yr Mbr
TIM-DAY-NAMING-OPT Alpha 1
Day Naming Opt
TIM-NBR-OF-PERIODS Numeric 3 IA80.1
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) IA80.1
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) IA80.1
Quarter Names Occurs 4 Times
TIM-LOCK-CHANGES Alpha 1
Lock Changes
TIM-STARTING-WKDAY Numeric 1 IA80.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 IA80.1
Day Of Wk Att
TIM-WEEKDAY-MBR Alpha 50 (Lower Case) IA80.1
Weekday Mbr
IATIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TIMSET1 USER-DIM-NAME KeyChange IA80.1 IA80.5
IA80.6 IA80.8
IA80.9 IART.1
IATM.1 IATS.1
|
