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