Chapter 5—Informatica Workflows
AML Banking Informatica Workflows
The following sections describe the required Informatica workflows for deriving and aggregating data for the AML Banking solution:
Informatica Miscellaneous: Optional Workflows—AML Banking
Informatica Miscellaneous: Pre-Watch List Workflows—AML Banking
Informatica Watch List Workflows—AML Banking
Informatica Miscellaneous: Post-Watch List Workflows—AML Banking
Informatica Summary Workflows—AML Banking Informatica Miscellaneous: Optional Workflows—AML Banking
Optional Miscellaneous workflows perform processing in support of workflows in multiple, functional areas. Figure 34 illustrates Informatica Miscellaneous Optional workflows for AML Banking.
Figure 34. Optional Workflows—AML Banking
The application completes these workflows in one sequence; processing of the workflows does not require data from external predecessors. Table 51 describes the Informatica Miscellaneous Optional workflows in Figure 34.
Table 51. Optional Workflows—AML Banking Sequence
Number Folder Workflow Number Workflow Name Predecessor
0 ORION_Production 0010 w_p0010_dump_asm_to_file
0 ORION_Production 0070 w_p0070_reload_asm_from_dump_file
0 MLM_Banking_Pro duction
0080 w_p0080_dump_cbsm_to_file
0 MLM_Banking_Pro duction
0140 w_p0140_reload_cbsm_from_dump_file
AML Banking Informatica Workflows Chapter 5—Informatica Workflows
Informatica Miscellaneous: Pre-Watch List Workflows—AML Banking
Pre-Watch List Informatica Miscellaneous workflows facilitate the application of customer-supplied measures of risk to corresponding entities, transactions, and instructions. Figure 35 illustrates Informatica Pre-Watch List Miscellaneous workflows for AML Banking.
Figure 35. Independent Pre-Watch List Workflows—AML Banking
The system completes these workflows in two sequences; processing of the workflows does not require data from external predecessors. These workflows may proceed simultaneously in all sequences as soon as processing of any predecessors has completed.
Table 52 describes the Informatica Miscellaneous Independent Pre-Watch List workflows in Figure 35.
Table 52. Independent Pre-Watch List Workflows—AML Banking Sequence
Number Folder Workflow Number Workflow Name Predecessor
1 ORION_Common 2005 w_p2005_set_cd_pd_dates
1 ORION_Common 2140 w_ph2140_pass_thru_process
1 ORION_Common 2180 w_ph2180_instn_identification
1 ORION_Common 2600 w_ph2600_loan_smry_mnth
2 ORION_Common 2190 w_ph2190_fotps_instn_processing ORION_Common:2180 2 ORION_Common 3091 w_ph3091_create_PartyNmEE_from_fotps
AML Banking Informatica Workflows Chapter 5—Informatica Workflows
Informatica Watch List Workflows—AML Banking
Informatica Watch List workflows facilitate the application of customer-supplied measures of risk to corresponding entities, transactions, and instructions. Figure 36 illustrates Informatica Watch List workflows for AML Banking.
Figure 36. Watch List Workflows—AML Banking
The application completes these workflows in nine sequences. Processing of some workflows requires data from Miscellaneous predecessors (refer to Informatica Miscellaneous: Optional Workflows—AML Banking, on page 146, for more information).
These workflows may proceed simultaneously in all sequences as soon as processing of any predecessors has completed.
Table 53 describes the Informatica Watch List workflows in Figure 36.
AML Banking Informatica Workflows Chapter 5—Informatica Workflows
Table 53. Watch List Workflows—AML Banking Sequence
Number Folder
Workflow
Number Workflow Name Predecessor
3 ORION_Common 3000 w_ph3000_Adjust_WL_WLS ORION_Common:2180
3 ORION_Common 3005 w_ph3005_apply_cust_KYC_risk 3 ORION_Common 3030 w_ph3030_truncate_wls 4 ORION_Common 3010 w_ph3010_truncate_ls 4 ORION_Common 3020 w_ph3020_truncate_nms 4 ORION_Common 3040 w_ph3040_truncate_wls2
4 ORION_Common 3051 w_ph3051_create_addresses_from_fotps
4 ORION_Common 3090 w_ph3090_create_external_entities_from_fotps ORION_Common:2190, ORION_Common:3091 4 MLM_Banking_Com
mon
3130 w_ph3130_create_client_banks_from_fotps ORION_Common:2190
5 ORION_Common 3070 w_ph3070_load_watch_list_staging_table ORION_Common:3000, ORION_Common:3030 5 ORION_Common 3140 w_ph3140_write_fotps_associations_to_ls ORION_Common:3010,
ORION_Common:3051,
ORION_Common:3090 6 ORION_Common 3100 w_ph3100_load_staging_fuzzy_matches ORION_Common:3020,
ORION_Common:3070,
ORION_Common:3090 6 ORION_Common 3180 w_ph3180_write_ls_to_link_tables ORION_Common:3110,
ORION_Common:3140,
MLM_Brokerage_Common:3160 7 ORION_Common 3150 w_ph3150_load_staging_and_validate_watch_list ORION_Common:3040,
ORION_Common:3070, 8 ORION_Common 3170 w_ph3170_update_staging_list_risk ORION_Common:3150 9 ORION_Common 3190 w_ph3190_apply_risk_to_nonacct_entities ORION_Common:3005,
ORION_Common:3170 9 ORION_Common 3200 w_ph3200_apply_membership_to_entities ORION_Common:3170
11 ORION_Common 3191 w_ph3191_apply_risk_to_acct_entities MLM_Brokerage_Common:3171, ORION_Comm
on:3190
12 ORION_Common 3210 w_ph3210_update_fotps_activity_risk ORION_Common:3191
AML Banking Informatica Workflows Chapter 5—Informatica Workflows
Informatica Miscellaneous: Post-Watch List Workflows—AML Banking
Informatica Miscellaneous Post-Watch List workflows facilitate the application of customer-supplied measures of risk to corresponding entities, transactions, and instructions. Figure 37 illustrates Informatica Miscellaneous Post-Watch List workflows for AML Banking.
Figure 37. Post-Watch List Workflows—AML Banking
The application completes these workflows in four sequences. Processing of some workflows requires data from Miscellaneous predecessor workflows 3130 and 3210 (refer to Informatica Miscellaneous: Optional Workflows—AML Banking, on page 146, for more information). These workflows may proceed simultaneously in all sequences as soon as processing of any predecessors has completed. Refer to the note in the section Informatica Miscellaneous: Post-Watch List Workflows—AML Brokerage, on page 140, for more information.
Table 54 describes the Informatica Miscellaneous Post-Watch List workflows in Figure 37.
Table 54. Post-Watch List Workflows—AML Banking Sequence
Number Folder Workflow Number Workflow Name Predecessor
13 MLM_Banking_Com mon
2090 w_ph2090_update_jurisdiction_in_cb MLM_Banking_Common:3130
13 ORION_Common 2200 w_ph2200_build_trxn_tables_from_fotps ORION_Common:3051, ORION_Common:3210
AML Banking Informatica Workflows Chapter 5—Informatica Workflows
Informatica Summary Workflows—AML Banking
Informatica Summary workflows maintain monthly aggregations of customer activity.
Figure 38 illustrates Informatica Summary workflows for AML Banking.
Figure 38. Summary Workflows—AML Banking
The application completes these workflows in five sequences; processing of some workflows requires data from external predecessors (refer to section Informatica Miscellaneous: Optional Workflows—AML Banking, on page 146 and Informatica Watch List Workflows—AML Banking, on page 148, for more information).
These workflows may proceed simultaneously in all sequences as soon as processing of any predecessors has completed.
Table 55 describes the Informatica Summary workflows in Figure 38.
AML Banking Informatica Workflows Chapter 5—Informatica Workflows
Table 55. Summary Workflows—AML Banking
Sequence
Number Folder
Workflow
Number Workflow Name Predecessor
16 MLM_Banking_Com mon
0081 w_ph0081_truncate_cbsm
16 ORION_Production 0150 w_p0150_truncate_asms ORION_Common:2005
16 9001 AccountDailyProfileTrade
16 9002 AccountDailyProfileTransaction
17 9005 AccountProfile 9001, 9002
17 ORION_Production 0190 w_p0190_aggregate_fotps_to_asms ORION_Common:3210, ORION_Production:0150 18 ORION_Production 0310 w_p0310_update_asm_for_daily_activity 9005, ORION_Production:0190 19 MLM_Banking_Pro
duction
0145 w_ph0145_truncate_CBPTxSM
19 MLM_Banking_Com mon
0480 w_ph0480_aggregate_asm_to_cbsm MLM_Banking_Common:0081, ORION_Produc
tion:0310
19 ORION_Production 0630 w_p0630_build_ATxSD_from_ASMS ORION_Production:0310 19 ORION_Production 0660 w_p0660_FOTPSR_to_AASD ORION_Production:0310 19 ORION_Production 0750 w_ph0750_truncate_APTxSM
19 MLM_Brokerage_P roduction
0280 w_p0280_create_clog_activity_records ORION_Production:0310
20 ORION_Production 0760 w_ph0760_ASM_to_APTxSM ORION_Production:0750 21 MLM_Banking_Pro
duction
0146 w_ph0146_CBSM_to_CBPTxSM MLM_Banking_Production:0145, MLM_Bank
ing_Common:0480