| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalancing |
1 | OIU_SB_SPEMP_T | Special owner entitlements at MP level | 13 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
2 | OIU_SB_SPEWC_T | Special owner entitlements at WC level | 14 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
3 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 34 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
4 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 33 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
5 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 20 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
6 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 21 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
7 | OIUP_SB_RNEWC | Residue and NGL entitlements at a WC level (PDM Shadow) | 16 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
8 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 28 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
9 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 14 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
10 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 28 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
11 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 14 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
12 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 15 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
13 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 33 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
14 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 32 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
15 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 32 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
16 | OIU_SB_CAP | Capacity Header | 5 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
17 | OIU_SB_ENTMP | MP level owner entitlements | 19 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
18 | OIU_SB_ENTMP_T | MP level owner entitlements | 20 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
19 | OIU_SB_ENTWC | WC level owner entitlements | 20 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
20 | OIU_SB_ENTWC_T | WC level owner entitlements | 21 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
21 | OIU_SB_RNEMP | Residue and NGL entitlements at a MP level | 15 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
22 | OIU_SB_RNEMP_T | Temporary Residue and NGL entitlements at a MP level | 16 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
23 | OIU_SB_RNEWC | Residue and NGL entitlements at a WC level | 15 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
24 | OIU_SB_RNEWC_T | Temporary Residue and NGL entitlements at a WC level | 16 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
25 | OIU_SB_SPEMP | Special owner entitlements at MP level | 13 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
26 | OIU_SB_SPEWC | Special owner entitlements at WC level | 14 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
TOPRoyalty Reporting |
27 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 28 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
28 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 32 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
29 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 14 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
30 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 18 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
TOPTax Reporting |
31 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 15 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
32 | OIUX1_RPT_VOLH | Reported Volume Data by Reporting Entities | 20 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
33 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 15 | ENERGY_U | Energy quantity unit | nvarchar | 3 | 0 | | |
TOPValuation |
34 | OIURV_SSTD | Settlement statement detail | 21 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
35 | OIUVL_GASDTL_CUR | Gas statement Detail | 14 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
36 | OIUVL_GASDTL_HST | Gas statement Detail | 14 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
37 | OIUVL_GASRPTD | Gas statement report detail | 19 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
38 | OIUVL_GASRPTH | Gas statement report header | 18 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
39 | OIUVL_SEV | Severance tax | 22 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |