IATIME

REFERENCED BY
HCDL.1 CBDM.1 CBOP.1 HCCE.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
Element: User Dim Name
Alpha 50 (Lower Case)
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.
IA80.1
TIM-TIME-DEPTH
Element: Time Depth
Alpha 1

Q = Quarters
P = Periods
D = Days
TIM-YEARS-INCLUDED
Element: Years Included
Alpha 1

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

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

Y = Yes
N = No
IA80.1
TIM-WEEKS-INCLUDED
Element: Weeks Included
Alpha 1

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

Y = Yes
N = No
IA80.1
TIM-YR-IDENTIFIER
Element: Yr Identifier
Alpha 1
IA80.1
TIM-YR-SEPARATOR
Element: Yr Separator
Alpha 1 (Lower Case)
IA80.1
TIM-BEGINNING-YEAR
Element: Beginning Year
Numeric 4
IA80.1
TIM-ENDING-YEAR
Element: Ending Year
Numeric 4
IA80.1
TIM-UNIQUE-MEMBERS
Element: Unique Members
Alpha 1

Y = Yes
N = No
IA80.1
TIM-PRIOR-YR-MBR
Element: Prior Yr Mbr
Alpha 50 (Lower Case)
IA80.1
TIM-DAY-NAMING-OPT
Element: Day Naming Opt
Alpha 1
TIM-NBR-OF-PERIODS
Element: Nbr Of Periods
Numeric 3
IA80.1
TIM-BEG-MONTH-DAY
Element: Beg Month Day
Numeric 4 (mmdd)
TIM-END-MONTH-DAY
Element: End Month Day
Numeric 4 (mmdd)
TIM-BEGIN-BAL-MBR
Element: Begin Bal Mbr
Alpha 50 (Lower Case)
IA80.1
TIM-BB-DEPTH
Element: Bb Depth
Alpha 1

A = Annual
Q = Quarter
P = Period
W = Week
D = Day
TIM-QUARTER-NAMES
Element: Quarter Names
Alpha 50 (Lower Case)
Occurs 4 Times
IA80.1
TIM-LOCK-CHANGES
Element: Lock Changes
Alpha 1
TIM-STARTING-WKDAY
Element: Starting Wkday
Numeric 1
IA80.1
TIM-ADJUST-PERIOD
Element: Adjust Period
Alpha 1
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
Element: Day Of Wk Att
Alpha 1
IA80.1
TIM-WEEKDAY-MBR
Element: Weekday Mbr
Alpha 50 (Lower Case)
IA80.1


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


File created: Thu Jun 09 11:16:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.