Data Catalogue: Challenges and Experiences of Asset Acquisitions

1
Data Catalogue Challenges and Experiences of
Asset Acquisitions

• Sue Edwards
• Jennifer Morrison
• Frank Watkin
• Richard Wright
• 21st June 2006
• POSC Regional SIG Meeting - Aberdeen

2
Who are Canadian Natural Resources ?

• One of Canadas largest producers of crude
• One of North Americas largest natural gas
  producers
• World Class Senior Independent Oil Gas
  Exploration, Development Production operator
• Sixth largest Independent Exploration
  Production Company with international exposure
• Major Alberta Oil Sands Player with HORIZON
  Project

3
Who are CNR
International ?
CNR Internationals operations are focused
in North Sea and offshore West Africa
Bases in
Aberdeen, Scotland
Abidjan, Cote dIvoire
Libreville, Gabon
4
CNR Internationals Assets
Tiffany
Murchison
Banff
Toni
Playfair
Kyle
Thelma
Espoir
Ninian
Balmoral
Baobab
Lyell
Stirling
Olowi
Columba
Glamis
5
Information Management at CNR International -
Organisation

• Central Service
• Document Control projects and operational
• Capture
• Archive
• Subscriptions, technical reference, library
• Draughting and Cartography
• Issue and control of Business Procedures, Safety
  Cases etc
• Single point of contact for all record types

6
Information Management at CNR International - Tool

• Document Management System - Documentum
• Information delivery on intranet
• One catalogue with targeted searches
• Electronic - paper seismic core samples
• Loan management
• Standard approach to classification
• In-house cataloguing
• Transmittal system for document control full
  project history
• Offsite storage is box management only

7
CNR International Significant Acquisitions

• Transfer of Operatorship
• December 2002 - Ninian and Murchison
• Kerr McGee
• Knowledge of asset through previous partner
  relationship
• September 2004 - TBlock (Tiffany Toni Thelma) and
  B-Block (Balmoral Glamis and Stirling)
• ENI
• No previous knowledge new asset
• Acquisition based on a plan for
  development/expansion
• Everyone needs information - NOW!

8
Data Transfer Challenges

• Simultaneously
• Deliver information to new consumers
• A real challenge when no previous interest in the
  asset
• Transition ongoing projects
• Ensure change management processes are in place -
  they may not match!
• Continue to work with existing suppliers
• Effect the transfer a variety of record types
• UKOOA Best Practice Guidelines should help
• Ensure completeness
• Approach based on our retention policy/schedule
• Integrate catalogues with own systems
• Deliver catalogue to users for self help

9
Challenges Variety of Catalogues

• Catalogues in Applications
• Spreadsheets and word documents
• Handwritten
• None!
• Engineers lists of boxes, subsequently renumbered
• Data type specific lists
• Pallets and bags of drawings
• Microfiche
• Core listings
• CDA
• Catalogue quality is dependent on available
  Information Management resources

10
Challenges Merging Catalogues

• Balancing act
• Easier to find if all in one place one
  catalogue versus 100 spreadsheets but
• Without consistent properties search results can
  be very poor
• How much time have we got?
• If you want it now live with what youve got
• If you want it next year then we can work on
  the data
• Involves
• Understanding the classification system
• Understanding the history of the data
• Mapping it to in-house classification
• Avoiding loss of information

11
The GG World

• Givens
• Standards in place
• A well name is a well name only small
  permutations
• Records are static
• If previous owner has been diligent in meeting
  obligations to the dti then information is
  accessible through CDA.
• Normally separate catalogues for paper and
  electronic records
• Routine tasks
• Clean up inconsistent well names
• Clean up field names
• Shoehorn catalogues for paper and electronic
  into one system.

12
Variations on a Well Name Columba well 3/08-S53

• 3/08-S53 DTI Well name
• 3/08A-S53 GG name
• 3/08A-S53 D3 GG name
• 3/08A-S53/D3 GG name
• 3/08A-S53DP3 Derivation on log/report
• 3/08a-S53 Derivation on log/report
• 3/08A-D3 Derivation on log/report
• 3/08A-DW3 Derivation on log/report
• One name for consistent and reliable search
  results

13
The Topsides and Subsea World

• Its dynamic
• Equipment is constantly modified and upgraded
• History is important
• Changes must be tracked
• Lacks standards
• Variable classification and cataloguing, often
  limited resources
• Vendor practices vary
• Older is worse!
• Different project teams and methodologies
• Cataloguing often reflects why being done not
  what
• Value is underestimated
• Inability to find topsides and subsea information
  costs money!

14
Topsides and Subsea Change Management

• Scenarios
• Pre 1990 - manual output hardcopy
• 1990 onwards manual during projects with
  electronic copy loaded at end of projects (by
  which time new projects and modifications
  started)
• Recent electronic with e workflow
• Issues
• Vendor numbering system is different to project
  numbering system is different to operator
  numbering system
• Changes of ownership triggered changes to
  document management
• Which system was maintained?
• Was it reflected across paper/sepia and
  microfiche?
• Know the history
• Its critical to retrieval of documentation for
  support of ongoing maintenance and development
  work

15
Topsides and Subsea Document Numbering Example

• Tiffany Vendor Numbering
• PO No Document Type - Discipline Code -
  Accession no - Sheet No
• U0003 - D - M - 4001 - 00
• Tiffany Project Numbering
• Project no - Area Code - Document Type -
  Discipline Code -
• Accession No - Sheet No
• E - 11 - T - S - 0010 - 00
• Tiffany Operator Numbering
• Asset name - Discipline Code - Document type -
  Accession number
• TIF - O - MN 0301
• Impedes ability to locate information by document
  number component

16
Topsides and Subsea T-BLOCK Engineering Change
Management

• T-Block Revision Numbering Philosophy
• 0,A,B Issued For Approval/Comment
• C,D,E, etc Issued for Construction/Revised for
  Construction
• X,X1,X2, etc As Fabricated
• Y,Y1,Y2, etc As Built by Project Group
• Z,Z1,Z2, etc As Built by Operator
• Toni/Thelma - Rules not used consistently/did not
  apply
• A, B, C, D As Built
• P1 to P9 Used for comment
• Check assumptions!
• What is the latest version?

17
Topsides and Subsea Classification Mapping

• Catalogue A Catalogue B
• ELECTRICAL ELECTRICAL
• ELECTRICAL HVAC ELECTRICAL
• ELECTRICAL TELECOMMUNICATIONS ELECTRICAL
• ELECTRICAL INSTRUMENTATION FIRE GAS -
  TELECOMMUNICATIONS
• ELECTRICAL
• HVAC ELECTRICAL HVAC
• HVAC FIRE AND GAS HVAC
• HVAC INSTRUMENTATION HVAC
• HVAC - INSTRUMENTATION ELECTRICAL HVAC
• HVAC MECHANICAL HVAC
• FIRE AND GAS ELECTRICAL FIRE AND GAS
• FIRE AND GAS HVAC FIRE AND GAS
• FIRE AND GAS INSTRUMENTATION FIRE AND GAS
• FIRE AND GAS TELECOMMUNICATIONS FIRE AND GAS

18
Topsides and Subsea Classification Mapping

• Catalogue A Catalogue B
• ANALYSIS STUDY
• ANALYSIS SHEET STUDY
• CALCULATION CALCULATION
• PUMP CURVE CALCULATION
• RESISTANCE CURVE CALCULATION
• CERTIFICATE CERTIFICATION RECORD
• CERTIFICATION CERTIFICATION RECORD
• CERTIFICATION DATA BOOK CERTIFICATION RECORD
• CERTIFICATION DATA DOSSIER CERTIFICATION RECORD
• WEIGHT DATA CERTIFICATION RECORD
• WELDING RECORD CERTIFICATION RECORD
• DATA BOOK DATA BOOK
• DATA DOSSIER DATA BOOK
• DATA SOSSIER DATA BOOK

19
Topsides and Subsea Classification Mapping

• Catalogue A Catalogue B
• BLANK UNKNOWN LEGACY
• CAD VERIFICATION UNKNOWN LEGACY
• CHECK SHEETS UNKNOWN LEGACY
• CURVE UNKNOWN LEGACY
• FOUNDATION SUPPORT UNKNOWN LEGACY
• INSPECTION UNKNOWN LEGACY
• MOTOR SPEED TORQUE UNKNOWN LEGACY
• PARTS LIST UNKNOWN LEGACY
• RECORD UNKNOWN LEGACY
• REQUIREMENT UNKNOWN LEGACY
• SULPHATE REMOVAL PACKAGE UNKNOWN LEGACY
• TORQUE STARTING CHARACTURES UNKNOWN LEGACY

20
Topsides and Subsea Cataloguing Equipment

• Dresser Rand Compressor
• One on Murchison and one on Balmoral Same piece
  of equipment
• Different companies - different project controls
  different documentation packages Same piece
  of equipment
• Murchison 400 records - generic descriptors
• Balmoral 800 records detailed descriptors
• Scenario - Gas leak threatens production
• Find a parts list or an exploded diagram for the
  seal cartridge
• seal plus compressor plus gas (no results
  with cartridge)
• Balmoral
• 16 original documents
• Murchison
• no original documents
• 13 documents recent documents reflecting
  modifications by CNR
• User must know history and adapt search queries

21
Technical Challenges Catalogue import to DMS

• Mapping properties from one system to another
• No classification have to work with keyword
  analysis
• Single page tif system to multipage tif
• Change management system/version structure
• Rules and assumptions must be checked or can end
  up with wrong version displayed as the latest
• Pick lists v free text
• Field lengths
• Different applications environments integrated
  systems

22
Vision

• User asks one question - gets relevant answers
• edocument control with change management
  standards across the industry
• Simple high level standard catalogue
  classification to support catalogue integration
  at AD
• .. increasing business efficiency and shareholder
  value