|
|
IATIMEWEEK FILE
REFERENCED BY
IATB.1 IATM.1
UPDATED BY
IA80.1 IA80.8 IA80.9
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IWK-USER-DIM-NAME Alpha 50 (Lower Case) IA80.1 IA80.9
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.
IWK-YEAR Numeric 4 IA80.1 IA80.9
Element: Last Closed YeContains the fiscal year for the data
stored on this record.
IWK-WEEK-NBR Numeric 2 IA80.1 IA80.9
Element: Week Nbr
IWK-MEMBER-NAME Alpha 50 (Lower Case) IA80.1 IA80.9
Element: Member Name This is an override member name for
Data Mart dimensions with no association
to a Budget dimension.
IWK-PERIOD-CONSOL Numeric 3 IA80.1 IA80.8
Element: Period Consol IA80.9
IWK-ENDING-YEAR Numeric 4 IA80.1 IA80.8
Element: Ending Year IA80.9
IWK-ENDING-DAY Numeric 4 (mmdd) IA80.1 IA80.8
Element: Ending Day IA80.9
IATIMEWEEK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IWKSET1 USER-DIM-NAME IA80.1 IA80.8
YEAR IA80.9 IATB.1
WEEK-NBR IATM.1
IWKSET2 USER-DIM-NAME KeyChange IATM.1
YEAR
PERIOD-CONSOL
WEEK-NBR
IWKSET3 USER-DIM-NAME IATM.1
WEEK-NBR
YEAR
IWKSET4 USER-DIM-NAME KeyChange IA80.8
YEAR
MEMBER-NAME
WEEK-NBR
|
