| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GHO_ALC_REF_NWC | Non Well Completion Reference Data for Allocation Run | 15 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
2 | GHO_ALC_SRC_CHEM | Chemical Analysis Source data for alloc results invalidation | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
3 | GHO_ALC_SRC_DFEV | Deferment Event source data to invalidate Allocation results | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
4 | GHO_ALC_SRC_KEY | Obsolete:Source Data Key for Allocation Results Invalidation | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
5 | GHO_ALC_SRC_NWC | Non-Well Completion Source data for alloc resul invalidation | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
6 | GHO_ALC_SRC_THEO | Obsolete:Theoretical Src data for Alloc reslts invalidation | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
7 | GHO_ALC_SRC_WC | Obsolete:Allocation Source Data from Well completion | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
8 | GHO_ALC_SRC_ZNL | Zonal Source data for Allocation Results Invalidation | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
9 | GHO_ALLOC_REF_WC | well completion reference data for allocation run | 14 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
10 | GHO_ALLOC_RUN | Allocation Headers to be triggered for preprocessing. | 9 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
11 | GHO_EFF_SRC_DATA | Table to store event effects data of defer used in alloc run | 9 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
12 | GHO_EVT_SRC_DATA | Table to store deferment events souce data used in alloc run | 9 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
13 | SHELL_ALL_STATUS | Shell Demo: Status of allocation run | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
TOPOwnership |
14 | GHO_OWNRES_H | Ownership results Header | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
15 | GHO_OWNRES_I | Ownership results items | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
16 | GHO_OWNRES_I_BG | Ownership results items Bearer Group details | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
17 | GHO_OWNRES_I_DOI | Ownership results items DOI details | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
TOPProduction Allocation |
18 | GHO_ALLOCRES_H | Allocation Results Header | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
19 | GHO_ALLOCRES_I | Allocation results Item | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
20 | GHO_ALLOCRES_IF | Allocation results Item with Final Indicator | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
21 | GHO_ALLOC_FACTOR | Allocation Factor values | 2 | ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | varbinary | 16 | 0 | | |
22 | GHO_ALLOC_FIN_I | OBSOLETE - Table to store final itemized allocation results | 2 | ALLOC_RUN_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
23 | GHO_ALLOC_FIN_PP | Table to hold PP related final allocation results | 2 | ALLOC_RUN_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
24 | GHO_ALLOC_RES_H | OBSOLETE - Table for storing allocation results (Header) | 2 | ALLOC_RUN_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
25 | GHO_ALLOC_RES_I | OBSOLETE - Table to store the itemized allocation results | 2 | ALLOC_RUN_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |
26 | GHO_ALLOC_RES_PP | Table to hold PP related allocation results | 2 | ALLOC_RUN_ID | Globally Unique Identifier | varbinary | 16 | 0 | | |