Problem Note 59453: NATIONAL_ID field in PARTY_LIVE table is not populated after you run Integrated Event Management macros in SAS® Anti-Money Laundering
 |  |  |  |  |
When you run Integrated Event Management macros to load data into SAS® Enterprise Case Management, the tax ID information for subjects might not be loaded. The fcf_iem_load_party macro contains a misspelled field name, NARTIONAL_ID, which prevents the party tax ID from being copied to the PARTY_LIVE table.
To work around the problem, change "NARTIONAL_ID" to "NATIONAL_ID" in the fcf_iem_load_party code below:
data iem.new_parties;
if 0 then set ecm_db.party_live;
set &SOURCEDS. (keep= PARTY_NUMBER SEGMENT_ID PARTY_TYPE_DESC PARTY_NAME
RISK_CLASSIFICATION PARTY_TAX_ID);
VALID_FROM_DTTM = "¤t_dt"dt;
PARTY_ID = CATX('-','PTY',PARTY_NUMBER);
SOURCE_SYSTEM_CD = SEGMENT_ID;
PARTY_TYPE_CD = 'FCFSUB';
PARTY_CATEGORY_CD = 'PTY';
INDIVIDUAL_FLG = PARTY_TYPE_DESC;
PARTY_FULL_NM = PARTY_NAME;
NARTIONAL_ID = PARTY_TAX_ID;
CREATE_USER_ID = "&ecm_user";
CREATE_DTTM = "¤t_dt"dt;
UPDATE_USER_ID = "&ecm_user";
VERSION_NO = 1;
DELETE_FLG = "0";
X_SASFCS_RSK_CLSSF = RISK_CLASSIFICATION;
drop PARTY_NUMBER SEGMENT_ID PARTY_TYPE_DESC PARTY_NAME RISK_CLASSIFICATION
PARTY_TAX_ID;
run;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Linux for x64 | 6.3 | 9.4 TS1M2 | ||
| Microsoft® Windows® for x64 | 6.3 | 9.4 TS1M2 | ||||
| 64-bit Enabled AIX | 6.3 | 9.4 TS1M2 | ||||
| 64-bit Enabled Solaris | 6.3 | 9.4 TS1M2 | ||||
A fix for this issue for SAS Compliance Solutions 6.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A1I.html#59453| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2016-12-21 13:37:23 |
| Date Created: | 2016-12-02 15:54:17 |