Systems and Methods for Sanction Management

A method for implementing dynamic data storage for sanction- reviewed transactions, comprising:

• receiving, at a server comprising at least one computer processor, a plurality of transactions from a transaction source;
• retrieving, by the server, from one of a public database and one or more organization-specific lists, decisioning on a sanction status associated with one or more transactions from the plurality of transactions;
• storing, by the server, the plurality of transactions and the decisioning for the one or more transactions in an active database, wherein the active database stores transactions for which the sanction status decisioning has not been received and the one or more transactions for which one or more respective sanction status decisionings has been received within a first time period;
• moving, by the server, the one or more transactions and the one or more respective sanction status decisionings to an archive database after the first period of time;
• moving, by the server, the one or more transactions and the one or more respective sanction status decisionings to cold storage from the archive database after a second period of time, wherein the one or more transactions and the one or more respective sanction status decisionings are not movable to the active database after being moved to the cold storage;
• dynamically changing, by the server, the first period of time based on volume of transactions and the second period of time based on anticipated need for retrieving archived transactions;
• receiving, at the server, a request to review a transaction;
• searching the active database for the requested transaction;
• in response to determining that the requested transaction is not stored in the active database, searching the archive database for the requested transaction;
• in response to finding the requested transaction in the archive database, retrieving transaction data of the requested transaction and automatically moving storage of the transaction data of the requested transaction from the archive database to the active database for a third period of time so that only transaction data that are younger than the first period of time and the transaction data of the requested transaction are stored in the active database for selective storage of currently relevant data, the third period of time being at least one week;
• and
• moving the transaction data of the requested transaction back to the archive database after passing of the third period of time.