OIUREP_MASTER

Regulatory Reporting Master Data | #masterdata | Component: Royalty Reporting
Column Name Description
MANDT FK Client
AGENCY FK Agency for Reporting
REP_NAME FK Regulatory Report Name
WL_NO FK Well ID number
WC_NO FK Well Completion Number
EFF_FROM_DT Effective from date
Column Name Description
Column Name Description
📏 Unit of measure of production allowable (ALLOW_UOM):
ALLOW_QTY Daily production allowable quantity
START_CUM_ALLOW Starting cummulative over/under allowance
Column Name Description
EFF_FROM_DT Effective from date
EFF_TO_DT Effective To Date
INAC_ABANDON Inactive Abandon Date
Column Name Description
EFF_TO_CD Checkbox Show values
UNITZ_FLG Checkbox Show values
MMS_ACT_CD MMS Well Status Action Code (OGOR-A) Show values
MMS_WELL_STAT MMS Well Status Code (OGOR-A) Show values
MMS_REAS_CD MMS Well Status Reason Code (OGOR-A) Show values
INACTIVE_FLAG Report on inactive well report only Show values
CBM_INDICATOR Coal Bed Methane Indicator Show values
Column Name Description Domain name
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
USERID User Name SYCHAR12
DIST_NO District number for Texas Reg ID CHAR3
GAS_WL_NO Regulatory Reporting: Gas Well Number
CMGL_PRMT_NO Commingled Permit Number CHAR8
RPT_CD Texas Report Code CHAR1
RRC_GAS_WL_NO Texas Railroad Commission Gas Well number CHAR16
RRC_OIL_NO Reg Reporting - TX H-10 Lease Number OIUREP_TX_LEASE_NO
RRC_SP_DSC_TX 30 Characters CHAR30
GAS_RRC_ID_NO Regulatory Reporting: Gas RRC ID
P1B_RRC_OIL_LSE Texas P-1B RRC Oil Lease
PARTIALLY_UNTZ Texas P-1B Partially Unitized
SPECIAL_PROJECT Texas P-1B Special Project
DRILL_PRMT_NO Regulatory Reporting: Texas Drilling Permit Number OIUREP_TX_DRILL_PERMIT
OPER_LSE_NO Operator Lease Number (internal id)
LSE_NO Lease Number (Externally-Issued ID)
AGY_LSE_NO Agency Lease Number (externally issued id)
MMS_GRP_API_WL API well number group OIU_WLAPI
MMS_GRP_API_WC API well completion number group OIU_API_WC_NO
OPER_WELL_NO OGOR-A Operator Well Number
OP_WL_NO Operator Well number (9-Character, NM)
NM_POOL_CD Pool Code (Reg ID)
NM_ST_PR_NO NM State Property Number
UNIT_NO Unit No (NM Reg ID)
OGRID_NO OGRID number
H2O_POD_NO Reg.Reporting New Mexico - H2O POD Code
CA_H2O_SRCE_CD Regulatory Rep: California H2O Source Code
CA_H2O_DISP_CD Regulatory Rep: California H2O Disposition Code
FIELD_NO Reg. ID specific field number - override CHAR8
UNIT_NUMBER Unit Number (WY Form 2)
INJ_SRCE_CD Injection Source
AGY_WELL_ID Agency well ID
ND_WELL_NAME Well Description OIU_TEXT35_CONV
ND_WELL_NO Well ID number OIU_WL_NO
ND_WL_FILE_NO Regulatory Reporting - North Dakota Well File Number
UIC_NO Reg. Reporting - ND Undergound Injection Control Number
ST_RESVR_CD Regulatory Reporting: Wyoming Form 2 Reservoir Code
RESVR_CD Regulatory Reporting: Wyoming Form 2 Reservoir Code
PROJ_CD Regulatory Reporting: Wyoming Form 2 Project Code
CONS_DIST_NO Regulatory Reporting - Conservation District Number
AREA_CD Regulatory Reporting - Area Code
WL_SERIAL_NO Well Serial Number
COMNG_FAC_NO Regulatory Reporting - Commingling Facility Number
LUW_NO Regulatory Reporting - Lease Unit / Well No
INAC_STATUS_CD Inactive Status Code
INAC_FUTURE_CD Inactive Future Code
SPLIT_GUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
OVERRIDE_GRP Override Group
ND_PIPE_OR_TRUCK Regulatory Reporting - North Dakota Pipeline or Truck
ND_CTB_NO Regulatory Reporting - North Dakorta Central Tank Battery
FLPT_CD Regulatory Reporting - Field Plant Code
OIU_PRI_GEO_LOC Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC
ADD_HDR1 Additional Master Data-Header Data
ADD_HDR2 Additional Master Data-Header Data
ADD_DTL1 Additional Master Data
ADD_DTL2 Additional Master Data
ADD_DTL3 Additional Master Data
ADD_DTL4 Additional Master Data
ADD_DTL5 Additional Master Data
ADD_DTL6 Additional Master Data
ADD_DTL7 Additional Master Data
ADD_DTL8 Additional Master Data
ADD_DTL9 Additional Master Data
ADD_DTL10 Additional Master Data
CA_WELL_DESIGNATION CA : Well Designation Code OIUREP_CA_WL_DESIGNATION
CA_AREA_CD CA: Area Code CHAR3
API_WL_OVERRIDE CCO: API Well Override Group OIU_WLAPI
API_SIDT Reg.Reporting - API Side Track
Master Data Relations Join Conditions
Agency for Reporting
  • Agency for Reporting
  • Regulatory Report Name
Client OIUREP_MASTER.MANDT == T000.MANDT
Regulatory Report Name
  • Agency for Reporting
  • Regulatory Report Name
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number