| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GHO_DM_CODE | Deferment Code Check | 6 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
2 | GHO_DM_CODE_T | Deferment Code Description | 6 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
3 | GHO_DM_EFFECTS | Deferment Event Effects | 15 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
4 | GHO_DM_EVENT | Deferment Event Data | 14 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
5 | GHO_DM_LINK_EVNT | Deferment Event Relations (Linked Events) | 5 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
6 | GHO_DM_OTYP_COD | Order Type and Deferment Code Relation | 5 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
7 | GHO_DM_PLANS | Deferment Plans Data | 5 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
8 | GHO_DM_RESULTS | Deferment Results | 22 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
9 | GHO_FORM_MEAS_H | Allocation Formula Measurements Header | 14 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
10 | GHO_MEAS_PRIO_H | Allocation Rules Measurement Priority Header | 11 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
11 | GHO_PPA_DATA | PPA request details | 15 | CREATED_TST | PPA Request Created Time | nvarchar | 6 | 0 | | |
12 | GHO_WELL_PRIOR | Capture Measurement - Well Test Priority | 11 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPMeasurement System |
13 | GHO_IMRG_STD_H | Header for Standardized QCI Volumes | 15 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPOwnership |
14 | GHO_OWNRES_H | Ownership results Header | 4 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPProduction Allocation |
15 | GHO_ALLOCRES_H | Allocation Results Header | 16 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
16 | GHO_ALLOC_OVR | OBSOLETE - GHO Allocation Theoratical Override | 15 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
17 | GHO_ALLOC_RES_H | OBSOLETE - Table for storing allocation results (Header) | 15 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
18 | GHO_CHM_ANL_H | Chemical analysis header data | 13 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
19 | GHO_COM_WC_H | Commingled Well Completion Header | 9 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
20 | GHO_NODERULE_H | Node Allocation Rules Header | 12 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
21 | GHO_NODE_DS_SP_H | Node Down Stream Split header table | 10 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
22 | GHO_NODE_RULE_H | OBSOLETE - Node Allocation Rules Header | 12 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
23 | GHO_NWRULE_H | Network Allocation Rules Header | 15 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
24 | GHO_NW_RULE_H | OBSOLETE - Production Flow Network Allocation Rules Header | 13 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
25 | GHO_NW_UOM_RULE | OBSOLETE - UoM Rule for Network | 10 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
26 | GHO_REP_MAT | Reproduced Material details table | 10 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
27 | GHO_RULE_LOG_H | Allocation Rule Log Header | 28 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
28 | GHO_SIMU_CAP | Simulation: Modified network object capacities | 9 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
29 | GHO_SIMU_DOWNTIM | Simulation: Predicted downtimes | 9 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
30 | GHO_SIMU_DS_SP_H | Simulation: Node Down Stream Split rules header | 11 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
31 | GHO_SIMU_FLRT_H | Simulation: Flow Rate Header | 8 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
32 | GHO_SIMU_H | Simulation Header | 9 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
33 | GHO_SIMU_NDRH | Simulation: Node Allocation Rules Header | 13 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
34 | GHO_SIMU_NWRH | Simulation: Network Allocation Rules Header | 16 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
35 | GHO_SIMU_REP_MAT | Simulation: Reproduced Material details table | 11 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
36 | GHO_SIMU_TOR_H | Simulation: Theoretical Override Header | 15 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
37 | GHO_SIMU_UOMRH | Simulation: Network UoM Rule Header | 12 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
38 | GHO_SIMU_WCOM_H | Simulation: Commingled Well Completion Header | 10 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
39 | GHO_SIMU_WC_OVR | Simulation: Well Completion Override Details Table | 12 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
40 | GHO_THEO_OVR_H | Allocation Theoretical Override Header | 14 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
41 | GHO_UOM_RULE_H | Network UoM Rule Header | 11 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
42 | GHO_WC_OVR | Well Completion Override Details Table | 11 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
43 | GHO_WC_RULE_LOG | Log table for Well Completion Override, Reproduce material | 21 | CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |