IAYEARVAR FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IYV-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.
IYV-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.
IYV-VAR-TYPE Alpha 1
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
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
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
Var Element2 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
MEMBER-NAME
|
