Yes. OFAC's SDN list is available in XML, fixed-field and delimited formats that can be imported into a variety of software programs. … 79 … Does OFAC provide its Specially Designated Nationals (SDN) List in a format that can be easily imported into a database? … 1641 … Yes. OFAC's SDN list is… Read more
OFAC publishes the SDN data in a comma separated values format (CSV). This format is recognized by Excel and other spreadsheet programs and can be imported into spreadsheet format by simply opening the file in your default spreadsheet application. … 80 … Does OFAC provide its Specially Designated… Read more
OFAC maintains other sanctions lists in addition to its Specially Designated Nationals (SDN) list . The names on these lists may also appear on the SDN list when such targets have a blocking provision associated with them. However, when the treatment of sanctions targets is unique and stops short… Read more
Yes. OFAC maintains many of its sanctions list files on an FTP server. This server can be accessed at: ftp://ofacftp.treas.gov . The server will accept an anonymous login. OFAC's data is stored in the directories listed below. OFAC does not currently support connections to this server via SFTP. /… Read more
The FTP site is run by OFAC. Please contact OFAC's support hotline at 1-800-540-6322 for technical support. … 87 … Your FTP site has gone offline. Who should I contact to remedy this problem? … 1641 … The FTP site is run by OFAC. Please contact OFAC's support hotline at 1-800-540-6322 for technical… Read more
OFAC cannot give specific advice on how to design an automated system for downloading its sanctions list data. Many institutions solve this problem by setting up a scheduled download of the SDN List and other sanctions lists . These firms conduct their own risk assessments and decide how often they… Read more
No. OFAC records changes to the SDN and other sanctions lists in human-readable form in the recent actions section of its website. An archive of changes files found on this page . Database administrators interested in refreshing their databases with new SDN and other sanctions list data should use… Read more
Throughout OFAC’s sanctions list data products , such as the XML file, each entry is assigned a unique identification number (UID) as a means to help make sorting and filtering through information easier. In OFAC’s files, a UID is a numeric string that is associated with a single entry within a… Read more
OFAC has rigorous quality control procedures in place to ensure that all sanctions list data are current and accurate when they are released (including all of its human-readable list formats [in PDF and text]). All of the sanctions list information is downloaded and checked by OFAC personnel using… Read more
The SDN list and OFAC's non-SDN Consolidated lists are comprehensive. Database administrators can overwrite any old data in their systems with the latest versions of the list's data files, thus ensuring that their database is current … 89 … I am a database administrator at a financial institution… Read more