|
IATIME FILE
REFERENCED BY
CBDM.1 CBOP.1 HCCE.1 HCDL.1 HCHE.1 HCHP.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 CBDM.1 CBOP.1
HCCE.1 HCDL.1
HCHE.1 HCHP.1
IA80.1 IA80.5
IA80.6 IA80.8
IA80.9 IARP.1
IART.1 IATB.1
IATM.1 IATS.1
|