| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
IFI-DATA-MART-NAME
Element: Data Mart Name | Alpha 20 (Lower Case)
This field contains the name of the data
mart.
|
|
IFI-USER-DIM-NAME
Element: User Dim Name | Alpha 50 (Lower Case)
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.
|
|
IFI-LEVEL-NBR
Element: Level Nbr | Numeric 3
|
|
IFI-COLUMN-CAT
Element: Column Cat | Alpha 1
L = Level Column
P = Property Column
I = ID Column
S = Sort Order Column
M = Measure Column
U = Unary Operator Column |
|
IFI-COLUMN-DESC
Element: Column Desc | Alpha 50 (Lower Case)
|
|
IFI-COLUMN-SIZE
Element: Column Size | Numeric 3
|
|
IFI-COLUMN-ATTR
Element: Column Attr | Alpha 1
I = Int
V = Varchar
N = Numeric |
|
IFI-COLUMN-DECIMAL
Element: Column Decimal | Numeric 2
|
|
IFI-LAW-COL-NAME
Element: Law Col Name | Alpha 50 (Lower Case)
|
|
IFI-CREATED-GEN
Element: Created Gen | Alpha 1
Y
N |
|
IFI-KEY-INDICATOR
Element: Key Indicator | Alpha 1
N = No
Y = Yes |
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| IFISET1 |
USER-DIM-NAME
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC
|
|
|
| IFISET2 |
USER-DIM-NAME
DATA-MART-NAME
COLUMN-DESC
|
|
|
| IFISET3 |
USER-DIM-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC
|
|
KeyChange, Subset |
| Where | | USER-DIM-NAME |
!= | Spaces | |
|
|
| IFISET4 |
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC
|
|
KeyChange, Subset |
| Where | | DATA-MART-NAME |
!= | Spaces | |
|
|
| IFISET5 |
USER-DIM-NAME
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
LAW-COL-NAME
|
|
|
| IFISET6 |
DATA-MART-NAME
USER-DIM-NAME
COLUMN-CAT
LAW-COL-NAME
|
|
|
| IFISET7 |
DATA-MART-NAME
USER-DIM-NAME
COLUMN-CAT
LEVEL-NBR
COLUMN-DESC
|
|
|
