Royalty Reporting (IS-OIL-PRA-REP-ROY)

ID: I400001074
Table Description
OIUGR_ROYSTG Gen Rep - Royalty Transaction (Staging)
OIUGR_ROYTXN Gen Rep - Royalty Transaction
OIUGR_ROYTXNA Gen Rep - Royalty Transaction (Allocated)
OIUGR_PRDT Gen Rep - PRA Detail Transaction
OIUGR_PRDTA Gen Rep - Royalty Transaction (Allocated)
OIUGR_ROYHST Gen Rep - Royalty Transaction History
OIUGR_ROYHSTA Gen Rep - Royalty Transaction History (Allocated)
OIUGR_OOSHST Gen Roy 2.0 - Out-of-Statute History
OIUGR_OOSTXN Gen Roy 2.0 - Out-of-Statute Transactions
/PRA/UTX_INTSTG Roy 2.0 - TX UT - Royalty Trans Interface Staging
/PRA/UTX_INTTXN Roy 2.0 - TX UT - Royalty Transaction Interface
OIUY3_TX_INTSTG Royalty 2.0 - TX GLO - Royalty Trans Interface Staging
OIUY3_TX_INTTXN Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface
OIUY6_WY_INTSTG Royalty 2.0 - WY - Royalty Transaction Interface (Staging)
OIUY6_WY_INTTXN Royalty 2.0 - WY - Royalty Transaction Interface
OIUREP_MRT_HIST MMS-2014 MMS Royalty Transaction Processed History
OIUREP_2014_REP MMS-2014 - Supplemental Reports From Report Executions
OIUREP_RRST Regulatory Reporting Status Table
OIUREP_RRST_NEW NEW Regulatory Reporting Status Table (with Version Number)
OIUREP_2014_RUNS MMS-2014 - Report Executions
OIUREP_RRST_DET Regulatory Reporting Status Table
OIUGR_MIG_CTRL Gen Rep - Migration Control
OIUREP_MMS_REJS MMS-2014 - Extraction Rejects
OIUREP_RT_HIST MMS-2014 - Royalty Transaction (Pending) History
OIUREP_VL_VOL Gross Volume and Value after VL/RD
OIUREP_ADJ_HDR Adjustment Header for MMS OGOR
OIUREP_RWC WCs that have been changed since previous report run
OIUY3_TX_ROYSTG Royalty 2.0 - TX GLO - Royalty Transactions (Staging)
OIUY3_TX_ROYTXN Royalty 2.0 - TX GLO - Royalty Transactions
OIUY3_TX_ROYTXNA Royalty 2.0 - TX GLO - Royalty Transactions (Allocated)
OIUREP_ADJ_DTLA MMS OGOR A Adjustment Detail Record
OIUREP_ADJ_DTLB MMS OGOR B Adjustment Detail Record
OIUREP_ADJ_DTLC MMS OGOR C Adjustment Detail Record
OIUREP_ADJ_PASR MMS PASR Adjustment Detail Record
OIUREP_ADJ_PASRH MMS PASR Adjustment Header Record
OIUY6_WY_ROYSTG Royalty 2.0 - WY - Royalty Transactions (Staging)
OIUY6_WY_ROYTXN Royalty 2.0 - WY - Royalty Transactions
OIUY6_WY_ROYTXNA Royalty 2.0 - WY - Royalty Transactions (Allocated)
/PRA/UTX_ROYSTG Roy 2.0 - TX UT - Royalty Transactions (Staging)
/PRA/UTX_ROYTXN Roy 2.0 - TX UT - Royalty Transactions
/PRA/UTX_ROYTXNA Roy 2.0 - TX UT - Royalty Transactions (Allocated)
OIUGR_RPDT Gen Rep - Report Detail Transaction
OIUREP_MASTER_ST Maintain Errors during Manual Upload in Master MP reg ID
OIUGR_PRDT_CA Gen Rep - PRA Detail CA Data
OIUGR_PRDT_PR Gen Rep - PRA Details PR Data
OIUGR_ROYHST_CA Gen Rep - Royalty History CA Data
OIUGR_ROYHST_PR Gen Rep - Royalty History PR Data
OIUGR_ROYSTG_CA Gen Rep - Royalty Transaction CA Data (Staging)
OIUGR_ROYSTG_PR Gen Rep - Royalty Transaction PR Data (Staging)
OIUGR_ROYTXN_CA Gen Rep - Royalty Transaction CA Data
OIUGR_ROYTXN_PR Gen Rep - Royalty Transaction PR Data
OIUREP_VOLHIST Reported Volume Data by Reporting Entities
OIUREP_VOL_DATA Reported Volume Data by Reporting Entities
OIUY3_TX_OOSHST Royalty 2.0 - TX - Out of Statute Royalty Transaction Hist
OIUY3_TX_OOSTXN Royalty 2.0 - TX GLO - Out of Statute Royalty Transactions
OIUY3_TX_PRDT Royalty 2.0 - TX GLO - Royalty PRA Details
OIUY3_TX_PRDTA Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated)
OIUY3_TX_ROYHST Royalty 2.0 - TX GLO - Royalty Transaction History
OIUY3_TX_ROYHSTA Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)
OIUY6_WY_OOSHST Royalty 2.0 - WY - Out of Statute Royalty Transaction Hist
OIUY6_WY_OOSTXN Royalty 2.0 - WY - Out of Statute Royalty Transactions
OIUY6_WY_PRDT Royalty 2.0 - WY - Royalty PRA Details
OIUY6_WY_PRDTA Royalty 2.0 - WY - Royalty PRA Details (Allocated)
OIUY6_WY_ROYHST Royalty 2.0 - WY - Royalty Transaction History
OIUY6_WY_ROYHSTA Royalty 2.0 - WY - Royalty Transaction History (Allocated)
OIUREPP_LEASE MMS-2014 - Lease PPA
OIUREPP_OWNER MMS-2014 - Owner PPA
OIUREPP_WCPAYXRF MMS-2014 - Well Completion / Payor XRef PPA
OIUREP_HISTCNTRL Regulatory Reporting History Control table
OIUREP_RECOUP MMS-2014 - Recoupable Balance
/PRA/UTX_OOSHST Roy 2.0 - TX UT - Out of Statute Roy Transactions History
/PRA/UTX_OOSTXN Roy 2.0 - TX UT - Out of Statute Royalty Transactions
/PRA/UTX_PRDT Roy 2.0 - TX UT - Royalty PRA Details
/PRA/UTX_PRDTA Roy 2.0 - TX UT - Royalty PRA Details (Allocated)
/PRA/UTX_ROYHST Roy 2.0 - TX UT - Royalty Transaction History
/PRA/UTX_ROYHSTA Roy 2.0 - TX UT - Royalty History (Allocated)
OIUY6_WY_RPDTD Royalty 2.0 - WY - Report Details
OIUY6_WY_RPDTL Royalty 2.0 - WY - Report Details Lease
OIUY6_WY_RPDTU Royalty 2.0 - WY - Report Details Unit
OIUYA_CO_FORM7 Roy 2.0 CO - Form 7 Data
OIUYA_CO_RRST Roy 2.0 CO - Processed FORM 7 Reports
OIUY9_LA_PRDTA Roy 2.0 LA – PRA Details
OIUY9_LA_ROYHSTA Roy 2.0 LA – Royalty History
OIUY9_LA_ROYTXNA Roy 2.0 LA – Royalty Transactions
OIUY3_TX_REVSTG Royalty 2.0 - TX GLO - Royalty Reversals (Staging)
OIUY3_TX_REVTXN Royalty 2.0 - TX GLO - Royalty Reversals
/PRA/UTX_REVSTG Roy 2.0 - TX UT - Royalty Reversals (Staging)
/PRA/UTX_REVTXN Roy 2.0 - TX UT - Royalty Reversals
OIUY6_WY_REVSTG Royalty 2.0 - WY - Royalty Reversals (Staging)
OIUY6_WY_REVTXN Royalty 2.0 - WY - Royalty Reversals
OIUGR_REVSTG Gen Rep - Royalty Reversal Transaction Staging
OIUGR_REVTXN Gen Rep - Royalty Reversal Transaction
OIUYA_CO_RPDT Roy 2.0 CO – Report Details
OIUREP_ROYHIST Reported Royalty and Volume Data by Reporting Entities
OIUREP_ROY_DATA Reported Royalty and Volume Data by Reporting Entities
OIUREP_2014_INFO MMS-2014 - Report Executions Start information
OIUY3_TX_RPGDT Royalty 2.0 - TX GLO/TAMU - Gas Report
OIUY3_TX_RPODT Royalty 2.0 - TX GLO/TAMU - Oil Report
OIUREP_XTRCT_ROY Extract Royaty Data for the current reporting period
OIUREP_REG_HIST Reporting history (System table INDX)
OIUY9_LA_RPDT Roy 2.0 LA - Report Details
OIUY8_NM_PRDTA Roy 2.0 NM – PRA Details
OIUY8_NM_ROYHSTA Roy 2.0 NM – Royalty History
OIUY8_NM_ROYTXNA Roy 2.0 NM – Royalty Transactions
OIUREP_ROY_AGY Reporting Agencies for Tax and Royalty
OIUREP_AGENCIES Regulatory Reporting Agencies
OIUREP_MASTER Regulatory Reporting Master Data
OIUREP_MASTER_MP Re.Reporting - MP related Reg ID
OIUREP_PR_REG Master data for rounding setup
OIUREP_REG_OPERA Regulatory Reporting Operator and Contact Xref
OIUREP_REG_OPER Regulatory Reporting Operator and Contact Xref EFF Dated
OIUREP_AGY_LSE Agency assigned Leases
OIUREP_EIA_914NO Regulatory Reporting - Group - New Operators
OIUREP_EIA_914PO Regulatory Reporting - Group - Previous Operators
OIUREP_AGY_PDCD Agency defined Product Code
OIUREP_FEDINDIAN MMS-2014 - Federal or Indian Leases
OIUREP_LEASE MMS-2014 - Lease
OIUREP_MP_XREF Regulatory Reporting X-ref - MP to State Assigned ID
OIUREP_OWNER MMS-2014 - Owner
OIUREP_PAYOR MMS-2014 - Payor / Company Code XRef
OIUREP_SALESTY MMS-2014: Sales Type Control Table
OIUREP_WCOWNERS MMS-2014 - Well Completion w/ Multiple Owners
OIUREP_WCPAYXREF MMS-2014 - Well Completion / Payor XRef
OIUREP_MMS_DTEDT MMS-2014 Edit Effective Date Table
OIUY3_TX_BAXRF Royalty 2.0 - TX GLO/TAU - BA Xref
OIUY3_TX_LEASE Royalty 2.0 - TX GLO - Lease Master
OIUY3_TX_PDCXRF Royalty 2.0 - TX GLO/TAMU - Production Disposition XRef
OIUY3_TX_RDCXRF Royalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef
OIUY3_TX_REJ Royalty 2.0 - TX GLO/TAMU - Reject Codes
OIUY3_TX_RDXR_CT Royalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef at CT
/PRA/UTX_LEASE Roy 2.0 – TX UT - Lease Master
/PRA/UTX_PDCXRF Roy 2.0 - TX UT - Production Disposition XRef
/PRA/UTX_PROF Roy 2.0 - TX UT - Reporting Profile
OIUY6_WY_CAPOVR Roy 2.0 - Wyoming - CA Percent Override
OIUY6_WY_CBMOVR Royalty 2.0 - WY - Coal Bed Methane Override
OIUY6_WY_LEASE Royalty 2.0 - WY - Lease Data
OIUY6_WY_PRICE Royalty 2.0 - WY - Report Pricing
OIUY6_WY_REJ Royalty 2.0 - WY - Reject Codes
OIUGR_PDC Gen Rep - Agency Product Code
OIUGR_REJ_CD Gen Rep - Reject Codes
OIUYA_CO_ENTITY Roy 2.0 CO – Entity/Lease details
OIUYA_CO_MASTER Roy 2.0 CO – Master Data details
OIUYA_CO_ZVOL Roy 2.0 CO - Zero Volume Reporting Master
OIUREP_EIA914CMT Regulatory Reporting - EIA-914 Form Comments
OIUREP_EIA_HSTHD Regulatory Reporting - EIA914 Report History Header
OIUREP_GROUP_HD Regulatory Reporting - EIA 914 : Group Master
OIUREP_GR_EIA914 Regulatory Reporting - EIA914: Group Master Data
OIUY5_OK_ENTITY Roy 2.0 OK – Lease Details
OIUY5_OK_PROF Roy 2.0 OK - Reporting Profile
OIUY9_LAY_ENTITY Roy 2.0 LA – LUW/Lease Details (PPN)
OIUY9_LA_ENTITY Roy 2.0 LA – LUW/Lease Details
OIUY9_LA_PROF Roy 2.0 LA - Reporting Profile
OIUY8_NM_ENTITY Roy 2.0 NM – PUN/Lease Details
OIUY8_NM_PROF Roy 2.0 NM - Reporting Profile
OIUGRY_ENTITY Gen Rep - Agency Entity (PPN)
OIUGR_ENTITY Gen Rep - Agency Entity
OIUGR_MASTER_HD Gen Rep - Master Header
OIUREP_SUPL_REP MMS-2014 - Supplemental Reports
OIUREP_LGL_RPTS Legal Reports for Tax and Royalty Reporting
OIUREP_STRUC Regulatory Reporting Structures
OIUREP_EIA_HSTDT Regulatory Reporting - EIA914 Report History Details
OIUY3_TX_ASU_HD Royalty 2.0 - TX GLO/TAMU - Auto Suspend Header
OIUY3_TX_SOL Royalty 2.0 - Texas GLO Statute of Limitation
OIUY3_TX_SOLEHD Royalty 2.0 - TX GLO/TAMU SOL Exception Header
OIUY3_TX_ASUE_HD Roy 2.0 TX - Auto Suspend Exception Header
/PRA/UTX_ASUE_HD Roy 2.0 - TX UT - Auto Suspend Exception Header
/PRA/UTX_ASU_HD Roy 2.0 - TX UT - Auto Suspend Header
/PRA/UTX_SOL Roy 2.0 - TX UT - Statute of Limitation
/PRA/UTX_SOLEHD Roy 2.0 - TX UT - SOL Exception Header
OIUY6_WY_ASUE_HD Roy 2.0 WY - Auto Suspend Exception Header
OIUY6_WY_ASU_HD Royalty 2.0 - WY - Auto Suspend Header
OIUY6_WY_SOL Royalty 2.0 - Wyoming Statute of Limitation
OIUY6_WY_SOLEHD Royalty 2.0 - WY Statute of Limitation Exception Header
OIUREP_EIA_HSTAO Regulatory Reporting - EIA914 Report History Additional data
OIUREP_REPORTS Supported Regulatory reports
OIUREP_TEXT_XREF Regulatory Reporting Texts for Diff Reporting Levels
OIUREP_2014_CONF MMS-2014: Configurable Items
OIUREP_ACTIVATE Reg./Tax and Royalty Reporting - report activation
OIUREP_ADJCD_XRF MMS-2014 - Reversal Rsn to Adjustment Reason Code XREF
OIUREP_CM_JIL Activate JIL control table
OIUREP_CODE_XREF Reg Reporting Product/Volume Type to Report Code Cross Ref
OIUREP_COMN_KEYS Reg.Reporting - Field description for COMN table keys
OIUREP_DD_STRUCT Master DD file structures
OIUREP_INDIAN_TR MMS-2014 - Indian Tribes
OIUREP_MMS_ACTN MMS Well Status Reason Code/Action Code Combos (OGOR-A)
OIUREP_MMS_REAS MMS Well Status / Reason Code Combinations (OGOR-A)
OIUREP_ROY_FLDTX Text Table for Report Fields
OIUREP_ROY_PRFL Royalty Reporting Profiles
OIUREP_RPT_PRFL Report Profile
OIUREP_RUNGRPKEY Reg.Reporting - Report Submission groups
OIUREP_RUN_GROUP Reg.Reporting - Report Submission grouping
OIUREP_TRAN_ERR Transaction code to error code xref for edits/vals
OIUREP_UOM Regulatory Report Unit of Measures
OIUREP_PD_MPP MMS Prod. Code/Entity Type enabling for Major Portion Price
OIUY3_TX_GLO2_TH Royalty 2.0 - TX GLO/TAMU - GLO2 Threshold
OIUY6_WY_PDCXRF Royalty 2.0 - WY - Product Code Xref
OIUGR_ENTITY_CON Gen Rep - Agency Entity Link Config
OIUGR_PDCXRF Gen Rep - PRA Product Code / Agency Product Code Xref
OIUGR_PROC_ID Gen Rep - Reporting Processes
OIUGR_MASTER_CON Gen Rep - Master Link Config