Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

In certain situations, an incorrect sort sequence on the prep files for
SAS Anti-Money Laundering can cause alerts not to be generated.

The specifics regarding required sort sequences are correctly documented
in Chapter 7 of the "SAS Anti-Money Laundering 1.4, Solution Planning
Guide".  The 1.3 version of the guide documented the information in
Chapter 6.

Customers are strongly encouraged to verify the sort sequence of the
tables which are registered as prep tables via the 'Register Tables'
add-in during the install process.  It is not required that the tables
be marked as sorted, only that the records appear in the proper sort
sequence.

Below is a listing of the required sort sequences of tables vulnerable
to the problem:

ACCOUNT_PROFILE                 by   ACCOUNT_NUMBER, MONTH_KEY
ACCOUNT_TRANSACTIONS            by   ACCOUNT_NUMBER, DATE_KEY
*DORMANT_ACCOUNT_TRANSACTIONS   by   ACCOUNT_NUMBER, DATE_KEY
PARTY_PROFILE                   by   PARTY_NUMBER,   MONTH_KEY
PARTY_TRANSACTIONS              by   PARTY_NUMBER,   DATE_KEY

* DORMANT_ACCOUNT_TRANSACTIONS is new in SAS Anti-Money Laundering
version 1.3.

Some sites may not choose to implement one or more of these prep files
if the site does not implement scenarios which require them.

Operating System and Release Information