| 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 | 14 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
2 | GHO_ALC_SRC_KEY | Obsolete:Source Data Key for Allocation Results Invalidation | 9 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
3 | GHO_ALLOC_PREP | Allocation Results Header | 10 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
4 | GHO_ALLOC_REF_WC | well completion reference data for allocation run | 13 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
5 | GHO_ALLOC_RUN | Allocation Headers to be triggered for preprocessing. | 8 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
6 | GHO_ALLOC_RUN_JB | Allocation Results Header | 10 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
7 | GHO_ALOC_SRC_KEY | Source Data Key for Allocation Results Invalidation | 9 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
8 | GHO_EFF_SRC_DATA | Table to store event effects data of defer used in alloc run | 8 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
9 | GHO_EVT_SRC_DATA | Table to store deferment events souce data used in alloc run | 8 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
TOPProduction Allocation |
10 | GHO_ALLOCRES_H | Allocation Results Header | 9 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |
11 | GHO_ALLOC_RES_H | OBSOLETE - Table for storing allocation results (Header) | 9 | ALLOC_PURPOSE | Allocation Purpose | nvarchar | 2 | 0 | | |