vail-plant pims user manual

7/17/2019 VAIL-Plant PIMS User Manual

http://slidepdf.com/reader/full/vail-plant-pims-user-manual 1/87

VAIL-PLANT

(RBI & INTEGRITY M ANAGEMENT SYSTEM)

VAIL-Plant® Version 14.8.14.1

ONSHORE PIPELINE INTEGRITY M ANAGEMENT SYSTEM

(PIMS ONSHORE)

M ANUAL

Engineering For a Safer World



VAIL-Plant v 14.8.14.1, PIMS Onshore Manual

Prepared by : Amee Trivedi Reviewed by: Gulzar Ahmad of 87

Approved by : Shahid Javed Kalair Date : April 2015 Revision : 1.4

2

Table of Contents

1 PURPOSE ............................................................................................................................... 4

2 SOFTWARE SUPPORT ........................................................................................................ 5

3 SYSTEM REQUIREMENTS ................................................................................................. 6

3.1 Application Software Requirements ............................................................................... 6

3.2 Hardware Requirements .................................................................................................. 7

4 SOFTWARE INSTALLATION ............................................................................................. 8

5 SOFTWARE STARTUP ........................................................................................................ 8

5.1 Startup ............................................................................................................................. 8

5.1.1 Trial & License ......................................................................................................... 9

5.1.2 User Login .............................................................................................................. 10

5.2

Dashboard ..................................................................................................................... 11

6 User Interface ........................................................................................................................ 12

6.1 Button Ribbon Functions .............................................................................................. 13

6.1.1 PIMS Off (Offshore Pipeline Integrity Management System) ............................... 14

6.1.2 PIMS On (Onshore Pipeline Integrity Management System) ................................. 14

6.1.3 COMPANY Button ................................................................................................. 14

6.1.4 LOG OFF Button .................................................................................................... 14

6.1.5 CLOSE Button ........................................................................................................ 14

6.2 User Details ................................................................................................................... 14

6.3 Navigation Bar .............................................................................................................. 15

6.4 Navigation Control (Tree View) ................................................................................... 16

6.5

Views Navigator ........................................................................................................... 17

7 PIMS Onshore Module (Pipeline Integrity Management System) ....................................... 18

7.1 PIMS Form View .......................................................................................................... 18

7.1.1 Toolbar .................................................................................................................... 18

7.1.1.1 Drawings ...........................................................................................................19

7.1.1.2 New button .......................................................................................................21

7.1.1.3 Save Button.......................................................................................................25

7.1.1.4 Edit Button ........................................................................................................25

7.1.1.5 Delete Button ....................................................................................................25

7.1.1.6 Drop Button ......................................................................................................26

7.1.2 Record Navigator .................................................................................................... 26

7.1.3

Form View Tabs ..................................................................................................... 27

7.1.3.1 Pipeline Data.....................................................................................................27

7.1.3.1.1 Pipeline Description .................................................................................... 28

7.1.3.1.2 Basic Data ................................................................................................... 28

7.1.3.1.3 Operational Data ......................................................................................... 29

7.1.3.1.4 Profiles ........................................................................................................ 31

7.1.3.1.5 UTM ............................................................................................................ 32

7.1.3.1.6 Pipeline Layouts .......................................................................................... 33






3

7.1.3.2 History/ Survey Records Tab ...........................................................................35

7.1.3.3 Inspection Results .............................................................................................37

7.1.3.4

Defect Assessment ............................................................................................41 7.1.3.5 Survey Assessment ...........................................................................................48

7.1.3.6 Condition Assessment ......................................................................................49

7.1.3.7 Pipeline Assessment .........................................................................................51

7.1.4 Integrity Operating Windows (IOWs) .................................................................... 61

7.1.5 Inspection Plan ........................................................................................................ 62

7.1.6 GIS (Geographical Information System) ................................................................ 63

7.2 PIMS LIST VIEW ........................................................................................................ 64

7.2.1 Grid Header ............................................................................................................. 66

7.2.2 Sorting Upward ....................................................................................................... 66

7.2.3 Sorting Downward .................................................................................................. 67

7.2.4

Records Filtering ..................................................................................................... 67

7.2.5 Exporting to Excel .................................................................................................. 68

7.2.6 List View Page Navigation Buttons ........................................................................ 69

7.2.7 List View’s Buttons in the Navigation Bar ............................................................. 70

7.2.7.1 Pipeline Data.....................................................................................................70

7.2.7.2 History/Survey Records ....................................................................................71

7.2.7.3 Inspection Plan .................................................................................................71

7.2.7.4 Defect Assessment ............................................................................................72

7.2.7.5 Pipeline Assessment .........................................................................................72

7.3 PIMS REPORT VIEW ................................................................................................. 73

7.4 PIMS USER LIST VIEW ............................................................................................. 77

7.4.1

How to create a new query? .................................................................................... 78

7.4.2 How to delete an existing query? ............................................................................ 82

7.4.3 How to export the results to excel file? .................................................................. 82

7.5 PIMS REFERENCE DOCUMENTS ........................................................................... 83






4

1 PURPOSE

The purpose of this document is to present a clear and concise procedural outline for using PIMS

Onshore module of VAIL-Plant version 14.8.14.1 so that the user may be able to utilize all its

features. We have listed step-wise procedures for performing tasks along with screenshots to aid

practical understanding.

This document details the methods of using features of the module such as viewing, searching

and updating pipeline data like pipeline description, basic data, operational data, pipeline profiles

and pipeline layouts etc. Enlisted below are the main features of the software which are

elaborated within this document:-

Pipeline data (pipeline description, basic data, operational data, profiles and layout etc.)

Survey records

Inspection records

Defect assessment

Condition assessment

Risk assessment

Component assessment

Inspection planning

Reporting

Reference documents

It is assumed that the operator is familiar with MS Windows, MS Office and so this is not

covered in this document.






5

2 SOFTWARE SUPPORT

Users can contact VELOSI for software support on technical issues about VAIL-Plant using the

below details.

There is a dedicated email ID for attending to all support related queries and issues.

Email ID: [email protected]

Office Address:

VELOSI ASSET INTEGRITY LIMITED,

Marina Plaza Building, Suite No. 402,

P.O. Box: 114192,

Abu Dhabi (UAE)

Website: www.velosi.com

Telephone: +971 2 6349815

Fax: +971 2 6349816






6

3 SYSTEM REQUIREMENTS

This section details the system requirements on both the server and client sides in order to run VAIL-

Plant.

3.1 Application Software Requirements

There are two different options for deploying VAIL-Plant on the server and client. Both options

have been detailed below:

1) VAIL-Plant installed on server

For this option, the VAIL-Plant Application software will be installed on a Server and the clientmachines will run this installation from a shortcut to a network drive.

Server Side Software Requirements

VAIL-Plant application

SQL Server 2005 Express Edition or Above

Microsoft Windows Server 2003 or above

Microsoft Chart Controls 3.5.0 or higher

Crystal Reports 10.0

Microsoft office package 2003 or higher as utility for data exporting and reporting purposes

Client Side Software Requirements

Microsoft Windows XP (Service Pack 2), Vista or 7

Microsoft .Net Framework 3.5 or above

Microsoft Charts

2) VAIL-Plant installed on each PC

For this option, the VAIL-Plant Application software will be installed on each client machine.

Server Side Requirements

SQL Server 2005 EE OR Above

Microsoft Windows Server 2000 or above

Client Side Requirements






7

Microsoft Windows XP (Service Pack 2), Vista or 7

Microsoft office package as utility for data exporting and reporting purposes

Microsoft .Net Framework 3.5 or above

VAIL-Plant application

Microsoft Chart Controls 3.5.0 or higher

Crystal Reports 10.0

Microsoft office package 2003 or higher as utility for data exporting and reporting purposes

3.2 Hardware Requirements Application Hardware Requirements

Below are the minimum hardware requirements for running VAIL-Plant application:

Pentium class processor, 2.1 GHz (recommend Core i3 Class)

1 GB Available RAM (recommended 2 GB)

1 GB hard drive space minimum on installation drive (recommended 50 GB)

Database Hardware Requirements

The VAIL-Plant Database will store a lot of information, and will increase in time. Attached

documents can be stored within the Database using BLOB and CLOB fields. They can also be

stored out-with the database. If storing documents in the Database, the size of that Database is

likely to increase considerably. Therefore, it is impossible to determine exactly how much hard

drive space would be required for VAIL-Plant Database. It is recommended to store out-with the

database to attain good performance from database. The information below is only a rough

guide.

At least 8GB hard drive space






8

4 SOFTWARE INSTALLATION

Software installation instructions are provided in the VAIL-Plant Installation Manual Revision

1.3. In this manual, we consider that the software has been successfully installed using the

information provided in the Installation Manual. The installation places one shortcut on the

user’s desktop as well as two menu items in the program menu.

5 SOFTWARE STARTUP

5.1 Startup

The software can be started using either of two methods:

1) The VAIL-Plant Installation shortcut on desktop

Figure 5-1 VAIL-Plant Desktop Shortcut

The desktop shortcut of the VAIL-Plant Installation is the easiest method to start VAIL-

Plant. Double click the icon highlighted in the above screenshot to start the application.

2) The VAIL-Plant Installation shortcut from the program menuClick the Start icon and select “All Programs”. Go to the folder named “VAIL-Plant”. On

clicking this folder, an icon of VAIL-Plant application shall appear. Click once on the

icon in order to start the application. The figure below illustrates the shortcut icon for

Windows 7.






9

Figure 5-2 Program Menu VAIL-Plant Shortcut

When running the software for the first time, the user will be prompted to complete

license validation before activating the software. This is described below.

5.1.1 Trial & License

The first time a user logs in to VAIL-Plant using the screen in figure 5-4, the screen shown in the

screenshot below shall be displayed. A 12-digit serial key (unique to the user’s computer) is

displayed in the grid. The user must provide this 12-digit key to VELOSI at the email address-

[email protected] or by calling +971 2 6349815. VELOSI will revert with an activation

key for the activation of the software. The user must enter this activation key (serial number)

under the “License Key” heading. Then the user must click on “Save” and then “Close” to save

the license setting. The user will be directed to the Login screen of figure 5-4 again and user

must click “OK” to proceed with login.






10

Figure 5-3 One time License validation at first log in

5.1.2 User Login

Figure 5-4 Login screen






11

The user will be prompted to perform the above step only once, but every time he/she starts

VAIL-Plant®, a login screen, as shown in the above screenshot will be displayed prompting for

Username and Password. User must select an appropriate system name from the “System”

dropdown as guided by the administrator. A valid username and password will be required for

login. These will be provided by the administrator.

5.2 Dashboard

Successful login gives way to the VAIL-Plant®

dashboard as shown in the figure below. All

these modules are also located on a ribbon and are accessible from every screen of VAIL-

Plant®

. User shall be able to click on only limited icons, based on the settings configured by theadministrator for the assigned user group. The rest of the icons shall be inactive. On the

dashboard, an active module icon is one whose border turns black in color when you place your

mouse over it. Clicking the PIMS icon opens up the PIMS module.

Figure 5-5 Dashboard






12

6 User Interface

The purpose of this section is to provide the user familiarity with the user interface of the

software, its usability, its operation and its capability. The elements of the user interface

described in this section are common to most modules. These elements are:

Button Ribbon Navigation Bar Toolbar

Navigation Control (Tree View) User Details Records Navigator

Figure 6-1 VAIL-Plant Main Screen

VAIL-Plant software application is designed in the same basic layout. At the top left corner of

main application interface is the name ‘VAIL-Plant’. A ribbon is at the top containing different

modules of VAIL-Plant. This ribbon is fixed and access of its buttons is based on user’s access /

permissions level. When user clicks on any of the modules from the Ribbon, that module loads.

The bottom right corner shows the user login and time details.

NavigationBar

NavigationControl

(Tree View) Toolbar

ButtonRibbon

View

Navigator

UserDetails

Record Navigator






13

6.1 Button Ribbon Functions

Ribbon functions are:-

Pressurized Equipment Management System (PEMS)

Structure Integrity Management System (SIMS)

Pressure Safety Valve & relief Valve Management System (PSVMS)

Lifting Equipment Management System (LEMS)

Onshore Pipeline Integrity Management System (PIMS On) and/or Offshore Pipeline

Integrity Management System (PIMS Off)

Miscellaneous Equipment Management System (MEMS)

Civil Inspection Management System (CIMS)

Electrical, Instrumental and Rotary Management System (EIRMS)

Hull Integrity Management System (HIMS)

Wellhead Integrity Management System (WHIMS)

Cathodic Protection Condition Evaluation System (CPMS)

Inspection Scheduling & Management System (ISMS)

Facility Status Integrity Report (FSIR)

Company

Log Off

Close

VAIL-Plant Button Ribbon

Figure 6-2 Button Ribbon






14

6.1.1 PIMS Off (Offshore Pipeline Integrity Management System)

Offshore PIMS module is accessed via the PIMS (Off) icon in the ribbon. PIMS module

manages the information of offshore pipelines, so that it is named as Pipeline Integrity

Management System.

6.1.2 PIMS On (Onshore Pipeline Integrity Management System)

Onshore PIMS module is accessed via the PIMS (On) icon in the ribbon. PIMS module manages

the information of onshore pipelines, so that it is named as Pipeline Integrity Management

System.

6.1.3 COMPANY Button

COMPANY setting form is accessed via the Company icon in the ribbon. Company form

provides the information of a company which will use VAIL-Plant and administrator can edit or

update this information according to his company profile.

6.1.4 LOG OFF Button

User can log-off application by clicking on the Log-Off button icon in the ribbon. Clicking this

button will return user to the login screen.

6.1.5 CLOSE Button

VAIL-Plant can be closed by clicking on the CLOSE button icon in the ribbon.

6.2 User Details

The bottom right corner shows the username with which the

user logged into the software. This username is based on

their roles and responsibilities. It also shows the login time. Figure 6-3 User Details






15

6.3 Navigation Bar

The Navigation bar is situated in the left side of the interface. The purpose

of this Navigation bar is to provide the different data views of record

navigation i.e. Form View, List View, Report View and User List View to

the user. Providing different data views to the user, user can achieve the

maximum level of accessibility, fastest level of search ability and effective

level of report ability of records. Navigation bar has the following data

views and each view has described in this section:-

a) Form View (default view)

b) List View

c) Report View

d) User List View

e) Reference Documents

Figure 6-4

Navigation Bar






16

6.4 Navigation Control (Tree View)

The Navigation Tree is situated just right to the Navigation Bar.

The navigation tree is the primary method to navigate through the

data records. VAIL-Plant®

Navigation tree hierarchy is organized

in the following way:-

Company-Location-Area-Pipeline ID

Level 1: Company Node

The root node is a company node. Company node shows the

company name as defined by company’s administrator. Single

click filters the forms records according to the company and

double click or click on the plus sign (collapse icon), navigates

down the navigation tree.

Level 2: Location Node

The node at level two is the location node. It shows the locations of

the pipelines as defined by company’s administrator. For example,

offshore and onshore pipelines are differentiated by their location.

Single click filters the forms records according to the company’s

location and double click or click on the plus sign (collapse icon),

navigates down the navigation tree.

Level 3: Area Node

The node at level three is the area node. Area node shows the area name within a company name

as defined by company’s administrator. Single click filters the forms records according to the

company’s area, loading the records in the “Views Navigator” which can be browsed using the

buttons of the record navigator. Double click or click on the plus sign (collapse icon), navigates

down the navigation tree.

Level 4: Pipeline ID Node

The node at level four is the Pipeline ID node. This node shows the identification number of the

pipeline. For example, if there are three pipelines with ID P1, P2 and P3 in the area A1 at

Figure 6-5 Navigation

Control (Tree View)






17

onshore location of company C1, then the Pipeline ID node contains the elements P1, P2 and P3.

Single click filters the forms records according to the Pipeline ID and double click or click on the

plus sign (collapse icon), navigates down the navigation tree.

6.5 Views Navigator

The view navigator is situated just right of the Navigation Tree. User can select a view by just

clicking the view button in the Navigation Bar and this selected view appears in the views

navigator. The default view is the Form View when a module loads. There are following views

shown by views navigator, as described already in the section describing Navigation Bar.

a) Form View (default view)

b) List View

c) Report View

d) User List View

e) Reference Documents

Figure 6-6 Views Navigator

View Navigator






18

7 PIMS Onshore Module (Pipeline Integrity Management System)

7.1 PIMS Form View

This is the default view when the PIMS module is started.

7.1.1 Toolbar

Figure 7-2 Toolbar

The Form View toolbar is situated top-right corner in the Form View. The toolbar contains the

following buttons and features:-

1. Drawings – Enables adding and viewing of drawings and documents to assets.

2. New – Enables adding of a new component.

3. Save – Enables saving the addition or update of a component.

4. Edit – Enables updating the information about a component.

Figure 7-1 PIMS Form View






19

5. Delete – Enables deleting a component.

6. Drop – Enables dropping any addition of newly added component or changes made to

an existing component.

7. Email – Opens up the default email application to send an email.

8. Download Template – Downloads the template for loading data into the system from

an excel file. The template will be saved in a location specified by the user.

7.1.1.1 Drawings

Drawings form is accessed via the Drawings icon on the toolbar. Drawings form allows user to

view and add multiple drawings under multiple categories (i.e. Sample Sketch, Isometrics, GA

drawings, Corrosion circuit drawings etc.) for each record.

a) View drawings

Figure 7-3 View Drawings






20

Drawings can be viewed by selecting “View drawings” tab. Multiple drawing files will be

displayed according to the selected drawing category. A drawing viewer in the right side displays

the selected drawing or file. User can view this selected file in full window by just clicking on

the “View in Separate Window” button.

b) Remove Drawings

Navigate to the component for which you want to remove a drawing. Click on the ‘Drawing’

button on the Form View Toolbar. Click the ‘View Drawings’ tab. Click the drawing you want to

remove to select it. Click the Delete button. You shall be prompted to confirm if you want to

remove the drawing. Then a message shall appear to report that the drawing was successfully

deleted.

c) Add drawings

Figure 7-4 Add Drawings

Drawings can be added by selecting “Add drawings” tab. By clicking on the “Browse” button

user can select the drawing or file to be added. You can only upload files in PDF format. A






21

drawing viewer in the right side displays the added drawing or file. “Add” button is used to save

drawing or file.

7.1.1.2 New button

New button accessed via “New” button icon on the toolbar. New button allows user to add new

record or new equipment in the database. Access of this button is only for those users, which

have the permission of insert or write new record. All read only fields will be editable after click

on this button.

When a user clicks on the new button, a dialogue box will appear as shown below.

Figure 7-6 Adding new Asset from Form or Excel Sheet

The button “Delete All Table Data” is used to clear all existing data in the system.

Option “Adding from Entry Form”: If the user clicks on the ‘Add new Record from Entry Form’,

a screen will appear as shown below with all blank fields. The fields marked yellow are read-

only fields. After entering data in all fields, user must click the “Save” button.

Figure 7-5 New Icon on toolbar






22

Figure 7-7 Adding new asset - starting with blank fields

Option “Loading from Excel”: If user selects this option, he may upload one or multiple records

at one time. For this, the record/s must be in the correct template in an excel file. This template is

included in the DVD with the name “PIMS_DataLoading_Template”. The application shall

verify whether the template is valid as well as if the records are valid before uploading them.

Once this option is selected, a dialog box opens as shown below shall appear allowing user to

select the excel file in the valid template from users hard disk.

Figure 7-8 Selecting excel file in valid template






23

On selecting the file, the below screen shall appear if the template is valid.

Figure 7-9 Excel File loading

Once the records are loaded, the below screen shall appear. This screen asks user to initiate

verification of the loaded records by the application.

Figure 7-10 Verifying loaded records

User must click the button “Verify Records before Uploading”. On doing this, the below screen

shall appear if the records are valid. This screen tells user that the data is verified. If the data is

not valid such as if text is present in a column where a number is expected, then the row with

incorrect data will be highlighted and an error message will be displayed to the user.






24

Figure 7-11 Data verified

On clicking “OK”, the below screen shall appear.

Figure 7-12 Uploading records after validation

User must click the “Upload to VAIL-Plant”. On doing this the application proceeds to load the

records. A dialog box indicating the status of the upload is shown to user such as “Successfully

loaded”. These records shall appear in the applicatio n as though they were manually uploaded.






25

7.1.1.3 Save Button

Save function is accessed via “Save” button icon on the toolbar. Save button allows user to save

new or edited records in the database. Access of this button is only for those users, who have the

permission to insert and edit.

By default all fields are read only and color is gray. When a user inserts or edits a record by

using “NEW” or “EDIT” button, all fields become editable and their color becomes white. After

clicking on the “SAVE” button, all fields go to their default mode.

Note: When SAVE button is enabled, the NEW, EDIT and DELETE buttons are disabled and

vice versa.

7.1.1.4 Edit Button

Edit function is accessed via the “Edit” button icon on the toolbar. Edit button allows user to edit

current record. Access of this button is only for those users, who have the permission to modify.

By default all fields are read only and their color is gray. When a user edits a record by using

“EDIT” button, all fields become editable and their color becomes white. After clicking on the

“SAVE” button all fields go to their default mode.

7.1.1.5 Delete Button

Delete function is accessed via the “Delete” button icon on the toolbar. Delete button allows user

to delete current record. Access of this button is only for those users, who have the permission to

delete records.

Figure 7-13 Save Icon

Figure 7-14 Edit icon






26

7.1.1.6 Drop Button

DROP function is accessed via “Drop” button icon on the toolbar. Drop button allows user to

drop or withdraw changes made through INSERT or EDIT command performed by the user on

current record. This feature is available only for that purpose, if the user changes his mind.

7.1.2 Record Navigator

Record Navigator is situated at the middle bottom in the Form View. Record Navigator shoes the

current record and the total number of records. With navigation buttons user can go to the first

record, last record, previous record and next record.

Figure 7-17 Record Navigator

First Button

By clicking on this button user can directly go to the first record.

Last Button

By clicking on this button user can directly go to the last record.

Figure 7-15 Delete Button

Figure 7-16 Drop Button

Figure 7-18 Record Navigator – First button






27

Previous Button

By clicking on this button user can go to the previous record.

Next Button

By clicking on this button user can go to the next record.

7.1.3 Form View Tabs

Form View tabs become visible/ invisible by clicking on the Form View button in the Navigation

bar. That’s why one tab is visible at a time in the Navigation bar. The purpose of these tabs is to

segregate the data for each record.

7.1.3.1 Pipeline Data

Velosi’s PIMS is based on the PODS (Pipeline Open Data Standard) data model. The pipeline

input data are stored in the VAIL-Plant Pipeline database (Microsoft SQL Server). The database

is enveloped by a security system and role-based access restrictions on pipelines and groups of

pipelines ensuring integrity of information.

The Main Data about the Pipeline Component is situated in the upper half of Form View. It

remains same on selection of any Form View tab from Form View’s button in the Navigation

bar. It shows the hierarchy data and risk of a current equipment or record.

Figure 7-19 Record Navigator - Last button

Fi ure 7-20 Record Navi ator - Previous button

Figure 7-21 Record Navigator - Next button






28

Figure 7-22 Pipeline Main Data

Additional information and description of the pipeline is included in sub tabs at the bottom of the

main pipeline data. These display additional vital information about the pipeline. Information

may be added/ edited to the fields in these sub tabs using the New, Edit, Delete and Drop buttons

on the toolbar. These sub tabs are:

7.1.3.1.1 Pipeline Description

It displays a description of the pipeline through fields like Summary, Description, Boundaries,

Design parameters and Interaction with other systems.

Figure 7-23 Pipeline Description

7.1.3.1.2 Basic Data

It displays details about the physical construction of the pipeline such as its dimensions (also

displayed as a part of main data), design, age, material, position, positioning system and coating

details.






29

Figure 7-24 Pipeline Basic Data

7.1.3.1.3 Operational Data

This sub tab further contains data organized under five sub tabs.

General: It contains general operational data about the pipeline grouped under the headings of

Service, Inspectability, Temperature and Pressure. It holds information such as the product that

the Pipeline carries, the density of the product at design, whether the interiors of the Pipeline can

be inspected etc.






30

Figure 7-25 Operational Data

Composition: It is divided into two grid views. The first contains a tabulated list of the products

carried by the Pipeline and the second grid contains a tabulation of the chemical composition of

each product. Each Grid view has two tabs: List View and Data Entry. The former displays data

while the latter is used to input data into the application.

Chemical Injection: It has a grid view that contains details of any chemicals injected into the

Pipeline for corrosion inhibition. It shows details about the type and description of the chemical,

its frequency of injection, exposure, Minimum and maximum values etc. The Grid view has two

tabs: List View and Data Entry. The former displays data while the latter is used to input data

into the application.

Monitoring: It has a grid view that contains monitoring of vital health parameters of the pipeline

such as its Corrosion rate, Metal Loss etc. It details the type and sub type of Inspection necessary

to be done along with the position and frequency at which Inspections must be carried out to






31

monitor the health of each of the parameters. The Grid view has two tabs: List View and Data

Entry. The former displays data while the latter is used to input data into the application.

Maintenance: Has a grid view that lists all maintenance tasks for the pipeline. Alongside each

task, it details the type, sub type, frequency and description of the task. The Grid view has two

tabs: List View and Data Entry. The former displays data while the latter is used to input data

into the application.

7.1.3.1.4 Profiles

Data profiles are pipeline parameters that varies along the pipeline (e.g. water depth, wallthickness, local pressure etc.). This tab contains the graphical representation of pipeline data. The

various parameters are displayed in a tree structure on the left. There is one Grid View which has

the data points relevant to the selected parameter from the tree. The bottom portion contains a

graph built from the data points entered in the grid. Users with the appropriate rights may change

any data point value and click the “SAVE” button for editing or entering a value.

In the below screenshot, The Nominal Wall thickness is the selected parameter. The grid enlists

the value of thickness in mm at a given KP in Km. A line graph plotted using the data points is

shown at the bottom.






32

Figure 7-26 Profiles of pipeline data

7.1.3.1.5 UTM

The Universal Transverse Mercator coordinate system (UTM) defines unique zones that cover

the Earth to provide detailed referencing. The terms easting and northing are geographic

Cartesian coordinates for a point. Easting refers to the eastward-measured distance (or the x-

coordinate), while northing refers to the northward-measured distance (or the y-coordinate).

As shown in the next screenshot, the UTM sub tab lists the Kp of the Pipeline, its easting

(UTME) and northing (UTMN) and Pipe Joint number in a grid. The Grid has two tabs: List

View and Data Entry. The former displays data while the latter is used to input data into theapplication.






33

Figure 7-27 Pipeline UTM - Data Entry screen

7.1.3.1.6 Pipeline Layouts

Pipeline Layouts are the definition and location of sections and components of a Pipeline system.

As shown in the next screenshot, this tab gives information about the sections, components and

crossings within the pipeline system.

Sections: This sub tab lists the various sections of the Pipeline system in a grid. Against each

section, it details information such as the sub section, type of section, description, its Kp values

(location), whether it is manned etc. For instance, in the next screenshot, the Pipeline has been

divided into 3 sections – Above ground, underground and above ground sections.

Figure 7-28 Example of Sections






34

Components: This sub tab contains a grid to display the various components which are part of

the pipeline system. Against each component, it details information such as the type of

component, description, its Kp values (location), module, design premises etc.

Figure 7-29 Example of "Components"

Crossing: This sub tab contains a grid to display the various crossings or joints which are part of

the pipeline system. Against each crossing, it details information such as the type of crossing,

description and its Kp values (location).

Figure 7-30 Example of "Crossings"






35

The Grid views in each of the three sub tabs have two tabs: List View and Data Entry. The

former displays data while the latter is used to input data into the application.

7.1.3.2 History/ Survey Records Tab

Figure 7-31 History Records tab

History/ Survey Information is accessed via the “History/ Survey Records” Form View button in

the Navigation bar. It has two sub tabs: Event/ Log History and Survey Records. Events are

issues / events that need follow-up activities (3rd party interference, trawl impact, change of

operating conditions etc.). The intent of the Event History log is to keep track of important

issues, assumptions, changes that have occurred in various phases (design, fabrication,

installation and operation), enabling other personnel to quickly obtain an overview of the

pipeline system.






36

The History tab is shown in the above diagram and it has a grid view to record and display the

details of events like repairs and maintenance that have taken place in the past. The Grid view

has two tabs: List View and Data Entry. The former displays data while the latter is used to input

data into the application.

The individual events are defined by the following data fields:

Date

Position (Kp1 and Kp2)

Event (Identification tag)

Description (memo-field)

Reference (Text field to input reference material)

Event type: Recommended choices: [Planned, Unplanned]

Importance: Recommended choices: [High, Medium, Low]

Status: Recommended choices: [Open, Closed]

Action: Describe any action to be taken

The bottom portion contains the graphical representation of various profiles of the pipeline as

recorded in past inspections.

The Survey Records tab is as shown in the figure below. This tab contains information about all past surveys and inspections It has a grid view which displays details about the survey such as:

Survey ID (unique name)

Survey type (CP Survey, ECDA, Intelligent Pigging etc)

Survey tool (name of used inspection tool)

Survey date (Start- and end-data)

Reference (to survey report or other relevant documents)

Survey comments (this is a memo-field where more detailed information / conclusions

from survey reports can be stored. In case of no notable findings, such information could

be stored in here).

The Grid view has two tabs: List View and Data Entry. The former displays data while the latter

is used to input data into the application.






37

The bottom portion contains the inspection coverage in terms of the number of kilometer points

(kp) spanned during the Inspection and the Inspection results type. Inspection coverage defines

the areas of the pipeline system that has been inspected. There is a graphical representation of the

number of Inspections versus the kp.

Figure 7-32 Survey Records Tab

7.1.3.3 Inspection Results

This tab is accessed via the “Inspection Results” Form View button in the Navigation bar and

contains detailed description of inspection findings. All inspection data is to be entered to the

data grid defined for each of the inspection types (Metal loss, CP-reading, Soil resistivity

analysis, DCVG Survey etc.). The screenshot below shows an example of inspection results for

metal-loss. The most important inspection quantities are:

Survey ID

Location (Kp)

Defect size (depth, width and length)

Inspection method including inspection accuracy






38

The inspection results have been classified as in-line inspections and Direct Assessments. These

inspection results can be exported to excel and can be viewed in the form of a report in pdf

format.

Figure 7-33 Inspection Results

At the top left of the screen, the categories of Inspection Results are listed. On the right there is a

dropdown to select the survey for which the selected results need to be viewed. Depending on

these two selections (Result category and Survey), the inspection results are displayed in a grid

view as shown in above diagram.

At the bottom of the main screen, there is a graphical representation of the Inspection coverage

(Number of Inspections against KP), Results Vs KP and Results Vs Time.

By clicking the “Add New’’ button, you can input the inspection results for a new Inspection as

shown in the below screenshot.






39

Figure 7-34 Add new Inspection Results

As shown it is possible to load data from an excel file in a pre specified template into the form

shown above. This template can be downloaded using the “Download Template” icon.






40

Figure 7-35 An example of inspection results related to Metal Loss. Note that it is possible to plot different inspectionresult-items (defect depth, defect length, defect width, and ERF-values (Estimated Repair Factor))

In case of several surveys, the results from the various surveys are plotted in different color.

Figure 7-36 Time-Development of Inspection Results






41

The time-development of inspection results can be examined. An example is shown in the

screenshot above.

Figure 7-37 Example of Inspection Results related to Close Interval Potential Survey

7.1.3.4 Defect Assessment

This is accessed via the “Defect Assessment” Form View button in the Navigation bar. Defect

assessment performs Integrity assessment of pipelines with metal loss defects, based on entered

pipeline data and inspection records etc.

PIMS covers metal loss assessment of single defects (both flat bottom and complex shaped)exposed to pressure loading only.






42

The Process of Risk Assessment of Defects

The flowchart below explains process of the risk assessment of defects. Each of the steps areexplained thereafter.

Figure 7-38 Process of Defect Assessment

Screen-ing

•Screening defects according to criteria entered by user. It is possible to screen defects by setting criteriafor the defect length and/ or defect width and/ or defect depth and/ or Percentage defect depth.

CodeCheck

•The screened defects are subject to Code Check to determine their severity.

AllocateDamageCauses

•Every defect is allocated damage causes and sub damage causes.

Historical Trend

•A historical trend of the defect is plotted. The short term and long term metal loss, Measured Corrosionrate and Remnant Life are calculated.

AssessRisk

•Based on the allocated damage causes and the history of the defect, the user assigns PoF and CoF valuesto each defect. The Risk Rank and Risk score are calculated for each defect.

Results•The combined Metal Loss, Corrosion Rate and Remnant Life of all the screened defects is calculated






43

Screening

Figure 7-39 Screening of Defects

Code Check

Each row in the defect assessment grid displays the risk color code associated with that defect for

the pipeline. The results displayed in the grid can be exported to excel.

VAIL-Plant PIMS includes a pressure containment function for analysis of a pipelines’ ability to

withstand bursting due to pressure conditions along the pipeline.

The “Allowable Pressure [bar]” grid at the lower part of the window presents the maximum

allowable pressure for the considered defect, whereas the plot reflects the specified MAOP. The

presented Safety Factors are the design factors applied in the design equation of the code.






44

Figure 7-40 Code Check

The integrity of the pipeline with corrosion defects, internal or external can be evaluated based

on commonly used codes (guidelines):

ASME B31G

DNV-RP-F101 [Part A]

DNV-RP-F101 [Part B]

RSTTRENG

SHELL92

PCORRC






45

Allocating Damage Mechanisms

Figure 7-41 Allocating Damage Mechanisms

Analyzing the historical trend of each defect

It shows the number of surveys undertaken in the past at the specific Kp point of each defect. It

then compares the Corrosion rate and Metal loss measured at each survey to plot a trend of the

defect. This helps to visualize whether the defect is growing or restricted and helps to determine

its risk.






46

Figure 7-42 Historical Trend of a defect

Determining Risk

Figure 7-43 Risk Assessment






47

The PoF, CoF and Risk are estimated for each defect for the selected pipeline. A typical example

is shown in the above screenshot. The program graphically displays the risk of each defect at the

corresponding Kp point for the selected pipeline.

Graphical Distribution of Defects

Calculation of Results






48

This tab shows the defect assessment results for all the screened defects.

It shows the aggregate the short term and long term Metal loss as the highest metal loss among

the metal losses of all the screened defects. It allows the user to select the corrosion rate from

among the measured, design, estimated corrosion rates or allows the user to input an expert

corrosion rate. On the basis of the selected corrosion rate, on clicking the ‘Calculate’ button, the

remnant life is calculated. A traffic signal color code is also assigned to it for easy visualization.

Figure 7-44 Assessment results of screened defects

7.1.3.5 Survey Assessment

This tab allows the comparison of the inspection results of up to three surveys against a common

Kp axis. This helps to visualize the condition of each Kp point at which inspection results are

gathered and how the results from various surveys conducted tie in together.






49

Figure 7-45 Comparison of upto three survey results

7.1.3.6 Condition Assessment

This tab is accessed via the “Condition Assessment” Form View button in the Navigation bar. It

includes Corrosion Coupon analysis, Fluid Analysis, Weight Loss Coupon, ERP and cathodic

protection.

Corrosion Coupon

Corrosion coupons represent a widely used and relatively simple form of corrosion monitoring.

This section includes a Corrosion Coupon model to arrive at the current and maximum corrosion

rates for the pipeline. The Current Corrosion rate trends are graphically displayed at the bottom

of the screen as shown in the screenshot below.






50

Figure 7-46 Corrosion Coupon Model

The various details captured for this model are: Installation date, Retrieval date, Exposure days,

Exposure months, Access fitting positions, Coupon reference, Original weight, Final weight,

Weight loss due to cleaning, Weight loss, Average Corrosion rate, Aspect before cleaning,

Aspect after cleaning, Current Corrosion rate and Maximum Corrosion rate.

Direct Examination

Direct Examination (Bell Hole Analysis) covers the recording of the details of Soil Analysis,

Water Analysis, Pipe to Soil Potential Measurement, Coating Condition and Wall thickness for

each examination.






51

Figure 7-47 Condition Assessment - Direct Examination

Various other techniques of condition assessment are included such as Visual Inspection, Fluid

Analysis, Weight Loss Coupon, ERP and Hydrotest. It is possible to add and view records for

each of these methods in this tab.

7.1.3.7 Pipeline Assessment

The risk assessment in VAIL-Plant PIMS addresses a range of failure modes and damage

mechanisms, with focus upon “inspectable” damage causes, such as corrosion, third party

interference causing dents, gouges or cracking, that can lead to rupture or leakage of the pipeline.

Risk is defined as:

Risk = PoF ´CoF

PoF = Probability of failure

CoF = Consequence of failure






52

PoF and CoF have been divided into 5 categories, i.e. 1 to 5 and A to E, where 5 and E represent

highest probability and highest consequences, respectively.

The PoF varies according to the damage mechanism.

The consequences of failure have further been divided into: Safety-

Economic-

Environmental-, and

Capital (e.g. company reputation)

The CoF for business, safety and environment can be performed using Level 1, Level 2 or Level

3 analysis with the detailing deepening with every level.

Figure 7-48 Risk Matrix






53

Figure 7-49 Risk Categories

The risk categories range from N (Negligible) to EH (Extremely High). The risk ranking matrix

is shown in the figure above.

Pipeline Risk Assessment is accessed by clicking on the ‘Pipeline Assessment’ Tab of the FormView on the Navigation Bar.

This tab deals with assessing the Risk of the entire pipeline which depends on the risk

assessment of its sections.

Figure 7-50 Pipeline Assessment

There are five sub tabs in the section as described below:






54

Sections: In this tab, a grid view field allows to add and view the different sections of the

pipeline. Against each section are details of its sub sections, its KP values, consequence of

failure, probability of failure and the associated risk.

The bottom part of the screen enlists section wise information such as technical Information,

Design Premises and Analysis, Operating experiences, relevant failure mechanisms and

Condition Notes and follow-ups.

The above screenshot shows this sub tab.

Note that Sections may be added from the above screen as well as from the Pipeline Data - >

Pipeline layout -> Sections tab.

Allocate Damage Causes

This sub tab allows allocation and display of Damage causes associated with each section. It also

shows the Probability and consequence assessments of each damage mechanism.

Figure 7-51 Pipeline Assessment - Allocate Damage Causes






55

Relevant damage mechanisms are assigned to each section of the pipeline for further analysis.

The risk is assessed against each applied damage mechanism and the highest risk among all the

damage mechanisms is assigned as the risk of the section.

The highest risk among the section risks is assigned as the risk of the overall pipeline.

Risk Assessment

This sub tab allows entering and viewing the probability of failure, Consequence of failure and

the Inspection Effectiveness for each section of the pipeline. The Risk is then evaluated for each

section. The section risk and the Overall risk are displayed along with a graph of Risk category

Vs KP value. This is shown in the screenshots below.

POF Assessment

The Probability of Failure or Susceptibility is derived from the questionnaire as shown below.

There is a separate questionnaire for each damage mechanism.

Figure 7-52 POF Assessment

There are in built models for calculating the estimated corrosion rates and the susceptibility

levels. This is shown in the next screenshot.






56

Figure 7-53 POF Assessment - Models for estimating corrosion rates

COF Assessment - Business

The Consequence of Failure for Business can be ascertained using one of three levels.

Figure 7-54 Business COF Assessment






57

COF Assessment - Safety

The Consequence of Failure for Safety can be ascertained using one of three levels.

Figure 7-55 Safety COF Assessment

COF Assessment – Environment

The Consequence of Failure for Environment can be ascertained using one of three levels.






58

Figure 7-56 Environment COF Assessment

Inspection Effectiveness

The Inspection Effectiveness is determined on the basis of a questionnaire as shown below.

Figure 7-57 Inspection Effectiveness






59

Condition Summary - Risk Assessment Summary of all sections

This sub tab shows the summary of each section. It tabulates the various damage mechanisms for

each section of the Pipeline. Against each damage mechanism, it details the PoF, CoF maximum

value and Risk category. It also details the section type, KP value and section risk category.

Figure 7-58 Pipeline Assessment - Condition Summary

Determination of Next Inspection Date

Results from the Risk Assessment such as the Metal Loss, Corrosion Rates, Remnant life,

Inspection Interval and the Next Inspection Date are dynamically calculated and displayed.






60

Figure 7-59 Next Inspection Date Calculation

Overall Pipeline Risk Assessment

Figure 7-60 Overall Pipeline Risk Assessment






61

The Overall pipeline Risk along with a graphical representation of the risk categories to which

each section belongs is shown below.

Risk Matrix

The Risk Matrix used to determine the risk category based on the PoF and CoF is shown below.

Each category also has a risk score associated with it. This risk Matrix is configurable to suit that

of an individual organization. There is facility to modify this matrix from the Control Panel of

VAIL-Plant.

Figure 7-61 Customizable Risk Matrix

7.1.4 Integrity Operating Windows (IOWs)

This tab allows the user to enter the integrity operating ranges/windows for each pipeline. These

are basically ranges and values that must be maintained during the operation of the pipeline to

ensure its integrity.

It includes the following information:

Parameter to be monitored or controlled

IOW Type and limit

Comments/ Reasons/ Actions/ Timing

Party (s) responsible for monitoring, control and response actions (who does what)






62

First select the pipeline for which IOWs need to be entered by clicking on the Pipeline ID in the

navigation tree. It is possible to enter a new record by clicking the ‘New’ button on the taskbar of

the IOW tab. After entering the record, the user has the option to either save it or drop it. User

may change an already saved record by clicking the ‘Update’ button. On this action, the entire

grid becomes editable. After editing one or more rows, user has the option to save changes by

clicking the ‘Save’ button or discarding these changes by clicking the ‘Drop’ button. Existing

records can be deleted by clicking the ‘Delete’ button after selecting the row to be deleted in the

grid.

A sample record is shown in the screenshot below.

Figure 7-62 Integrity Operating Windows

7.1.5 Inspection Plan

Inspection Plan Tab accessed via the “Inspection Plan” Form View’s button in the Navigation

bar.

Inspection Plan tab shows the Inspection Interval, NDT Resources, Inspection techniques, Next

inspection date and Plant Inspection Routines (PIR) of the current record.






63

It allows adding and viewing the Task lists associated with the Equipment, logistic requirements

for the Inspection and the Inspection sketches.

Figure 7-63 Inspection Plan

7.1.6 GIS (Geographical Information System)

A geographic information system (GIS) captures, manages, analyzes and displays all forms of

geographically referenced information. GIS allows us to view, understand and visualize data in

ways that reveal relationships, patterns, and trends.

PIMS-GIS is accessed by clicking the GIS tab on the Navigation bar. It graphically represents

the pipeline on a map. The options on the left panel allow to mark various elements such as Risk,

KP points, Sections, Photos and Inspection Results on the pipeline. In the screenshot below, the

various sections of the pipeline are graphically represented. Clicking on the pipeline displays a

list of these sections and their details.






64

GIS can be accessed when connected to the Internet as well as without it. The online and offline

Map options respectively are used for each of these modes.

Figure 7-64 GIS

7.2 PIMS LIST VIEW

User can change the user interface from Form View to List View by clicking on List View

button in the Navigation bar. The same data shown in form format in the Form View is displayed

as a list which can be exported to excel.






65

Figure 7-65 Changing to List View

As soon as user will click on this button, the View navigation portion will change to following

view i.e. List View.

Figure 7-66 List View






66

7.2.1 Grid Header

The panel above the grid in which column names are displayed is the grid header. Under each

column user will find respective records.

Figure 7-67 Grid Header

Figure 7-68 Sorting of Records

User will notice that whenever he clicks on the column name in the header, an arrow appears.

This arrow indicates the sorting order of the records in the grid by making the selected column as

a reference.

7.2.2 Sorting Upward

Figure 7-69 Sorting Ascending






67

Arrow in the upward direction shows that all the records in this selected column are sorted in

ascending order and rest of the columns will have the same records according to the selected

column data.

7.2.3 Sorting Downward

Arrow in the downward direction shows that all the records in this selected column are sorted in

descending order and rest of the columns will have the same records according to selected

column.

Figure 7-70 Sorting Descending

7.2.4 Records Filtering

Records can easily be filtered by selecting the downward arrow present along with each column

in the grid view. A dropdown list appears showing all the possible values in the column. Select a

value to filter only those records which match the selected column value. You can also applymultiple filters by selecting filtered values on more than one column.






68

Figure 7-71 Filtering Records

7.2.5 Exporting to Excel

One of the most important features of the List View is the ability to view all records in a list

format and to be able to export it to an excel file on your computer. This enables sharing data

outside the software and a method to perform further analysis and reporting.

User can filter records as need be and then click the ‘Export button’ at the top of the page. On

filtering, it is possible that the result set extends to more than a single page. There are two

options while exporting to excel as described below:

Current Page – Selecting this option ensures that only the records shown on the current page are

exported to excel. This maybe a subset of the entire result set obtained in the software.All Records - Selecting this option ensures that all the records in the result set are exported to

excel. This may span a number of pages in the List View.

On Clicking on the ‘Export’ button, the below window shall appear, allowing you to save to an

excel file in desired location.






69

Figure 7-72 Saving Excel File

7.2.6 List View Page Navigation Buttons

The List View has buttons to navigate to the first page, last page and to move to the previous or

next pages. It also shows the current page number, for instance: 1 of 22.

A description of the functions of these buttons is summarized below.

There is a textbox to fill in the number of records you wish to see per page. When you enter a

number in the box, say 100, and click the ‘Fill Grid’ button, 100 records will be shown in the

grid. If you enter 25, only 25 records will be shown at a time on one page. The number of pages

of the result set will change accordingly to accommodate all the records in the result set.

Table 7.1 Description of Page Navigation Buttons

This button moves to the next page

This button moves to the last page

This button moves to the previous page

This button moves to the first page






70

7.2.7 List View’s Buttons in the Navigation Bar

The tabs under the List View are very similar to those in the Form View. The data displayed in

the Form View is displayed as a tabulated spreadsheet in the List View with the added facility to

filter, sort and export to Excel. Also, User can set the number of records to be displayed per page

at the bottom of the screen and can navigate through the pages using the arrow buttons to the

bottom right corner of the screen.

Some of the tabs are described briefly below.

Figure 7-73 List View Sub Tabs

7.2.7.1 Pipeline Data

The same results which were populating in the Form View of Pipeline Data in text fields

populate in the grid, in the List View. There are two sub tabs: Main data and operational data.

This is shown in the screenshot above. The “Operational Data” tab is further divided into sub

tabs such as Composition, Chemical Injection, Monitoring and Maintenance.






71

7.2.7.2 History/Survey Records

The same results which were populating in the form view of History/ Survey Records in text

fields populate in the grid, in the List View.

Figure 7-74 History/Survey Records tab

7.2.7.3 Inspection Plan

The same results which were populating in the form view of Inspection Results in text fields

populate in the grid, in the List View.

Figure 7-75 Inspection Results tab

Initial columns display information about the pipeline; whereas the rest of the columns show the

details of inspection results. The screen lists the Inspection result types as radio buttons. Only

one option can be chosen at a time by clicking the radio button against it. When an Inspection






72

result type is selected, the information in the grid is filtered to display records pertaining to the

selected Inspection result type only.

7.2.7.4 Defect Assessment

Initial columns indicate information about the pipeline and the rest of the columns show the

complete details of defect assessment covered in the Form View Defect Assessment tab.

Figure 7-76 Defect Assessment tab

7.2.7.5 Pipeline Assessment

Initial columns indicate information about the pipeline and the rest of the columns show the

complete details of Pipeline assessment covered in the Form View Pipeline Assessment tab.






73

Figure 7-77 Pipeline Assessment tab

7.3 PIMS REPORT VIEW

Inherent reporting functionality is an important part of VAIL-Plant.

Figure 7-78 PIMS Report View

The report module comprises of the following pre-defined reports: Pipeline Profiles

Portfolio Assessment

Pipeline Section

Survey Results






74

Damage Cause Assessment

Portfolio Assessment Risk by Damage Cause

Defect Assessment

Inline Inspection Summary Report

Direct Assessment Summary Report

Below are the steps to access reports.

1. Click on the ‘Report View’ tab on the Navigation bar. A list of pre-defined reports shall

appear.

2. Select the Pipeline you want to draw a report for by selecting one Pipeline ID from the

drop down menu on the right of the screen.

3. After selecting the criteria, simply click on ‘View’ button and you can see the report in

the report viewer. If you click the ‘Clear’ button, the pipeline selection is reset. The

below screenshot shows the ‘Summary Report’

4. Figure 7-79 Example of Pipeline Assessment Report






75

Figure 7-80 Report for Screening by Damage Cause

Figure 7-81 Example of Defect Assessment Results Report






76

Figure 7-82 Direct Assessment Summary Report

Figure 7-83 Survey Results Report






77

Figure 7-84 Portfolio Assessment Report - Highest Pipeline Risk

7.4 PIMS USER LIST VIEW

Figure 7-85 PIMS User List View






78

The most customized feature of VAIL-Plant®

is the USER LIST View which allows users to

build customized queries.

The screenshot above shows the screen when the ‘User List View’ tab on the Navigation bar is

clicked. You can create your own custom query and save it for future reference. All the

previously stored queries are stored in new Existing Query panel. The grid view shows the result

of the query.

7.4.1 How to create a new query?

1. By clicking on New Query button, a new window will pop up as shown in next figure.

2. When you click on the drop down box against ‘Select Table’ you will see a list of all

available tables as shown in above figure..

3. After you select any table, you will get a list of all available fields in the list box. These

fields are the columns of the tables which contains all records information. Now you can

select the fields you need.

Figure 7-86 New Query – Select Table






79

4. Left panel shows all the fields available where as the right panel will show those fields

for which query will be executed. Select the field you want to see in the result and click

the button highlighted in the screenshot below. Repeat this step with all the fields youwish to appear in the results.

5. Once selected, the field will shift to the right panel to show that it is a selected field to

appear in the result of the query. Repeat the steps 2, 3 and 4 to select the required fields

from related tables. For example, first select the “Pipeline Engineering table” and select

fields such as Pipeline Name, From Position, To Position, Length km etc. Then select

the “Profiles Data” table which is a table related to the “Pipeline Engineering table”.

Please note that data may be joined only between logically related tables. From the

“Profiles Data” table, select fields such as profile type, Kp and value.

6. Once your selection is complete, click the ‘Next’ button. This is shown in the below

screenshot.

Figure 7-87 New Query - Select Fields






80

7. Description of the functions of the buttons on the screen is tabulated below:

This button moves the selected field from the table to the query result.

This button moves all the available fields to the query result.

This button will move back the selected field from the query result; it means this

field will no longer be in the result when query will be executed.

This button will bring all the fields back to table and will not show any result after

query execution. It is used to reset the right panel to start again.

Table 7.2 Description of Buttons

Figure 7-88 New Query - Next Button






81

Figure 7-89 Applying filters to the custom query

8. After clicking on Next button a new form will appear as shown above. Provide a namefor this query so as to be able to reuse it from the ‘Existing Queries’ panel at a later time.

Click ‘Finish’ button.

9. After clicking on the Finish button, you will see the query result in the grid view panel.

You can see that the recently made query is also being showing in the ‘Existing Query’

Panel.






82

Figure 7-90 Query saved and Results Displayed

7.4.2 How to delete an existing query?

1) Select the query you want to delete from the ‘Existing queries’ panel.

2) Click the ‘Delete Query’ button as illustrated alongside.

3) By clicking on this button, selected query shall be deleted and will

no longer appear in the Existing Query section.

7.4.3 How to export the results to excel file?

Export to excel feature will export all the records displayed in the VAIL-Plant® Grid view to

Microsoft Excel file. This allows more usability and easy transfer of the data.

1) When the needed records are being displayed in the grid view, click on the ‘ExportCurrent Page’ button at the top of the screen. With this button, only the records shown on

the current page are exported to excel. This maybe a subset of the entire result set

obtained in the software.

2) An excel file will open with the grid view records. Save this excel file to use the

information shown in the report.

Figure 7-91 DeleteQuery






83

7.5 PIMS REFERENCE DOCUMENTS

This tab of VAIL-Plant® provides the facility to view all the documents under the categories of

AIRMs, SOPs and Operating Manuals. The default tab is AIRMs.

Figure 7-92 Reference Documents

How to view a document?

For any sub tab, the method to view documents remains same. Select the needed document from

the ‘View Documents’ tab to view it on the right of the screen. Click on the ‘View in Separate

Window’ button to open the document in a new window.






84

How to remove a document?

For any sub tab, the method to remove documents remains same. Select the needed document

from the ‘View Documents’ tab. Click the ‘Delete’ button. You shall be prompted to confirm if

you want to remove the document. Then a message shall appear to report that the document was

successfully deleted.

How to add a document?

Select the ‘Add Documents’ tab. Click on the Browse button to select a PDF document from

your hard disk. You shall be able to view it on the right of the screen. Give it a file title,document number and revision number. All three are mandatory fields. Click on the ‘Add’

button. You shall get a message box saying that the document has been successfully attached.

User shall be able to see the newly added document in the list of documents in the ‘View

Documents’ tab.

Figure 7-93 Adding Reference documents






85

Tabs within Reference Documents tab are described below. These are so named to provide

classification of the documents you upload.

AIRMS (Asset Integrity and Reliability Management System)

AIRMS contains all the documents related to Asset integrity & reliability management system.

Figure 7-94 AIRMS documents

SOPs (Standard Operating Procedures)

This tab contains all the reference documents related to Standard Operating Procedures.






86

Figure 7-95 SOPs

Operating Manuals

You can find all Operating Manuals under this section.

Figure 7-96 Operating Manuals






Other Documents

This is a tab to upload documents which do not fall into any of the categories above.

Figure 7-97 Other Documents

vail-plant pims user manual

Documents

system requirements

software startup

company button

close button

software support

software installation

safer world vailplant

button ribbon functions