Reference

Offline Inspection Families

The following baseline Inspection families are available in Inspection Field Data Collection:

Family Caption

Related Families Enabled for Offline Forms

Offline Form Caption

API 510 External Checklist

None

API 510 External Checklist Offline Form

API 510 Internal Checklist None API 510 Internal Checklist Offline Form
API 510 Internal Exchanger Checklist None API 510 Internal Exchanger Checklist Offline Form
API 570 External Checklist None API 570 External Checklist Offline Form
API 653 External Checklist None API 653 External Checklist Offline Form
API 653 Internal Checklist None API 653 Internal Checklist Offline Form

Bundle Sub-Inspection

None

Bundle Sub-Inspection Offline Form

Checklist Finding

None

Checklist Finding Offline Form

External PRD Checklist None External PRD Checklist Offline Form

Full Inspection

Bundle Sub-Inspection, Pressure Test Sub-Inspection, General Finding

Full Inspection Offline Form

General Finding

None

General Finding Offline Form

General Inspection Pressure Test Sub-Inspection, General Finding General Inspection Offline Form
Inspection Recommendation None Inspection Recommendation

PRD Pop Test Checklist

None

PRD Pop Test Checklist Offline Form

Pressure Test Sub Inspection

None

Pressure Test Sub-Inspection Offline Form

Field Behavior for Offline Inspections

In order for any field to work in offline forms, baseline behaviors are defined for required fields.

Important: If you have customized any of the following behaviors in previous versions of APM, then your customizations will be overwritten with the offline baseline behaviors listed below.

Offline Family

Field Caption

Field Behavior

Resulting Offline Behavior

Bundle Inspection

Action This Inspection

Default Value

The literal value NO ACTION.

Valid Value

Populated by the MI BUNDLE ACTION System Code and Table.

Bundle Type

Valid Value

Populated by the MI BUNDLE TYPE System Code and Table.

Total Number of Tubes in Bundle

Default Value

The literal value 0.

Tubes Plugged During This Inspection

Default Value

The literal value 0.

Tubes (Plugged At Start) Replaced

Default Value

The literal value 0.

Tubes Plugged at Inspection Start

Default Value

The literal value 0.

Tubes (Not Previously Plugged) Replaced

Default Value

The literal value 0.

Checklist Finding

Action Taken Code

Default Value

The literal value NONE.

Valid Value

Populated by the FROM MI ACTION System Code and Table where the value in the MI INSPECTION REFERENCES field equals INSPECTION FINDING ACTION.

Deterioration Mechanism

Valid Value

Populated by the MI DAMAGE MECHANISM System Code and Table.

Deterioration Mode

Valid Value

Populated by the MI DAMAGE MODE System Code and Table.

Type

 

Default Value

The literal value OBSERVATION.

Valid Value

Populated by the MI FINDING TYPE System Code and Table.

Inspection

Asset ID

Disable Value

Always disabled.

Equipment Operating State

Valid Value

Populated by the FROM MI EQUIP OP STATE System Code and Table where the value in the MI INSPECTION REFERENCES field equals INSPECTION EQUIPMENT STATE.

Functional Location ID

Disable Value

Always disabled.

Inspection Recommendation Asset ID Disable ValueAlways disabled.
Functional Location ID Disable ValueAlways disabled.
Recommendation ID Disable ValueAlways disabled.
Target Completion Date RequiredAlways required.

PRD Pop Test Checklist

As Found Pop Pressure

Validation

Greater than or equal to 0.

As Left Pop Pressure

Validation

Greater than or equal to 0.

Design Set Pressure

Validation

Greater than or equal to 0.

Leak Category

Valid Value

Populated by the MI INSPECTION LEAK CATEGORY System Code and Table.

Leak Test Results

Valid Value

Populated by the FROM MI INSPECTION RESULT System Code and Table where the value in the MI RBI REFERENCES field equals MI INSP RESULTS LEAK.

Over Pressure Test Results

Valid Value

Populated by the FROM MI INSPECTION RESULT where the value in the MI RBI REFERENCES field equals MI INSP RESULTS OVER PRESSURE.

Test Media (Shell)

Valid Value

Populated by the MI TEST MEDIA System Code and Table.

Test Media (Tube)

Valid Value

Populated by the MI TEST MEDIA System Code and Table.

Inspection Field Data Collection URLs

There is one URL route associated with Inspection Field Data Collection: im/offline. The following table describes the various paths that build on the route, and the elements that you can specify for each.

ElementDescriptionAccepted Value(s)Notes

im/offline/overview: Displays the Inspection Field Collection page.

im/offline/form/<FormFamilyKey>/inspection/<InspectionEntityKey>: Displays the offline Inspection Details section for the selected inspection.

<FormFamilyKey> Specifies the Offline Inspection Form that you want to view. Any related Form Family Key. N/A
<InspectionEntityKey> Specifies the Inspection for which you want to view information.Any related Inspection Entity Key. N/A

Example URL

Example URLDestination
im/offline/form/2052484/inspection/3221525 The offline Inspection Details section of the inspection.

Overview Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Overview Queries contains queries that are used on the Inspection Field Data Collection Overview page.

The following table provides a list of queries that are used on the Inspection Field Data Collection Overview page along with a list of required fields and their alias names for each query.

Important: The queries in the table below may have one or more required fields or parameters. When using the queries:
  • Do not remove the required fields from a query.
  • Do not change the alias of the required fields.
  • Do not modify the order of required fields.
  • Do not modify the IDs of the query parameters.
If you do so, you cannot perform certain operations in the Inspection Field Data Collection Overview page.
Query NameBehavior and Usage Required Fields
All Downloaded InspectionsReturns a list of inspections which are currently downloaded for Inspection Field Data Collection.ENTY_KEY (Alias Name: ENTY_KEY)
User Downloaded Inspections

Returns a list of open inspections where the current user is the Inspection Report Owner or Inspection Report Reviewer.

This query is used to display results in the My Open Inspections section of the Inspection Field Data Collection Overview page.

ENTY_KEY (Alias Name: Inspection Entity Key

MI_INSP_001_LOCK_INSP_L (Alias Name: Inspection Lock)

MI_INSP_001_DWNLDED_F (Alias Name: Downloaded)

User Downloaded Inspections (including team members)

Returns a list of open inspections where the current user is the Inspection Report Owner, Inspection Report Reviewer, or a member of the team assigned to the Inspection Report.

This query can be used to display results in the My Open Inspections section of the Inspection Field Data Collection Overview page by copying the SQL code from the query editor into the query located at \\Public\Meridium\Modules\Inspection\Overview Queries\Users Downloaded Inspections.

ENTY_KEY (Alias Name: Inspection Entity Key

MI_INSP_001_LOCK_INSP_L (Alias Name: Inspection Lock)

MI_INSP_001_DWNLDED_F (Alias Name: Downloaded)