Recommended Job Startup Procedure - SQL Server Database
The following document details the recommended procedures to follow in Well Seeker Pro from pre job, through to post job. These procedures are designed to aid office and field personnel by providing a structured, repeatable workflow for them to follow.
The document is split into the following sections:
- Pre-job - Office Steps
- Job Start - Rigsite Steps
- Real Time Monitoring - Office Tools
- Post-Job - Office Steps
1. Log on to the SQL server field database.
2. Check the correct Compass Import Settings are selected.
This step is critical. Well Seeker requires each well name to be unique, whereas Compass does not. For example, a Compass file could contain two wells named 3H, but if Well Seeker has two wells named 3H then the data will be corrupted and only one well will display. To account for this, ensure that the Append Operator Name to Field, Append Field Name to Facility & Append Facility Name to Well are selected.
3. Select Import Compass EDM file.
4. Select the correct Compass export file to import that includes final well plan and any offset wells not already included in the database.
5. Right click at well level
6. Select Insert new actual well
7. Input and check actual well name, vertical section, magnetics and depth reference details
8. Select Apply
9. Right click at actual well level
10. Select Insert new survey
11. Input and check survey name, tie on details and survey instrument / IPM
12. Select Apply
13. Double left click on the newly created survey. This will open the survey table
14. Select the save icon
15. Close the survey table
16. Double left click on the actual wellbore. This will open the actual wellbore table
17. Select the Select Offsets icon
18. Select all relevant offset wells and the definitive well plan (this is important as it will determine what offset wells get pulled down by the rig)
19. Select Apply
20. Select the actual wellbore and then right click and select Reporting > Drill String Editor. Alternatively select the Drill String Editor icon from the toolbar
21. Select the Add new BHA icon
22. Input BHA description
23. Input BHA number
24. Select the save icon
25. Close the Drill String Editor window
26. Select Tools > Well Permissions
27. If using well permissions, then ensure that the Enable Individual Well Permissions is checked. If not, then ensure it is unchecked
28. If using well permissions, input the relevant computer names and well that that computer will be authorized to pull down. Ensure the Active cell is checked. Apply
31. Select Tools > Rig Names
32. Ensure the details are correct and up to date. Select Apply
33. Right click on the actual well and select Reporting > Daily Reporting. Alternatively select the Daily Reporting icon from the tool bar. This will open the Daily Reporting dialog
34. Select the Activity Codes button from the Daily Reporting toolbar
35. Verify that the Activity Codes are correct and select Apply
36. Select the Cost Codes button from the Daily Reporting toolbar
37. Verify that the Cost Codes are correct for the well and select Apply
38. Select the Phase Codes button from the Daily Reporting toolbar
39. Verify that the Phase Codes are correct and select Apply
40. Select the job status as Upcoming
41. Select the job coordinator from the dropdown menu. If the correct name is not available, then update the Personnel Names and Details table
42. Select the Save icon.
43. Close the Daily Reporting dialog
44. Right click on the actual wellbore and select External Files
45. Here you can add any files that that you want the rig to have when they start the job. Select the browse icon and select the file you want to upload
46. Select Add
1. Double left click on the Well Seeker icon on the desktop
2. Well Seeker will open and the database tree should be blank
3. You need to pull down your job from the server database. Select Tools > Remote Data Fetch. This will bring up the Data Fetch dialog, which will allow you to select your job from the server
4. Ensure IP and Port numbers are input correctly
5. Ensure Filter By Status is unchecked
6. Select Connect
7. Select to Auto Pull Offsets
8. Select your well from the remote database tree
9. Select Pull Selected
10. Once your well has been pulled from the server a message will appear. Select OK
11. Select Close
12. Right click on the actual wellbore and select External Files
13. Here you can view any files that the office may have put in pre-job. You can also put any signed tickets here during the job
14. Right click on the Plan and select Properties
15. Check that all the information is correct before closing
16. Double left click on the plan to open it
17. Check that the well plan matches what well planning sent in their report
18. The office will have an actual wellbore already made for you. Right click on the actual wellbore and select Properties
19. Check that the data is correct and matches the well plan
20. The office will have an actual wellbore already made for you.
21. Right click on the actual wellbore and select Properties
22. Check that the data is correct and matches the well plan
23. Click on the actual wellbore
24. Click on the Daily Reporting icon
25. Click on the Add Daily Report icon
26. Click on the Well Data and Personnel icon
27. Fill in the Job #
28. Select the Rig, State, County and Personnel names from the dropdown menus, as well as filling in the time on and off shifts. If any names / rigs are not present, then get the office to update their list on the server database
29. Select Apply
30. Select the Daily Costs icon
31. Enter the charges for the day from the dropdown menu and quantity
32. Select Apply
33. Select the Tool Inventory icon
34. Enter the tools on location
35. Select Save
36. Go back to the Daily Reporting dialog and change the Well Status to Active
37. Select Reporting Options > Set Default Activity Code / Description. Select 10D: Connection and Survey and Apply
38. Start entering your daily activities
39. Select Save
40. Select the Drill String Editor icon
41. Select the component from the dropdown list. Then right click and select either Insert from Inventory or Catalogue
42. Select the component and then select Insert
43. Fill in the Component Properties details
44. Repeat process for the rest of the BHA
45. All rigs should send data back to the server database. Select the RT Data Exchange icon
46. Check the well and data selections are correct. Set the update rate to 30 minutes. Select Start
47. Close the dialog. The data exchange will continue to run in the background even when closed
48. To open the slide sheet you must first open a survey. Double left click on your survey
49. Select the Slide Sheet icon from the toolbar
50. Select the BHA you are drilling with. Enter the start date and time that drilling commenced
51. Input drilling parameters. Important to input as accurately as possible, as this impacts the rest of the reporting and KPI data
Steps 52 – 64 are only relevant on jobs running WITS. If you are not running WITS you can skip ahead to step 65.
52. WITS can also be used to populate the slide sheet. Select Tools > WITS Mapping. Verify mapping is the same as incoming WITS source
53. The rest of the WITS options are accessed from the slide sheet. Select the Slide Sheet icon from the toolbar
54. Select the Configure WITS Data icon
55. Select the applicable WITS port and select Start Reading. Ensure WITS data is being received
56. Check Send Data To Server. This sends the WITS stream to the Server database. If successful, the data stream will read Update completed with no critical errors
57. Minimize the WITS Reader, do not close it
58. Select the Rig States icon
59. Ensure thresholds are appropriate for incoming WITS data
60. Incoming WITS data values will be visible in the Current WITS Data section
61. Minimize the Rig States Settings dialog, do not close it
62. Select the Auto Populate Slide Sheet icon. The message Live Rig States Running will be visible. All times, depths and drilling parameters will be populated by the incoming WITS data
63. In order to manually edit the slide sheet the automatic updates must first be turned off
64. Minimize the Slide Sheet dialog, do not close it
65. Throughout the day during drilling, come back to the daily report after selecting save on the slide sheet and update the daily report. Select Get DDR from Run Sheet. This will update the daily activities section
66. Select Get Params. This will update the drilling parameters section
67. Select Calculate. This will update other information
68. During the day check that your slide sheet and daily reporting data match. Select the Check Daily Activity against slide sheet icon.
69. Any differences will be detailed in the message
70. There are also data validation options available to help you keep your data updated and correct
71. Plots can be viewed when a plan, survey of well are open
72. Select any of the plot icons from the main toolbar
73. Offsets for a plan, survey or well can be selected / adjusted. Select the Select Offsets icon. Check the relevant offsets and select Apply
74. To toggle the offsets visible on and off on the plots select the Offsets On icon
75. When a survey is open you can view the real time anticollision dialog. Select the RT AC icon from the toolbar
76. The real time AC dialog will show the anticollision results for all the selected offsets and the center-to-center distances from the plan and any lease / hard lines
77. Projection tools can be accessed when a survey is open. Select Tools > Projection Tools and select the relevant option
78. Various reports can be printed via the main UI Reports menu
79. Additional reports can be printed from the Daily Reporting dialogs File menu. The content included in these reports can be customized within Reporting Options
80. At the end of a run update details in the BHA performance dialog. From the Drill String Editor dialog select the Performance Report icon
81. Select Get data from DDR
82. Fill in any additional data. Performance, failure and chargeback information is all input within this dialog
83. Select Save
84. Shipping tickets can be created when sending tools back from location. With the current well selected, select the Shipping Ticket icon from the toolbar
85. Select the Add Ticket icon
86. Fill in the details and check all the components that are being shipped
87. When completed select Ship Tools. This will update your inventory
88. At the end of the well check reports for input errors. Right click on the actual well and select Reporting > Daily Activity Editor
89. Any errors found will be displayed in a message
90. Correct any errors highlighted in red (note NPT activities will also be in red, no need to edit these)
91. Select Apply and then Yes
Things to Check
92. Each BHA needs one pick up (6O) and one lay down (6P) activity code
93. Every row has the correct phase selected
94. Every row has the correct BHA selected. If no BHA is in hole, then no BHA should be selected
95. No depth or time gaps when on location
96. At the end of the well, change the Well Status to EOW Ready or EOW Sent, dependent upon the job status. The Well Status should be updated during the well if the status changes from anything other than Active. This will update the office who will have an overview of the status of all the jobs running
1. As well as standard Well Seeker functionality, there are multiple tools that can be used on the SQL server database that aid real time monitoring of multiple wells. Dashboards can be found that provide details for multiple wells by selecting Tools > Dashboards
2. The Activity Dashboard provides an overview of all the wells on the SQL server database. Filter the well results using the filters
3. View either the summary of all the wells or details for a specific well from the filtered list
4. The Logistics Dashboard provides an overview of all the tools in an actual wells inventory on the SQL database. Filter the results using the filters
5. Clicking on the well location pinhead on the map will display a list of the filtered tools on location
6. The Rigs Online Dashboard provides an overview of all the PCs that are pushing data back to the SQL server database
7. Select File > Shows WITS Connections to view a similar list displaying the number of PCs that are transmitting back real time WITS data to the SQL server database
8. The Anti-Collision Dashboard displays all the wells that have a well status of Active on the SQL server database. Select File > Open RT AC For Active Wells
9. Check the Select cell for the required wells, update the offset selection if required and select OK
10. The selected wells will be opened, with a Real Time AC dialog for each and will be included on the dashboard
11. For a detailed overview of a specific well the DD Dashboard is a very useful tool. To access it open a survey from the relevant well, select the Slide Sheet icon
12. Select the DD Dashboard icon
13. The DD Dashboard displays the bit projection, advisory and anti-collision data based upon the survey and slide sheet data
14. The real time gauges and drilling parameters sections update based upon incoming WITS data
15. The settings can be adjusted from the menus
1. Verify that the bottom line of the actual wellbore and actual wellbore property details match the well planner’s details
2. At the end of the well check reports for input errors. Right click on the actual well and select Reporting > Daily Activity Editor
3. Any errors found will be displayed in a message
4. Correct any errors highlighted in red (note NPT activities will also be in red, no need to edit these)
5. Select Apply and then Yes
Things to Check:
6. Each BHA needs one pick up (6O) and one lay down (6P) activity code
7. Every row has the correct phase selected
8. Every row has the correct BHA selected. If no BHA is in hole, then no BHA should be selected
9. No depth or time gaps when on location
10. When all data has been QC’d and finalized, change the Well Status to Verified
11. Transfer the well data from your field database to the clean database using your company specific method
12. When all data has been transferred to the clean database, change the Well Status to Transferred
Last modified 1yr ago