Problem Note 14407: Additional column needed in several bridge table primary keys for SAS
Anti-Money Laundering
The CHANGE_BEGIN_DATE column should be part of the primary key for
FSC_HOUSEHOLD_ACCOUNT_BRIDGE, FSC_PARTY_ACCOUNT_BRIDGE and
FSC_HOUSEHOLD_PARTY_BRIDGE. This is necessary because successive type-2
changes to relationships require storing multiple records in these
tables with the same entity keys.
For example, party_key and household_key alone do NOT guarantee
uniqueness in FSC_HOUSEHOLD_PARTY_BRIDGE. A party might be disassociated
with an account on 1/21, resulting in a closed out record, only to be
added again on 2/15. This should result in two records, both of which
have the same party_key and household_key, but different
change_begin_date and change_end_date values. Adding change_begin_date
to the key allows this.
A fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/aml14.html#014407
Operating System and Release Information
| SAS System | SAS Anti-Money Laundering Alert Generation Server | Microsoft Windows NT Workstation | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 1.4 | 2.1 | 9.1 TS1M3 | |
| Solaris | 1.4 | 2.1 | 9.1 TS1M3 | |
| Linux | 1.4 | 2.1 | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 1.4 | 2.1 | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 1.4 | 2.1 | 9.1 TS1M3 | |
| AIX | 1.4 | 2.1 | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2005-01-30 08:23:06 |
| Date Created: | 2005-01-27 10:09:38 |
