| 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 | 5 | OWN_NO | Business Associate | nvarchar | 6 | 0 | | |
2 | OIUY6_WY_RPDTC | Royalty 2.0 - WY - Lease/Unit Report Detail - CA | 10 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
TOPBalancing |
3 | OIUBL01_ADJ | Balancing Adjustments | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
4 | OIUBL01_ADJH | Balancing Adjustments History | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
5 | OIUBL01_PBADOI | PBA DOI | 10 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
6 | OIUBL01_RPTPA | Balancing Permanent Report Adjustments | 3 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
7 | OIUBL01_RPTPD | Balancing Permanent Report Detail | 3 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
8 | OIUBL_IMBMP | Measurement Point Imbalance | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
9 | OIUBL_IMBWC | Well Completion Imbalance | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
10 | OIU_SB_SPEMP_T | Special owner entitlements at MP level | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
11 | OIU_SB_SPEWC_T | Special owner entitlements at WC level | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
TOPCheck Input |
12 | OIUCI_CDEXD | CDEX Detail | 3 | OWN_NO | Owner Number | nvarchar | 12 | 0 | | |
13 | OIUCI_CDEXH | CDEX Header | 3 | OWN_NO | Owner Number | nvarchar | 12 | 0 | | |
14 | OIUCI_CDEX_REMX | CDEX Remitter Xref | 3 | OWN_NO | Owner Number | nvarchar | 12 | 0 | | |
15 | OIUCI_DOC_CIREJ | Contains VL/RD rejects to be reported to Check Input | 6 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
16 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 30 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
17 | OIUCI_SPC_DIST | Purchaser DOI Cross Reference | 8 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
TOPCheck Write |
18 | OIUCW_EXTD | Extended Details from Payment Run | 4 | OWN_NO | Owner (Business Associate) | nvarchar | 6 | 0 | | |
19 | OIUCW_OWNER_SEQ | Owner/Sequence List for Payment Runs | 4 | OWN_NO | Owner (Business Associate) | nvarchar | 6 | 0 | | |
20 | OIUCW_PAYMENT | Payment Details from Payment Run | 4 | OWN_NO | Owner (Business Associate) | nvarchar | 6 | 0 | | |
21 | OIUCW_REJECTS | Payments Not Made in the Run | 4 | OWN_NO | Owner (Business Associate) | nvarchar | 6 | 0 | | |
22 | OIU_CW_SUM_PAY | Summarized Payable Table for Check Write | 3 | OWN_NO | Owner (Business Associate) | nvarchar | 6 | 0 | | |
TOPContractual Allocation |
23 | OIUCA_OSP | Termination Point Component Options for Selective Process. | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
TOPOwnership |
24 | OIUOW_DORH | DO Owner Request History | 8 | OWN_NO | Transferor - owner | nvarchar | 10 | 0 | | |
25 | OIUOW_POW | Owners on Pending Requests | 2 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
26 | OIUOW_PP | Ownership Production Payment | 2 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
TOPProduction and Revenue Accounting |
27 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
28 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 9 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
29 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 12 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
30 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 13 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
31 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 9 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
32 | OIUP_SB_RNEWC | Residue and NGL entitlements at a WC level (PDM Shadow) | 9 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
33 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 31 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
34 | OIU_DO_BR | Bearer Table | 3 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
35 | OIU_DO_BR_WK | Bearer Table | 3 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
36 | OIU_DO_DO | Division of Interest Ownership | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
37 | OIU_DO_DOGRI | Division Order Gross Revenue Interest | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
38 | OIU_DO_DO_WK | Division of Interest Ownership Worktable | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
39 | OIU_DO_TRGRI | Tract Gross Revenue Interest | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
40 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
41 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
42 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
43 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
44 | OIU_SB_AVD | Availability Detail | 4 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
45 | OIU_SB_ENTMP | MP level owner entitlements | 11 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
46 | OIU_SB_ENTMP_T | MP level owner entitlements | 11 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
47 | OIU_SB_ENTWC | WC level owner entitlements | 12 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
48 | OIU_SB_ENTWC_T | WC level owner entitlements | 12 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
49 | OIU_SB_MGDD | Marketing Group Determination Detail | 3 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
50 | OIU_SB_MGOPMP | Marketing Group Owner Percent MP | 10 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
51 | OIU_SB_MGOPMP_T | Marketing Group Owner Percent MP | 10 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
52 | OIU_SB_MGOPWC | Marketing Group Owner Percent WC | 11 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
53 | OIU_SB_MGOPWC_T | Marketing Group Owner Percent WC | 11 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
54 | OIU_SB_OAD | Owner Availability Detail | 4 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
55 | OIU_SB_RNAMP | Residue and NGL actual at a MP level | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
56 | OIU_SB_RNAMP_T | Temporary Residue and NGL actual at a MP level | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
57 | OIU_SB_RNAWC | Residue and NGL actual at a WC level | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
58 | OIU_SB_RNAWC_T | Temporary Residue and NGL actual at a WC level | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
59 | OIU_SB_RNEMP | Residue and NGL entitlements at a MP level | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
60 | OIU_SB_RNEMP_T | Temporary Residue and NGL entitlements at a MP level | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
61 | OIU_SB_RNEWC | Residue and NGL entitlements at a WC level | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
62 | OIU_SB_RNEWC_T | Temporary Residue and NGL entitlements at a WC level | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
63 | OIU_SB_SPEMP | Special owner entitlements at MP level | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
64 | OIU_SB_SPEWC | Special owner entitlements at WC level | 7 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
TOPRevenue |
65 | OIUE1_LSSL_SUM | Legal Suspense Summary | 2 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
66 | OIUE2_CW_REJECTS | Proc 2.0 - Check Write Rejects | 5 | OWN_NO | Owner (Business Associate) | nvarchar | 6 | 0 | | |
67 | OIUE2_ESCH_BA | Proc 2.0 - Escheat - BA | 2 | OWN_NO | Business Associate | nvarchar | 6 | 0 | | |
68 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 3 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
69 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 3 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
70 | OIUE2_ESCH_RPDTP | Proc 2.0 - Escheat - Report Detail - Property | 4 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
71 | OIUE2_ESCH_SUM | Proc 2.0 - Escheat - Owner Summary | 3 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
72 | OIUE2_ESCH_SUMH | Proc 2.0 - Escheat - Owner Summary History | 3 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
73 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 3 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
74 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 31 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
75 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 29 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
76 | OIUH_RV_JEINTF | PRA Journal Entries | 30 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
TOPRoyalty Reporting |
77 | OIUREPP_OWNER | MMS-2014 - Owner PPA | 3 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
78 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 27 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
79 | OIUREP_OWNER | MMS-2014 - Owner | 3 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
80 | OIUREP_RECOUP | MMS-2014 - Recoupable Balance | 4 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
81 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 26 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
82 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 26 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
TOPTax Reporting |
83 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 43 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
84 | OIUX6_WY_CAPRDT | Tax 2.0 - Wyoming Conservation CA PRA Detail Transactions | 10 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
85 | OIUX6_WY_CASTG | Tax 2.0 - Wyoming Conservation CA Transactions Staging | 9 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
86 | OIUX6_WY_CATXN | Tax 2.0 - Wyoming Conservation CA Transactions | 9 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
87 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 9 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
88 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
89 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 8 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
TOPValuation |
90 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 32 | OWN_NO | Owner Number | nvarchar | 6 | 0 | | |
91 | OIUVL_GSP | Gas Statement Profile | 8 | OWN_NO | owner | nvarchar | 10 | 0 | | |
92 | OIUVL_MTAH | Marketing Cost Tax Exemption - Header | 5 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
93 | OIUVL_OSP | Oil Statement Profile | 8 | OWN_NO | owner | nvarchar | 10 | 0 | | |
94 | OIUVL_RPAD | Royalty Processing Allowance Detail | 4 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |
95 | OIUVL_TPAH | Tax Processing Allowance | 6 | OWN_NO | PRA owner | nvarchar | 10 | 0 | | |