10.2.2.4 Viewing Reference Data for Web Services
Previously, all reference data was available in EDQ. From 807 onwards, only data related to name and address is enabled in EDQ. All other reference data is available in the database in the following tables:
- Goods prohibition reference data is available in
fcc_prohibiton_goods_ref_data - Ports prohibition reference data is available in
fcc_port_ref_data - Bad BICs reference data is available in
dim_sanctioned_identifier - Stop Keywords reference data is available in
dim_stop_keywords - Blacklisted Cities reference data is available in
dim_sanctioned_city - Blacklisted Countries reference data is available in
dim_sanctioned_country
Bad BICs Reference Data
The following columns are available in the template for BICs:
- Record ID: This column displays the record serial number for the blacklisted BIC. The record ID is unique for every BIC.
- BIC: This column displays the name of the BIC.
- Details of BIC: This column displays the details of the BIC.
- Data Source: This column displays the source of the data for the BIC.
- Risk Score: This column displays the risk score for the BIC.
Sample Data for Sanctioned BICs
The following table provides examples based on BICs:
Table 10-1 Sample Data for Sanctioned BICs
| Record ID | BIC | Data Source | Risk Score |
|---|---|---|---|
| 1 | SIIBSYDA | OFAC (Office of Foreign Assets Control) | 85 |
| 2 | FTBDKPPY | OFAC (Office of Foreign Assets Control) | 90 |
| 3 | DCBKKPPY | OFAC (Office of Foreign Assets Control) | 85 |
| 4 | ROSYRU2P | OFAC (Office of Foreign Assets Control) | 90 |
| 5 | INAKRU41 | OFAC (Office of Foreign Assets Control) | 90 |
| 6 | SBBARUMM | OFAC (Office of Foreign Assets Control) | 90 |
Blacklisted Cities Reference Data
The following columns are available in the template for blacklisted cities:
- Record ID: This column displays the record serial number for the blacklisted city. The record ID is unique for every city.
- Country: This column displays the name of the country of the blacklisted city.
- City: This column displays the name of the blacklisted city.
- ISO City Code: This column displays the ISO code of the blacklisted city.
- Data Source: This column displays the source of the data for the blacklisted city.
- Risk Score: This column displays the risk score for the blacklisted city.
Sample Data for Sanctioned Cities
Table 10-2 Sample Data for Sanctioned Cities
| Record ID | Country | City | ISO City Code | Data Source | Risk Score |
|---|---|---|---|---|---|
| 1 | IRAQ | ARBIL | ABL | OFAC (Office of Foreign Assets Control) | 90 |
| 2 | IRAQ | ABU AL FULUS | ALF | OFAC (Office of Foreign Assets Control) | 90 |
| 3 | IRAQ | AMARA (AL- AMARAH) | AMA | OFAC (Office of Foreign Assets Control) | 85 |
| 4 | IRAQ | ARAK | ARK | OFAC (Office of Foreign Assets Control) | 90 |
Blacklisted Countries Reference Data
The following columns are available in the template for blacklisted countries:
- Record ID: This column displays the record serial number for the blacklisted country. The record ID is unique for every country.
- Country: This column displays the name of the blacklisted country.
- ISO Country Code: This column displays the ISO code of the blacklisted country.
- Country Synonyms: This column displays the synonyms of the blacklisted country.
- Data Source: This column displays the source of the data for the blacklisted country.
- Risk Score: This column displays the risk score for the blacklisted country.
Sample Data for Sanctioned Countries
Table 10-3 Sample Data for Sanctioned Countries
| Record ID | Country | ISO Country Code | Country Synonyms | Data Source | Risk Score |
|---|---|---|---|---|---|
| 1 | IRAQ | IQ | IRAK, REPUBLIC OF IRAQ, AL JUM- HURIYAH AL IRAQIYAH, AL IRAQ | OFAC (Office of Foreign Assets Control) | 90 |
Table 10-4 Sample Data for Sanctioned Countries
| Record ID | Country | ISO Country Code | Country Synonyms | Data Source | Risk Score |
|---|---|---|---|---|---|
| 2 | DEMOCRATIC REPUBLIC OF THE CONGO | CD | CONGO, THE DEMOCRATIC REPUBLIC OF THE | OFAC (Office of Foreign Assets Control) | 90 |
| 3 | AFGHANI- STAN | AF | NA | ITAR (International Traffic in Arms Reg- ulations) | 85 |
| 4 | ZIMBABWE | ZW | NA | ITAR (International Traffic in Arms Reg- ulations) | 90 |
| 5 | CENTRAL AFRICAN REPUBLIC | CF | NA | EAR (Export Administration Regula- tions) | 85 |
| 6 | BELARUS | BY | NA | EAR (Export Administration Regula- tions) | 80 |
Stop Keywords Reference Data
The following columns are available in the template for keywords:
- Record ID: This column displays the record serial number for the keyword.
- Stop keyword: This column displays the keyword.
- Risk Score: This column displays the risk score for the keyword.
Sample Data for Sanctioned Stop Keywords
Table 10-5 Sample Data for Sanctioned Stop Keywords
| Record ID | Stop KeyWords | Risk Score |
|---|---|---|
| 1 | EXPLOSIVE | 80 |
| 2 | DIAMOND | 90 |
| 3 | TERROR | 80 |
| 4 | TERRORIST | 85 |
| 5 | ARMS | 80 |
| 6 | NUCLEAR | 90 |
Goods Prohibition Reference Data
The following columns are available in the template for prohibited goods:
- Record ID: This column displays the record serial number for the prohibited good. The record ID is unique for every good.
- Good Code: This column displays the code of the prohibited good.
- Good Name: This column displays the name of the prohibited good.
- Good Description: This column displays the description of the prohibited good.
Sample Data for Prohibited Goods
Table 10-6 Sample Data for Prohibited Goods
| Record ID | Good Code | Good Name | Good Description |
|---|---|---|---|
| 1 | 0207 43 00 | Fatty livers | Fatty livers, fresh or chilled |
| 2 | 0208 90 10 | Ivory | CONGO, THE DEMOCRATIC REPUBLIC OF THE |
| 3 | 0209 10 00 | Ivory powder and waste | NA |
| 4 | 3057100 | Shark fins | NA |
| 5 | 4302 19 40 | Tiger-Cat skins | NA |
Ports Prohibition Reference Data
The following columns are available in the template for prohibited ports:
- Record ID: This column displays the record serial number for the prohibited port. The record ID is unique for every port.
- Country: This column displays the name of the country where the prohibited port is located.
- Port Name: This column displays the name of the prohibited port.
- Port Code: This column displays the code of the prohibited port.
- Port Synonyms: This column displays the synonym of the prohibited port.
Sample Data for Prohibited Ports
Table 10-7 Sample Data for Prohibited Ports
| Record ID | Country | Port Name | Port Code | Port Synonyms |
|---|---|---|---|---|
| 1 | IRAN, ISLAMIC REPUBLIC OF | KHORRAM- SHAHR | IR KHO | KHORRAMSHAHR Port |
| 2 | RUSSIA | Sevastopol | SMTP | Sebastopol,Port of Sevasto- pol |
| 3 | New Zealand | Dunedin | NZ ORR | Otago Harbour |
| 4 | New Zealand | Ravensbourne | NZ ORR | Otago Harbour |