IAFILEDEF

UPDATED BY
AMAS.1 AMBK.1 AMCV.1 AMDL.1 AMLF.1 AMMD.1
AMME.1 AMPD.1 AMYR.1 CBBB.1 CBBC.1 CBBD.1
CBBO.1 CBBR.1 CBBT.1 CBOP.1 HCAG.1 HCCP.1
HCDL.1 HCEM.1 HCHM.1 HCHP.1 HCJC.1 HCMS.1
HCPO.1 HCRV.1 HCSC.1 HCSU.1 HCYR.1 IA120
IA150 IAAP.1 IAMB.1 IANM.1 IATM.1 IAVO.1
IAYR.1 GLBA.1 GLBD.1 GLBP.1 GLBT.1 GLBY.1
GLOP.1 IFBA.1 IFBC.1 IFBO.1 IFBS.1

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.
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
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.
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-LEVEL-NBR
Element: Level Nbr		Numeric 3
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
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
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-COLUMN-DESC
Element: Column Desc		Alpha 50 (Lower Case)
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-COLUMN-SIZE
Element: Column Size		Numeric 3
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-COLUMN-ATTR
Element: Column Attr		Alpha 1

I = Int
V = Varchar
N = Numeric
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-COLUMN-DECIMAL
Element: Column Decimal		Numeric 2
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-LAW-COL-NAME
Element: Law Col Name		Alpha 50 (Lower Case)
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-CREATED-GEN
Element: Created Gen		Alpha 1

Y
N
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
GLBA.1 GLBD.1
GLBP.1 GLBT.1
GLBY.1 GLOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IANM.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1
IFI-KEY-INDICATOR
Element: Key Indicator		Alpha 1

N = No
Y = Yes


IAFILEDEF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IFISET1 USER-DIM-NAME
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC
KeyChange
...
AMAS.1 AMBK.1
AMCV.1 AMLF.1
AMMD.1 AMME.1
AMPD.1 AMYR.1
CBBB.1 CBBC.1
CBBD.1 CBBO.1
CBBR.1 CBBT.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAAP.1
IAMB.1 IATM.1
IFISET2 USER-DIM-NAME
DATA-MART-NAME
COLUMN-DESC
KeyChange
...
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IFISET3 USER-DIM-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC
KeyChange, Subset
WhereUSER-DIM-NAME !=Spaces
IANM.1
IFISET4 DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
COLUMN-DESC
KeyChange, Subset
WhereDATA-MART-NAME !=Spaces
AMDL.1 CBOP.1
HCDL.1 HCHP.1
IA150 IANM.1
GLOP.1
IFISET5 USER-DIM-NAME
DATA-MART-NAME
LEVEL-NBR
COLUMN-CAT
LAW-COL-NAME
KeyChange
IFISET6 DATA-MART-NAME
USER-DIM-NAME
COLUMN-CAT
LAW-COL-NAME
KeyChange
IAAP.1
IFISET7 DATA-MART-NAME
USER-DIM-NAME
COLUMN-CAT
LEVEL-NBR
COLUMN-DESC
KeyChange
IAAP.1

File created: Wed Jun 08 20:49:33 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.