| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | UKMDB_AGCADDR0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
2 | UKMDB_AGCPROD0 | UKM: Key agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
TOPKey Mapping |
3 | UKMDB_AGCBNSS0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
4 | UKMDB_AGCCCGH0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
5 | UKMDB_AGCCHRT0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
6 | UKMDB_AGCCMPN0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
7 | UKMDB_AGCCSTC0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
8 | UKMDB_AGCENGN0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
9 | UKMDB_AGCFINA0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
10 | UKMDB_AGCFNCL0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
11 | UKMDB_AGCFNNC0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
12 | UKMDB_AGCGLAM0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
13 | UKMDB_AGCINDV0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
14 | UKMDB_AGCINST0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
15 | UKMDB_AGCLGST0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
16 | UKMDB_AGCMATE0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
17 | UKMDB_AGCORGC0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
18 | UKMDB_AGCPCGH0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
19 | UKMDB_AGCPLNT0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
20 | UKMDB_AGCPRFT0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
21 | UKMDB_AGCSLSF0 | UKM: Key Agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
TOPStandardized Key Mapping |
22 | UKMDB_AGC00000 | UKM: Key agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
23 | UKMDB_AGCUNIT0 | UKM: Key agency | 5 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |
24 | UKM_AGENCY | UKM: Key agency | 4 | CCT_SASAGENCY_ID | UKM: CCT:Identifier SchemeAgencySchemeAgencyID | nvarchar | 3 | 0 | | |