20.5 Third-party Application Process

This section describes the process for the Third-party application.

The following processes are used for this:
  1. Start Batch
  2. Load Data from Third-party to ECM
  3. Correlation
  4. Scoring
  5. Promote to Case
  6. Create Case
  7. End Batch

Start Batch

ECM Start E2E Batch process is used to start the batch execution to move the data from Third-party application to ECM.

Load Data from Third-party to ECM

Load_From_LA_To_CA process loads the data from the Landing area to the Consolidation area. Here, the data will populate to the Landing area from the Staging area. This has the following four subprocesses:
  • Loading Events: See Level 1 and 2 in the below table
  • Entity Surrogate Key Generation: See Level 3 and 4 in the below table
  • Evented Data Load: See Level 5 in the below table
  • Derive Wire, Cash and MI Transaction: See Level 6 in the below table

The following table contains the list of Third-party sub-process codes.

Here, Level 1 sub-process code execution is a prerequisite for Level 2 subprocess execution. Similarly, Level 2 sub-process code execution is a prerequisite for Level 3 sub-process execution and so on. Subprocess within a level can be executed in any order or it can be executed in parallel. BD_ENTITY_SUP_INFO sub-process code has to be executed after the business data population (see the Business Metadata Movement).

Table 20-6 Third-party sub-process codes

Level 1 Level 2 Level 3 Level 4 Level 5 Level 6
t2t_LOOKUP_ EVENT t2t_EVENTS t2t_LOOKUP_A CCOUNT t2t_FCC_EVENT _ENTITY_MAP_ ACCOUNT t2t_EVENTED_A CCT t2t_FCC_TRXN_PI VOT_TRANSFOR M_DS
t2t_FC- C_EVENT_BI NDING t2t_LOOKUP_C USTOMER t2t_FCC_EVENT _ENTITY_MAP_ CUSTOME R t2t_EVENTED_A CCT_ADDR t2t_FCC_TRXN_B NK2BNK_FL_DS
t2t_FCC_EVEN T_DETAILS t2t_LOOKUP_E MPLOYEE t2t_FCC_EVENT _ENTITY_MAP_ EMPLOYE E t2t_EVENTED_A CCT_RSTRN t2t_FCC_TRXN_P ARTY_XREF_BOT
t2t_LOOKUP_E XTERNAL_ENTI TY t2t_FCC_EVENT _ENTITY_MAP_ EXTERNA L_ENTITY t2t_EVENTED_C UST t2t_FCC_TRXN_P ARTY_XREF_BOT _OFFSET
t2t_LOOKUP_INSTITUTION_CB t2t_EVENTED_C UST_CREDIT_R TNG t2t_FCC_TRXN_P ARTY_XREF_FOT
t2t_LOOKUP_A CCOUNT_GRO UP t2t_EVENTED_E MP
t2t_LOOKUP_B OT t2t_LOOKUP_F OT t2t_EVENTED_E MP_ACCT
t2t_EVENTED_E MP_ADDR
t2t_FCC_EVENT _ENTITY_MAP_ CLIENT_B ANK t2t_EVENTED_E MP_EMAIL_AD DR
t2t_FCC_EVENT _ENTITY_MAP_ ACCOUNT_GROUP t2t_EVENTED_ NTCPTRY_PRFL _ACCT
t2t_EVENTED_ NTCPTRY_PRFL _CUST
t2t_FCC_EVENT _ENTITY_MAP_ FOTWIRE t2t_EVENTED_A CCT_BAL_POS N_SMRY
t2t_FCC_EVENT _ENTITY_MAP_ FOTCASH t2t_EVENTED_A CCT_GRP
t2t_FCC_EVENT _ENTITY_MAP_ FOTMI t2t_EVENTED_A UTO_QUOTE
t2t_EVENTED_B
ACK_OFFICE_TRXN
t2t_EVENTED_CLIENT_BANK
t2t_EVENTED_CORP_ACTN
t2t_EVENTED_CUST_ADDR
t2t_EVENTED_CUST_SUPPLEM ENTAL_ATTR
t2t_EVENTED_ DERIVED_ADDRESS
t2t_EVENTED_EMP_PHON
t2t_EVENTED_EXTERNAL_ENTITY
t2t_EVENTED_I NSTN_MASTER
t2t_EVENTED_ MANGD_ACCT
t2t_EVENTED_ ONLINE_ACCT
t2t_EVENTED_ ONLINE_ACCT_ ACCT
t2t_EVENTED_PEER_GRP
Stage to CA Customer Account Lookup Stage to CA Account
Stage to CA Customer Customer Lookup Stage to CA Account Address Email Address
Stage to CA Employee Account Lookup Stage to CA Account Address Email Phone
Stage to CA Account Addrss
Stage to CA Customer Account
Stage to CA Customer Address
Stage to CA Customer Country
Stage to CA Customer Email Address
Stage to CA Customer Phone
Stage to CA Customer Supplemental Attribute
Stage to CA Customer to Customer Relation
Stage to CA Correspondent Bank
Stage to CA Back Office Transaction
Stage to CA Derived Address
Stage to CA Derived Entity
Stage to CA Derived Entity Link
Stage to CA Derived Entity to Derived Address
Stage to CA Front Office Transaction Party
Stage to CA Financial Institution
Stage to CA Employee
Stage to CA Employee Address
Stage to CA Employee Email Address
Stage to CA Employee Phone
Stage to CA Front Office Transaction
Stage to CA Employee Account
Stage to CA Account Leases
BD_ENTITY_SU P_INFO This sub- process code has to be executed after the business data population (see the Business Metadata Movement). This sub- process code has to be executed after the business data population.
The following tables are used for ECM third-party landing areas:
  • STG_FCC_EVENT_CNTRCT_MSG
  • STG_FCC_EVENT_CUST_IMP_LICENSE
  • STG_FCC_EVENT_DOC_COLL_CNTR
  • STG_FCC_EVENT_DOC_COLL_CNTR_EV
  • STG_FCC_EVENT_DOC_COLL_DIS_DTL
  • STG_FCC_EVENT_DOC_COLL_INVOICE
  • STG_FCC_EVENT_DOC_COLL_MUL_DTL
  • STG_FCC_EVENT_DOC_COLL_SHP_DTL
  • STG_FCC_EVENT_TRADE_FIN_ACCT
  • STG_FCC_EVENT_TRADE_FIN_BRKRGE
  • STG_FCC_EVENT_TRADE_FIN_CNTRCT
  • STG_FCC_EVENT_TRADE_FIN_DOC
  • STG_FCC_EVENT_TRADE_FIN_DRAFT
  • STG_FCC_EVENT_TRADE_FIN_PARTY
  • STG_FCC_EVENT_TRD_FIN_BRK_DSTR
  • STG_FCC_EVENT_TRD_FIN_CNTRCT
  • STG_FCC_EVENT_TRD_FIN_CNTRCTET
  • STG_FCC_EVENT_TRD_FIN_GD_SRVC
  • STG_FCC_EVNT_CUST_IMP_LIC_GOOD
  • STG_FCC_GOOD_SRVC

Correlation

Correlation is used to perform correlation on loaded BD events. This has the following two tasks:
  • PGX_CORRELATION
  • BD_CORRELATION

Scoring

This is used to perform the scoring of third-party events, entities, and correlation. This has the following sub-process:
  • Entity_Scoring
  • Event_Scoring
  • Correlation_Scoring
  • Pre_Case_Scoring

Promote to Case

Promote_To_Case_Decision is used to decide if a Third-party correlation can be promoted to a case. This is based on the defined threshold limit.

Create Case

Create_Case is used to create a case if a third-party event is promoted to the case. Following is the list of Promote_To_Case T2Ts:
  • f_generatecaseid
  • f_insertcases
  • Promote_To_Case T2Ts
  • CASE_COMPLETION_FLAG

End Batch

ECM_End_E2E_Batch is used for ending the batch execution.