A.1 Regular Processing
To process watch list data, run the following data maps:
runjob $MANTAS_HOME/bdf/scripts/execute.sh WLMProcessingLockrunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchListEntry_WatchListEntryCurrDayInsertrunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchListAudit_StatusUpdrunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchList_WatchListSourceAuditInsertrunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchList_WatchListSourceAuditUpdrunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchList_WatchListSourceUpdrunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchListEntry_WatchListAuditUpdrunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchListEntryAudit_WatchListEntryUpdaterunjob $MANTAS_HOME/bdf/scripts/execute.sh WatchListStagingTable_WatchListrunjob $MANTAS_HOME/bdf/scripts/execute.sh WLMProcessingUnlock
Table A-1 Regular Processing
| Task ID | Rule Name (As configured) | Description | Component ID | Precedence |
|---|---|---|---|---|
| Task1 | Customer | This is an IPE pre filtering task that is used to run the Accelerated Re-review, New Accounts, and Periodic Re-review Assessments and to find the eligible customers for Risk Assessment. | INLINE PROCESSING | Task2 |
| Task2 | BD_POPULATE_LAST_RUN_BATCH | This is a task that populates the kdd_extrl_batch_last_run table and is used to keep track of the current batch that is being run. | TRANSFORM DATA | START |
| Task3 | Populate_Cust_Prcsng |
This is a task that populates the pre-filtered Customer Data into the Cust_Prcsng table when run. |
LOAD DATA | Task1, Task2 |
| Task4 | Populate_Processed_NewAcct | This is a task that populates the new accounts processed in the system into the processing table when run. | TRANSFORM DATA | Task3 |
| Task5 | Populate_Cust_Addr_Prcsng | This is a task that populates the pre-filtered Customer Data into the Cust_Addr_Prcsng table when run. | LOAD DATA | Task3 |
| Task6 | Populate_Cust_Cntry_Prcsng | This is a task that populates the pre-filtered Customer Data into the Cust_Cntry_Prcsng table when run. | LOAD DATA | Task3 |
| Task7 |
Populate_Cust_Id_Doc_Prcsng |
This is a task that populates the pre-filtered Customer Data into the Cust_Id_Doc_Prcsng table when run. | LOAD DATA | Task3 |
| Task8 | Populate_Cust_Mkt_Served_Prcsng | This is a task that populates the pre- filtered Customer Data into the Cust_Mkt_Served_Prcsng table when run. | LOAD DATA | Task3 |
| Task9 | Populate_Cust_Phon_Prcsng | This is a task that populates the pre- filtered Customer Data into the Cust_Phon_Prcsng table when run. | LOAD DATA | Task3 |
| Task10 | Populate_Cust_Prod_Prcsng | This is a task that populates the pre- filtered Customer Data into the Cust_Product_Prcsng table when run. | LOAD DATA | Task3 |
| Task11 | Populate_Cust_to_Cust_Prcsng | This is a task that populates the pre- filtered Customer Data into the Cust_Cust_Prcsng table when run. | LOAD DATA | Task3 |
| Task12 | Populate_Cust_Acct_Prcsng | This is a task that populates the pre- filtered Customer Data into the Cust_Acct_Prcsng table when run. | LOAD DATA | Task3 |
| Task13 | Populate_Acct_Prcsng | This is a task that populates the pre- filtered Customer Data into the Acct_Prcsng table when run. | LOAD DATA | Task12 |
| Task14 | POPULATE_IP_KYC | This is a task that populates the Interested Party Customers and Accounts when they are run. | TRANSFORM DATA | Task10, Task11, Task12, Task13, Task3, Task4, Task5, Task6, Task7, Task8, Task9 |
| Task15 |
t2t_PARTY_ADDRESS_PRCNG_IP |
This is a task that populates the party address into the pricing table when run. | LOAD DATA | Task14 |
| Task16 | t2t_PARTY_DETAILS_PRCNG_IP | This is a task that populates the party details into the pricing table when run. | LOAD DATA | Task14 |
| Task17 | t2t_PARTY_ID_DOC_PRCNG_IP | This is a task that populates the party doc ID into the pricing table when run. | LOAD DATA | Task14 |
| Task18 | t2t_PARTY_PARTY_RLSHP_PRCSNG_BO |
This is a task that populates the beneficial owner details into the PARTY_PARTY_RLSHP_PRCSNG_BO table when run. |
LOAD DATA | Task14, Task15, Task16, Task17 |
| Task19 | t2t_PARTY_DETAILS_PRCNG_BO_INT |
This is a task that populates the internal beneficial owner details into the PARTY_DETAILS_PRCNG_BO_INT table when run. |
LOAD DATA | Task18 |
| Task20 | t2t_PARTY_DETAILS_PRCNG_BO_EXT |
This is a task that populates the external beneficial owner details into the PARTY_DETAILS_PRCNG_BO_EXT table when run. |
LOAD DATA | Task18 |
| Task21 |
t2t_PARTY_ADDRESS_PRCNG_BO_INT |
This is a task that populates the internal beneficial owner details into the PARTY_ADDRESS_PRCNG_BO_INT table when run. |
LOAD DATA | Task18 |
| Task22 |
t2t_PARTY_ADDRESS_PRCNG_BO_EXT |
This is a task that populates the external beneficial owner details into the PARTY_ADDRESS_PRCNG_BO_EXT table when run. |
LOAD DATA | Task18 |
| Task23 | t2t_PARTY_ID_DOC_PRCNG_BO_INT |
This is a task that populates the internal beneficial owner details into the PARTY_ID_DOC_PRCNG_BO_INT table when run. |
LOAD DATA | Task18 |
| Task24 | t2t_PARTY_ID_DOC_PRCNG_BO_EXT |
This is a task that populates the external beneficial owner details into the PARTY_ID_DOC_PRCNG_BO_EXT table when run. |
LOAD DATA | Task18 |
| Task25 | t2t_FCT_TP_WLS_REQUESTS_PRCNG | This is a task that populates Requests into the watch list Processing table for the pre-filtered Customers when run. | LOAD DATA | Task18, Task19, Task20, Task21, Task22, Task23, Task24 |
| Task26 | t2t_FCT_TP_WLS_RESULTS_PRCNG | This is a task that populates the watch list Score in the FCT_TP_WLS_RESULTS_PRCNG table when run. | LOAD DATA | Task27 |
| Task27 | Watchlist_FuzzyMatch | This is a task that calls the watch list Fuzzy Match to calculate the watch list Score when run. | TRANSFORM DATA | Task25 |
| Task28 | UPDATE_WLS_ STATUS | This is a task that updates the Status of the watch list Request to Closed when run. | TRANSFORM DATA | Task26 |
| Task29 | Customer Processing | This is a task that is used to run the IPE assessment for Rule-based Rules and generate the scores when run. | INLINE PROCESSING | Task25, Task26, Task27, Task28 |
| Task30 | Customer Processing | This is a task that is used to run the IPE assessment for Model-based Rules and generate the scores when run. | INLINE PROCESSING | Task29 |
| Task31 | t2t_POPULATE_FCT_RA | This is a task that generates the Risk Assessment IDs for each Customer and populates the FCT_RA table when run. | LOAD DATA | Task30 |
| Task32 |
t2t_POPULATE_FCT_RA_RISK_SUMMARY |
This is a task that populates the FCT_RA_RISK_SUMMARY table with the final MB and RB scores for each Customer when run. | LOAD DATA | Task31 |
| Task33 |
t2t_POPULATE_FCT_RA_RISK_REASONS |
This is a task that populates the FCT_RA_RISK_REASONS table with the scores of each Parameter for every Customer when run. | LOAD DATA | Task31 |
| Task34 | t2t_FCT_RA_ RISK_DETAILS | This is a task that populates the FCT_RA_RISK_DETAILS table with the actual values of each Parameter for every Customer when run. | LOAD DATA | Task31 |
| Task35 | t2t_FCT_CUST_RA_HISTRY | This is a task that populates the FCT_CUST_RA_HISTRY table with the names of the pre-filtered customers when run. | LOAD DATA | Task36 |
| Task36 | F_CLOSURE_UPDATES | This is a task that updates the RA once they are closed. | TRANSFORM DATA | Task37 |
| Task37 | t2t_FCT_CUST_RVWDTL S | This is a task that populates the FCT_CUST_RVWDTLS table when run. | LOAD DATA | Task31 |
| Task38 | t2t_FCT_TP_WLS_REQUESTS | This is a task that populates the FCT_TP_WLS_REQUESTS table when run. | LOAD DATA | Task31 |
| Task39 | t2t_FCT_TP_WLS_RESULTS | This is a task that populates the FCT_TP_WLS_RESULTS table when run. | LOAD DATA | Task21 |
| Task40 | t2t_FCT_RA_ RISK_RATING_HISTORY |
This is a task that populates the FCT_RA_RISK_RATING_HISTORY table when run. |
LOAD DATA | Task31 |
| Task41 | t2t_FCT_CUST_REVIEW_REASON S |
This is a task that populates the customer review reasons into the FCT_CUST_REVIEW_REASONS table when run. |
LOAD DATA | Task31 |
| Task42 | KYC_PURGE_LAST_RUN_TAB | This is a task that purges or truncates the kdd_extrl_batch_last_run table when run. | TRANSFORM DATA | Task31, Task32, Task33, Task34, Task35, Task36, Task37, Task38, Task39, Task40, Task41 |
| Task43 | t2f_GenCustDetails_ED | This is a task that generates the Customer details flat file. | EXTRACT DATA | Task42 |
| Task44 | t2f_GenWLSFeedback_ED | This is a task that generates the watch list feedback details flat file. | EXTRACT DATA | Task42 |
| Task45 | t2f_GenCBSFeedback_ED | This is a task that generates the GenCBSFeedback details flat file. | EXTRACT DATA | Task42 |
| Task46 |
KYC_File_Rename |
This is a task that generates the new KYC file name. | TRANSFORM DATA | Task43, Task44, Task45 |