IAFILEDEF

UPDATED BY
ACBA.1 ACBC.1 ACBP.1 ACBR.1 ACBS.1 ACBU.1
ACBY.1 ACDL.1 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 POA3.1 POAB.1 POAM.1 POAO.1 POAP.1
WACP.1 WAD1.1 WAD2.1 WAD3.1 WAD4.1 WADL.1
WAMS.1 WAOP.1 WAPC.1 WAYR.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.
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.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.
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.1
IFI-LEVEL-NBR
Element: Level Nbr
Numeric 3
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.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
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.1
IFI-COLUMN-DESC
Element: Column Desc
Alpha 50 (Lower Case)
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.1
IFI-COLUMN-SIZE
Element: Column Size
Numeric 3
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.1
IFI-COLUMN-ATTR
Element: Column Attr
Alpha 1

I = Int
V = Varchar
N = Numeric
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.1
IFI-COLUMN-DECIMAL
Element: Column Decimal
Numeric 2
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.1
IFI-LAW-COL-NAME
Element: Law Col Name
Alpha 50 (Lower Case)
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.1
IFI-CREATED-GEN
Element: Created Gen
Alpha 1

Y
N
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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 POA3.1
POAB.1 POAM.1
POAO.1 POAP.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
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 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
IFISET2 USER-DIM-NAME
DATA-MART-NAME
COLUMN-DESC
KeyChange
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 ACDL.1
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
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
ACDL.1 AMDL.1
CBOP.1 HCDL.1
HCHP.1 IA150
IANM.1 GLOP.1
POA3.1 WADL.1
WAOP.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: Thu Jun 09 11:16:26 2016

Home
Contact Us



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