RDM_COUNTRY_RISK_1

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..NROD_RDM_COUNTRY_RISK_1

SDSNZP05_BANK..CBA_RDM_COUNTRY_RISK_1

SDSNZP05_BANK..NROD_RDM_COUNTRY_RISK_1

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 ISO_CODE NATIONAL CHARACTER VARYING(3) 3
11 CROOK_COUNTRY_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
12 CROOK_COUNTRY_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
13 CROOK_COUNTRY_FLAG_ID INTEGER 4
14 TAX_HAVEN_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
15 TAX_HAVEN_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
16 TAX_HAVEN_FLAG_ID INTEGER 4
17 HIGHRISK_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
18 HIGHRISK_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
19 HIGHRISK_FLAG_ID INTEGER 4
20 FATF_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
21 FATF_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
22 FATF_FLAG_ID INTEGER 4
23 NARCOTIC_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
24 NARCOTIC_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
25 NARCOTIC_FLAG_ID INTEGER 4
26 OFAC_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
27 OFAC_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
28 OFAC_FLAG_ID INTEGER 4
29 SUSPICIOUS_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
30 SUSPICIOUS_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
31 SUSPICIOUS_FLAG_ID INTEGER 4
32 EUROPE_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
33 EUROPE_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
34 EUROPE_FLAG_ID INTEGER 4
35 TERRORISTHAVEN_FLAG NATIONAL CHARACTER VARYING(1) 1
36 CONTINENT_NAME NATIONAL CHARACTER VARYING(20) 20
37 REGION_CODE NATIONAL CHARACTER VARYING(250) 250
38 REGION_NAME NATIONAL CHARACTER VARYING(250) 250
39 REGION_ID INTEGER 4
40 NO_EXTERNAL_ACCESS_CODE NATIONAL CHARACTER VARYING(250) 250
41 NO_EXTERNAL_ACCESS_NAME NATIONAL CHARACTER VARYING(250) 250
42 NO_EXTERNAL_ACCESS_ID INTEGER 4
43 FRDDC_RISK NUMERIC(31,0) 19
44 PF_RISK NUMERIC(31,0) 19
45 AMLCB_RISK_FLAG_CODE NATIONAL CHARACTER VARYING(250) 250
46 AMLCB_RISK_FLAG_NAME NATIONAL CHARACTER VARYING(250) 250
47 AMLCB_RISK_FLAG_ID INTEGER 4
48 PFCD_RISK NUMERIC(31,0) 19
49 ORG_UNIT_CODE NATIONAL CHARACTER VARYING(250) 250
50 ORG_UNIT_NAME NATIONAL CHARACTER VARYING(250) 250
51 ORG_UNIT_ID INTEGER 4
52 RISK_WEIGTH NUMERIC(31,0) 19
53 ENTERDATETIME TIMESTAMP 8
54 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
55 ENTERVERSIONNUMBER INTEGER 4
56 LASTCHGDATETIME TIMESTAMP 8
57 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
58 LASTCHGVERSIONNUMBER INTEGER 4
59 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
60 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
61 CDC_RECORD_TYPE CHARACTER(14) 14
62 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
63 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8