30.2 Overview of the Other Results Population
Table to Table seeded definitions are provided for loading data into the target Fact tables.
Table 30-1 Other Result T2T Definitions
| Source Table Name | Target Table Name | T2T Name |
|---|---|---|
| STG_ASSETS_SOLD | FCT_ACCOUNT_POSTION_PAIR | T2T_FCT_ASSETS_SOLD |
| STG_ENTITY_PARENT_DETAILS | FCT_ENTITY_PARENT_INFO | T2T_FCT_ENTITY_PARENT_INFO |
| STG_ISSUED_INSTR_POSITIONS | FCT_ISSUED_INSTR_POSITIONS | T2T_FCT_ISSUED_INSTR_POSITIONS |
| STG_CUSTOMER_IDENTIF CTN_DOC | FCT_CUST_IDENTIFICATI ON_DOC | T2T_FCT_CUST_IDENTIFICATION_DOC |
| FCT_COMMON_ACCOUNT_SUMMARY | FCT_INTRA_COMPANY_ACCT_SUMMARY | T2T_FCT_INTRA_COMPANY_ACCT_SUMMARY |
| STG_LOANS_SERVICED | FCT_ACCT_RECOVERY_DETAILS | T2T_FCT_LOANS_SERVICED |
| STG_FIXED_ASSETS_DETAILS | FCT_ACCT_WRITE_OFF_DETAILS | T2T_FCT_FIXED_ASSETS |
| STG_CREDIT_LINE_DETAILS | FCT_ASSETS_SOLD | T2T_FCT_CREDIT_LINE |
| STG_LEGAL_ENTITY_DETAILS | FCT_CAP_INSTR_POSITIONS | T2T_FCT_LEGAL_ENTITY_DETAILS |
| STG_CAP_INSTR_POSITIONS | FFCT_CAP_INSTR_TXNS | T2T_FCT_CAP_INSTR_POSITIONS |
| STG_CAP_INSTR_TXNS | FCT_CAP_INSTR_TXNS | T2T_FCT_CAP_INSTR_TXNS |
| STG_FUND_CIS_COMPOSITION | FCT_FUND_CIS_COMPOSITION | T2T_FCT_FUND_CIS_COMPOSITION |
| STG_MERCHANT_BANKING | FCT_MERCHANT_BANKING | T2T_FCT_MERCHANT_BANKING |
| STG_SPEND_OBLIGATIONS | FCT_SPEND_OBLIGATIONS | T2T_FCT_SPEND_OBLIGATIONS |
| STG_ACCT_WRITE_OFF_DETAILS | FCT_ACCT_WRITE_OFF_DETAILS | T2T_FCT_ACCT_WRITE_OFF_DETAILS |
| STG_RECOVERIES | FCT_ACCT_RECOVERY_DETAILS | T2T_FCT_ACCT_RECOVERY_DETAILS |
| STG_ACCT_RECOVERY_DETAILS | FCT_RECOVERY | T2T_FCT_RECOVERY |
| STG_INSTR_PROPOSED_TXNS | FCT_INSTR_PROPOSED_TXNS | T2T_FCT_INSTR_PROPOSED_TXNS |
| STG_LITIGATION_DETAILS | FCT_LITIGATION_DETAILS | T2T_FCT_LITIGATION_DETAILS |
| STG_SERV_LN_CUST_RELATIONSHIP | FCT_SERV_LN_CUST_RELATIONSHIP | T2T_FCT_SERV_LN_CUST_RELATIONSHIP |
| STG_PARTY_ACCOUNT_ROLE_MAP | FCT_ACCT_CUST_RELATIONSHIP | T2T_FACR_STG_PARTY_ACCOUNT_ROLE_MAP |
| STG_ASSETS_SOLD | FCT_ACCOUNT_POSTION_PAIR | T2T_FCT_ASSETS_SOLD |
| STG_ENTITY_PARENT_DETAILS | FCT_ENTITY_PARENT_INFO | T2T_FCT_ENTITY_PARENT_INFO |
| STG_ISSUED_INSTR_POSITIONS | FCT_ISSUED_INSTR_POSITIONS | T2T_FCT_ISSUED_INSTR_POSITIONS |
| STG_CUSTOMER_IDENTIFCTN_DOC | FCT_CUST_IDENTIFICATION_DOC | T2T_FCT_CUST_IDENTIFICATION_DOC |
| FCT_COMMON_ACCOUNT_SUMMARY | FCT_INTRA_COMPANY_ACCT_SUMMARY | T2T_FCT_INTRA_COMPANY_ACCT_SUMMARY |
| STG_LOANS_SERVICED | FCT_ACCT_RECOVERY_DETAILS | T2T_FCT_LOANS_SERVICED |
| STG_FIXED_ASSETS_DETAILS | FCT_ACCT_WRITE_OFF_DETAILS | T2T_FCT_FIXED_ASSETS |
| STG_CREDIT_LINE_DETAILS | FCT_ASSETS_SOLD | T2T_FCT_CREDIT_LINE |
| STG_LEGAL_ENTITY_DETAILS | FCT_CAP_INSTR_POSITIONS | T2T_FCT_LEGAL_ENTITY_DETAILS |
| STG_CAP_INSTR_POSITIO NS | FFCT_CAP_INSTR_TXNS | T2T_FCT_CAP_INSTR_POSITIONS |
| STG_CAP_INSTR_TXNS | FCT_CAP_INSTR_TXNS | T2T_FCT_CAP_INSTR_TXNS |
| STG_FUND_CIS_COMPOSITION | FCT_FUND_CIS_COMPOSITION | T2T_FCT_FUND_CIS_COMPOSITION |
| STG_MERCHANT_BANKING | FCT_MERCHANT_BANKING | T2T_FCT_MERCHANT_BANKING |
| STG_SPEND_OBLIGATIONS | FCT_SPEND_OBLIGATIONS | T2T_FCT_SPEND_OBLIG ATIONS |
| STG_ACCT_WRITE_OFF_DETAILS | FCT_ACCT_WRITE_OFF_DETAILS | T2T_FCT_ACCT_WRITE_OFF_DETAILS |
| STG_RECOVERIES | FCT_ACCT_RECOVERY_DETAILS | T2T_FCT_ACCT_RECOVERY_DETAILS |
| STG_ACCT_RECOVERY_DETAILS | FCT_RECOVERY | T2T_FCT_RECOVERY |
| STG_INSTR_PROPOSED_TXNS | FCT_INSTR_PROPOSED_TXNS | T2T_FCT_INSTR_PROPOSED_TXNS |
| STG_LITIGATION_DETAILS | FCT_LITIGATION_DETAILS | T2T_FCT_LITIGATION_DETAILS |
| STG_SERV_LN_CUST_REL ATIONSHIP | FCT_SERV_LN_CUST_REL ATIONSHIP | T2T_FCT_SERV_LN_CUST_RELATIONSHIP |
| STG_PARTY_ACCOUNT_ROLE_MAP | FCT_ACCT_CUST_RELATIONSHIP | T2T_FACR_STG_PARTY_ACCOUNT_ROLE_MAP |
| STG_CORPORATE_ACTIONS | FCT_CORPORATE_ACTIONS | T2T_FCT_CORPORATE_ACTIONS |
| STG_TRADE_EXECUTION | FCT_TRADE_EXECUTION | T2T_FCT_TRADE_EXECUTION |
| STG_SECURITIZATION_POOL | FCT_SECURITIZATION_POOL | T2T_FCT_SECURITIZATI ON_POOL |
| STG_SHARE_HOLDING_DETAILS | FCT_SHARE_HOLDING_DETAILS | T2T_FCT_SHARE_HOLDING_DETAILS |
The Other Dimension Definition details are as follows.
Table 30-2 Other Dimension Table Definitions
| SCD Map Reference Number | Source Table Name | Dimension Table Name |
|---|---|---|
| 469 | STG_CREDIT_REASON_MASTER | DIM_CREDIT_REASON |
| 470 | STG_COMMODITY_GRADE_MASTER | DIM_COMMODITY_GRADE |
| 471 | STG_SUB_NETTING_AGREEMENT | DIM_SUB_NETTING_AGREEMENT |
| 472 | STG_LEGAL_PROCEDING_STS_MASTER | DIM_LEGAL_PROCEDING_STATUS |