| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_MPAPH | Fill Header for Measure Point Allocation Profile Header | 5 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
2 | OIU_RV_LOAD_OIL | Valuation Load Oil Transactions | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
TOPBalancing |
3 | OIUBL_IMBMP | Measurement Point Imbalance | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
4 | OIUBL_IMBWC | Well Completion Imbalance | 10 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
TOPProduction and Revenue Accounting |
5 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 11 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
6 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
7 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
8 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 14 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
9 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 10 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
10 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 11 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
11 | OIUXI_PPNH | XI: Prior Period Notification Header | 6 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
12 | OIU_PR_DNAPH | Network Allocation Profile Header | 3 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
13 | OIU_PR_DNSTH | Delivery Network Status Header | 4 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
14 | OIU_PR_DNTCM | Delivery Network Theoretical Calculation Method | 3 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
15 | OIU_PR_HPPNH | Volumetric Historical PPN Header | 5 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
16 | OIU_PR_MPALB | PRA: Measurement Point Allocation Base | 4 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
17 | OIU_PR_MPALF | MP Allocation Factor | 2 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
18 | OIU_PR_MPAPH | Measure Point Allocation Profile Header | 4 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
19 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 10 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
20 | OIU_PR_PPNH | Prior Period Notification Header | 5 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
21 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
22 | OIU_PR_WCALB | PRA: Well Completion Allocation Base | 5 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
23 | OIU_PR_WCALF | WC Allocation Factor | 2 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
24 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
25 | OIU_PR_WCTCM | PRA: Well Completion Theoretical Calculation Method | 4 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
26 | OIU_RV_NPC | Valuation Network Processing Control - Table | 4 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
27 | OIU_RV_RVT | Rejected Valuation Transactions | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
28 | OIU_RV_VCR | Valuation Cross Reference | 11 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
29 | OIU_RV_VLDP | Valuation Division Order Prior Period Process | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
30 | OIU_RV_VLRPT | Valuation Reporting | 15 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
31 | OIU_RV_VLRVS | Valuation Reversal Notificaton | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
32 | OIU_RV_VLTXNS | Valuation Transactions | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
33 | OIU_RV_VPPN | Valuation Prior Period Notification | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
34 | OIU_RV_VPPNM | Manually Created Valuation Prior Period Notifications | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
35 | OIU_RV_VPPNU | Valuation Prior Period Notification | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
36 | OIU_RV_VXDS | Valuation Cross Reference Date Stamp | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
37 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
38 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 12 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
39 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
40 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
41 | OIU_SB_CAMPH | Contract volumes by measurement point header | 5 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
42 | OIU_SB_CTRMP | Volumes for sale | 8 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
43 | OIU_SB_CTRMP_T | Volumes for sale | 8 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
44 | OIU_SB_CTRWC | Volumes for sale | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
45 | OIU_SB_CTRWC_T | Volumes for sale | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
46 | OIU_SB_ENTMP | MP level owner entitlements | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
47 | OIU_SB_ENTMP_T | MP level owner entitlements | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
48 | OIU_SB_ENTWC | WC level owner entitlements | 10 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
49 | OIU_SB_ENTWC_T | WC level owner entitlements | 10 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
50 | OIU_SB_MGOPMP | Marketing Group Owner Percent MP | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
51 | OIU_SB_MGOPMP_T | Marketing Group Owner Percent MP | 9 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
52 | OIU_SB_MGOPWC | Marketing Group Owner Percent WC | 10 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
53 | OIU_SB_MGOPWC_T | Marketing Group Owner Percent WC | 10 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
54 | OIU_SB_NIMB | Marketing representative imbalance volumes | 5 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
TOPRevenue |
55 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 15 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
56 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 8 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
TOPValuation |
57 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 15 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
58 | OIURV_DOC_DTL_RV | Valuation Reversal Notificaton | 15 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
59 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 8 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
60 | OIURV_DOC_HDR | Valuation Document Header | 7 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
61 | OIURV_SSTD | Settlement statement detail | 13 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |
62 | OIUVL_RPT | Valuation reporting header | 5 | FREQ_CD | Frequency | nvarchar | 1 | 0 | | |