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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET5 SET6
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IFISET1
  1. USER-DIM-NAME
  2. DATA-MART-NAME
  3. LEVEL-NBR
  4. COLUMN-CAT
  5. COLUMN-DESC
Primary, KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, AMAS.1 +22 more (list truncated in source)
IFISET2
  1. USER-DIM-NAME
  2. DATA-MART-NAME
  3. COLUMN-DESC
KeyChangeACBA.1, ACBC.1, ACBP.1, ACBR.1, ACBS.1, ACBU.1, ACBY.1, ACDL.1 +22 more (list truncated in source)
IFISET3
  1. USER-DIM-NAME
  2. LEVEL-NBR
  3. COLUMN-CAT
  4. COLUMN-DESC
KeyChange, SubsetWhere USER-DIM-NAME != SpacesIANM.1
IFISET4
  1. DATA-MART-NAME
  2. LEVEL-NBR
  3. COLUMN-CAT
  4. COLUMN-DESC
KeyChange, SubsetWhere DATA-MART-NAME != SpacesACDL.1, AMDL.1, CBOP.1, HCDL.1, HCHP.1, IA150, IANM.1, GLOP.1 +1 more
IFISET5
  1. USER-DIM-NAME
  2. DATA-MART-NAME
  3. LEVEL-NBR
  4. COLUMN-CAT
  5. LAW-COL-NAME
KeyChange—
IFISET6
  1. DATA-MART-NAME
  2. USER-DIM-NAME
  3. COLUMN-CAT
  4. LAW-COL-NAME
KeyChangeIAAP.1
IFISET7
  1. DATA-MART-NAME
  2. USER-DIM-NAME
  3. COLUMN-CAT
  4. LEVEL-NBR
  5. COLUMN-DESC
KeyChangeIAAP.1

Programs

Updated by (60)