| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOwnership |
1 | GHO_OWNDOI_ITMCK | Ownership : Division of Interest details in item work table | 14 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
2 | GHO_OWNRES_I_BG | Ownership results items Bearer Group details | 8 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
3 | GHO_OWN_BG_HDR | Ownership Bearer Group Header table | 2 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
4 | GHO_OWN_BG_HDRCK | Ownership Bearer Group Header - Work Table | 2 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
5 | GHO_OWN_BG_ITMCK | Bearer Group Items table - work table | 3 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
6 | GHO_OWN_BG_ITMS | Bearer Group Items table | 3 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
7 | GHO_OWN_DOI_ITMS | Ownership : Division of Interest details | 14 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
8 | GHO_OWN_TRO_DOI | DOI for Ownership transfer request | 8 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
9 | GHO_TRO_BG_HDR | Bearer group header details created from Transfer Request | 6 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |
10 | GHO_TRO_BG_ITMS | Temporary storage for Bearer group from transfer request | 10 | BEARER_GRP_NO | Ownership Bearer Group Number | nvarchar | 5 | 0 | | |