Chapter 5—Informatica Workflows
Table 60. Post-Watch List Workflows—Broker Compliance
Fraud Detection Informatica Workflows
The following sections describe the Informatica workflows that are required for deriving and aggregating data for Fraud Detection:
Informatica Miscellaneous: Optional Workflows—Fraud Detection
Informatica Miscellaneous: Pre-Watch List Workflows—Fraud Detection
Informatica Watch List Workflows—Fraud Detection
Informatica Miscellaneous: Post-Watch List Workflows—Fraud Detection
Informatica Summary Workflows—Fraud Detection Informatica Miscellaneous: Optional Workflows—Fraud Detection
Optional Miscellaneous workflows perform processing in support of workflows in multiple, functional areas. Figure 44 illustrates Optional Miscellaneous Informatica workflows for Fraud Detection.
Figure 44. Optional Workflows—Fraud Detection
The application completes these workflows in one sequence; processing of the workflows does not require data from external predecessors.
Sequence
Number Folder Workflow Number Workflow Name Predecessor
13 ORION_Common 2172 w_ph2172_update_jurisdiction_in_ag
Fraud Detection Informatica Workflows Chapter 5—Informatica Workflows
Table 61 describes the Optional Miscellaneous workflows in Figure 44.
Table 61. Optional Workflows—Fraud Detection
Informatica Miscellaneous: Pre-Watch List Workflows—Fraud Detection
Pre-Watch List Miscellaneous workflows perform processing in support of workflows in multiple, functional areas. Figure 45 illustrates Pre-Watch List Miscellaneous Informatica workflows for Fraud Detection.
Figure 45. Pre-Watch List Workflows—Fraud Detection
The application completes these workflows in three sequences; processing of the workflows does not require data from external predecessors.
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_Brokerage_P
roduction
2020 w_p2020_delete_nonstanding_instructions
Fraud Detection Informatica Workflows Chapter 5—Informatica Workflows
Table 62 describes the Informatica Miscellaneous Pre-Watch List workflows in Figure 45.
Table 62. Pre-Watch List Workflows—Fraud Detection
Informatica Watch List Workflows—Fraud Detection
Informatica Watch List workflows facilitate the application of customer-supplied measures of risk to corresponding entities, transactions, and instructions.
Sequence
Number Folder Workflow Number Workflow Name Predecessor
1 ORION_Common 2005 w_p2005_set_cd_pd_dates
1 ORION_Common 2050 w_ph2050_update_bot_reversals
1 ORION_Common 2070 w_ph2070_truncate_cas
1 ORION_Common 2140 w_ph2140_pass_thru_process 1 ORION_Common 2180 w_ph2180_instn_identification
2 ORION_Common 2190 w_ph2190_fotps_instn_processing ORION_Common:2180 2 ORION_Common 2191 w_ph2191_anticipatory_profile_instn_processing ORION_Common:2180 3 ORION_Common 2130 w_ph2130_update_fot_unrelated_party_code
3 MLM_Brokerage_C ommon
2192 w_ph2192_update_inst_instn_seq_id ORION_Common:2180
Fraud Detection Informatica Workflows Chapter 5—Informatica Workflows
Figure 46 illustrates Informatica Watch List workflows for Fraud Detection.
Figure 46. Watch List Workflows—Fraud Detection
The application completes these workflows in 10 sequences; processing of some workflows requires data from Miscellaneous predecessors. These workflows may proceed simultaneously in all sequences as soon as processing of any predecessors has completed.
Table 63 details the Informatica Watch List workflows in Figure 46.
Fraud Detection Informatica Workflows Chapter 5—Informatica Workflows
Table 63. Watch List Workflows—Fraud Detection 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 MLM_Brokerage_C
ommon
3041 w_ph3041_create_addresses_from_inst
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
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, 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,
Fraud Detection Informatica Workflows Chapter 5—Informatica Workflows
Informatica Miscellaneous: Post-Watch List Workflows—Fraud Detection
Post-Watch List Miscellaneous workflows perform processing in support of workflows in multiple, functional areas. Figure 47 illustrates Post-Watch List Miscellaneous Informatica workflows for Fraud Detection.
Figure 47. Post-Watch List Workflows—Fraud Detection
The application completes these workflows in four sequences; processing of a workflow requires data from a Watch List predecessor (refer to Informatica Watch List Workflows—Fraud Detection, on page 160, for more information). Refer to the note in the section Informatica Miscellaneous: Post-Watch List Workflows—AML Brokerage, on page 140, for more information.
Table 64 describes the Informatica Miscellaneous Post-Watch List workflows in Figure 47.
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 12 MLM_Brokerage_C
ommon
3220 w_ph3220_update_bot_activity_risk ORION_Common:3191
12 MLM_Brokerage_C ommon
3230 w_ph3230_update_inst_activity_risk ORION_Common:3191
Fraud Detection Informatica Workflows Chapter 5—Informatica Workflows
Table 64. Post-Watch List Workflows—Fraud Detection
Informatica Summary Workflows—Fraud Detection
Informatica Summary workflows maintain monthly aggregations of customer activity.
Figure 48 illustrates Informatica Summary workflows for Fraud Detection.
Figure 48. Summary Workflows—Fraud Detection
The application completes these workflows in five sequences; processing of some
Sequence
Number Folder Workflow Number Workflow Name Predecessor
13 ORION_Common 2172 w_ph2172_update_jurisdiction_in_ag
13 ORION_Common 2200 w_ph2200_build_trxn_tables_from_fotps ORION_Common:3051, ORION_Common:3210 14 ORION_Common 2220 w_ph2220_update_fot_reversals ORION_Common:2200 20 ORION_Common 3501 w_ph3501_Exp_and_Risk_Review_TP ORION_Common:2200
21 ORION_Common 3502 w_ph3502_Flag_Trusted_Trxn ORION_Common:3501
Fraud Detection Informatica Workflows Chapter 5—Informatica Workflows
These workflows may proceed simultaneously in all sequences as soon as processing of any predecessors has completed.
Table 65 describes the Summary workflows in Figure 48.
Table 65. Summary Workflows—Fraud Detection Sequence
Number Folder Workflow Number Workflow Name Predecessor
16 ORION_Production 0150 w_p0150_truncate_asms ORION_Common:2005
16 9001 AccountDailyProfileTrade
16 9002 AccountDailyProfileTransaction
17 ORION_Production 0190 w_p0190_aggregate_fotps_to_asms ORION_Common:3210 ORION_Production:0150
17 9005 AccountProfile 9001, 9002
18 ORION_Production 0310 w_p0310_update_asm_for_daily_activity 9005
ORION_Production:0190 19 ORION_Production 0630 w_p0630_build_ATxSD_from_ASMS 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