DFCSIngestion_Weekly Batch Details

The DFCSIngestion_Weekly batch must be run with the DFCSIngestion_Daily batch for all implementations that are running the Networks of Accounts and Entities and Customers scenario. This batch replaces the Ingestion batch for these implementations.

Note:

ATTENTION: This batch is only required if your implementation is using the Networks of Accounts and Entities and Customers scenario pipeline. If you are not implementing this new scenario, you can continue to use your current Ingestion batch.

Note:

This batch must be executed AFTER the StageDataLoad and StageDataQuality batches have successfully completed without errors. This batch must be run before the TMScenario batch.

This batch loads the data from the staging tables to the business tables in the specified order. The loading process receives, transforms, and loads Market, Business, and Reference data that is required for event detection, and runs all DFCSIngestion batch tasks, the tasks for Network of Accounts Rules, and the Link Analysis task.

The default lookback period is set to seven (7) days.

The following table provides the tasks that are configured for the DFCSIngestion_Weekly batch. These tasks must be executed in the following order:

Table 20-18 DFCSIngestion_Weekly Batch Details

Sequence	Tasks for DFCSIngestion_Weekly Batch	Jobs for DFCSIngestion_Weekly Batch	Pipelines for DFCSIngestion_Weekly Batch
1	StartBatch	Not Applicable	Not Applicable
2	ACCTTRXNINT	Load Intermediate Account and Transaction Data DFCS	Load Intermediate Account and Transaction Data DFCS
3	WatchList	Load and Prepare Watchlists	Load and Prepare Watchlists
4	Customer	Load Customer Data DFCS	Load Customer Data DFCS
5	LoadCustomerAddition	Load Customer Addition	Load Customer Addition
6	CustomerAddData	Load Customer Add On Data DFCS	Load Customer Add On Data DFCS
7	AnticipatoryProfile	Load Customer Anticipatory Profile Data DFCS	Load Customer Anticipatory Profile Data DFCS
8	Account	Load Account Data DFCS	Load Account Data DFCS
9	AccountGroup	Load Account Group Data	Load Account Group Data
10	AccountAddData	Load Additional Account Data DFCS	Load Additional Account Data DFCS
11	AcctAnticipatoryProfile	Load Account Anticipatory Profile Data DFCS	Load Account Anticipatory Profile Data DFCS
12	CustMapData	Load Customer Mapping Data DFCS	Load Customer Mapping Data DFCS
13	SupplyInfo	Derive Risk and Load Supplementary Information	Derive Risk and Load Supplementary Information
14	Transaction	Load Transaction and Transaction Party Data DFCS	Load Transaction and Transaction Party Data DFCS
15	RiskDerivation	Derive External Entities and Risk DFCS	Derive External Entities and Risk DFCS
16	TrustedPair	Load Trusted Pair Data	Load Trusted Pair Data
17	LoanData	Load Loan Data DFCS	Load Loan Data DFCS
18	InsuranceData	Load Insurance Data	Load Insurance Data
19	ConductorData	Load Conductor Data	Load Conductor Data
20	LocationData	Load Location Data	Load Location Data
21	Deal	Load Deal and Investment Advisor Data	Load Deal and Investment Advisor Data
22	ManagedAccount	Load Managed Account Data	Load Managed Account Data
23	CorporateAction	Load Corporate Action and Settlement Instruction Data	Load Corporate Action and Settlement Instruction Data
24	LoadMarketCenterData	Load Market Center Data	Load Market Center Data
25	LoadSecurityData	Load Security and Security Market Daily Data	Load Security and Security Market Daily Data
26	TradeExecutionEventStage	Load Trade Execution Event Data	Load Trade Execution Event Data
27	OrderStage	Load Order Stage Data	Load Order Stage Data
28	InsideQuote	Load Inside Quote Data	Load Inside Quote Data
29	TradeExecutionEvent	Load Execution and Trade Data	Load Execution and Trade Data
30	NT_ACCTEMAIL	Derive Network for NoA Rules	Derive Network for NoA Rules
31	NT_ACCTPHONE	Derive Network for NoA Rules	Derive Network for NoA Rules
32	NT_ACCTADDR	Derive Network for NoA Rules	Derive Network for NoA Rules
33	NT_ACCTTAXID	Derive Network for NoA Rules	Derive Network for NoA Rules
34	NT_CUACADDR	Derive Network for NoA Rules	Derive Network for NoA Rules
35	NT_CUACEMAIL	Derive Network for NoA Rules	Derive Network for NoA Rules
36	NT_CUACTAXID	Derive Network for NoA Rules	Derive Network for NoA Rules
37	NT_CUACPHONE	Derive Network for NoA Rules	Derive Network for NoA Rules
38	NT_WIRETRXN	Derive Network for NoA Rules	Derive Network for NoA Rules
39	NT_WIREACORIG	Derive Network for NoA Rules	Derive Network for NoA Rules
40	NT_WIREACBENE	Derive Network for NoA Rules	Derive Network for NoA Rules
41	NT_JRNL	Derive Network for NoA Rules	Derive Network for NoA Rules
42	NoA	Derive Network of Account	Derive Network of Account
43	CleanAMTempTables	CleanAMTempTables	Not Applicable
44	EndBatch	Not Applicable	Not Applicable