System Code Tables

European Inspection Management System Code Tables

The following table lists the System Code Tables for European Inspection Management:


System Table ID	System Table Description	System Code ID	System Code Description	Behavior and Usage
MI_COMPLIANCE_STANDARD	Compliance Standard	API 510	API 510	This system code table stores the certification value. The values in this field are populated from a drop-down list box.
		API 653	API 653
		NBIC	NBIC
		API 650	API 650
		ASTM 1137	ASTM 1137
		DIN 43760	DIN 43760
		API 570	API 570
		TC-1A MT II	ASNT TC-1A MT Level II
		TC-1A PT II	ASNT TC-1A PT Level II
		TC-1A RT II	ASNT TC-1A RT Level II
		TC-1A UT Thickness II	ASNT TC-1A UT Thickness
		TC-1A UT Shearwave II	ASNT TC-1A UT Shearwave Level II
		ZUS	ZUS
		BP	bP
MI_INTGY_FLUID_CTGY	Integrity Fluid Category	Explosive	Explosive	This system code table stores the fluid category list. The values in this field are populated from a drop-down list box.
		Flammable Category 1	Flammable Category 1
		Flammable Category 2	Flammable Category 2
		Flammable Category 3	Flammable Category 3
		Pyrophoric	Pyrophoric
		Acute Toxic Category 1	Acute Toxic Category 1
		Acute Toxic Category 2	Acute Toxic Category 2
		Oxidising	Oxidising
		Corrosive	Corrosive
		Others	Others
NR13_FLAMMABLE	NR13_FLAMMABLE	C	Combustible	This system code table stores the type of fluid. The fluid type is either Combustible or Flammable.
NR13_FLAMMABLE	NR13_FLAMMABLE	I	Flammable
FLUID TYPES	Fluid Types	Gas	Gas	This system code table stores the type of fluid. The fluid type is either Gas or Liquid.
FLUID TYPES	Fluid Types	Liquid	Liquid
MI_INTGY_ASSET_TYPE	Integrity Asset Type	Steam Boiler	Steam Boiler	This system code table is required to calculate certification requirements for the asset of the following types: Pressure Vessel Simple Pressure Vessel Steam Boiler Piping
		Pressure Vessel	Pressure Vessel
		Simple Pressure Vessel	Simple Pressure Vessel
		Piping	Piping
MI_INTGY_REGULATION	Integrity Inspection Regulations	European Inspection Regulation	European Inspection Regulation	This system code table is populated with a list of European Inspection regulations to be linked to a task. This field is always disabled.
MI_MAPPING_REFERENCE	MI Mapping Reference	ATD - CR	Asset Technical Data - Compliance Recommendation	This system code table stores the references of a Compliance Recommendation Mapping record
MI_INTGY_FLUID_NAME	Integrity Fluid Name			This system code table stores a list of fluid names. You can choose from the baseline values, populated from a drop-down list box
MI_INTGY_FLUID_GROUP	Integrity Fluid Group	1	1	This system code table specifies the fluid group according to Table F: Fluid Group Table.
MI_INTGY_FLUID_GROUP	Integrity Fluid Group	2	2
MI_INTGY_GRACE_PERIOD_BASIS	Grace Period Basis	User_Defined	User Defined	This system code table contains the information about basis on which the Inspection Grace Date is calculated.
		EOM	End of Month
		EOQ	End of Quarter
		EOY	End of Year
MI_CHAMBER	Chamber	AHRS	Half pipe jacket	This system code table information about the type of chamber. The values in this field are populated from a drop-down list box.
		AR	Jacket
		AVRS	Full pipe jacket
		DISK	Disk
		FARM	Loading arm
		GASK	Gasket
		GAUG	Gauge
		GSMT	Total object
		HEAD2	Head2
		HEAD	Head1
		IR	Interior
		IVRS	Interior coil
		JAC2	Jacket 2 chamber
		JAC3	Jacket 3 chamber
		JACK	Jacket 1 chamber
		NOZZ	Nozzles
		PRDR	Hot chamber
		RDDR	Tube chamber
		RUDR	Shell chamber
		SHEE	Sheet
		SHEL	Shell
		SLTG	Hose
		SORA	Miscelleneous chamber
		SRVR	Cold chamber
		TUBE	Tube
		TUSH	Tubesheet
EU_INSP_INST	European Inspection Instructions	AwSV-RT	AwSV - Recurrent Test	This system code table stores the value selected in the Inspection Instruction. The values in this field are populated from a drop-down list box.
		AwSV-BEF-COM-SC	AwSV Test Before Commissioning - After a Significant Change
		AwSV-BEF-COM-BR	AwSV Test Before Commissioning - Before Restarting
		AwSV-BEF-COM_FT	AwSV Test Before Commissioning - For The First Time
		AwSV-Decom	AwSV Test When Decommissioned
		D-CHK-BEF-STRT-UP-RI	D -Check Before Start-Up - After a Change Requiring Inspection
		D-CHK-BEF-STRT-UP-FT	D -Check Before Start-Up - For The First Time
		D-RI-PS	D -Repeated Inspection -Checking the Pressure System
		D-RT-Internal	D -Repeated Test -Internal Test
		D-RI-OTST	D -Repeated Test -Outside Test and Strength Test
		D-PI-External	D-Periodic Inspection -External Inspection
		D-PI-ST	D-Periodic Inspection-Strength Test
		EX-BEF-COM-FT	EX Test Before Commissioning - For The First Time
		EX-BEF-COM-RI	EX Test Before Start-Up After a Change Requiring Inspection
		EX-PI-5.1	EX-Periodic Inspection -5.1
		EX-PI-5.3	EX-Periodic Inspection -5.3
		EX-RT-5.2	EX-Recurrent Test -5.2
		INSP-REPORT	Inspection Report
		RESUME	Resume
MI_EN_DOC_CTGY	Inspection	Test Certificate by ZUS	Test Certificate by ZUS	This system code table stores the value selected in the Inspection Document Category. The values in this field are populated from a drop-down list box.
		Test Record by Company Inspector	Test Record by Company Inspector
		Test Report by Subcontractor	Test Report by subcontractor
MI_EU_TASK_RESCHEDULE	Inspection	NXT_DT_BASED_ON_COMPL_DATE	Next Date Based on Completion Date	This system code table captures the information based on how the Next Date field is calculated. The field can be calculated either by the Completion Date or the Previous Next Date. This field is always disabled.
MI_EU_TASK_RESCHEDULE	Inspection	NXT_DT_BASED_ON_PREV_NXT_DT	Next Date Based on Previous Next Date