System Code Tables Used by Inspection Management

The following grid lists the System Code Tables that are used by Inspection Management.

Table ID	Table Description	Function
INSM	Inspection Interval Types	Used to populate the Desired Interval Basis list in Inspection Task records.
INST	Inspection Status Code	None.
MI ACTION	CORE, Actions Taken	Used to populate the Action Taken Code list in General Finding records. Note that only system codes that contain the reference INSPECTION_FINDING_ACTION appear in the Action Taken Code list.
MI API 510 EXTERNAL CHECKLIST FINDING SECTIONS	API 510 External Checklist Finding Section	Used to display sections and rows on the Inspection Finding Checklist page.
MI API 510 INTERNAL CHECKLIST FINDING SECTIONS	API 510 Internal Checklist Finding Section	Used to display sections and rows on the Inspection Finding Checklist page.
MI API 510 INTERNAL EXCHANGER CHECKLIST FINDING SE	API 510 Internal Exchanger Checklist Finding Section	Used to display sections and rows on the Inspection Finding Checklist page.
MI API 570 EXTERNAL CHECKLIST FINDING SECTIONS	API 570 External Checklist Finding Section	Used to display sections and rows on the Inspection Finding Checklist page.
MI API 653 EXTERNAL CHECKLIST FINDING SECTIONS	API 653 External Checklist Finding Section	Used to display sections and rows on the Inspection Finding Checklist page.
MI API 653 INTERNAL CHECKLIST FINDING SECTIONS	API 653 Internal Checklist Finding Section	Used to display sections and rows on the Inspection Finding Checklist page.
MI BUNDLE ACTION	Inspection; Inspection / Maintenance Actions taken on a exchanger bundle	Used to populate the Action This Inspection list in Bundle Sub-Inspection records.
MI BUNDLE TYPE	Inspection; Bundle Types	Used to populate the Bundle Type list in Bundle Sub-Inspection records.
MI BUSINESS IMPACT	CORE, Impact to company's production carrying out equipment work	Used to populate the Business Impact list in Inspection Recommendation records.
MI CHECKLIST CATEGORIES	MI_CHECKLIST_CATEGORIES; Checklist Categories	Used to populate the Categories list in Checklist Configuration Template page.
MI CHECKLIST FINDING ITEMS	Checklist Finding Items	Used to display values in the first column on the Inspection Finding Checklist page.
MI CHECKLIST FINDING TYPES	Checklist Finding Types	Used to populate the Finding Value lists on the Inspection Finding Checklist page.
MI COMPLIANCE STANDARD	CORE, Compliance Standard	Used to populate the Certification Type list in Personnel Certification records. Note that only the System Codes that contain the reference INSPECTION_PERS_CERTS appear in the Certification Type list.
MI CORE REFERENCES	CORE, Used to limit values by common components	Used to populate the Status list in Inspection Recommendation records.
MI DAMAGE MECHANISM	Inspection, Damage Mechanisms	Used to populate the Damage Mechanism list in General Finding records.
MI DAMAGE MODE	Inspection, Damage Mode	Used to populate the Damage Mode list in General Finding records.
MI DAMAGECHECKLIST SECTIONS	Damage Checklist Sections	Used to populate the Third Party Damage list in Checklist Findings records.
MI DEGRADATION MECHANISM TYPES	Degradation Mechanism Types	Used to populate the Degradation Mechanism list in Inspection records.
MI EQUIP OP STATE	MI Inspection, Equipment Operating State	Used to populate the Equipment Operating State list in Inspection records. Note that only the System Codes that contain the reference INSPECTION_EQUIPMENT_STATE appear in the Equipment Operating State list.
MI EVENT REASON	CORE, Reason for Event	Used to populate the Reason for Inspection list in Inspection records. Note that: References that have been added to the INSPECTION REASON1 System Code Table are available in a Full Inspection record, and references that have been added to the INSPECTION REASON2 System Code Table are available in a General Inspection record. All System Codes in the MI EVENT REASON System Code appear in the Reason for Inspection list in Bundle Inspection and Pressure Test Inspection records.
MI EXTERNAL PRD CHECKLIST FINDING SECTIONS	External PRD Checklist Finding Section	Used to display sections and rows on the Inspection Finding Checklist page.
MI FINDING TYPE	MI Inspection, Provides categories for an inspection finding	Used to populate the Type list in General Finding records.
MI FREQUENCIES	CORE, Frequencies	Used to populate the Frequency of Alert After Due Date list in Inspection Recommendation records. Note that only the System Codes that contain the reference INSPECTION ALERT INTERVAL appear in the Frequency of Alert After Due Date list.
MI INSPCONFEV	Inspection Confidence Evaluation	None.
MI INSPECTION METHOD CATEGORY	MI INSPECTION METHOD CATEGORY	Used to populate the Category list in Inspection Method records.
MI INSPECTION METHOD REFERENCE	MI Inspection, Stores system codes and descriptions that represent Inspection Methods	Used to determine the confidence for each Degradation Mechanism used in RBI Analyses.
MI INSPECTION PROFILE CATEGORY	Inspection, Profile Category	Used to populate the Item Category list in Inspection Profile records.
MI INSPECTION PROFILE REFERENCE	MI Inspection	Stores the equipment family ID's, system codes, and descriptions to limit the Profile Categories shown for a piece of equipment. Built during implementation when equipment model known
MI INSPECTION REFERENCES	MI Inspection, Inspection Reference Codes - Inspection	Used to limit values in System Code Tables to values used in the inspection solution.
MI INSPECTION STRATEGY	MI Inspection Strategy	None.
MI PDM FILTER	MI RBI, Potential Degradation Filter	Used to populate the Degradation Mechanism list in Inspection records belonging to the PRD Pop Test Checklist subfamily.
MI PRD INSPECTION TYPE FILTER	PRD Inspection Type Filter	Used to populate the Type of Inspection list in PRD Pop Test Checklist records.
MI PRD PT CHECKLIST FINDING SECTIONS	PRD Pop Test Checklist Finding Sections	Used to display sections and rows on the Inspection Finding Checklist page.
MI PRIORITY	CORE, baseline priority types	Used to populate the Recommendation Priority list in Inspection Recommendation records.
MI RECOMMENDATION TYPE	CORE, Recommendation Type	Used to populate the Recommendation Type list in Inspection Recommendation records. Note that the Recommendation Type field is not included on the baseline Inspection Recommendation datasheet.
MI RESOURCE ROLE	List of user roles	Used to populate the Role list in Resource Role records.
MI STATUS	Status Codes - CORE	Used to populate the Inspection Document Status list in Inspection records. Note that only the System Codes that contain the reference INSPECTION_DOCUMENT_STATUS appear in the Inspection Document Status list.
MI TASK TYPE REFERENCE	CORE, Reference values to limit task type lists when creating tasks	Used to populate the list in the Reference list in Task Types records.
MI TEST MEDIA	Fluids used for testing	Used to populate the Test Media list in Pressure Test Sub-Inspection records.
MI YES NO	MI Core, Yes-No	Used to populate the Predictable list in General Finding records.