| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UKMDB_AGCADDR0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 2 | UKMDB_AGCPROD0 | UKM: Key agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 3 | UKMDB_KEYADDR0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 4 | UKMDB_KEYPROD0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| Business Partner | ||||||||||
| 5 | RATCE_AGENCY | Rating Agencies | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
| 6 | RATCE_AGENCY_TXT | Description of Rating Agency | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
| 7 | RATCE_PROCEDURES | Rating Procedure | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
| 8 | RATCE_PROC_TXT | Description of Rating Procedure | 4 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
| 9 | RATCE_RATING | Rating Procedure | 3 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
| 10 | RATCE_RATING_TXT | Texts for Ratings | 4 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
| 11 | RATINGS | Ratings | 5 | AGENCY_ID | ID of Rating Agency | nvarchar | 10 | 0 | ||
| Key Mapping | ||||||||||
| 12 | UKMDB_AGCBNSS0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 13 | UKMDB_AGCCCGH0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 14 | UKMDB_AGCCHRT0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 15 | UKMDB_AGCCMPN0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 16 | UKMDB_AGCCSTC0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 17 | UKMDB_AGCENGN0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 18 | UKMDB_AGCFINA0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 19 | UKMDB_AGCFNCL0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 20 | UKMDB_AGCFNNC0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 21 | UKMDB_AGCGLAM0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 22 | UKMDB_AGCINDV0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 23 | UKMDB_AGCINST0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 24 | UKMDB_AGCLGST0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 25 | UKMDB_AGCMATE0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 26 | UKMDB_AGCORGC0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 27 | UKMDB_AGCPCGH0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 28 | UKMDB_AGCPLNT0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 29 | UKMDB_AGCPRFT0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 30 | UKMDB_AGCSLSF0 | UKM: Key Agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 31 | UKMDB_KEYBNSS0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 32 | UKMDB_KEYCCGH0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 33 | UKMDB_KEYCHRT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 34 | UKMDB_KEYCMPN0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 35 | UKMDB_KEYCSTC0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 36 | UKMDB_KEYENGN0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 37 | UKMDB_KEYFINA0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 38 | UKMDB_KEYFNCL0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 39 | UKMDB_KEYFNNC0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 40 | UKMDB_KEYGLAM0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 41 | UKMDB_KEYINDV0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 42 | UKMDB_KEYINST0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 43 | UKMDB_KEYLGST0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 44 | UKMDB_KEYMATE0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 45 | UKMDB_KEYORGC0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 46 | UKMDB_KEYPCGH0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 47 | UKMDB_KEYPLNT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 48 | UKMDB_KEYPRFT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 49 | UKMDB_KEYSLSF0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| Master Data Framework | ||||||||||
| 50 | DML_OWNERTYPE | MDF Owners | 6 | AGENCY_ID | Scheme ID | nvarchar | 60 | 0 | ||
| Production and Revenue Accounting | ||||||||||
| 51 | OIUX2_RSG_LOG | Tax reporting log table for rpt | 12 | AGENCY_ID | Agency Identifier | nvarchar | 20 | 0 | ||
| Standardized Key Mapping | ||||||||||
| 52 | UKMDB_AGC00000 | UKM: Key agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 53 | UKMDB_AGCUNIT0 | UKM: Key agency | 2 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 54 | UKMDB_KEY00000 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 55 | UKMDB_KEYUNIT0 | UKM: Key | 4 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| 56 | UKM_AGENCY | UKM: Key agency | 1 | AGENCY_ID | UKM: Key Agency ID | varbinary | 16 | 0 | ||
| Tax Reporting | ||||||||||
| 57 | OIUX1_RPT_SGB | Report Submission Group base table | 8 | AGENCY_ID | Agency Identifier | nvarchar | 20 | 0 | ||
| 58 | OIUX1_RPT_SGRP | Report Submission Group | 6 | AGENCY_ID | Agency Identifier | nvarchar | 20 | 0 | ||