| 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 | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
2 | OIUY6_WY_RPDTC | Royalty 2.0 - WY - Lease/Unit Report Detail - CA | 12 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPBalancing |
3 | OIUBL01_ADJ | Balancing Adjustments | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
4 | OIUBL01_ADJH | Balancing Adjustments History | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
5 | OIUBL01_PBADOI | PBA DOI | 12 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
6 | OIUBL01_RPTPA | Balancing Permanent Report Adjustments | 4 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
7 | OIUBL01_RPTPD | Balancing Permanent Report Detail | 4 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
8 | OIUBL_IMBMP | Measurement Point Imbalance | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
9 | OIUBL_IMBWC | Well Completion Imbalance | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
10 | OIU_SB_SPEMP_T | Special owner entitlements at MP level | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
11 | OIU_SB_SPEWC_T | Special owner entitlements at WC level | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPContractual Allocation |
12 | OIUCA_OSP | Termination Point Component Options for Selective Process. | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPOwnership |
13 | OIUOW_DORH | DO Owner Request History | 10 | OWN_ISQ_NO | Transferor owner interest sequence number | nvarchar | 2 | 0 | | |
14 | OIUOW_POW | Owners on Pending Requests | 4 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
15 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
16 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 11 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
17 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 14 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
18 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 15 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
19 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 11 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
20 | OIUP_SB_RNEWC | Residue and NGL entitlements at a WC level (PDM Shadow) | 11 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
21 | OIU_DO_BR | Bearer Table | 5 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
22 | OIU_DO_BR_WK | Bearer Table | 5 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
23 | OIU_DO_DO | Division of Interest Ownership | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
24 | OIU_DO_DOGRI | Division Order Gross Revenue Interest | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
25 | OIU_DO_DO_WK | Division of Interest Ownership Worktable | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
26 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
27 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
28 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
29 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
30 | OIU_SB_AVD | Availability Detail | 6 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
31 | OIU_SB_ENTMP | MP level owner entitlements | 13 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
32 | OIU_SB_ENTMP_T | MP level owner entitlements | 13 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
33 | OIU_SB_ENTWC | WC level owner entitlements | 14 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
34 | OIU_SB_ENTWC_T | WC level owner entitlements | 14 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
35 | OIU_SB_MGDD | Marketing Group Determination Detail | 5 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
36 | OIU_SB_MGOPMP | Marketing Group Owner Percent MP | 12 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
37 | OIU_SB_MGOPMP_T | Marketing Group Owner Percent MP | 12 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
38 | OIU_SB_MGOPWC | Marketing Group Owner Percent WC | 13 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
39 | OIU_SB_MGOPWC_T | Marketing Group Owner Percent WC | 13 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
40 | OIU_SB_OAD | Owner Availability Detail | 6 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
41 | OIU_SB_RNAMP | Residue and NGL actual at a MP level | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
42 | OIU_SB_RNAMP_T | Temporary Residue and NGL actual at a MP level | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
43 | OIU_SB_RNAWC | Residue and NGL actual at a WC level | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
44 | OIU_SB_RNAWC_T | Temporary Residue and NGL actual at a WC level | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
45 | OIU_SB_RNEMP | Residue and NGL entitlements at a MP level | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
46 | OIU_SB_RNEMP_T | Temporary Residue and NGL entitlements at a MP level | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
47 | OIU_SB_RNEWC | Residue and NGL entitlements at a WC level | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
48 | OIU_SB_RNEWC_T | Temporary Residue and NGL entitlements at a WC level | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
49 | OIU_SB_SPEMP | Special owner entitlements at MP level | 8 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
50 | OIU_SB_SPEWC | Special owner entitlements at WC level | 9 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPRoyalty Reporting |
51 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 28 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
52 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 27 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
53 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 27 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPTax Reporting |
54 | OIUX6_WY_CAPRDT | Tax 2.0 - Wyoming Conservation CA PRA Detail Transactions | 12 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
55 | OIUX6_WY_CASTG | Tax 2.0 - Wyoming Conservation CA Transactions Staging | 11 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
56 | OIUX6_WY_CATXN | Tax 2.0 - Wyoming Conservation CA Transactions | 11 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
57 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 11 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
58 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
59 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 10 | OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |