IAFILEDEF – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IFI
Primary key
USER-DIM-NAME, DATA-MART-NAME, LEVEL-NBR, COLUMN-CAT, COLUMN-DESC
Fields
11
Updated by
60 programs
Referenced by
0 programs

IAFILEDEF is a Lawson Analytic Architect table (prefix IFI); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME, DATA-MART-NAME, LEVEL-NBR, COLUMN-CAT, COLUMN-DESC (IFISET1); alternate indexes: IFISET2, IFISET3, IFISET4, IFISET5, IFISET6 and IFISET7. It is updated by ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 and 52 more. The table has 11 fields, 7 indexes and 0 documented relations.

About IAFILEDEF

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the IFI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
IFI-DATA-MART-NAME PK
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 +52 more
IFI-USER-DIM-NAME PK
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 +52 more
IFI-LEVEL-NBR PK
LEVEL_NBR		Numeric 3—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +52 more
IFI-COLUMN-CAT PK
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 +52 more
IFI-COLUMN-DESC PK
COLUMN_DESC		Alpha 50 (Lower Case)—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +52 more
IFI-COLUMN-SIZE
COLUMN_SIZE		Numeric 3—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +52 more
IFI-COLUMN-ATTR
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 +52 more
IFI-COLUMN-DECIMAL
COLUMN_DECIMAL		Numeric 2—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +52 more
IFI-LAW-COL-NAME
LAW_COL_NAME		Alpha 50 (Lower Case)—ACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +52 more
IFI-CREATED-GEN
CREATED_GEN		Alpha 1Y NACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +52 more
IFI-KEY-INDICATOR
KEY_INDICATOR		Alpha 1—
  • N No
  • Y Yes
—

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IFISET1USER-DIM-NAME, DATA-MART-NAME, LEVEL-NBR, COLUMN-CAT, COLUMN-DESCPrimary, KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
IFISET2USER-DIM-NAME, DATA-MART-NAME, COLUMN-DESCKeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
IFISET3USER-DIM-NAME, LEVEL-NBR, COLUMN-CAT, COLUMN-DESCKeyChange, SubsetWhere USER-DIM-NAME != SpacesIANM.1
IFISET4DATA-MART-NAME, LEVEL-NBR, COLUMN-CAT, COLUMN-DESCKeyChange, SubsetWhere DATA-MART-NAME != SpacesACDL.1, AMDL.1, CBOP.1, HCDL.1, HCHP.1, IA150, IANM.1, GLOP.1 +1 more
IFISET5USER-DIM-NAME, DATA-MART-NAME, LEVEL-NBR, COLUMN-CAT, LAW-COL-NAMEKeyChange—
IFISET6DATA-MART-NAME, USER-DIM-NAME, COLUMN-CAT, LAW-COL-NAMEKeyChangeIAAP.1
IFISET7DATA-MART-NAME, USER-DIM-NAME, COLUMN-CAT, LEVEL-NBR, COLUMN-DESCKeyChangeIAAP.1

Programs

Updated by (60)