|
|
IAYEARVAR FILE
REFERENCED BY
IAYR.1
UPDATED BY
IA85.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IYV-USER-DIM-NAME Alpha 50 (Lower Case) IA85.3
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.
IYV-MEMBER-NAME Alpha 50 (Lower Case) IA85.3
Element: Member Name This is an override member name for
Data Mart dimensions with no association
to a Budget dimension.
IYV-VAR-TYPE Alpha 1 IA85.3
Element: Var Type The Variance Type field contains the
value that represents the variance type
for fiscal year variances.
Valid values are:
A = Variance Amount
P = Variance Percent
IYV-VAR-SUBTYPE Alpha 1
Element: Var Subtype The Variance Subtype field contains the
value that represents the variance
subtype for budget variances.
Value values are:
A = Budget to Actuals
B = Budget to Budget
IYV-VAR-ELEMENT1 Numeric 4 IA85.3
Element: Var Element1 The Variance Element One field contains
the first item (fiscal year or budget
member) that is used in the variance
calculation.
IYV-VAR-ELEMENT2 Numeric 4 IA85.3
Element: Var Element1 The Variance Element Two field contains
the second item (fiscal year or budget
member) that is used in the variance
calculation.
IAYEARVAR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IYVSET1 USER-DIM-NAME IA85.3 IAYR.1
MEMBER-NAME
|
