| 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 | 11 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
2 | OIU_SB_SPEWC_T | Special owner entitlements at WC level | 12 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
3 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 37 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
4 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 35 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
5 | OIUP_PR_WCTST | Well Test (PDM Shadow) | 17 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
6 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 16 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
7 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 17 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
8 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 16 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
9 | OIUP_SB_RNEWC | Residue and NGL entitlements at a WC level (PDM Shadow) | 14 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
10 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 36 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
11 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 34 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
12 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 34 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
13 | OIU_PR_WCTST | Well Test | 16 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
14 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 15 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
15 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 15 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
16 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 16 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
17 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 16 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
18 | OIU_SB_RNAMP | Residue and NGL actual at a MP level | 15 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
19 | OIU_SB_RNAMP_T | Temporary Residue and NGL actual at a MP level | 15 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
20 | OIU_SB_RNAWC | Residue and NGL actual at a WC level | 15 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
21 | OIU_SB_RNAWC_T | Temporary Residue and NGL actual at a WC level | 15 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
22 | OIU_SB_RNEMP | Residue and NGL entitlements at a MP level | 13 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
23 | OIU_SB_RNEMP_T | Temporary Residue and NGL entitlements at a MP level | 14 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
24 | OIU_SB_RNEWC | Residue and NGL entitlements at a WC level | 13 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
25 | OIU_SB_RNEWC_T | Temporary Residue and NGL entitlements at a WC level | 14 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
26 | OIU_SB_SPEMP | Special owner entitlements at MP level | 11 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |
27 | OIU_SB_SPEWC | Special owner entitlements at WC level | 12 | HEAT_VAL_U | Heating Value Unit | nvarchar | 3 | 0 | | |