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