IACUSTMART – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IUM
Primary key
ASP-CUSTOMER, DATA-MART-NAME
Fields
11
Updated by
1 program
Referenced by
2 programs

IACUSTMART is a Lawson Analytic Architect table (prefix IUM); no description in the lawson data dictionary. It is indexed by ASP-CUSTOMER, DATA-MART-NAME (IUMSET1); alternate indexes: IUMSET2 and IUMSET3. It is related 1:1 to IACUSTOMER and IACUSTUSRS. It is updated by IA90.4 and referenced by IA199 and IA99.1. The table has 11 fields, 3 indexes and 2 documented relations.

About IACUSTMART

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the IUM- 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
#IUM-ASP-CUSTOMER PK
ASP_CUSTOMER		Numeric 9—IA90.4
#IUM-DATA-MART-NAME PK
DATA_MART_NAME		Alpha 20 (Lower Case)This field contains the name of the data mart.IA90.4
#IUM-DATABASE-TYPE SET2
DATABASE_TYPE		Alpha 1—
  • E Essbase
  • S Microsoft Analysis Services
IA90.4
#IUM-SERVER-NAME SET2
SERVER_NAME		Alpha 40 (Lower Case)The Server Name field contains the IP address of the server to which you are connecting. You can also specify a name that has been associated with the server (DNS name).IA90.4
#IUM-APPLIC-NAME SET2
APPLIC_NAME		Alpha 8 (Lower Case)The Application Name is the name of the application that describes the database names it contains. This user-defined name can contain up to eight characters. The first letter of the name must be capitalized.IA90.4
#IUM-DATABASE-NAME SET2
DATABASE_NAME		Alpha 8 (Lower Case)The Database Name is the name of the database that is stored within the OLAP application. Each application may contain more than one database. This user-defined name can contain up to eight characters. The first letter of the name must be capitalized.IA90.4
#IUM-AUTHENTICATE
AUTHENTICATE		Numeric 14——
#IUM-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.IA90.4
#IUM-LOGIN SET3
LOGIN		Alpha 30 (Lower Case)—IA90.4
#IUM-PROCESSING
PROCESSING		Alpha 1The Processing field shows the current status of the data mart. It provides a locking mechanism to prevent updates when data is being loaded to the data mart. Value values are: ~ = No data is being processed
  • M Outline build in process
  • D Data load in process
  • C Data mart calculation in process
—
#IUM-JOB-NAME
JOB_NAME		Alpha 10——

Indexes (3)

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
IUMSET1
  1. ASP-CUSTOMER
  2. DATA-MART-NAME
Primary, KeyChangeIA199, IA90.1, IA90.4, IA99.1
IUMSET2
  1. DATABASE-TYPE
  2. SERVER-NAME
  3. APPLIC-NAME
  4. DATABASE-NAME
KeyChange, SubsetWhere DATABASE-TYPE = "E"IA90.4
IUMSET3
  1. LOGIN
  2. ASP-CUSTOMER
  3. DATA-MART-NAME
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
IACUSTOMERIACUSTUSRSIACUSTMART

One to one (2) — lookups and parents

RelationTableRulesConditionField map
IacustomerIACUSTOMERRequired
IUM-ASP-CUSTOMER→ICE-ASP-CUSTOMER (ICESET1)
IacustusrsIACUSTUSRSRequired
IUM-LOGIN→IUU-LOGIN

Programs

Updated by (1)

Referenced by (2)