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.
More:
ACCESS_KEYWORDS (Validation)
ADDRESS_PURPOSE (Validation)
APPEAL_TYPE (Validation)
BAD_ADDRESS (Validation)
BADGE_TYPES (Validation)
CATEGORY (Validation)
CEU_TYPE (Required Validation)
COMMITTEE_GROUP (Validation)
COMMITTEE_STS (Required Validation)
CONFLICT_CODE (Validation)
CONTACT_TYPE (Validation)
COUNTRY (Validation, Expansion)
DESIGNATION (Expansion only)
EXPENSE_TYPE (Validation, Expansion)
EXPO_CAT (Validation)
EXPO_PROD_CAT (Validation)
FUNC_TITLE (Validation)
FUNDRAISER_TYPE (Validation)
GIFT_AMOUNT (Lookup only)
GL_ACCOUNT (Validation)
GROUP_CODE (Validation)
HOLD_CODES (Lookup only)
LOCATION (Lookup only)
MAIL_CODE (Lookup only)
MEETING_TYPE (Lookup only)
MEM_TRIB_RELATIONSHIP (Validation)
MEMBER_STATUS (Required Validation)
MERGE_CODE (Validation)
NOTE_PURPOSE (Validation)
PREFIX (Validation)
REFERRAL_AREA (Validation)
REQUEST_STATUS (Validation)
REQUEST_TYPE (Validation)
SALUTATION_CODE (Validation)
SHIP_METHOD (Required Validation)
SIC_CODE (Validation)
SOURCE_CODE (Validation)
SR_AREA (Validation)
SR_CAT (Validation)
SR_ENVIRON (Validation)
SR_CATLEVEL (Validation)
SR_CNTTYPE (Validation)
SR_RES (Required Validation)
SR_SRVTYPE (Required Validation)
SR_SYS (Validation)
SR_VERSION (Validation)
STATE (Validation)
SUFFIX (Validation)
TITLE (Validation/Lookup)
ZIP3 (Validation)