Attachment_6_User_Stories_for_Cost_Report_Tracker_1.docx

BSEE Decommissioning User Stories Cost Report Tracker Decommissioning Expenditures are due for each permanently plugged well (PA), temporary abandoned wells with a SCP in place, platform or facility removed, site cleared, and pipeline segment decommissioned. Based on 30 CFR 250.1704(i), decommissioning expenditures summaries are due 120 days after the completion of each decommissioning activity. The Decommissioning Cost Report Tracker will allow the Decommissioning Section to view the Wells, Facilities and Pipelines in which the requirement has been met, within 120 days of the due/requirement date, and those with expenditures overdue. The decommissioning expenditures summaries are submitted using TW Submittals - Decomm Expenditure Reports Required by Regulation/NTL (DECOM_EXP_REP_REQ).

As an Internal User, I would like to view Wells in which Decommissioning Expenditures are due, soon to be due, and have not been received, so that I can track what decommissioning expenditures summaries has been submitted, what haven’t been submitted, and what should be submitted in the future.

· Data displayed includes:

· Company Name, Company Number

· API Well Number

· Decommissioning Type

· Decommissioning Date

· Due Date – calculated as Decommissioning Date + 120 Days

· Status - values includes:

· Overdue

· Received | Under Review

· Report Not Required

· Waiting For Report

· Notice Sent

· Notice Send Date

· Report Received: Y/N

· Report Received Date

· Extension Granted: Y/N

· Date Granted

· Extension Date

· Remarks

· The data is sorted by Company and Status As an Internal User, I would like to view Facilities in which Decommissioning Expenditures are due, soon to be due, and have not been received, so that I can track what decommissioning expenditures summaries has been submitted, what haven’t been submitted, and what should be submitted in the future.

· Data displayed includes:

· Company Name, Company Number

· Complex Id Number ‘-‘ Structure Number

· Decommissioning Type

· Platform Removal Date

· Platform Removal Due Date

· SCV Date

· SCV Due Date

· Status - values includes:

· Overdue

· Received | Under Review

· Report Not Required

· Waiting For Report

· Notice Sent

· Notice Send Date

· Report Received: Y/N

· Report Received Date

· Extension Granted: Y/N

· Date Granted

· Extension Date

· Remarks As an Internal User, I would like to view Pipelines in which Decommissioning Expenditures are due, soon to be due, and have not been received, so that I can track what decommissioning expenditures summaries has been submitted, what haven’t been submitted, and what should be submitted in the future.

· Data displayed includes:

· Company Name, Company Number

· Segment Number

· Decommissioning Type:

· Decommissioning Date

· Due Date – calculated as Decommissioning Date + 120 Days

· Status - values includes:

· Overdue

· Received | Under Review

· Report Not Required

· Waiting For Report

· Notice Sent

· Notice Send Date

· Report Received: Y/N

· Report Received Date

· Extension Granted: Y/N

· Date Granted

· Extension Date

· Remarks

· The system will auto populate the status based on the following conditions:

· Overdue: 120 Days after the asset has been decommissioned and a Submittal has not been submitted in TW Submittal.

· Received | Under Review: A submittal has been Accepted in TW Submittal for this Well/Facility/Pipeline.

· Report Not Required: This may need to be a manual selection.

· Waiting For Report: A submittal has not been submitted using TW Submittal for this Well/Facility/Pipeline

· Allow the status to be modified.

· The Notice Sent and Send Date are based on data tracked in the user story pertaining to Tracking Mailing Notification associated with the Well, Facility, and Pipelines.

· The Report Received and Received Date are based on the data tracked in the user story pertaining to Decommissioning Expenditures submittals.

· The Extension Granted, Date Granted and Extension Date is based on data tracked in the user story pertaining to Time Extension submittals.

As an Internal User, I would like to search the results by Company, API Well Number, Complex Id Number and Segment Number, so that I can view the associated decommissioning Wells, Facilities and Pipelines data.

· Allow the user to select a Company to view associated data.

· Allow the user to select All Companies to view the associated data.

· Allow the user to enter an API Well Number to view the associated Well data.

· Allow the user to enter the Complex Id Number to view the associated Facility data.

· Allow the user to enter the Segment Number to view the associated Pipeline data.

· Allow the user to select to view All Records.

As an internal user, I would like to generate a Courtesy Reminder Report of the Decommissioning Expenditure summaries that are to be submitted to BSEE, so that I can email the report to the operator.

· Allow the user to select a Company.

· Displays a listing of Wells, Facilities and Pipelines that have been decommissioned and the Expenditure report has not been received for the selected Company. The status will be Waiting for Report or Overdue.

· The data displayed for Wells includes:

· Company

· API Well Number

· Decommission Type

· Status

· Decommission Date

· Due Date

· Extension Granted

· Notified

· The data displayed for Facilities includes:

· Company

· Complex Id Number ‘-‘ Structure Number

· Decommission Type

· Platform Removal Date

· Platform Removal Due Date

· Site Clearance Verification (SCV) Date

· SCV Due Date

· Extension Granted Date

· The data displayed for Pipelines includes:

· Company

· Segment Number

· Status

· Decommission Type

· Decommission Date

· Due Date

· Extension Granted Date

· Notified

· Allow an option for the user to Open the Report to view the results in PDF format. The information contained in the report are included as an attachment. It includes a title, three paragraphs and data for Wells, Facilities, and Pipelines.

· The data for Wells includes:

· API Well Number

· Well Name

· Area/Block

· Decommission Type

· Status

· Decommission Date

· Due Date

· Extension Date

· The data for Facilities includes:

· Complex Id Number

· Area/Block

· Decommission Type

· Status

· Removal Date

· PR Due Date

· SCV Date

· SCV Due Date

· Extension Date

· The data for Pipelines includes:

· Segment Number

· Status

· Decommission Type

· Decommission Date

· Due Date

· Extension Date

· Allow an option for the user to Print the Report.

· The report can be printed for a single company or for all companies.

As an Internal User, I would like to select the Well, Facility or Pipeline to view/capture details associated with INCs, Decommissioning Expenditure submittal, Time Extension submittal and notifications so that I can track the operator’s transactions as it pertains to the decommissioned asset.

· Data pertaining to INCs are described in the INC user story.

· Data pertaining to Decommissioning Expenditures are described in the Decommissioning Expenditures submittal user story.

· Data pertaining to Time Extension are described in the Time Extension submittal user story.

· Data pertaining to notifications are described in the Tracking Mailing Notification user story.

As an Internal User, I would like to enter Remarks associated with the decommissioning asset so that I can review the comments for the asset.

As an Internal User, for each infrastructure, I would like to track the INCs that are issued to the entities for failure to submit the decommissioning expenditures report within 120 days of completion of decommissioning.

· Associate the INC issued with the following criteria:

· INCs created using infrastructure (API, Segment Num, Complex Id)

· Regulation numbers includes at least one of the following: 30 CFR 250.1704(i), 30 CFR 250.1704(j)

· Display the INC Number and Description

· Display the INC Issued Date

· Display To Whom it is assigned.

· Display the INC Correction Deadline Date

· Capture the INC Correction Deadline Extension Date (associated with a time extension request – should be in INC Response)

· Display the INC Correction Date

· Display INC Status

· For each infrastructure, there can be multiple INCs.

· Capture Tracking Mailing Notification. The data pertaining to Tracking Mailing Notification is described in the Tracking Mailing Notification user story.

As an Internal User, I would like to display data capture regarding the decommissioning expenditures requests received so that I can track the receipt and status of the Decommissioning Expenditures in TW Submittals.

· Associate the TW Submittal Decomm Expenditure Reports based on WELL_API_NUMBER, COMPLEX_ID_NUM, and/or SEGMENT_NUM

· Decomm Expenditure Reports Required by Regulation/NTL (DECOM_EXP_REP_REQ)

· Display the TW Submittal information for each submittal. The data pertaining to TW Submittals is described in the TW Submittal user story.

· Report Received Date is assigned the Submitted Date when final action of Accept has been taken.

· Report Received is assigned the value of Yes when a Decomm Expenditure Reports is submitted.

· Allow for multiple requests.

· Capture Tracking Mailing Notification. The data pertaining to Tracking Mailing Notification is described in the Tracking Mailing Notification user story.

As an Internal User, I would like to display data capture regarding the time extension requests received so that I can track the Time Extensions received in TW Submittals.

· Associate the TW Submittal Time Extension Request based on WELL_API_NUMBER, COMPLEX_ID_NUM, and/or SEGMENT_NUM

· Time Extension to Submit Decom Expenditure Reports as per 250.1704(i) (DCOM_TIME_EXT_EXPENDITURES)

· Display the TW Submittal information for each submittal. The data pertaining to TW Submittals is described in the TW Submittal user story.

· Date Granted is assigned the Variance Approval Date

· Extension Date is assigned the Variance Expiration Date

· Allow for multiple requests.

· Capture Tracking Mailing Notification. The data pertaining to Tracking Mailing Notification is described in the Tracking Mailing Notification user story.

As an Internal user, I would like to view the data associated with the TW Submittal, so that I can view the information associated with the submittal that was submitted.

· For each submittal, display the following:

· Display Submittal Id

· Display Company (Submitter)

· Display Submittal Types Description

· Display Submittal Date

· Display Request Description

· Display Current Status

· Display Current Status Date

· Display Submittal Attributes As an Internal user, I would like to view and capture the Tracking Mailing Notification data associated with each notification, so that I can track the notifications.

· Tracking Mailing Notification includes the following:

· Capture Notification type (email, mail)

· Capture Mailing Address

· Capture Email Address

· Capture Mailing Date

· Capture Tracking Number

· Capture Date Received by Company

· Capture Acceptance of Mailing (Yes/No/Refused)

· Allow for multiple notification