6.2 Tables Used by the Account Summary Population T2T Process
There are separate T2T definitions configured for each instrument or stage t.able, which
are used to populate each of - FCT_COMMON_ACCOUNT_SUMMARY,
FCT_FTP_ACCOUNT_SUMMARY, FCT_ALM_ACCOUNT_SUMMARY, and
FCT_LOAN_COMMITMENTS.
Table 6-1 Seeded T2T Definitions
Definition Name | Source Table | Destination Table |
---|---|---|
T2T_STG_ANNUITY_CONTRACTS_CAS | STG_ANNUITY_ CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_BORROWINGS_CAS | STG_BORROWINGS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_CARDS_CAS | STG_CARDS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_CASA_CAS | STG_CASA | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_FX_CONTRACTS_CAS | STG_FX_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_GUARANTEES_CAS | STG_GUARANTEES | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_INVESTMENTS_CAS | STG_INVESTMENTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_LC_CAS | STG_LC_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_LEASES_CONTRACTS_CAS | STG_LEASES_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_LOANS_CAS | STG_LOAN_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_MM_CAS | STG_MM_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_OD_CAS | STG_OD_ACCOUNTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_OPTIONS_CAS | STG_OPTION_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_RETIREMENT_ACCOUNTS_CAS | STG_RETIREMENT_ACCOUNTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_TD_CONTRACTS_CAS | STG_TD_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_FUTURES_CAS | STG_FUTURES | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_STG_SWAPS_CONTRACTS_CAS | STG_SWAPS_CONTRACTS | FCT_COMMON_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__ANNUITY | FSI_D_ANNUITY_CONTRACTS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__BORROWINGS | FSI_D_BORROWINGS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__BREAK_FUNDING | FSI_D_BREAK_FUNDING_CHARGES | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__CASA | FSI_D_CASA | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__CREDIT_LINES | FSI_D_CREDIT_LINES | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__CREDITCARDS | FSI_D_CREDIT_CARDS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT_TDEPOSITS | FSI_D_TERM_DEPOSITS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__FORWARDS | FSI_D_FORWARD_RATE_AGMTS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__FUTURES | FSI_D_FUTURES | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__FX_CONTRACTS | FSI_D_FX_CONTRACTS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__GUARANTEES | FSI_D_GUARANTEES | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUN T__INVESTMENTS |
FSI_D_INVESTMENTS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUN T__LEASES |
FSI_D_LEASES | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__LEDGER_STAT | FSI_D_LEDGER_STAT_INSTRUMENT | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__LOANS | FSI_D_LOAN_CONTRACTS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__MM_CONTRACTS | FSI_D_MM_CONTRACTS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__MORTGAGE_BACK_SEC | FSI_D_MORTGAGE_BACK_SEC | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__MORTGAGES | FSI_D_MORTGAGES | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__OPTIONS | FSI_D_OPTIONS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__RETIREMENT | FSI_D_RETIREMENT_ACCOUNTS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__SWAPS | FSI_D_SWAPS | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__ANNUITY | FSI_D_ANNUITY_CONTRACTS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__ANNUITY | FSI_D_ANNUITY_CONTRACTS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__BORROWINGS | FSI_D_BORROWINGS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__CASA | FSI_D_CASA | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__CREDIT_LINES | FSI_D_CREDIT_LINES | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__CREDITCARDS | FSI_D_CREDIT_CARDS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT_TDEPOSITS | FSI_D_TERM_DEPOSITS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT_FORWARDS | FSI_D_FORWARD_RATE_AGMTS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__GUARANTEES | FSI_D_GUARANTEES | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__INVESTMENTS | FSI_D_INVESTMENTS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_ALM_ACCOUNT__LEASES | FSI_D_LEASES | FCT_ALM_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__LOANS | FSI_D_LOAN_CONTRACTS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT_MM_CONTRACTS | FSI_D_MM_CONTRACTS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT__MORTGAGES | FSI_D_MORTGAGES | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT_RETIREMENT | FSI_D_RETIREMENT_ACCOUNTS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT_SWAPS | FSI_D_SWAPS | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_ACCOUNT_BREAK_FUNDING | FSI_D_BREAK_FUNDING_CHARGES | FCT_FTP_ACCOUNT_SUMMARY |
T2T_FCT_FTP_LOAN_COMMITMENTS | FSI_D_LOAN_COMMITMENTS | FCT_LOAN_COMMITMENTS |