Inspection Records

Inspection records store information about:

Bundle Inspections
Bundle Sub-Inspections
Checklist Inspections
Full Inspections
General Inspections
Pressure Test Inspections
Pressure Test Sub Inspections

The table below provides an alphabetical list and description of the fields that exist for the Inspection family. The information in the table reflects the baseline state and behavior of these fields. This list is not comprehensive.

Field	Data Type	Description	Behavior and Usage
Action This Inspection	Character	The action that was performed on the tube bundle during the inspection.	This field displays a list of the IDs and Descriptions of the System Codes that are stored in the MI BUNDLE ACTION (Bundle Sub-Inspection) System Code Table. The value No Action is selected in the list by default.
Actual Work Time	Number	The number of hours required to complete the inspection.	This field appears on datasheets configured for Inspection families whose caption contains the word Checklist , and on SAP Integration datasheets configured for the following families: Bundle Inspection Full Inspection General Inspection Pressure Test Inspection
As Found Pop Pressure	Number	The pressure at which the PRD opens at the time of the inspection.	This field accepts non-negative, numeric values only (e.g., 10).
As Left Pop Pressure	Number	The pressure at which the PRD opens after maintenance has been performed on the PRD (e.g., cleaning).	This field accepts non-negative, numeric values only (e.g., 10).
Asset ID	Character	The Equipment Record ID to which the Inspection is linked.	This field is populated by the associated Equipment Record ID. This field is either populated with the Equipment Record ID, or with the Equipment Record ID that is linked to the selected Functional Location.
Asset ID Link	Character	A hyperlink to the Equipment record to which the Inspection record is linked.	When you select this hyperlink, the Equipment record will be opened.
Bundle Inspection Summary	Text	A summary of the inspection.	You can use this field to record any additional information about the inspection that is not stored in another field in the Bundle Sub-Inspection record.
Bundle Tag	Text	Unique ID applied by the user to identify the bundle.	You can specify a value for this field using the datasheet.
Bundle Type	Character	The type of the tube bundle equipment.	This field is populated with a list of the IDs and Descriptions of the System Codes that are stored in the MI BUNDLE TYPE (Inspection; Bundle Types) System Code Table.
Completion Date	Date	The date on which the inspection was completed.	By default, this value is set to the date that the Inspection is created. You can modify this date to reflect the actual completion date. If the value in the Inspection Task Complete field is set to True, the value in the Completion Date field will be used to populate the Last Date field when the Inspection is saved. The commencement date and completion date are always the same.
Deterioration Mechanism	Character	The Degradation Mechanism that was observed during the inspection.	This field displays a list of the IDs and Descriptions of the System Codes stored in the MI DAMAGE MECHANISM (Inspection, Damage Mechanism) System Code Table. The datasheet caption for this field is As Found Degradation Mechanism.
Deterioration Mode	Character	How the Degradation Mechanism was observed during the inspection.	This field displays a list of the IDs and Descriptions of the System Codes stored in the MI DAMAGE MODE (Inspection, Damage Mode) System Code Table.
Design Set Pressure	Number	The pressure at which the PRD was designed to open.	This field accepts non-negative, numeric values only (e.g., 10).
Equipment Operating Site	Character	Documents the operating state that the equipment was in at the time of the inspection.	You can specify a value for this field using the datasheet.
Equipment Technical Number	Alphanumeric	Unique ID that identifies the equipment.	This ID is assigned during manufacture.
Extent	Character	The extent to which the inspection was performed.	This field displays a list of values based on the value that you selected in the Type of Inspection field and the values that exist in the Inspection Extent field in Inspection Strategy records. The Extent field displays a list of values that exist in the Inspection Extent field in all Inspection Strategy records whose Inspection Task Type field contains the value that you selected in the Type of Inspection field.
Final Inspection Lock	Logical	Indicates whether or not the Inspection record has reached a final state.	Typically, the person reviewing the Inspection Document will set this field to True when the review is complete.
Functional Location ID	Character	The ID of the Functional Location record linked to the Inspection record.	This field is populated with the ID of the Functional Location record with which the Inspection record is associated. This field is either populated by the Functional Location record ID or the Functional Location record of the Equipment record.
Functional Location ID Link	Character	A link to the Functional Location record to which the Inspection record is linked.	When you select this link, the Functional Location record will be opened.
Generate Represented Inspections	Logical	Indicates whether or not Inspection records will be created automatically for equipment in Inspection Groups that you create using the Risk Based Inspection (RBI) module.	When the value in this field is set to True, Represented Inspections may be created. This field is enabled only when the Inspection record fulfills two criteria: The Inspection Task Record is associated with an Equipment record in an Inspection Group. The Inspection Task record was created from an RBI Recommendation record that was created from that Inspection Group. Note: This field is not available on datasheets for the External PRD Checklist and PRD Pop Test Checklist subfamilies.
Inspection Completion Date	Date	The date on which the inspection was completed.	This field is populated automatically by the Meridium Enterprise APM system; however, you can modify the date by selecting .
Inspection Document Status	Character	The status of the Inspection Document.	This field displays a list of the IDs and Descriptions of the System Codes stored in the MI STATUS (Status Codes - CORE) System Code table. When an Inspection record is created, the value is set to Draft (DRAFT) by default. You can change it to Pending Approval when you are ready for the reviewer to review it. Likewise, the reviewer can change it to Approved (APPROVED) after they have reviewed it. Note: This field does not apply to Third Party Damage.
Inspection Headline	Character	A short description of the findings of the inspection.	You can specify a value for this field using the datasheet.
Inspection Lock	Logical	Indicates whether or not the Inspection record is locked. When this field is set to False, the Inspection record is unlocked. When this field is set to True, the Inspection record is locked.	Important: After you lock an Inspection record, you cannot unlock it. When an Inspection record is locked, all fields except for the following fields will be disabled: Inspection Document Status Inspection Lock Reviewers Name Reviewers Comments Final Inspection Lock Published After the Inspection record is locked, you can flag it for approval using the Inspection Document Status field. You can lock an Inspection record only if the Inspection Report Owner field contains the first and last name associated with your Security User account.
Inspection Reference	Character	A value used to identify the Inspection record.	This value is generated automatically by the Meridium Enterprise APM System.
Inspection Report Owner	Character	The first and last name of the Meridium Enterprise APM Security User who performed the inspection.	This field contains a list of Security Users who have been assigned the Inspector role. When you create the Inspection record, you will need to select the name of the Meridium Enterprise APM Security User who performed the inspection.
Inspection Start Date	Date	The date on which the inspection began.	This field is populated automatically by the Meridium Enterprise APM system; however, you can modify the date by selecting .
Inspection Summary	Text	A summary of the inspection.	You can specify a value for this field using the datasheet.
Inspection Task Complete	Logical	Indicates whether or not the Inspection record is closed and the associated Task records have been updated. When this field is set to True, the Inspection record is closed.	This field appears on datasheets configured for Inspection families whose caption does not contain the word Checklist. When you close an Inspection record: The value in the Completion Date field will be used to populate the Last Date field in the Task record. A Task Execution record will be created automatically and linked to the Inspection and Inspection Task records. The value in the Date Executed field in the Task Execution record will be set automatically to the date on which the Inspection record was closed.
Leak Category	Character	The type of leak that is associated with the PRD.	On the datasheet, this field appears as list that contains the following values: Minor Moderate Stuck Open This list is populated with the descriptions of the System Codes stored in the MI INSPECTION LEAK CATEGORY (Inspection Leak Category) System Code Table. This field is enabled and can retain a value only when the Leak Test Results field contains the value Leak.
Leak Test Results	Character	Indicates whether or not there was a leak detected on the PRD during the inspection.	On the datasheet, this field appears as a list that contains the following values: No Leak Leak This list is populated with the descriptions of referenced System Codes for the MI INSP RESULTS LEAK System Code that is stored in the System Code Table with the ID MI RBI REFERENCES.
No. of Gauges Used	Number	The total number of gauges used by a piece of equipment.	You can specify a value for this field using the datasheet.
Published	Logical	Indicates whether or not the Inspection Document is published.
Over Pressure Test Results	Character	Indicates whether or not the PRD passed the Pressure Test that you performed during the inspection.	On the datasheet, this field appears as a list that contains the following values: Pass Fail This list is populated with the descriptions of referenced System Codes for the MI INSP RESULTS OVER PRESSURE System Code that is stored in the System Code Table with the ID MI RBI REFERENCES.
Percentage Heat Transfer Area Loss	Number	The percentage of the area of the tube bundle that will experience heat transfer loss due to plugged tubes.	This value is calculated using the following formula: Percentage Heat Transfer Area Loss = (Total Number of Tubes Plugged At Inspection End / Total Number of Tubes In Bundle) x 100
Published	Logical	Indicates whether or not the Inspection Document is published.
Reason for Inspection	Text	The inspector's comments about why the inspection was performed	You can specify a value for this field using the datasheet.
Reviewers Comments	Text	The reviewer's comments about the Inspection Document.	You can specify a value for this field using the datasheet. Note: This field does not apply to Third Party Damage.
Reviewers Name	Character	The first and last name of the Meridium Enterprise APM Security User that is responsible for reviewing the Inspection Document.	This field contains a list of Security Users who have been assigned the Inspection Supervisor role. When you create the Inspection record, you should specify in this field the Security User who will be responsible for reviewing the Inspection record.
Scope	Text	The recommended scope for this type of inspection.	This field displays a value based on the value that you selected in the Type of Inspection field, the value that you selected in the Extent field, and the values that exist in the Recommended Inspection Scope field in Inspection Strategy records. The Scope field displays the value that exists in the Recommended Inspection Scope field in all Inspection Strategy records whose: Inspection Task Type field contains the value that you selected in the Type of Inspection field. Inspection Extent field contains the value that you selected in the Extent field.
SRV Set Pressure	Text	The pressure at which the test is set.	You can specify a value for this field using the datasheet.
Tasks Addressed	Character	The tasks that are addressed by the inspection.	You can select Task records associated with the Inspection record from the list of Task Record IDs when you open an existing Inspection record: Defined for a family whose caption includes the word Checklist in the Tasks Addressed list. Defined for a family whose caption does not include the word Checklist in the Tasks Addressed list in the Inspection datasheet.
Test Comments	Text	The inspector's comments about the performed test.	You can specify a value for this field using the datasheet.
Test Duration	Number	The length of time pressure was held.	You can specify a value for this field using the datasheet.
Test Media	Text	The liquid or gas used to perform the Pressure Test.	You can specify a value for this field using the datasheet.
Test Media Temperature	Number	Temperature of the test media used.	You can specify a value for this field using the datasheet.
Test Pressure	Number	Pressure at which the test was performed.	You can specify a value for this field using the datasheet.
Total Number of Tubes in Bundle	Number	The number of tubes in the tube bundle.	This value is used to calculate the value in the Percentage Heat Transfer Area Loss field. By default, this field contains the value 0 (zero). If you enter a value in this field, save the record, and then modify the value, the following fields will be populated with the value 0 (zero), because if you modify the value in the Total Number Of Tubes In Bundle field after saving the record, you should re-enter values in these fields: Tubes Plugged at Inspection Start Tubes (Plugged At Start) Replaced Tubes Plugged During This Inspection Tubes (Not Previously Plugged) Replaced Total Number of Tubes Replaced at Inspection End The value in this field must be greater than or equal to the: Value in the Tubes Plugged at Inspection Start field. Value in the Tubes Plugged During This Inspection field. Sum of the values in the Tubes Plugged At Inspection Start and Tubes Plugged During This Inspection
Total Number of Tubes Plugged at Inspection End	Number	The number of tubes in the tube bundle that were plugged at the end of the inspection	This field is populated based upon the following values: Tubes Plugged at Inspection Start Tubes Plugged During Inspection Tubes (Plugged At Start) Replaced Depending upon which of these fields contain values, this field is populated as follows: If only the Tubes Plugged At Inspection Start and Tubes Plugged During Inspection field contains a value, the Total Number of Tubes Plugged At Inspection End field is populated with that value. If the Tubes Plugged At Inspection Start and fields contain values, the Total Number of Tubes Plugged At Inspection End field is populated with the sum of these values. If all three fields contain values, the Total Number of Tubes Plugged At Inspection End field is populated with the sum of the values in the Tubes Plugged At Inspection Start and Tubes Plugged During Inspection minus the value in the Tubes (Plugged At Start) Replaced field. This field is disabled when the Action This Inspection field contains a value.
Total Number of Tubes Replaced at Inspection End	Number	The total number of tubes in the tube bundle that have been replaced at the end of a given inspection.	By default, this field contains the value 0 (zero). This field is disabled when the Action This Inspection field contains a value. When the Action This Inspection field contains the value: Partial Retube (PARTIAL RETUBE), this field is populated with the sum of the values in the Tubes (Plugged At Start) Replaced and Tubes (Not Previously Plugged) Replaced fields. If only one of these fields contains a value, the Total Number of Tubes Replaced at Inspection End field is populated with that value. Bundle Replaced (BUNDLE REPLACED) or Total Retube (TOTAL RETUBE), this field is populated with the value in the Total Number of Tubes In Bundle field. Tubes Plugged (TUBES PLUGGED) or No Action (NO ACTION), this field is populated with the value 0 (zero).
Tubes (Not Previously Plugged) Replaced	Number	The number of tubes in the tube bundle that were not plugged before the inspection started but were plugged in during the inspection.
Tubes (Plugged At Start) Replaced	Number	The number of tubes in the tube bundle that were plugged before the inspection started but were replaced during the inspection.	This field is enabled only when the value in the Action This Inspection field is Partial Retube (PARTIAL RETUBE). This value must be less than or equal to the value in the Tubes Plugged At Inspection Start field. By default, this field contains the value 0 (zero).
Tubes Plugged at Inspection Start	Number	The number of tubes in the tube bundle that were not plugged before the inspection started but were replaced during the inspection.	This field is enabled only when the value in the Action This Inspection field is Partial Retube (PARTIAL RETUBE). By default, this field contains the value 0 (zero).
Tubes Plugged During This Inspection	Number	The number of tubes in the tube bundle that were plugged during the inspection.	This field is enabled only when the Action This Inspection field contains a value other than No Action (NO ACTION). By default, this field contains the value 0 (zero). The value in this field must be less than or equal to the value in the Total Number Of Tubes In Bundle field. When the value in the Action This Inspection field is Bundle Replaced (BUNDLE REPLACED), this field is populated with the value 0 (zero).
Tubes Plugged in at Inspection Start	Number	The number of tubes in the tube bundle that were plugged before the inspection started.	By default, this field contains the value 0 (zero). The value in this field must be: Greater than or equal to the value in the Tubes (Plugged At Start) Replaced field. Less than or equal to the value in the Total Number Of Tubes In Bundle field. This value is used to calculate the value in the Percentage Heat Transfer Area Loss field.
Type of Inspection	Character	The type of inspection that was performed.	This field displays a list of values stored in the Task Type ID field in Task Types records whose Reference field contains the value INSPECTION STRATEGY. The values that appear in this list depend on the type of Inspection record that you are viewing. For Inspection records belonging to: The PRD Pop Test Checklist subfamily, the values in this list are populated using the System Code Table MI PRD INSPECTION TYPE FILTER (PRD Inspection Type Filter). Any Inspection subfamily except the PRD Pop Test Checklist subfamily, this list is populated with the Task Type ID value in each Task Types record that does not correspond to a value in the System Code Table MI PRD INSPECTION TYPE FILTER (PRD Inspection Type Filter).
Witnessed By	Character	The first and last name of the Meridium Enterprise APM Security User who witnessed the test.