20.4 OSTDO Application Process
This section describes the process for the OSTDO application.
The following processes are used for this:
Start Batch
STDO_ECM_Start_E2E_Batch process is used to start the batch execution to move the data from OSTDO to ECM.
Load Data from STDO to Consolidation Area
STDO_Load_From_LA_To_CA process loads OSTDO data from the Landing area to
the Consolidation area. This has the following sub-processes:
- STDO_Event_Load
- STDO_Entity_Surrogate_Key_Gen
- STDO_Business_Data_Load
- STDO_SUPLMTRY_INFO
- STDO_Evented_Data_Load
Here, Level 0 sub-process code execution is a prerequisite for Level 1
subprocess execution. Similarly, Level 1 sub-process code execution
is a prerequisite for Level 2 sub-process execution and so on.
Subprocess within a level can be executed in any order or it can be
executed in parallel as shown in the following table.
Table 20-5 Load Data from STDO to Consolidation Area
| Level 0 | Level 1 | Level 2 |
|---|---|---|
| STDO_Event_Load | STDO_EVENT_LOOKUP | |
| STDO_EVENT | ||
| STDO_EVENT_BINDING | ||
| STDO_EVENT_DETAILS | ||
| STDO_Entity_Surrogate_Key_Gen | BD_ACCOUNTATMDAILY_LOOKUP | STDO_EVENT_ENTITY_MAP |
| BD_ACCOUNTDLY_LOOKUP | STDO_EVENT_ENTITY_MAPII | |
| BD_ACCOUNTTRADEDLY_LOOKUP | STDO_EVENT_ENTITY_MAPIII | |
| BD_ACCOUNTTRXNDLY_LOOK UP | STDO_EVENT_ENTITY_MAPIV | |
| BD_ACCOUNT_GROUP_LOOKUP | ||
| BD_ACCOUNT_PEERGROUP_LOOKUP | ||
| BD_ACCT_CLIENTBANK_LOOKUP | ||
| BD_ACCT_PR_TRXN_SMR_MN_ LOOKUP | ||
| BD_ACCT_SMRY_MNTH_LOOKUP | ||
| BD_CBPEERTRXNSMRY_LOOKUP | ||
| BD_CLIENTBANK_PEERGRP_LOOKUP | ||
| BD_CLINETBANKBSMRY_LOOKUP | ||
| BD_CUSTOMERBALANCE_LOOKUP | ||
| BD_CUSTOMERDLY_LOOKUP | ||
| BD_CUSTOMERSMRY_LOOKUP | ||
| BD_CUSTOMER_ACCOUNT_LOOKUP | ||
| STDO_ACCOUNT_LOOKUP | ||
| STDO_CUSTOMER_LOOKUP | ||
| STDO_BACK_OFFICE_TRXN_LOOKUP | ||
| STDO_CASH_TRXN_LOOKUP | ||
| STDO_MI_TRXN_LOOKUP | ||
| STDO_WIRE_TRXN_LOOKUP | ||
| BD_CUSTOMER_PRODUCT_LOOKUP | ||
| BD_DERIVED_ADDRESS_LOOKUP | ||
| BD_EMPLOYEE_ACCOUNT_LOOKUP | ||
| BD_EMPLOYEE_LOOKUP | ||
| BD_EXTERNALENTITYDLY_LOOKUP | ||
| BD_EXTERNAL_ENTITY_LOOKUP | ||
| BD_HOUSEHOLDBALDLY_LOOKUP | ||
| BD_HOUSEHOLDSMRY_LOOKUP | ||
| BD_INSTACCOUNTSMRY_LOOKUP | ||
| BD_INSTITUTION_LOOKUP | ||
| BD_INSTLACCOUNTDLY_LOOK UP | ||
| BD_INSURANCEPOLICYBAL_LOOKUP | ||
| BD_INSURANCEPOLICYDLY_LOOKUP | ||
| BD_INSURPOLICY_CUST_LOOKUP | ||
| BD_LOANSMRY_LOOKUP | ||
| BD_LOAN_LOOKUP | ||
| BD_MANAGEDACCOUNTDLY_LOOKUP | ||
| BD_MANAGEDACCOUNT_LOOKUP | ||
| BD_MARKET_CENTER_LOOKUP | ||
| BD_NETWORKLOGON_LOOKUP | ||
| BD_NTWKUSER_ACCOUNT_LOOKUP | ||
| BD_ONLINEACCOUNT_LOOKUP | ||
| BD_ONLINEACCT_ACCT_LOOKUP | ||
| BD_PEER_GROUP_LOOKUP | ||
| STDO_Business_Data_Load | BD_ACCT_ATM_SMRY_DAILY | |
| BD_ACCT_BAL_POSN_SMRY | ||
| BD_ACCT_GRP | ||
| BD_ACCT_ID_INSTN_ID_MAP | ||
| BD_ACCT_LIST_MEMBERSHIP | ||
| BD_ACCT_PEER_GRP | ||
| BD_ACCT_PEER_TRXN_SMRY_ MNTH | ||
| BD_ACCT_SMRY_MNTH | ||
| BD_ACCT_SUPPLEMENTAL_ATR | ||
| BD_BACK_OFFICE_TRXN | ||
| BD_CASH_TRXN | ||
| BD_CB_LIST_MEMBERSHIP | ||
| BD_CB_PR_TRXN_SMRY_MNTH | ||
| BD_CLIENT_BANK | ||
| BD_CLIENT_BANK_PEER_GRP | ||
| BD_CLIENT_BANK_SMRY_MNTH | ||
| BD_CUST | ||
| BD_ONLINE_ACCT_ACCT | ||
| STDO_ACCT | ||
| STDO_ACCT_ADDR | ||
| STDO_ACCT_EMAIL_ADDR | ||
| STDO_ACCT_PHON | ||
| STDO_ACCT_RSTRN | ||
| STDO_ACCT_LIST_MEMBERSHIP | ||
| BD_CUST_ACCT | ||
| BD_CUST_ACCT_ROLE | ||
| BD_CUST_ADDR | ||
| BD_CUST_CUST | ||
| BD_CUST_LIST_MEMBERSHIP | ||
| BD_CUST_PHON | ||
| BD_CUST_EMAIL_ADDR | ||
| BD_CUST_SMRY_MNTH | ||
| BD_CUST_SUPPLEMENTAL_ATR | ||
| BD_DERIVED_ADDRESS | ||
| BD_EMP BD_EMP_ACCT | ||
| BD_EMP_ADDR | ||
| BD_EMP_EMAIL_ADDR | ||
| BD_EMP_PHON | ||
| BD_EXTERNAL_ENTITY | ||
| BD_EXTERNAL_ENTITY_ADDR | ||
| BD_EXTRNAL_NTTY_MMBRSHP | ||
| BD_HH_BAL_POSN_SMRY | ||
| BD_HH_SMRY_MNTH | ||
| BD_HOUSE_HOLD | ||
| BD_INSTL_ACCT_SMRY_MNTH | ||
| BD_INSTN_MASTER | ||
| BD_INSURANCE_POLICY | ||
| BD_INSURANCE_POLICY_CUST | ||
| BD_INSURANCE_PRODUCT | ||
| BD_LOAN | ||
| BD_LOAN_SMRY_MNTH | ||
| BD_MANGD_ACCT | ||
| BD_MI_TRXN | ||
| BD_NTCPTRY_PRFL | ||
| BD_NVSMT_MGR | ||
| BD_NVSMT_MGR_SMRY_MNTH | ||
| BD_ONLINE_ACCT | ||
| BD_WIRE_TRXN | ||
| STDO_SUPLMTRY_INFO | Studio Supplementary Information | |
| STDO_Evented_Data_Load | STDO_ACCT_EVENT | |
| STDO_CUST_EVENT | ||
| STDO_EMP_EMAIL_ADDR_EVNT | ||
| STDO_ACCT_PR_TXN_SMRY_MN_EVNT | ||
| STDO_ACCT_SMRY_MNTH_EVNT | ||
| STDO_MI_TRXN_EVNT | ||
| STDO_ACCT_BAL_POSN_SMRY_EVNT | ||
| STDO_HH_BAL_POSN_SMRY_EVNT | ||
| STDO_INSTN_MASTER | ||
| STDO_BOT_EVNT | ||
| STDO_CASH_TRXN_EVNT | ||
| STDO_EMP_ACCT_EVNT | ||
| STDO_ACCT_PEER_GRP_EVNT | ||
| STDO_NTCPTRY_PRFL_EVNT | ||
| STDO_ACCT_SUPPLEMENTAL_ ATR_EVN | ||
| STDO_WIRE_TRXN_EVNT | ||
| STDO_EMP_PHON_EVNT | ||
| STDO_ONLINE_ACCT_ACCT_EVNT | ||
| STDO_EMP_ADDR_EVNT | ||
| STDO_ACCT_ADDR_EVNT | ||
| STDO_CUST_SMRY_MNTH_EVNT | ||
| STDO_ONLINE_ACCT_EVNT | ||
| STDO_EMP_EVNT | ||
| STDO_ACCT_RSTRN_EVNT | ||
| STDO_CUST_SUPPL_ATR_EVNT | ||
| STDO_ACCT_GRP_EVNT | ||
| STDO_MANGD_ACCT_EVNT | ||
| STDO_HH_SMRY_MNTH_EVNT | ||
| STDO_CLIENT_BANK_EVNT | ||
| STDO_ACCT_ATM_SMRY_DAILY_EVNT | ||
| STDO_DERIVED_ADDRESS_EVNT |
Correlation
The DT_CORRELATION is used to perform a correlation on loaded STDO events.
Scoring
STDO_SCORING is used to perform the scoring of OSTDO events. This has the
following sub-process:
- Oracle Behavior Detection Event Scoring
- Oracle Behavior Detection Entity Scoring
- Oracle Behavior Detection Correlation Scoring
- Oracle Behavior Detection Pre-Case Scoring
Promote to Case
STDO_Promote_To_Case_Decision is used to decide if an OSTDO correlation can be promoted to a case. This is based on the defined threshold limit and has the Pre Case Promotion Rule sub-process.
Create Case
STDO_Create_Case is used to create a case if an OSTDO event is promoted to the case.
Oracle Behavior Detection Generate Cases and below is the list of T2T
tasks for STDO application:
- f_generatecaseid
- f_insertcases
- t2t_KDD_CASE_ACCOUNTS
- t2t_KDD_CASE_CUSTOMERS
- t2t_KDD_CASE_DERIVED_ADDRESS
- t2t_KDD_CASE_EMPLOYEES
- t2t_KDD_CASE_ACCOUNT_ADDRESS
- t2t_KDD_CASE_ACCOUNT_MANAGED
- t2t_KDD_CASE_ACCOUNT_RSTRNS
- t2t_KDD_CASE_ACCT_BAL_POSN_SMRY
- t2t_KDD_CASE_ACCT_EMAIL_ADDR
- t2t_KDD_CASE_ACCT_PEER_GRP
- t2t_KDD_CASE_ACCT_PHON
- t2t_KDD_CASE_ACCT_SMRY_MNTH
- t2t_KDD_CASE_ACCT_SUPPL_ATTR
- t2t_KDD_CASE_ACT_PEER_TRXN_SMRY
- t2t_KDD_CASE_ACCT_NTCPTRY_PRFL
- t2t_FCC_CASE_ACCT_LIST_MBRSP
- t2t_KDD_CASE_CLIENT_BANK
- t2t_KDD_CASE_CLIENT_BANK_SMRY_MNTH
- t2t_KDD_CASE_CUST_ADDR
- t2t_KDD_CASE_CUST_EMAIL_ADDRS
- t2t_KDD_CASE_CUST_LIST_MEMBERSHIP
- t2t_KDD_CASE_CUST_PHONE
- t2t_KDD_CASE_CUST_SUPPL_ATTR
- t2t_KDD_CASE_CUST_SMRY_MNTH
- t2t_KDD_CASE_EMP_ACCT
- t2t_KDD_CASE_EMP_ADDR
- t2t_KDD_CASE_EMP_EMAIL_ADDR
- t2t_KDD_CASE_EMP_PHONE
- t2t_KDD_CASE_INSTL_ACCT_SMRY_MNTH
- t2t_KDD_CASE_INSTN_MASTER
- t2t_KDD_CASE_INSURANCE_POLICY
- t2t_KDD_CASE_INSURANCE_PRODUCT
- t2t_KDD_CASE_NTWK_USER_ACCT_MAP
- t2t_KDD_CASE_ONLINE_ACCT
- t2t_KDD_CASE_ONLINE_ACCT_ACCT
- t2t_KDD_CASE_PEER_GRP
- t2t_KDD_CASE_CB_LIST_MEMBERSHIP
- t2t_KDD_CASE_CB_PEER_TXN_SMRY_MNTH
- t2t_KDD_CASE_CLIENT_BANK_PEER_GRP
- t2t_KDD_CASE_EXTERNAL_ENTITY
- t2t_KDD_CASE_EXTERNAL_ENTITY_MEMBERSHIP
- t2t_KDD_CASE_HH_ACCT_BAL_SMRY
- t2t_KDD_CASE_HH_SMRY_MNTH
- t2t_KDD_CASE_INSURANCE_PLCY_CUST
- t2t_KDD_CASE_NVSMT_MGR_SMRY_MNTH
- t2t_KDD_CASE_NVSMT_MGR
- t2t_KDD_CASE_ACCT_ID_INSTN_ID_MAP
- t2t_KDD_CASE_ACCT_GRP
- t2t_KDD_CASE_WIRE_TRXN
- t2t_KDD_CASE_CASH_TRXN
- t2t_KDD_CASE_DERIVED_ADDRESS_CASH_TRXN
- t2t_KDD_CASE_DERIVED_ADDRESS_MI_TRXN
- t2t_KDD_CASE_DERIVED_ADDRESS_WIRE_TRXN
- t2t_KDD_CASE_BACK_OFFICE_TRXN
- t2t_KDD_CASE_CUST_IMP_LICENSE_GOODS
- t2t_KDD_CASE_CUST_IMP_LICENSE
- t2t_KDD_CASE_DOC_COLL_CNTRCT
- t2t_KDD_CASE_DOC_COLL_CNTRCT_EVENT
- t2t_KDD_CASE_DOC_COLL_DISCRP_DTL
- t2t_KDD_CASE_DOC_COLL_INVOICE
- t2t_KDD_CASE_DOC_COLL_MULTNR_DTL
- t2t_KDD_CASE_DOC_COLL_SHPMT_DTL
- t2t_KDD_CASE_EXTERNAL_INSURANCE_PLCY
- t2t_KDD_CASE_EXTERNAL_ORG
- t2t_KDD_CASE_TRADE_FIN_SWIFT_MSG
- t2t_KDD_CASE_TRADE_FIN_PARTY
- t2t_KDD_CASE_TRADE_FIN_GOOD_SRVC
- t2t_KDD_CASE_TRADE_FIN_DRAFT
- t2t_KDD_CASE_TRADE_FIN_DOC
- t2t_KDD_CASE_TRADE_FIN_CNTRCT
- t2t_KDD_CASE_TRADE_FIN_BRKRGE_DIST
- t2t_KDD_CASE_TRADE_FIN_BRKRGE
- t2t_KDD_CASE_TRADE_FIN_ACCT
- t2t_KDD_CASE_TRADE
- t2t_KDD_CASE_ORDER
- t2t_KDD_CASE_MI_TRXN
- t2t_KDD_CASE_LOAN_ACCOUNT
- t2t_KDD_CASE_LOAN
- t2t_KDD_CASE_LOAN_SMRY_MONTH
- t2t_KDD_CASE_INSTRUCTION
- CASE_COMPLETION_FLAG
- CASE_ASSIGNMENT
End Batch
STDO_ECM_End_E2E_Batch is used for ending the batch execution for Studio.