| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOwnership |
1 | GHO_OWNDOI_HDRCK | DOI Header Details work tabel | 2 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
2 | GHO_OWNDOI_ITMCK | Ownership : Division of Interest details in item work table | 3 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
3 | GHO_OWNRES_I | Ownership results items | 9 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
4 | GHO_OWNRES_I_BG | Ownership results items Bearer Group details | 5 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
5 | GHO_OWN_BG_HDR | Ownership Bearer Group Header table | 3 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
6 | GHO_OWN_BG_HDRCK | Ownership Bearer Group Header - Work Table | 3 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
7 | GHO_OWN_BG_ITMCK | Bearer Group Items table - work table | 4 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
8 | GHO_OWN_BG_ITMS | Bearer Group Items table | 4 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
9 | GHO_OWN_DOI_HDR | DOI Header Details | 2 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
10 | GHO_OWN_DOI_ITMS | Ownership : Division of Interest details | 3 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
11 | GHO_OWN_NET_ASG | Ownership (DOI) assignment to Network Objects | 2 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
12 | GHO_TRO_BG_HDR | Bearer group header details created from Transfer Request | 13 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |
13 | GHO_TRO_BG_ITMS | Temporary storage for Bearer group from transfer request | 9 | DOI_ID | DOI Number | nvarchar | 20 | 0 | | |