Reference to general lookup/validation tables
For this reference to the general lookup/validation tables that are used in iMIS, the heading is the name of the table as it appears in the Set up general lookup/validation window, followed by indication of the table's purpose (data validation, expansion, or lookup only) and whether the table is required.
Table reference guide
- Required - Indicates that a value must be entered. Click the Lookup icon to select a value.
- Validation - Indicates that iMIS validates the data entered against the entries in the table. "Lookup" indicates that no validation is performed.
- Module - The name of the iMIS module that uses the table.
- Display field- The fields in the iMIS window where you can select from a value in the table.
- iMIS table - The specific iMIS table and column(s) whose contents are affected by the general lookup/validation table.
CEU_TYPE (Required Validation)
COMMITTEE_STS (Required Validation)
COUNTRY (Validation, Expansion)
EXPENSE_TYPE (Validation, Expansion)
MEM_TRIB_RELATIONSHIP (Validation)
MEMBER_STATUS (Required Validation)
SHIP_METHOD (Required Validation)