+1 vote
334 views

What is Completions Database?

asked Apr 10, 2015 in Engineering by belmoreno (2,190 points)
I’ve heard of the term Completions Database. What does it refer to? Can someone give an example or sample figure of what it looks like. Furthermore, who makes these databases?

2 Answers

+1 vote
answered Apr 11, 2015 by ekwuemesam (3,660 points)

The Completions Database is the means by which progress both in the Construction and Commissioning Phases is tracked at the ‘Tag Number’ or equipment level. Every Unique Identification code, ‘Tag Number’, for a piece of equipment is recorded in the database; these tag numbered items include such things as Cables, Mechanical Equipment, Piping, Instruments, and Electrical Equipment. The tag numbers are cross-referenced to Commissioning systems.

This allows the reports to be generated in a consistent way for customers. The Completions database, accurately populated and maintained, provides the project with a range of reports and graphs that show progress on the completeness of completions scope of work.

The database would typically contain the following information: Tag number, description, manufacturer, system, sub-system, location and applicable Inspection and Test Records (ITR’s) defining the ‘Mechanical Completion’ and ‘Pre-commissioning’ work scope. The information needed for the population of the database is identified by the discipline engineers like piping, mechanical, instruments and electrical.

0 votes
answered Apr 20, 2015 by redonetti (1,280 points)

There is some software companies that make proven Completions System database to provide real-time tracking, visibility, control and management of the completions on individual or combined system/subsystem. The database will support the documented technical integrity of Completions certificates, Acceptance Test Certificates and handover. One I can name is ECOM.

ECOM is a SBM developed software, tailored to fulfill the requirements specified on the corporate Mechanical Completion and Commissioning Standard Specification. SBM will provide all the necessary hardware, software, networks and associated equipment to ensure its functionality.

The database can track the completion of sub-system elements at the ‘Tag Number’ level. A unique identification code for a piece of equipment called ‘Tag Number’ is recorded in the Completions Database. These tagged items include Mechanical Equipment, Piping, Cables, Instruments and Electrical Equipment.

The project Completion Database is populated with data from various design disciplines. These include the following:

  • Electric & Instrument Cable lists
  • Instrument Index / Loop diagrams
  • Electrical Equipment list
  • Mechanical Equipment list
  • F&G, PAGA, Telephone and LAN Cable lists
  • Lighting & small power Cable lists
  • Junction Box register
  • Process Line List
  • PSV Index
  • Vendor Equipment Tag list

A manual entry from the site engineer via the Database coordinator can also be added to complement the available data.

The data structure within the database can vary to accommodate individual discipline requirements. For example, in order to control the piping scope during construction and installation, the piping section of the database will only identify reinstatement certificates per subsystem. Separate piping trackers are used to track the fabrication, testing and final completion of the pipework.

The Completions Database will be updated on daily basis and at all times demonstrate status of all aspects of mechanical completions, commissioning, execution, and transition through to Completions phases. It will also cover the inspection and testing requirements for all systems, sub-systems and their components.

Every document in ECOM has a unique ID / barcode. The set of documents are scanned back to ECOM and processed by the scan service. ECOM will automatically update the project database and update progress report. ECOM can split / file automatically every single document and incorporate additional attachments. It will finally generate the next sequence document in case of routine inspection and testing records

ECOM can generate a variety of reports to show progress at the different levels defined within it. This will allow the project team to identify potential manpower or productivity problems and address them accordingly. The reports are excel based and on live data.

Hope that provide some insights!? Anyone from SBM want to add anything further?

Related questions

1 answer
asked Apr 9, 2015 in Engineering by belmoreno (2,190 points)
2 answers
asked Apr 20, 2015 in Engineering by guyredumis (540 points)
1 answer
asked Apr 21, 2015 in Engineering by GerritMcLane (870 points)
1 answer
asked Apr 7, 2015 in Engineering by wangroc (3,280 points)
...