A.2 Deployment Initiation Processing
Table A-2 Deployment Initiation Processing
| Task ID | Rule Name (As configured) | Description | Component ID | Precedence |
|---|---|---|---|---|
| Task1 | FN_IPE_LAST_BATCH_RUN_KY | This is a task that captures the current batch ID when run. | TRANSFORM | DATA |
| Task2 | Populate_Cust_Prcsng_DI |
This is a task that populates the pre-filtered Customer Data into the Cust_Prcsng table when run. |
LOAD DATA | Task1 |
| Task3 | GathrStats_CUST_PRCSNG | This is a task that is used to gather statistics for the Cust_Prcsng table. | TRANSFORM | DATA |
| Task4 | 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 |
| Task5 | 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 | Task4 |
| Task6 | 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 | Task5 |
| Task7 | 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 | Task6 |
| Task8 | 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 | Task7 |
| Task9 | 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 | Task8 |
| Task10 | 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 | Task9 |
| Task11 | 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 | Task10 |
| Task12 | GathrStats_CUST_ACCT_PRC |
This is a task that is used to gather statistics for the Cust_acct_Prc table. |
TRANSFORM | DATA |
| 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 |
Task1, Task10, Task1 1, Task12, Task13, Task2, Task3, Task4, Task5, Task6, Task7, Task8, Task9 |
| Task15 | GathrStats_IP |
This is a task that is used to gather statistics for the FCT_CUST_iINTERESTED_PARTY table. |
TRANSFORM DATA | Task14 |
| Task16 | t2t_PARTY_DETAILS_PRCNG_IP | This is a task that populates the party details in the PARTY_DETAILS_PRCNG_IP table when run. | LOAD DATA | Task15 |
| Task17 | t2t_PARTY_ADDRESS_PRCNG_IP | This is a task that populates the party address in the PARTY_ADDRESS_PRCNG_IP table when run. | LOAD DATA | Task15 |
| Task18 | t2t_PARTY_ID_DOC_PRCNG_IP | This is a task that populates the party doc ID in the PARTY_ID_DOC_PRCNG_IP table when run. | LOAD DATA | Task15 |
| Task19 | t2t_FCT_TP_WLS_REQUESTS_PRCNG |
This is a task that populates the watch list Score in the FCT_TP_WLS_REQUESTS_PRCNG table when run. |
LOAD DATA | Task14, Task15, Task16, Task17, Task18 |
| Task20 | GathrStats_WLSREQUESTS_P |
This is a task that is used to gather statistics for the FCT_TP_WLS_REQUESTS and FCT_TP_WLS_REQUESTS_PRCNG tables. |
TRANSFORM DATA | Task19 |
| Task21 | Watchlist_FuzzyMatch | This is a task that calls the watch list Fuzzy Match to calculate the watch list Score when run. | TRANSFORM DATA | Task20 |
| Task22 | GathrStats_WLSRESULT_STG |
This is a task that is used to gather statistics for the FCT_TP_WLS_RESULTS and FCT_TP_WLS_RESULTS_PRCNG tables. |
TRANSFORM DATA | Task21 |
| Task23 | 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 | Task22 |
| Task24 | UPDATE_WLS_STATUS | This is a task that updates the Status of the watch list Request to Closed when run. | TRANSFORM DATA | Task 23 |
| Task25 | GathrStats_KYCPRCSNG_TAB | This is a task that is used to gather statistics for all the KYC processing tables. | TRANSFORM DATA | Task 24 |
| Task26 | Customer Processing | This is a task that generates rule or model based scores when run. | INLINE PROCESSING | Task19, Task20, Task21, Task22, Task23, Task24, Task25 |
| Task27 | Customer Processing | This is a task that generates rule or model based scores when run. | INLINE PROCESSING | Task26 |
| Task28 | t2t_FCT_RA_DI | This is a task that is used to populate the FCT_RA_DI table. | LOAD DATA | Task27 |
| Task29 |
GathrStats_FCT_RA |
This is a task that is used to gather statistics for the FCT_RA table for Regular Processing. | TRANSFORM DATA | Task28 |
| Task30 | 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 | Task29 |
| Task31 | 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 | Task30 |
| Task32 | 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 |
| Task33 | t2t_FCT_CUST_RVWDTLS_ AUTO_CLOSED_DI | This is a task that stores the details of the assessments that are auto-closed. | LOAD DATA | Task32 |
| Task34 | t2t_FCT_CUST_RVWDTLS_ PTC_DI | This is a task that stores the details of the assessments that are promoted to a case through the batch. | LOAD DATA | Task33 |
| Task35 | t2t_FCT_TP_WLS_REQUESTS | This is a task that populates the watch list score in the FCT_TP_WLS_REQUESTS table when run. | LOAD DATA | Task 34 |
| Task36 | t2t_FCT_TP_WLS_RESULTS | This is a task that populates the watch list score in the FCT_TP_WLS_RESULTS table when run. | LOAD DATA | Task 35 |
| Task37 | t2t_FCT_RA_RISK_RATING_HISTORY |
This is a task that populates the FCT_RA_RISK_RATING_HISTORY table when run. |
LOAD DATA | Task 36 |
| Task38 | 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 | Task 37 |
| Task39 | KYC_PURGE_LAST_RUN_TAB | This is a task that purges or truncates the kdd_extrl_batch_last_run table when run. | TRANSFORM DATA |
Task28, Task 29, Task 30, Task 31, Task 32, Task 33, Task 34, Task 35, Task 36, Task 37, Task 38 |