Catalog Items | On-Premises APM

Config Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Config Queries contains the following items.


Query	Behavior and Usage
Asset Query	This query is used to identify the records that store information about pieces of equipment for which you perform inspections. In the baseline database, this query returns a count of all Equipment records with the Entity Key specified in the query prompt (i.e., one or zero).
Base Summary Query	Used by the Inspection History Summary Query.
Inspection History Summary Query	Returns a list of all Inspection records that are linked to a certain Equipment or Functional Location record. This query uses the Base Summary Query to determine the Entity Key of the Equipment or Functional Location record.
Published Documents	Returns a list of all Inspection records whose Published fields are set to true. This query contains a Load Inspection hyperlink that lets you open Inspection records in the Record Manager.
Published Documents by Asset	This query returns the same results as the Published Documents query; however, this query contains a prompt on the Asset Key field in the Inspection record.
User Key for HR Key	Returns the Entity Key of each Security User record and the Entity Key of each Human Resource record to which that Security User record is linked. This query exists simply to support the workflow facilitated by the following queries, which exist in the Review Queries folder: Bundle Inspections for Review for Current User - Choose State Bundle Inspections Pending Approval for Current User Full Inspections for Review for Current User - Choose State Full Inspections Pending Approval for Current User General Inspections for Review for Current User - Choose State General Inspections Pending Approval for Current User Pressure Inspections Pending Approval for Current User Pressure Test Inspections for Review for Current User - Choose State

Inspection Task Related Families Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Inspection Task Related Families contains the following queries:


Query	Behaviour and Usage	Required Fields
MI_CONFMATN	Returns a list of Task Confirmations for an Inspection Task. This query is used to display results in the Related Records section of the Inspection Task.	pred_key (Inspection Task Key)
MI_TASKEXEC	Returns a list of Task Executions for an Inspection Task. This query is used to display results in the Related Records section of the Inspection Task.	pred_key (Inspection Task Key)

Overview Charts Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Overview Charts contains the following items.


Graph Name	Behavior and Usage
Open Recommendations by Asset	This graph shows the number of open Recommendations for the selected Asset. It appears in the OPEN INSPECTION RECOMMENDATIONS BY ASSET section on the Inspection Management Overview page.
Task Types Coming Due Within the Year	This graph shows the number of Inspection Tasks of each type that must be completed in the current year. It appears in the TASK TYPES COMING DUE WITHIN THE YEAR section on the Inspection Management Overview page.

Overview Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Overview Queries contains queries that are used on the following pages:

The Inspection Management Overview page for the selected hierarchy level.
The Inspection Management Overview page for the selected asset.

The following table provides a list of queries that are used in the Inspection Management Overview page for the selected hierarchy level, 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 Management Overview page.


Query Name	Behavior and Usage	Required Fields
All Inspection Assets for Unit	Returns a list of assets with at least one Inspection or Inspection Task in the selected unit or underlying assets. This query is used to display results in the grid in the Inspection Assets section.	ENTY_KEY (Alias Name: ENTY_KEY)
All Inspections for Unit	Returns a list of Inspections performed on the selected Functional Location. This query is used to display results in the All Inspections for This Location subsection in the Underlying Inspections section.	ENTY_KEY (Alias Name: Inspection Entity Key) ENTY_ID (Alias Name: Inspection ID)
All Inspections for Unit and Below	Returns the count of Inspections performed on the selected Functional Location or underlying assets.	None
All Inspection Assets with Inspection Or Task for Unit	Returns a list of assets with at least one Inspection or Inspection Task. This query is used by the All Inspection Assets for Unit query.	None
All Tasks for Unit	Returns all Inspection Tasks performed on the assets in the unit.	ENTY_KEY (Alias Name: ENTY_KEY0)
Count of Task Types due Within the Year	Returns the number of Task Types that are due within the calendar year. This query is used in the graph in the TASK TYPES COMING DUE WITHIN THE YEAR section.	None
Inspection Overview Parameters	Returns the parameters used to navigate through the Asset Hierarchy.	All fields in the query
My Open Inspections	Returns a list of open Inspections assigned to you. This query is used to display results in the My Open Inspections subsection in the Underlying Inspections section.	ENTY_KEY (Alias Name: Inspection Entity Key) ENTY_ID (Alias Name: Inspection ID)
Open Inspection Recommendations by Asset	Returns the number of open Inspection Recommendations for each asset contained within the unit. This query is used in the graph in the OPEN INSPECTION RECOMMENDATIONS BY ASSET section.	None
Open Inspections for Unit	Returns a list of open Inspections for Equipment or Functional Locations contained within the unit based on their current assigned status. This query is used to display results in the Underlying Open Inspections subsection in the Underlying Inspections section.	ENTY_KEY (Alias Name: Inspection Entity Key) ENTY_ID (Alias Name: Inspection ID)
Open Recommendations for Asset	Returns a list of Inspection Recommendations for the given asset based on their current assigned status. This query is used to display results in the following sections: All Recommendations for this Location subsection in the Overdue Recommendations section Recommendation section in the Inspection Management Asset Overview page This query is used when the Use State Management for Inspection Recommendations check box in Application Settings is cleared.	ENTY_KEY (Alias Name: Inspection Entity Key) startDate endDate
Open Recommendations for Asset (State Management)	Returns a list of open Inspection Recommendations for the given asset based on their current assigned state. This query is used to display results in the following sections: All Recommendations for this Location subsection in the Overdue Recommendations section Recommendation section in the Inspection Management Asset Overview page This query is used when the Use State Management for Inspection Recommendations check box in Application Settings is selected.	ENTY_KEY (Alias Name: ENTY_KEY) startDate endDate
Open Inspection Recommendations for Unit	Returns a list of open Inspection Recommendations for assets within the unit based on their current assigned status and filtered by date. This query is used to display results in the Underlying Open Recommendations subsection in the Underlying Recommendations section. This query is used when the Use State Management for Inspection Recommendations check box in Application Settings is cleared.	ENTY_KEY (Alias Name: ENTY_KEY) startDate endDate
Open Inspection Recommendations for Unit (State Management)	Returns a list of open Inspection Recommendations that are associated with the asset and Functional Locations in the unit based on their current assigned state and filtered by date. This query is used to display results in the Underlying Open Recommendations subsection in the Underlying Recommendations section. This query is used when the Use State Management for Inspection Recommendations check box in Application Settings is selected.	ENTY_KEY (Alias Name: ENTY_KEY) startDate endDate
Overdue Inspection Recommendations for Unit	Returns a list of overdue Inspection Recommendations that are associated with the asset and Functional Locations in the unit based on their current assigned status and filtered by date. This query is used to display results in the Recommendations Due for Implementation subsection in the Underlying Recommendations section. This query is used when the Use State Management for Inspection Recommendations check box in Application Settings is cleared.	ENTY_KEY (Alias Name: Inspection Entity Key) startDate endDate
Overdue Inspection Recommendations for Unit (State Management)	Returns a list of overdue Inspection Recommendations that are associated with the asset and Functional Locations in the unit based on their current assigned state and filtered by date. This query is used to display results in the Recommendations Due for Implementation subsection in the Underlying Recommendations section. This query is used when the Use State Management for Inspection Recommendations check box in Application Settings is selected.	ENTY_KEY (Alias Name: ENTY_KEY) startDate endDate
Overdue Tasks for Unit	Returns a list of Inspection Tasks that are overdue and associated with the Equipment or Functional Locations in the unit. This query is used to display results in the Overdue Tasks subsection in the Inspection Tasks subsection.	ENTY_KEY (Alias Name: ENTY_KEY0)
Top-Level Work Packs	Returns a list of top-level Work Packs in APM. This query is used to display results in the Work Packs section.	Work Pack ID (Alias Name: Work Pack ID) ENTY_KEY (Alias Name: ENTY_KEY)
All Tasks for Unit	Returns all Inspection Tasks for this Functional Location.	ENTY_KEY (Alias Name: ENTY_KEY0) ENTY_KEY (Alias Name: ENTY_KEY) ENTY_ID (Alias Name: Task ID)

The following table provides a list of queries that are used on the Inspection Management Overview page for the selected asset.


Query Name	Behavior and Usage	Required Fields
All Inspections for Asset	Returns a list of Inspections performed on the selected asset. This query is used to display results in the Inspections section.	ENTY_KEY (Alias Name: Inspection Entity Key) ENTY_ID (Alias Name: Inspection ID)
All Health Evaluations for Asset	Returns a list of Health Evaluations for the selected assets. This query is used to display results in the Health Evaluations section.	PRED_ENTY_KEY (Alias Name: INSP_KEY) ENTY_KEY (Alias Name: HEALTH_EVAL_KEY) ENTY_ID (Alias Name: Inspection ID) MI_INSP_HLTH_EVL_ASSMNT_C (Alias Name: Health Assessment)
All Tasks for Asset	Returns a list of Inspection Tasks for the selected asset. This query is used to display results in the Inspection Tasks section.	ENTY_KEY (Alias Name: ENTY_KEY0)
Open Recommendations for Asset	Returns a list of Inspection Recommendations for the given asset. This query is used to display results in the Recommendations section.	ENTY_KEY (Alias Name: ENTY_KEY)
Top-Level Work Packs	Returns a list of top-level Work Packs in APM. This query is used to display results in the Work Packs section.	MI_WORKPACK_ID_C (Alias Name: Work Pack ID) ENTY_KEY (Alias Name: ENTY_KEY)

Report Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Report Queries contains the following items.


Query	Behavior and Usage
Checklist Report Query	Generates the report for an Inspection Document associated with a Checklists record.
MI Asset Corrosion Analysis	Generates information in the Asset Corrosion Analysis section of each main report.
MI Reference Document	Generates information in the Reference Documents section of each main report.
MI FIND CHECK	Generates information in the Checklist Findings section of a Checklist Inspection report.
MI FIND GEN	Generates information in the Findings section of each main report.
MI INSP GEN	Generates the report for a General Inspection Document.
MI INSPBSUB	Generates information in the Bundle Sub Inspections section of a Full Inspection report.
MI INSPBUND	Generates the report for a Bundle Inspection Document.
MI INSPFULL	Generates the report for a Full Inspection Document.
MI INSPPSUB	Generates the information in the Pressure Test Sub Inspections section of a Full and General Inspection report.
MI INSPPTST	Generates the report for a Pressure Test Inspection Document.
MI RECINSP	Generates the information in the Recommendations section of each main report.
MI TEAMINSP	Generates the information in the Inspection Team Members section of each main report.
MI_INSPHIST_RECINSP	Generates the information in the Recommendation History section of an Inspection History Report.

Reports and SSRS Reports

The Catalog folders \\Public\Meridium\Modules\Inspection\Reports and \\Public\Meridium\Modules\Inspection\SSRS contain the following items.


Report Name	Behavior and Usage
Asset Corrosion Analysis Report	Generates the SSRS report that provides a summary of the Asset Corrosion Analysis.
Blank Checklist Finding Report	Generates the sub-report for the Blank Checklist Inspection report. This sub-report provides blank entries for the Checklist Findings related to a particular Checklist Inspection.
Blank Checklist Inspection Report	Generates the SSRS report that provides blank entries for the Checklist Inspection and a blank section for the manual entry of Checklist Finding details.
Bundle Inspection Report	Generates the SSRS report that displays the number of tubes present in a bundle and the condition of the tubes.
Bundle Sub Inspection Report	Generates the SSRS report that provides details on bundle subinspections for the Bundle Inspection Report.
Checklist Findings Report	Generates the SSRS report that displays all of the Checklist Findings associated with a Checklist Inspection.
Checklist Inspection Report	Generates the SSRS report that provides a summary of Checklist Inspection data, Checklist Findings, and related sub-report data.
Finding Report	Generates the SSRS report that displays all the Findings for an Inspection.
Full Inspection Report	Generates the SSRS report that provides a summary of Findings, Bundle Inspection, Pressure Test, Recommendations, Inspection Team Members, and reference documents.
General Inspection Report	Generates the SSRS report that provides a summary of Findings, Bundle Inspection, Pressure Test, Recommendations, Inspection Team Members, and reference documents.
Inspection Recommendation Report	Generates the SSRS report that displays all recommendations that are associated with a given Inspection.
Inspection Team Member Report	Generates the SSRS report that displays all team members associated with an Inspection.
NR13 Full Inspection	Generates the SSRS report (NR13 Version) that provides a summary of Findings, Bundle Inspection, Pressure Test, Recommendations, Inspection Team Members, and reference documents.
NR13 General Inspection Report	Generates the SSRS report (NR13 Verison) that provides a summary of Findings, Bundle Inspection, Pressure Test, Recommendations, Inspection Team Members, and reference documents.
Pressure Test Inspection Report	Generates the SSRS report that displays results of a Pressure Test for Corrosion Analysis, Findings, and Recommendations, using subreports.
Pressure Test Sub Inspection Report	Generates the SSRS report that provides details on Pressure Test subinspections for the Pressure Test Inspection report.
Reference Document Report	Generates the SSRS report that displays a summary of all the reference documents that are associated with an Inspection.
Work Pack Inspection Findings Summary Report	Generates the Work Pack Inspection Findings Summary Report.
Work Pack Inspection Scope Summary Report	Generates the Work Pack Inspection Scope Summary Report.

Resource Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Resource Queries contains the following items.


Query	Behavior and Usage
All Human Resources	Returns a list of all the Human Resource records in the database. This query contains the following URL Fields: Manage Resource Roles (Field Alias: Manage Roles): Displays the Human Resource record in the master/detail datasheet. The detail grid lets you view and create Resource Role records that are linked to the Human Resource record. Manage Resource Certifications (Field Alias: Manage Certifications): Displays the Human Resource record in the master/detail datasheet. The detail grid lets you view and create Personnel Certification records that are linked to the Human Resource record.
Human Resources with Certification	Returns a list of Human Resource records that are linked to a Personnel Certification record. This query contains the following URL Field: Last Name: Displays the Human Resource Record in the master/detail datasheet. The detail grid lets you view and create Personnel Certification records that are linked to the Human Resource record.
Human Resources with Roles	Returns a list of Human Resource records that are linked to a Resource Role record. This query contains the following URL Field: Last Name: Displays the Human Resource Record in the master/detail datasheet. The detail grid lets you view and create Resource Role records that are linked to the Human Resource record.

Work Pack Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Work Pack Queries contains the following items:


Query Name	Behavior and Usage	Required Fields
Available Tasks for Work Pack	Returns a list of Tasks available for linkage to a Work Pack	ENTY_KEY (Alias Name: TASK_ENTY_KEY)
All Inspections in a Work Pack	Returns a list of Inspections linked to a given Work Pack	Inspection.ENTY_KEY (Alias Name: INSP_ENTY_KEY) Inspection.ENTY_ID (Alias Name: INSP_ID)
All related Work Packs	Returns a list of Work Packs linked to a given Work Pack	KEY ID LEVEL
All Tasks in a Work Pack	Returns a list of Inspection Tasks linked to a given Work Pack	ENTY_KEY (Alias Name: TASK_ENTY_KEY) MI_TASK_ID (Alias Name: TASK_ID) MI_TASK_INSP_INSPTYPE_FMLYID_C (Alias Name: INSP_DOC_TYPE) PRED_ENTY_KEY (Alias Name: ASSET_ENTY_KEY)