| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUY3_TX_OWNOVR | Royalty 2.0 - TX GLO/TAMU Owner Level Reporting Override | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
2 | OIUY6_WY_RPDTC | Royalty 2.0 - WY - Lease/Unit Report Detail - CA | 11 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPBalancing |
3 | OIUBL01_ADJ | Balancing Adjustments | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
4 | OIUBL01_ADJH | Balancing Adjustments History | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
5 | OIUBL01_PBADOI | PBA DOI | 11 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
6 | OIUBL_IMBMP | Measurement Point Imbalance | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
7 | OIUBL_IMBWC | Well Completion Imbalance | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
8 | OIU_SB_SPEMP_T | Special owner entitlements at MP level | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
9 | OIU_SB_SPEWC_T | Special owner entitlements at WC level | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPCheck Input |
10 | OIUCI_DOC_CIREJ | Contains VL/RD rejects to be reported to Check Input | 8 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
11 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 37 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
12 | OIUCI_SPC_DIST | Purchaser DOI Cross Reference | 10 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
TOPCheck Write |
13 | OIUCW_BA_WH_EXMP | Business Associates exempt from State Withholding | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
14 | OIUCW_EXTD | Extended Details from Payment Run | 7 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
15 | OIUCW_PAYMENT | Payment Details from Payment Run | 27 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
TOPContractual Allocation |
16 | OIUCA_OSP | Termination Point Component Options for Selective Process. | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPOwnership |
17 | GHO_OWN_INTTY | Ownership Interest Type | 2 | OWN_INT_TYPE_CD | Owner Interest Type | nvarchar | 2 | 0 | | |
18 | GHO_OWN_INTTY_TX | Ownership Interest Type Text Table | 3 | OWN_INT_TYPE_CD | Owner Interest Type | nvarchar | 2 | 0 | | |
19 | OIUOW_DORH | DO Owner Request History | 9 | OWN_INT_TYPE_CD | Transferor participant interest type | nvarchar | 2 | 0 | | |
20 | OIUOW_POW | Owners on Pending Requests | 3 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
21 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
22 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 10 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
23 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 13 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
24 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 14 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
25 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 10 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
26 | OIUP_SB_RNEWC | Residue and NGL entitlements at a WC level (PDM Shadow) | 10 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
27 | OIU_CM_PINTTY | Participant Interest Type (TBLRV006 & TBLRV035) | 1 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
28 | OIU_CM_PINTTY_TX | Participant Interest Type Description (TBLR006 & TBLR035) | 2 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
29 | OIU_DO_BR | Bearer Table | 4 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
30 | OIU_DO_BR_WK | Bearer Table | 4 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
31 | OIU_DO_DO | Division of Interest Ownership | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
32 | OIU_DO_DOGRI | Division Order Gross Revenue Interest | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
33 | OIU_DO_DO_WK | Division of Interest Ownership Worktable | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
34 | OIU_DO_TRGRI | Tract Gross Revenue Interest | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
35 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
36 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
37 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
38 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
39 | OIU_SB_AVD | Availability Detail | 5 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
40 | OIU_SB_ENTMP | MP level owner entitlements | 12 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
41 | OIU_SB_ENTMP_T | MP level owner entitlements | 12 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
42 | OIU_SB_ENTWC | WC level owner entitlements | 13 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
43 | OIU_SB_ENTWC_T | WC level owner entitlements | 13 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
44 | OIU_SB_MGDD | Marketing Group Determination Detail | 4 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
45 | OIU_SB_MGOPMP | Marketing Group Owner Percent MP | 11 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
46 | OIU_SB_MGOPMP_T | Marketing Group Owner Percent MP | 11 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
47 | OIU_SB_MGOPWC | Marketing Group Owner Percent WC | 12 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
48 | OIU_SB_MGOPWC_T | Marketing Group Owner Percent WC | 12 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
49 | OIU_SB_OAD | Owner Availability Detail | 5 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
50 | OIU_SB_RNAMP | Residue and NGL actual at a MP level | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
51 | OIU_SB_RNAMP_T | Temporary Residue and NGL actual at a MP level | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
52 | OIU_SB_RNAWC | Residue and NGL actual at a WC level | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
53 | OIU_SB_RNAWC_T | Temporary Residue and NGL actual at a WC level | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
54 | OIU_SB_RNEMP | Residue and NGL entitlements at a MP level | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
55 | OIU_SB_RNEMP_T | Temporary Residue and NGL entitlements at a MP level | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
56 | OIU_SB_RNEWC | Residue and NGL entitlements at a WC level | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
57 | OIU_SB_RNEWC_T | Temporary Residue and NGL entitlements at a WC level | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
58 | OIU_SB_SPEMP | Special owner entitlements at MP level | 7 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
59 | OIU_SB_SPEWC | Special owner entitlements at WC level | 8 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPRevenue |
60 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 38 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
61 | OIUH_CDEX_INTYP | Mapping Owner Interest type with CDEX Interest type | 1 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
62 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 36 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
63 | OIUH_RV_EXSL | Journal Entry Expense Subledger Table | 13 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
64 | OIUH_RV_EXSL_H | Oil and Gas appl table | 13 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
65 | OIUH_RV_INSL | Journal Entry Income Subledger Table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
66 | OIUH_RV_INSL_H | Oil and Gas appl table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
67 | OIUH_RV_JE | Journal Entry | 42 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
68 | OIUH_RV_JEINTF | PRA Journal Entries | 37 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
69 | OIUH_RV_LSSL | Journal Entry Legal Suspense Subledger Table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
70 | OIUH_RV_LSSL_H | Oil and Gas appl table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
71 | OIUH_RV_MSSL | Journal Entry Miscellaneous Subledger Table | 19 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
72 | OIUH_RV_MSSL_H | Oil and Gas appl table | 19 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
73 | OIUH_RV_OPSL | Journal Entry Owner Payable Subledger Table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
74 | OIUH_RV_OPSL_H | Oil and Gas OPSL History Table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
75 | OIUH_RV_STSL | Journal Entry Statistical Subledger Table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
76 | OIUH_RV_STSL_H | Oil and Gas appl table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
TOPRoyalty Reporting |
77 | OIUH_TEMP_OPSL | Journal Entry Owner Payable Subledger Table | 16 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
78 | OIUREP_XTRCT_ROY | Extract Royaty Data for the current reporting period | 36 | OWN_INT_TYPE_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
TOPTax Reporting |
79 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 46 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |
80 | OIUX6_WY_CAPRDT | Tax 2.0 - Wyoming Conservation CA PRA Detail Transactions | 11 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
81 | OIUX6_WY_CASTG | Tax 2.0 - Wyoming Conservation CA Transactions Staging | 10 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
82 | OIUX6_WY_CATXN | Tax 2.0 - Wyoming Conservation CA Transactions | 10 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
83 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 10 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
84 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
85 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 9 | OWN_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPValuation |
86 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 39 | OWN_INT_TYPE_CD | Owner Interest Type Code | nvarchar | 2 | 0 | | |