{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"livesearch","parameters":{"macroParams":{"spaceKey":{"value":"PR"},"size":{"value":"large"},"placeholder":{"value":"Search the IFS Reporting Wiki"}},"macroMetadata":{"macroId":{"value":"513fc34678b491bfff8fd53a4c3c8a9d2f5f0e07abc61bc3720ea276160010fb"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://ifsenr.atlassian.net/wiki/download/resources/confluence.extra.livesearch/images/search.png"}}],"title":"Live Search"}},"localId":"78e147ef-0069-4502-b75b-0acead04285c"}},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"type":"hardBreak"},{"text":"Payout Data Import ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"PayoutDataupload"}},"macroMetadata":{"macroId":{"value":"48f394a8-eaa5-4b5b-b39f-0fd321f99a26"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"80924019-e4cc-4953-9531-6c46a8b24445"}}]},{"type":"paragraph","content":[{"text":"The data in Payout.xlsx must conform to the IFS Reporting template for successful import.","type":"text"},{"type":"hardBreak"}]},{"type":"expand","attrs":{"title":"Payout Data Import Instructions"},"content":[{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"IFS Reporting provides two out-of-the-box payout reports:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"R 02.16 Payout Non-Consent Report","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"R 02.17 Unleased Mineral Interest Report","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To implement the out-of-the-box payout reports:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In addition to the standard IFS Reporting account groups, the payout reports require additional, payout-specific account groups. Also, the Payout spreadsheet must be filled out and uploaded to the ETL bulk folder. See instructions on how to do this below.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create Account Groups.","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The payout reports require the standard IFS Reporting account groups as well as the following Payout-specific account groups.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For information on how to set up the standard account groups, please see","type":"text"},{"text":" Account Groups","type":"text","marks":[{"type":"link","attrs":{"href":"https://ifsenr.atlassian.net/wiki/display/PR/Account+Groups"}}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

-PO-ID	PO Intangible Drilling Costs
-PO-TD	Tangible Drilling Costs
-PO-IC	Intangible Completion
-PO-TC	Tangible Completion
-PO-S	Surface
-PO-TM	Trans/Gath/Mark
-PO-RF	Regulatory Fees
-PO-T-O	Oil Taxes
-PO-T-G	Gas Taxes
-PO-T-N	NGL Taxes

Field	Description
Well ID	Well ID that correlates with financial product
Owner ID	Owner ID that correlates with Financial product
LASerialNumber	Louisiana Well Serial Number assigned by the state
LAOperator	Louisiana Operator code assigned by the State.
LAWellAmount	Louisiana Approved amount for Well Completion Cost
SourcePressureBase	Source Well recorded pressure base
SourceBTUBasis	Source Well recorded BTU basis - 'S'at or 'D'ry
TargetPressureBase	Target Well reportable pressure base
TargetBTUBasis	Target Well reportable BTU basis - 'S'at or 'D'ry
TotalWI	Total Well Working Interest
EligibleTaxCredit	Is this well eligible for a tax credit? 'Y' or 'N'
NonConsent	Non Consent Owner name
NonConsentDate	Date of Non Consent
NonConsentDecimal	Non consent percent in decimal
UMI	Unleased mineral interest name
UMIDecimal	Unleased mineral percent
IntDrillingPenalty	Intangible drilling penalty
TangDrillingPenalty	Tangible drilling penalty
IntCompletionPenalty	Intangible completion penalty
TangCompletionPenalty	Tangible completion penalty
SurfacePenalty	Surface penalty
LOEPenalty	LOE penalty
WOEPenalty	WOE penalty

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Field","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Well ID","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Well ID that correlates with financial product","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Owner ID","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Owner ID that correlates with Financial product","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"LASerialNumber","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Louisiana Well Serial Number assigned by the state","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"LAOperator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Louisiana Operator code assigned by the State.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"LAWellAmount","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Louisiana Approved amount for Well Completion Cost","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"SourcePressureBase","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Source Well recorded pressure base","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"SourceBTUBasis","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Source Well recorded BTU basis - 'S'at or 'D'ry","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"TargetPressureBase","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Target Well reportable pressure base","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"TargetBTUBasis","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Target Well reportable BTU basis - 'S'at or 'D'ry","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"TotalWI","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Total Well Working Interest","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"EligibleTaxCredit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Is this well eligible for a tax credit? 'Y' or 'N'","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"NonConsent","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Non Consent Owner name","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"NonConsentDate","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Date of Non Consent","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"NonConsentDecimal","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Non consent percent in decimal","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"UMI","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Unleased mineral interest name","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"UMIDecimal","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Unleased mineral percent","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"IntDrillingPenalty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Intangible drilling penalty","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"TangDrillingPenalty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Tangible drilling penalty","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"IntCompletionPenalty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Intangible completion penalty","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"TangCompletionPenalty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Tangible completion penalty","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"SurfacePenalty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Surface penalty","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"LOEPenalty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"LOE penalty","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"WOEPenalty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"WOE penalty","type":"text"}]}]}]}]}],"version":1},"reason":"A table in list item can't be created or edited in the new editor."}}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The workbook must be named ","type":"text"},{"text":"Payout.xlsx","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"},{"type":"hardBreak"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Place Payout.xlsx in the ETL pathway","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hosted","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"clients: ","type":"text","marks":[{"type":"strong"}]},{"text":"Log a case to have Managed Services upload your Payout data to the server.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On-premise","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"clients:","type":"text","marks":[{"type":"strong"}]},{"text":" Place the Payout.xlsx file in the P2 Reporting JSON folder on your IFS Reporting server.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The pathway will vary a bit, but should be similar to: ","type":"text"},{"text":"C:\\P2\\P2Reporting\\P2Energy\\bulk","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3366ff"}}]},{"text":".","type":"text"}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Verify your Data","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Log into IFS Reporting ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Run the payout report to make sure the wells are populating.","type":"text"}]}]}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}

Browser not supported