D.1 CSA Ingestion

This section refers to Common Staging Area (CSA) ingestion and covers the following topics:

CSA Datamaps

The following list of files can be run using Common Area Staging. Files have been grouped in such a way that files in the same group can be executed in parallel to load data. However, you must execute Group 1 through Group 6 in sequence.

Note:

You must run the Country and Customer data files before you run the other files.

Table D-1 CSA Datamaps

Group LogicalTable Name -
10 .Country Customer
11

.Account Phone Watch List

Account Email Address

Front Office Transaction

Account Customer Role Organization

Customer Credit Rating

Customer Identification Document
12 .Customer
13

.Account

WatchList Entry

 Front Office Transaction Party
14

.Account To Customer Account Balance Account Address

Customer To Markets Served Customer To Products Offered Customer To Customer Relationship

 Customer Phone Customer Email Address Customer Country Customer Address Controlling Customer
15

.Borrower

Account Restriction

Back Office Transaction

Investment Advisor Settlement Instruction

Loan Origination Document Print Log

List of Data Quality Group, T2T and H2T Names

Table D-2 Data Quality Group Names and Related T2T Names

Interface File Name Data Quality GroupName CorrespondingT2T Name CorrespondingH2T Name
Account ACCT
  • t2t_Account.STG_CASA
  • t2t_Account.STG_CORRESPOND ENT_ACCOUNT

Some clients chose to include the following product processors, but they are not mandatory for running Trade Finance.

  • t2t_Account.STG_ANNUITY_CO NTRACTS
  • t2t_Account.STG_CARDS
  • t2t_Account.STG_MERCHANT_C ARDS
  • t2t_Account.STG_MM_CONTRA CTS
  • t2t_Account.STG_OD_ACCOUNT S
  • t2t_Account.STG_REPO_CONTR ACTS
  • t2t_Account.STG_RETIREMENT_ ACCOUNTS
  • t2t_Account.STG_SWAPS_CONT RACTS
  • t2t_Account.STG_TD_CONTRAC TS
  • t2t_Account.STG_TRADING_ACC OUNT
  • t2t_Account.STG_TRUSTS
  • t2t_Account.STG_LEASES_CONT RACTS
  • t2t_Account.STG_LOAN_CONTR ACTS
  • h2t_Account.STG_CASA
  • h2t_Account.STG_CORRESPOND ENT_ACCOUNT

Some clients chose to include the following product processors, but they are not mandatory for running Trade Finance.

  • h2t_Account.STG_ANNUITY_CO NTRACTS
  • h2t_Account.STG_CARDS
  • h2t_Account.STG_MERCHANT_ CARDS
  • h2t_Account.STG_MM_CONTRA CTS
  • h2t_Account.STG_OD_ACCOUN TS
  • h2t_Account.STG_REPO_CONTR ACTS
  • h2t_Account.STG_RETIREMENT

_ACCOUNTS

  • h2t_Account.STG_SWAPS_CONT RACTS
  • h2t_Account.STG_TD_CONTRAC TS
  • h2t_Account.STG_TRADING_AC COUNT
  • h2t_Account.STG_TRUSTS
  • h2t_Account.STG_LEASES_CON TRACTS
  • h2t_Account.STG_LOAN_CONTR ACTS
Account Address ACCT_ADDR
  • t2t_AccountAddress
  • h2t_AccountAddress
Account Balance ACCT_BAL_ POSN_SMR Y
  • t2t_AccountBalance.STG_ANNUI TY_CONTRACTS
  • t2t_AccountBalance.STG_CARDS
  • t2t_AccountBalance.STG_CASA
  • t2t_AccountBalance.STG_INVES TMENTS
  • t2t_AccountBalance.STG_LEASE S_CONTRACTS
  • t2t_AccountBalance.STG_LOAN_ CONTRACTS
  • t2t_AccountBalance.STG_OD_AC COUNTS
  • t2t_AccountBalance.STG_RETIRE MENT_ACCOUNTS
  • t2t_AccountBalance.STG_TD_CO NTRACTS
  • t2t_AccountBalance.STG_TRADI NG_ACCOUNT
  • t2t_AccountBalance.STG_TRUST S
  • h2t_AccountBalance.STG_ANNU ITY_CONTRACTS
  • h2t_AccountBalance.STG_CARD S
  • h2t_AccountBalance.STG_CASA
  • h2t_AccountBalance.STG_INVES TMENTS
  • h2t_AccountBalance.STG_LEASE S_CONTRACTS
  • h2t_AccountBalance.STG_LOAN

_CONTRACTS

  • h2t_AccountBalance.STG_OD_A CCOUNTS
  • h2t_AccountBalance.STG_RETIR EMENT_ACCOUNTS
  • h2t_AccountBalance.STG_TD_C ONTRACTS
  • h2t_AccountBalance.STG_TRADI NG_ACCOUNT
  • h2t_AccountBalance.STG_TRUS TS
Account Customer Role

CUST_ACCT

_ROLE

 t2t_AccountCustomerRole h2t_AccountCustomerRole
Account Email Address ACCT_EMAI L_ADDR t2t_AccountEmailAddress h2t_AccountEmailAddress
Account Phone ACCT_PHO N t2t_AccountPhone h2t_AccountPhone
Account to Customer CUST_ACCT t2t_AccountToCustomer h2t_AccountToCustomer
Back Office Transaction BACK_OFFIC E_TRXN
  • t2t_BackOfficeTransaction.STG_ CASA_TXNS
  • t2t_BackOfficeTransaction.STG_ CORRESPONDENT_ACCT_TX NS

Some clients chose to include the following product processors, but they are not mandatory for running Trade Finance.

  • t2t_BackOfficeTransaction.STG_ CARDS_PAYMENT_TXNS
  • t2t_BackOfficeTransaction.STG_ SWAP_ACCOUNT_TXNS
  • t2t_BackOfficeTransaction.STG_ TERMDEPOSITS_TXNS
  • t2t_BackOfficeTransaction.STG_ TRADING_ACCOUNT_TXNS
  • t2t_BackOfficeTransaction.STG_ TRUSTS_TXNS
  • t2t_BackOfficeTransaction.STG_ ANNUITY_TXNS
  • t2t_BackOfficeTransaction.STG_ LEASES_TXNS
  • t2t_BackOfficeTransaction.STG_ LOAN_CONTRACT_TXNS
  • t2t_BackOfficeTransaction.STG_ MERCHANT_CARDS_TXNS
  • t2t_BackOfficeTransaction.STG_ MM_TXNS
  • t2t_BackOfficeTransaction.STG_ OD_ACCOUNTS_TXNS
  • t2t_BackOfficeTransaction.STG_ REPO_TRANSACTIONS
  • t2t_BackOfficeTransaction.STG_ RETIREMENT_ACCOUNTS_T XNS
  • h2t_BackOfficeTransaction.STG_ CASA_TXNS
  • h2t_BackOfficeTransaction.STG_ CORRESPONDENT_ACCT_TX NS

Some clients chose to include the following product processors, but they are not mandatory for running Trade Finance.

  • h2t_BackOfficeTransaction.STG_ CARDS_PAYMENT_TXNS
  • h2t_BackOfficeTransaction.STG_ SWAP_ACCOUNT_TXNS
  • h2t_BackOfficeTransaction.STG_ TERMDEPOSITS_TXNS
  • h2t_BackOfficeTransaction.STG_ TRADING_ACCOUNT_TXNS
  • h2t_BackOfficeTransaction.STG_ TRUSTS_TXNS
  • h2t_BackOfficeTransaction.STG_ ANNUITY_TXNS
  • h2t_BackOfficeTransaction.STG_ LEASES_TXNS
  • h2t_BackOfficeTransaction.STG_ LOAN_CONTRACT_TXNS
  • h2t_BackOfficeTransaction.STG_ MERCHANT_CARDS_TXNS
  • h2t_BackOfficeTransaction.STG_ MM_TXNS
  • h2t_BackOfficeTransaction.STG_ OD_ACCOUNTS_TXNS
  • h2t_BackOfficeTransaction.STG_ REPO_TRANSACTIONS
  • h2t_BackOfficeTransaction.STG_ RETIREMENT_ACCOUNTS_T XNS
Country GEOGRAPH Y t2t_Country.STG_COUNTRY_MASTER h2t_Country.STG_COUNTRY_MASTER
Country Trade List - t2t_CountryTradeList.STG_COUNTRY_ TRADE_MAP

h2t_CountryTradeList.STG_COUNTRY

_TRADE_MAP
Customer CUST t2t_Customer.STG_PARTY_MASTER h2t_Customer.STG_PARTY_MASTER
Customer Address CUST_ADDR t2t_CustomerAddress h2t_CustomerAddress
Customer Country CUST_CNTR Y
  • t2t_CustomerCountry
  • t2t_CustomerCreditRating
  • h2t_CustomerCountry
  • h2t_CustomerCreditRating
Customer E- mail Address CUST_EMAI L_ADDR t2t_CustomerEmailAddress h2t_CustomerEmailAddress
Customer Identification Document CUST_ID_D OC t2t_CustomerIdentificationDocument h2t_CustomerIdentificationDocument
Customer Phone CUST_PHO N t2t_CustomerPhone h2t_CustomerPhone
Customer to Customer Relationship CUST_CUST t2t_CustomerToCustomerRelationship h2t_CustomerToCustomerRelationshi p
Documentary Collection Contract Acceptance Stage - t2t_DocumentaryCollectionContractAc ceptanceStage.STG_DOC_COLLCTN_C NTRCT_ACC h2t_DocumentaryCollectionContractA cceptanceStage.STG_DOC_COLLCTN_ CNTRCT_ACC
Documentary Collection Contract Acknowledgment Stage - t2t_DocCollectionContractAcknowlege mentStage.STG_DOC_COLLCTN_CNT RCT_ACK h2t_DocCollectionContractAcknowleg ementStage.STG_DOC_COLLCTN_CN TRCT_ACK
Documentary Collection Discrepancy Detail -

t2t_DocumentaryCollectionDiscrepanc yDetail.STG_DOC_COLLCTN_DISCPNT

_DTL

 h2t_DocumentaryCollectionDiscrepan cyDetail.STG_DOC_COLLCTN_DISCPN T_DTL
Documentary Collection Contract Event - t2t_DocumentaryCollectionContractEv ent.STG_DOC_COLLCTN_CNTRCT_EV ENT h2t_DocumentaryCollectionContractE vent.STG_DOC_COLLCTN_CNTRCT_E VENT
External Party Stage - t2t_ExternalPartyStage.STG_PARTY_M ASTER h2t_ExternalPartyStage.STG_PARTY_ MASTER
Front Office Transaction FO_TRXN_S TAGE
  • t2t_FrontOfficeTransaction.STG_ CASA_TXNS
  • t2t_FrontOfficeTransaction.STG_ CORRESPONDENT_ACCT_TX NS

Some clients chose to include the following product processors, but they are not mandatory for running Trade Finance.

  • t2t_FrontOfficeTransaction.STG_ ANNUITY_TXNS
  • t2t_FrontOfficeTransaction.STG_ CARDS_PAYMENT_TXNS
  • t2t_FrontOfficeTransaction.STG_ LEASES_TXNS
  • t2t_FrontOfficeTransaction.STG_ LOAN_CONTRACT_TXNS
  • t2t_FrontOfficeTransaction.STG_ MERCHANT_CARDS_TXNS
  • tt2t_FrontOfficeTransaction.STG

_MM_TXNS

  • t2t_FrontOfficeTransaction.STG_ OD_ACCOUNTS_TXNS
  • t2t_FrontOfficeTransaction.STG_ REPO_TRANSACTIONS
  • t2t_FrontOfficeTransaction.STG_ RETIREMENT_ACCOUNTS_T XNS
  • t2t_FrontOfficeTransaction.STG_ SWAP_ACCOUNT_TXNS
  • t2t_FrontOfficeTransaction.STG_ TERMDEPOSITS_TXNS
  • t2t_FrontOfficeTransaction.STG_ TRADING_ACCOUNT_TXNS
  • t2t_FrontOfficeTransaction.STG_ TRUSTS_TXNS
  • h2t_FrontOfficeTransaction.STG

_CASA_TXNS

  • h2t_FrontOfficeTransaction.STG

_CORRESPONDENT_ACCT_T XNS

Some clients chose to include the following product processors, but they are not mandatory for running Trade Finance.

  • h2t_FrontOfficeTransaction.STG

_ANNUITY_TXNS

  • h2t_FrontOfficeTransaction.STG

_CARDS_PAYMENT_TXNS

  • h2t_FrontOfficeTransaction.STG

_LEASES_TXNS

  • h2t_FrontOfficeTransaction.STG

_LOAN_CONTRACT_TXNS

  • h2t_FrontOfficeTransaction.STG

_MERCHANT_CARDS_TXNS

  • h2t_FrontOfficeTransaction.STG

_MM_TXNS

  • h2t_FrontOfficeTransaction.STG

_OD_ACCOUNTS_TXNS

  • h2t_FrontOfficeTransaction.STG

_REPO_TRANSACTIONS

  • h2t_FrontOfficeTransaction.STG

_RETIREMENT_ACCOUNTS_ TXNS

  • h2t_FrontOfficeTransaction.STG

_SWAP_ACCOUNT_TXNS

  • h2t_FrontOfficeTransaction.STG

_TERMDEPOSITS_TXNS

  • h2t_FrontOfficeTransaction.STG

_TRADING_ACCOUNT_TXNS

  • h2t_FrontOfficeTransaction.STG

_TRUSTS_TXNS
Front Office Transaction Party FO_TRXN_P ARTY_STAG E t2t_FrontOfficeTransactionParty h2t_FrontOfficeTransactionParty
Goods or Service - t2t_GoodsorService.STG_TRADE_FIN_ GOODS_MASTER h2t_GoodsorService.STG_TRADE_FIN_ GOODS_MASTER
Party Identification Document - t2t_PartyIdentificationDocument.STG_ CUSTOMER_IDENTIFCTN_DOC

h2t_PartyIdentificationDocument.STG

_CUSTOMER_IDENTIFCTN_DOC
Party to Party Relationship - t2t_PartytoPartyRelationship.STG_PAR TY_PARTY_RELATIONSHIP h2t_PartytoPartyRelationship.STG_PA RTY_PARTY_RELATIONSHIP
Trade Finance Contract Event Acknowledgment Stage - t2t_TradeFinanceContractEventAckno wledgementStage.STG_TRD_FIN_CNT RCT_EVENT_ACK h2t_TradeFinanceContractEventAckno wledgementStage.STG_TRD_FIN_CNT RCT_EVENT_ACK
Trade Finance Contract Amendment Status Stage - t2t_TradeFinanceContractAmendment StatusStage.STG_TRD_FIN_CNTRCT_ AMD_STATUS h2t_TradeFinanceContractAmendmen tStatusStage.STG_TRD_FIN_CNTRCT_ AMD_STATUS
Trade Finance Contract Event - t2t_TradeFinanceContractEvent.STG_ TRADE_FIN_CNTRCT_EVENT h2t_TradeFinanceContractEvent.STG_ TRADE_FIN_CNTRCT_EVENT
Trade Finance Document - t2t_TradeFinanceDocument.STG_TRA DE_FINANCE_DOCUMENT h2t_TradeFinanceDocument.STG_TRA DE_FINANCE_DOCUMENT
Trade Finance Good or Service - t2t_TradeFinanceGoodorService.STG_ TRADE_FINANCE_GOODS h2t_TradeFinanceGoodorService.STG_ TRADE_FINANCE_GOODS
Trade Finance Party - t2t_TradeFinanceParty.STG_TRADE_FI NANCE_PARTY_EVENT h2t_TradeFinanceParty.STG_TRADE_F INANCE_PARTY_EVENT
Trade Finance to Account - t2t_TradeFinancetoAccount.STG_TRA DE_FINANCE_ACCT h2t_TradeFinancetoAccount.STG_TRA DE_FINANCE_ACCT
WatchList WATCH_LIS T_SOURCE t2t_WatchList h2t_WatchList
WatchList Entry WATCH_LIS T t2t_WatchListEntry h2t_WatchListEntry

Group Dependencies

Processing data in Group1 requires no prerequisite information (dependencies) for Pre-processing. Groups 2-5, however, rely on successful pre-processing of the previous group to satisfy any dependencies. For example, the Ingestion Manager does not run Group 4 until processing of data in Group 3 completes successfully.

Processing bases the dependencies that determine grouping on the referential relationships within the data. If the Oracle client chooses not to perform referential integrity checking, grouping is not required (except in some instances). In this case, a need still exists to process some reference data files prior to processing trading data.