3        OFSDF Application Pack Release Notes v8.1.2.0.0

External Engine

This is a Process created to source the OFSAA External Engine Data into OFSDF in the absence of OFSAA Applications. The Interface Tables are created to source the External Engine Outputs as POI (Processing Output Integration) Tables and related Metadata (T2Ts) to handle all the ETL Activities and load the Data into the Application-specific Result Tables in OFSDF. As a result, the necessity to rebuild the OFSAA-specific complex Data Transformation Logics, constant maintenances, and the data anomalies during the Currency Conversion Process are eliminated.

33123797

Sourcing Account Balances

When you have to add a new Amount or Balance related Column in the Stage Tables and those Columns are not available in the Stage Product Processing Tables, then you can add those Amount and Balance related Columns in the Stage Account Balances Table for dynamic sourcing. In the Account Balances Tables, the Balance Attributes are added as the Row-level Entries.

32886446

Sourcing Special Terms and Covenants

The Special Terms and Covenants are precautionary measures put in place to handle the financial risks.

The Special Terms and Covenants are a Formal Agreement or a Promise between two or more Parties that the specifically defined Actions will be or will not be carried out, or that if specific Conditions are met or if Terms are violated, then the corresponding Events or Actions are triggered.

32968876

33247411

OFSAA PARTY ROLES STANDARDIZATION - T2T METADATA CHANGES

Added the DIM_STD_PARTY_ROLE Table. Now, you can source the System Specific Values in the DIM_PARTY_ROLE Table.
Updated the Join Conditions in the following T2Ts, where the DIM_PARTY_ROLE Table is replaced with the DIM_STD_PARTY_ROLE Table:

·        T2T_FACR_STG_PARTY_ACCOUNT_ROLE_MAP

·        T2T_FCT_PARTY_ACCOUNT_ROLE_MAP

·        T2T_FCT_APPLN_PARTY_ROLE_MAP

·        T2T_FCT_PARTY_ROLE_MAP

·        T2T_FCT_SHARE_HOLDING_DETAILS

33123797

EXTERNAL ENGINE DATA LOADS

Created the following Tables to source the External Engine Data from the OFS IFRS, OFS LLFP, and OFS LRM Tables to OFSDF:

·        POI_IFRS_CREDIT_LINE_DETAILS

·        POI_IFRS_MITIGANTS_SUMMARY

·        POI_IFRS_PLACED_COLLATERAL

·        POI_LLFP_CRE_FACILITY_SUMMARY

·        POI_COHORT_LOAN_LOSS_DETAILS

·        POI_LRM_MITIGANTS_SUMMARY

·        POI_LRM_PLACED_COLLATERAL

Created a Process to source the External Engine Data in the absence of OFSAA Applications. As a part of the Process, created the following Metadata:

·        T2Ts T2T_FCT_IFRS_CREDIT_LINE_DETAILS, T2T_FCT_IFRS_MITIGANTS_SUMMARY, and T2T_FCT_IFRS_PLACED_COLLATERAL to source the External Engine Data for the OFSIFRS Application.

·        T2Ts T2T_FCT_LLFP_CRE_FACILITY_SUMMARY and T2T_FCT_COHORT_LOAN_LOSS_DETAILS to source the External Engine Data for the OFSLLFP Application.

·        T2Ts T2T_FCT_LRM_MITIGANTS_SUMMARY and T2T_FCT_LRM_PLACED_COLLATERAL to source the External Engine Data for the OFSLRM Application.

Created the FSDF_EXCHNG_RATE Sub Process in the EXTERNAL ENGINE RUN, which populates the Reporting Currecy (RCY) Columns of the Target Table.

32968876

RESULT TABLE FOR STG_SUBSTITUTABLE_COLLATERAL AND ENHANCEMENTS FOR ACCOUNTING ENTRIES, COVENANTS AND COLLATERAL SOURCE

Created the T2Ts T2T_FCT_SUBSTITUTABLE_COLLATERAL, T2T_FCT_PLACED_COLLAT_SRC_DTLS, and T2T_FCT_SPECIAL_TERMS_COVENANTS.
Created the SCD SCD-1010-DIM_SPECIAL_TERM-STG_SPECIAL_TERM_MASTER.

32906491

INTRODUCE ACCOUNT ACCOUNT RELATIONSHIP TABLE

All the relationships between two Accounts, such as the relationships usually held by a Common Customer or held under a Program, Interdependent Assets and Liabilities, Offset Account Relationship, and so on, are sourced and stored in the Account-Account Relationship Tables. The Tables store the Source System and the Source Code from where the Data is extracted for a defined Extraction Date, a Unique Identifier for each interdependent Program launched by the Bank, the Relationship Type Identification Code, and so on.
Created the T2T T2T_FCT_ACCT_ACCT_RELATIONSHIP to load the FCT_ACCT_ACCT_RELATIONSHIP Table from the STG_ACCT_ACCT_RELATIONSHIP Table. Added seven Column Mappings in the DIM_PROGRAM_MASTER Table.

32886446

NEW TABLE TO STORE ACCOUNT BALANCES

Created the following Entities to eliminate the dependency on the OFSDF Application related to adding the newly required Amount and Balance related Columns:

·        STG_ACCOUNT_BALANCES and FCT_ACCOUNT_BALANCES Tables with the new T2T T2T_FCT_ACCOUNT_BALANCES.

·        SCD 1001 with the STG_BALANCE_TYPE_MASTER and DIM_BALANCE_TYPE Tables.

·        Seeded Table DIM_STD_BALANCE_TYPE for the Reclassification Process.

Now, you can dynamically source the new Amount and Balance related Columns using the Stage Account Balances Table.

28407523

DATA MODEL EXTENSION: STAGE ACCOUNT DEVIATION TABLE, CORRESPONDING FACT AND DIME

Account Deviations are Legal Rules defined for the Regulatory Reporting System, where the Account Holder can report certain circumstances and as a result, there is no need to take the Action defined in the Legal Rules.
The Account Deviation Tables store the Deviation Rules and the Accounts that are impacted by those Deviation Rules.
Created the T2T T2T_FCT_ACCOUNT_DEVIATIONS and the SCD SCD-1009-DIM_ACCOUNT_DEVIATION-STG_ACCOUNT_DEVIATION_MASTER.

32409076

ENHANCE MAP HISTORY TABLES TO ACCOMODATE ALL MAP TABLE MEMBERS AND HISTORY LOAD T2T TO MOVE DATA TO NEW HIST MEMBER COLUMNS AS WELL

Added V_MEMBER_3 to V_MEMBER_9 in all the Map Tables and in all the Mapper History Tables in the following T2Ts, and mapped the corresponding FSI Table Columns to the Map Table Columns:

·        T2T_FSI_PARTY_R_STD_PARTY_R_HIST

·        T2T_FSI_WROFF_STD_WROFF_REASN_HIST

·        T2T_FSI_VEHCL_TY_STD_VEHCL_TY_HIST

·        T2T_FSI_RECVR_TY_STD_RECVR_TY_HIST

·        T2T_FSI_PROD_CODE_STD_PROD_TY_HIST

·        T2T_FSI_PARTY_TY_STD_PARTY_TY_HIST

·        T2T_FSI_MITG_TY_STD_MITGN_TY_HIST

·        T2T_FSI_GL_CODE_REP_LINE_HIST

·        T2T_FSI_GL_ACCT_STD_GL_TYPE_HIST

·        T2T_FSI_DIM_LOB_STD_LOB_HIST

·        T2T_FSI_DIM_IRC_STD_IRC_HIST

·        T2T_FSI_CRLN_TYP_STD_CRLN_TYP_HIST

·        T2T_FSI_CRLN_PUR_STD_CRLN_PUR_HIST

·        T2T_FSI_CRDT_SCR_MDL_REG_MDL_HIST

·        T2T_FSI_BAL_CAT_STD_BAL_CAT_HIST

33143559

FORWARD PORT (81112 TO 812) - REPORTING INTEGRATION FOR C06 REQUIREMENT IN BASEL

Integrated the T2T T2T_FCT_REG_CAP_ENTITY_SUMMARY for the Reporting Integration requirement in the BASEL (OFSCAP) Application.

33130483

FORWARD PORT (81112 TO 812) - T2T_STG_LC_CAS N_ORIGINATION_DATE_SKEY MAPPING MODIFICATION CAUSING DOWNSTREAM IMPACT

Modified the Mapping by modifying the Expression for the STG_LC_CONTRACTS.N_ORIGINATION_DATE_SKEY Column in the T2T T2T_STG_LC_CAS.

33130361

FORWARD PORT (81112 TO 812) - T2T MAPPING REMOVED FOR FCT_LEGAL_ENTITY_DETAILS.N_SOLO_SUPERVISOR_SKEY

Added the Mapping by adding the Expression for the FCT_LEGAL_ENTITY_DETAILS.N_SOLO_SUPERVISOR_SKEY Column in the T2T T2T_FCT_LEGAL_ENTITY_DETAILS.

33130304

FORWARD PORT (81112 TO 812) - T2T_STG_FX_CONTRACTS_CAS T2T N_ISSUER_TYPE_SKEY MAPPING IS REMOVED

Added the Mapping by adding the Expression for the STG_FX_CONTRACTS.N_ISSUER_TYPE_SKEY Column in the T2T T2T_STG_FX_CONTRACTS_CAS.

33242657

DEFAULT VALUE MISSING IN COLUMN FCT_REG_REPORT_ADJUSTMENTS.V_PAGE_INSTANCE_VALUE

The Default Value is set to NA in the Column FCT_REG_REPORT_ADJUSTMENTS.V_PAGE_INSTANCE_VALUE.

33149464

INTRODUCE NEW DIM_TRANSITION_MATRIX SCD - FSDF 812

Created the SCD-1011 with the DIM_TRANSITION_MATRIX and STG_TRANSITION_MTRX_MASTER Tables.

33143953

FORWARD PORT (81112 TO 812) - INCORRECT JOIN ON FCT_LOANS_SERVICED FOR N_ORIG_LIEN_POSITION_SKEY

The Record Start Date and End Date are joined on the Original Table DIM_LIEN_POSITION in the place of an Alias.

33143540

FORWARD PORT (81112 TO 812) - 81110 - PROCEDURE PR_ENABLEBASELINTT2T IS HAVING DUPLICATE INSERTS

Removed the duplicate entries in the pr_enableBaselIntT2T Procedure. As a result, the T2T T2T_FCT_REG_CAP_CP_CTRY_RSK_SUMARY now appears in the UI.

33138755

FORWARD PORT (81112 TO 812) - T2T_FCT_CARDS_SUMMARY - INCORRECT EXCHANGE RATES JOIN MAKES ALL ALL RCY COLUMN POPULATION AS NULL

Removed the RUN_EXE_PARAMETERS_GAAP.V_PARAM_VALUE_CODE Join on the FSI_EXCHANGE_RATES Table from the T2T T2T_FCT_CARDS_SUMMARY. As a result, the Reporting Currency can be fetched.

33138750

FORWARD PORT (81112 TO 812) - STG INVESTMENTS TO COMMON ACCOUNT SUMMARY JOIN ISSUES

Added the NVL Condition in the ANSI Join of the STG_INVESTMENTS Table with the following Entities:

·        DIM_UNDRLYNG_ASST_POOL_TYPE

·        DIM_IRC

·        DIM_INTEREST_TYPE

·        DIM_SECURITIZED_PRODUCTS

·        DIM_SECURITIZATION_TYPE

·        DIM_ACCOUNT_PURPOSE

·        DIM_PARTY DIM_PARTY_GUARANTOR

·        DIM_OPTION_TYPE

33138693

FORWARD PORT (81112 TO 812) - INCORRECT JOIN IN T2T FCT_ENTITY_PARENT_INFO

Modified the Join in the T2T T2T_FCT_ENTITY_PARENT_INFO by validating the Parent Code (STG_ENTITY_PARENT_DETAILS.V_PARENT_LV_CODE) against the V_ENTITY_CODE Column in the place of the DIM_ORG_STRUCTURE.V_PARENT_CODE Column.

33138684

FORWARD PORT (81112 TO 812) - FSDF 809X JOIN ON EXCHANGES RATES MODIFIED FOR PERFORMANCE GOT REVERTED IN 81X

Modified the Left Outer Join in the FSI_EXCHANGE_RATES Table.

33138660

FORWARD PORT (81112 TO 812) - T2T_FCT_CAP_INSTR_DETL EXPRESSION AND JOIN ISSUES

Modified the Mappings in the T2T T2T_FCT_CAP_INSTR_DETL based on the removal of Instrument Contract in a previous Release (v8.1.1.1.0).

33134673

FORWARD PORT (81112 TO 812) - FSI_ACCOUNT_LOAD_RUN_MAP JOIN MISSING IN FCAS T2TS

Added the FSI_ACCOUNT_LOAD_RUN_MAP Join in the following FCT_COMMON_ACCOUNT_SUMMARY T2Ts:

·        T2T_STG_ANNUITY_CONTRACTS_CAS

·        T2T_STG_GUARANTEES_CAS

·        T2T_STG_RETIREMENT_ACCOUNTS_CAS

33134645

FORWARD PORT (81112 TO 812) - T2T_FSCAS_STG_CREDIT_DERIVATIVES - FCT_SEC_COMDTY_ACCT_SUMMARY.N_CUST_SKEY T2T ISSUE

Modified the Mapping by modifying the Coalesce Expression for the Column FCT_SEC_COMDTY_ACCT_SUMMARY.N_CUST_SKEY in the T2T T2T_FSCAS_STG_CREDIT_DERIVATIVES by replacing the DIM_PARTY Table with the DIM_CUSTOMER Table because the Foreign Key (FK) is in the DIM_CUSTOMER Table.

33133219

FORWARD PORT (81112 TO 812) - T2T_FDB_STG_BORROWINGS - EXPRESSION MODIFIED FCT_DEPOSITS_BORROWINGS.F_SUBORDINATED_INDICATOR

Modified the Mapping by modifying the Expression for the Column FCT_DEPOSITS_BORROWINGS.F_SUBORDINATED_INDICATOR in the T2T T2T_FDB_STG_BORROWINGS.

33133188

FORWARD PORT (81112 TO 812) - FCT_SEC_COMDTY_ACCT_SUMMARY - N_UNDERLYING_GUARANTOR_SKEY & N_UNDERLYING_ISSUER_SKEY MODIFIED

Modified the Mapping by modifying the Expression for the Columns FCT_SEC_COMDTY_ACCT_SUMMARY.N_UNDERLYING_ISSUER_SKEY and FCT_SEC_COMDTY_ACCT_SUMMARY.N_UNDERLYING_GUARANTOR_SKEY in the T2T T2T_FSCAS_STG_INVESTMENTS.

33133170

FORWARD PORT (81112 TO 812) - T2T_STG_FORWARDS_CAS & T2T_STG_FUTURES_CAS - F_BUY_SELL MAPPING CHANGE

Modified the Mapping by modifying the Coalesce Expression for the Column FCT_COMMON_ACCOUNT_SUMMARY.F_BUY_SELL in the T2Ts T2T_STG_FORWARDS_CAS and T2T_STG_FUTURES_CAS.

33133129

FORWARD PORT (81112 TO 812) - ADDTION OF T2T DATA FLOW FOR FCT_LEGAL_ENTITY_CNSLDTN_MAP

For the T2T T2T_FCT_LEGAL_ENTITY_CNSLDTN_MAP that was created in the Release v8.1.1.1.2, added the Mappings as a part of the Forward Release Compatibility Process.

33133103

FORWARD PORT (81112 TO 812) - T2T_STG_REPO_CONTRACTS_CAS - IMPACT ON CHANGE OF EXPRESSION FOR N_UNDERLYING_TYPE_SKEY

Modified the Mapping by modifying the Coalesce Expression for the N_UNDERLYING_TYPE_SKEY Column in the T2T T2T_STG_REPO_CONTRACTS_CAS.

33133089

FORWARD PORT (81112 TO 812) - MAPPING MODIFIED FOR FCT_LEGAL_ENTITY_DETAILS.N_FULL_TIME_EQVLNT_EMPLOYEES

Added the Mapping from the Column FCT_LEGAL_ENTITY_DETAILS.N_FULL_TIME_EQVLNT_EMPLOYEES to the Column STG_LEGAL_ENTITY_DETAILS.N_FULL_TIME_EQVLNT_EMPLOYEES in the T2T T2T_FCT_LEGAL_ENTITY_DETAILS.

33133077

FORWARD PORT (81112 TO 812) - T2T_FCT_PLACED_COLLATERAL - EXPRESSION MODIFIED FOR FCT_PLACED_COLLATERAL.V_COLL_CURRENCY_CD

Modified the Mapping for the Column FCT_PLACED_COLLATERAL.V_COLL_CURRENCY_CD in the T2T T2T_FCT_PLACED_COLLATERAL.

33130546

FORWARD PORT (81112 TO 812) - DIM_NETTING_AGREEMENT HAVE MSG/OTH SEEDED WITH WRONG START DATE END DATE

Modified the Default Values for the following Columns in the DIM_NETTING_AGREEMENT Table as listed:

·        FIC_MIS_DATE: 01-JAN-1900

·        D_RECORD_START_DATE: 01-JAN-1900

·        D_RECORD_END_DATE: 31-DEC-9999

33130530

FORWARD PORT (81112 TO 812) - SCD MAPPINGS HAVE INCORRECT RECORD END DATE CONFIGURATION (IDEALLY IT SHOULD BE 31-DEC-9999)

Modified the SCD Mapping Configuration of the D_RECORD_END_DATE Column to 31-DEC-9999 in the following SCDs:

·        SCD-57-DIM_ISSUER_TYPE-STG_ISSUER_TYPE

·        SCD-85-DIM_PRODUCT_TYPE-STG_PRODUCT_TYPE_MASTER

·        SCD-260-DIM_SOCIAL_MEDIA-STG_SOCIAL_MEDIA_MASTER

·        SCD-261-DIM_SOCIAL_MEDIA_POST-STG_SOCIAL_MEDIA_POST

·        SCD-470-STG_COMMODITY_GRADE_MASTER-DIM_COMMODITY_GRADE

·        SCD-49-DIM_GUARANTOR_TYPE-STG_GUARANTOR_TYPE

·        SCD-21-DIM_CHANNEL-STG_SALES_CHANNEL_MASTER

33130513

FORWARD PORT (81112 TO 812) - INCORRECT DEFAULT VALUE RECORD END DATE FOR DIM_COMMON_COA

Modified the Default Value for the Column D_RECORD_END_DATE to 31-DEC-9999 in the DIM_COMMON_COA Table.

33130338

FORWARD PORT (81112 TO 812) - T2T MAPPINGS MISSING FOR FCT_COMMON_ACCOUNT_SUMMARY.N_EXP_UNREALIZED_LOSS_GAIN

Added the Mappings for the Column FCT_COMMON_ACCOUNT_SUMMARY.N_EXP_UNREALIZED_LOSS_GAIN in the following T2Ts:

·        T2T_STG_BILLS_CAS

·        T2T_STG_INVESTMENTS_CAS

·        T2T_STG_LC_CAS

·        T2T_STG_LEASES_CONTRACTS_CAS

·        T2T_STG_LOANS_CAS

32892214

REQUIRED MITIGANT PERCENTAGE IN ACCOUNT MITIGANT MAP

Added the following Columns in the corresponding Source and Result Tables, and mapped the Source Columns to the Result Columns:

·        FCT_CAP_INSTR_POSITIONS.N_STD_ACCT_HEAD_SKEY to STG_CAP_INSTR_POSITIONS.V_STD_ACCT_HEAD_ID (LOOKUP on DIM_STANDARD_ACCT_HEAD)

·        FCT_ACCOUNT_MITIGANT_MAP.N_REQUIRED_MITIGANT_PCT to STG_ACCOUNT_MITIGANT_MAP.N_REQUIRED_MITIGANT_PCT

·        FCT_COMMON_ACCOUNT_SUMMARY.N_REQUIRED_MITIGANT_PCT to STG_LOAN_CONTRACTS.N_REQUIRED_MITIGANT_PCT

·        FCT_COMMON_ACCOUNT_SUMMARY.N_GROSS_UNDRAWN_AMT to STG_LOAN_CONTRACTS.N_GROSS_UNDRAWN_AMT

·        FCT_ACCOUNT_MITIGANT_MAP.F_ELIGIBILITY_FLAG to STG_ACCOUNT_MITIGANT_MAP.F_ELIGIBILITY_FLAG

32874325

DEFINITION UPDATE FOR STG_PARTY_MASTER.V_INCORPORATION_COUNTRY_CD

Updated all occurrences of the V_INCORPORATION_COUNTRY_CD Column Description in the Data Model.

32873832

ERL-6255 - STG_BORROWINGS ELEMENTS OVERLAP WITH SICM

Removed TO_NUMBER from the Expression of the N_INTEREST_TYPE Column Mapping in the T2T T2T_STG_BORROWINGS_CAS.

32844867

STANDARDIZATION OF OFFSET ACCOUNT IDENTIFIER

Changed the Logical Name of the following Columns to Offset Account Identifier:

·        STG_FUTURES.V_CONTRACT_OFFSET_ID

·        STG_FORWARDS.V_CONTRACT_OFFSET_ID

·        STG_ACCOUNT_POSITION_PAIR.V_OFFSET_ACCOUNT_NUMBER

·        STG_INVESTMENTS.V_OFFSET_ACCT_NBR

32780156

T2T_STG_LC_CAS FAILING WITH DUPLICATE ROWS DUE TO JOIN WITH STG_CREDIT_PARTICIPATION_DTLS_LUA

The existing logic, which uses the Syndication Line Code, fails when there are records related to different Legal Entity Codes for the same Credit Line Code. Therefore, removed the Code Snippet in the T2T T2T_STG_LC_CAS, where the Measures are obtained by validating the Syndication Line Code. As a replacement, the Syndication Account Number is added for the same purpose.

32453218

T2T_STG_LOANS_CAS IS FAILING POST 8094 UPGRADE

The existing logic, which uses the Syndication Line Code, fails when there are records related to different Legal Entity Codes for the same Line Code. Therefore, removed the Code Snippet in the following T2Ts, where the Measures are obtained by validating the Syndication Line Code:

·        T2T_STG_LEASES_CONTRACTS_CAS

·        T2T_STG_LOANS_CAS

·        T2T_STG_OD_CAS

·        T2T_STG_INVESTMENTS_CAS

·        T2T_STG_LC_CAS

As a replacement, the Syndication Account Number is added for the same purpose.

32773974

DATA PRECISION OF THE TARGET COLUMN LESSER THAN THE DIRECTLY MAPPED SOURCE COLUMN IN T2T MAPPINGS

Updated the Data Type length of the Coulmns FCT_SEC_COMDTY_ACCT_SUMMARY.N_FLOATING_RATE_SPREAD_RCV and FCT_SEC_COMDTY_ACCT_SUMMARY.N_FLOATING_RATE_SPREAD_PAY.

32773915

DATA SIZE OF THE TARGET COLUMN LESSER THAN THE DIRECTLY MAPPED SOURCE COLUMN IN T2T MAPPINGS

Updated the Data Type length of the following Columns:

·        FCT_APPLICATION.N_NO_OF_DEPENDENTS

·        FCT_REF_CCY_SWAPS_RATE.N_LOAD_RUN_ID

·        FCT_REF_EQ_CMDTY_VOL.N_LOAD_RUN_ID

·        FCT_REF_EQ_DIV_RATE.N_LOAD_RUN_ID

·        FCT_REF_FOREX_RATE.N_LOAD_RUN_ID

·        FCT_REF_FOREX_VOL.N_LOAD_RUN_ID

·        FCT_REF_FRA_SWAPS_RATE.N_LOAD_RUN_ID

·        FCT_REF_INFLATION_RATE.N_LOAD_RUN_ID

·        FCT_REF_INTEREST_RATE.N_LOAD_RUN_ID

·        FCT_REF_MKT_CREDIT_RATE.N_LOAD_RUN_ID

·        FCT_REF_OPTION_VOL.N_LOAD_RUN_ID

·        FCT_REG_LE_CAPITAL_SUMMARY.N_REP_LINE_SKEY

32767692

DIM_DATA_ORIGIN JOIN MISSING IN T2TS

Resolved as a part of the Bug 32233187.

32677628

T2T MAPPING UPDATE FOR FCAS.N_MAX_AMT_GUARANTEED

Modified the Mapping for the Column FCT_COMMON_ACCOUNT_SUMMARY.N_MAX_AMT_GUARANTEED in the T2Ts T2T_STG_CASA_CAS and T2T_STG_TD_CONTRACTS_CAS.

32631373

COLUMN TO STORE SAFEKEEPING CODE

Added the F_FIDUCIARY_RELATIONSHIP_FLAG Column in the Tables STG_TRADING_ACCOUNT and STG_RETIREMENT_ACCOUNTS, and mapped the following Columns:

·        FCT_COMMON_ACCOUNT_SUMMARY.F_FIDUCIARY_RELATIONSHIP_FLAG to STG_RETIREMENT_ACCOUNTS.F_FIDUCIARY_RELATIONSHIP_FLAG

·        FCT_COMMON_ACCOUNT_SUMMARY.F_FIDUCIARY_RELATIONSHIP_FLAG to STG_TRADING_ACCOUNT.F_FIDUCIARY_RELATIONSHIP_FLAG

32631013

COLUMN DEFINITION UPADATE F_UNCOND_CANCELLED_EXP_IND

Updated the F_UNCOND_CANCELLED_EXP_IND Column Description in the Data Model.

32623684

CUSTOMER IS REQUESTING TO UPDATE THE V_ISO_COUNTRY_CD OF TABLE STG_PARTY_MASTER FROM PHONE NUMBER TO BIRTH PLACE

Updated the V_ISO_COUNTRY_CD Column Description in the Data Model for the Tables STG_PARTY_MASTER and DIM_PARTY.

32618867

INCORRECT MAPPING TO FCT_SEC_COMDTY_ACCT_SUMMARY.N_CUST_SKEY FROM STG_CREDIT_DERIVATIVES

Modified the Mapping for the Column FCT_SEC_COMDTY_ACCT_SUMMARY.N_CUST_SKEY in the T2T T2T_FSCAS_STG_CREDIT_DERIVATIVES.

32585842

CAS - T2T MAPPING MISSING FOR CREDIT QUALITY TYPE SKEY

Modified the Mapping for the following Columns:

·        FCT_COMMON_ACCOUNT_SUMMARY.N_CREDIT_QUALITY_TYPE_SKEY to STG_CASA.V_CREDIT_QUALITY_TYPE_CODE

·        FCT_COMMON_ACCOUNT_SUMMARY.N_CREDIT_QUALITY_TYPE_SKEY to STG_LC_CONTRACTS.V_CREDIT_QUALITY_TYPE_CODE

32574897

ORACLE ATTRIBUTE DEFINITION UPDATES

Enhanced the Description of the following Columns:

·        STG_BILLS_CONTRACTS.D_PURCHASE_DATE

·        STG_REPO_CONTRACTS.D_PURCHASE_DATE

·        STG_CORRESPONDENT_ACCOUNT.F_TRANSFERABILITY_RESTRICTION

·        STG_INVESTMENTS.F_TRANSFERABILITY_RESTRICTION

·        STG_CREDIT_PARTCPN_DETAILS.N_FEES

·        STG_LEASES_CONTRACTS.N_ADVANCE_PMT_AMT

·        STG_LOAN_CONTRACTS.N_ADVANCE_PMT_AMT

·        STG_OD_ACCOUNTS.N_ADVANCE_PMT_AMT

·        STG_OD_ACCOUNTS.V_PARENT_ACCOUNT_NUMBER

·        STG_REPO_CONTRACTS.V_PARENT_ACCOUNT_NUMBER

·        STG_LOAN_CONTRACTS.V_PARENT_ACCOUNT_NUMBER

·        STG_BORROWINGS.V_PARENT_ACCOUNT_NUMBER

·        STG_CASA.V_OFFSET_ACCT_NBR

·        STG_TD_CONTRACTS.V_OFFSET_ACCT_NBR

·        STG_ASSETS_SOLD.N_LEASE_RESIDUAL_AMOUNT

·        STG_OTHER_ASSETS.N_DEPRECIATION_RESERVE

·        STG_INVESTMENTS.N_FEES

·        STG_BILLS_CONTRACTS.F_MATERIALITY_FLAG

·        STG_LEASES_CONTRACTS.V_PARENT_ACCOUNT_NUMBER

·        STG_INVESTMENTS.V_OFFSET_ACCT_NBR

·        STG_UNDERLYING_EXPOSURES.V_PARENT_EXPOSURE_ID

·        STG_BILLS_CONTRACTS.D_INDEMNIFICATION_DATE

·        STG_CARDS.D_INDEMNIFICATION_DATE

·        STG_INVESTMENTS.D_INDEMNIFICATION_DATE

·        STG_LOAN_CONTRACTS.D_INDEMNIFICATION_DATE

·        STG_OD_ACCOUNTS.D_INDEMNIFICATION_DATE

·        STG_LOAN_CONTRACTS.D_DEFERRED_PERIOD_START_DATE

·        STG_REPO_CONTRACTS.N_UNEARNED_INCOME

·        STG_REPO_CONTRACTS.N_AMORTIZED_COST

32566490

FSDF T2T'S MISSING LOAD RUN ID JOIN.

Added the N_LOAD_RUN_ID Column as a Primary Key (PK) in the STG_COMMODITIES and STG_OTHER_ASSETS Tables and mapped in the T2Ts T2T_STG_COMMODITIES_CAS and T2T_STG_COMMODITIES_CAS.

Enabled the FSI_ACCOUNT_LOAD_RUN_MAP Table in the ANSI to cater to multiple Datasets on a FIC_MIS_DATE.

32553977

COLUMN DEFINITION EXPANSION FOR V_UNDERLYING_INSTR_TYPE_CODE

Enhanced the V_UNDERLYING_INSTR_TYPE_CODE Column Description in the following Tables:

·        STG_FUTURES

·        STG_FX_CONTRACTS

·        STG_OPTION_CONTRACTS

·        STG_REPO_CONTRACTS

·        STG_SWAPS_CONTRACTS

·        STG_CREDIT_DERIVATIVES

·        STG_FORWARDS

32483713

VOTING RIGHTS FOR NFRR 13D/F/G REPORTING

Added the following Columns in the DIM_INSTRUMENT_CONTRACT and STG_INSTRUMENT_CONTRACT_MASTER Tables for the SCD-54:

·        F_VOTING_RIGHTS_IND (Voting Rights Indicator) with the VARCHAR(1) Data Type and Data Length

·        F_VOTING_RIGHTS_CLASS_IND (Voting Rights Class Indicator) with the VARCHAR(1) Data Type and Data Length

·        N_VOTING_RIGHTS_PER_SHARE (Voting Rights Per Share) with the NUMBER(8,4) Data Type and Data Length

·        Added the Seeded Data Entries in the DIM_INDICATOR_VALUES Table for the Voting Rights Indicator and Voting Rights Class Indicator Columns.

32453661

DEFINITION FOR STG_GEOGRAPHY_MASTER.V_BRANCH_COUNTRY

Enhanced the STG_GEOGRAPHY_MASTER.V_BRANCH_COUNTRY Column Description.

32409197

FSDF ISSUE FOR HC-M/RC-M AND RC-T- ADD COLUMNS AND MAPPINGS.

·        Added the F_ACQ_FRM_FAILED_INS_DEP Column in the STG_OTHER_ASSETS, STG_BILLS_CONTRACTS, and STG_REPO_CONTRACTS Tables and mapped to the FCT_COMMON_ACCOUNT_SUMMARY.F_ACQ_FRM_FAILED_INS_DEP Column.

·        Added the V_SELLER_ID Column in the STG_BILLS_CONTRACTS and STG_OD_ACCOUNTS Tables, and mapped to the FCT_COMMON_ACCOUNT_SUMMARY.N_SELLER_SKEY Column by using the Lookup on the DIM_PARTY Table in the T2Ts T2T_STG_BILLS_CAS and T2T_STG_OD_CAS respectively.

·        Added the F_DEBT_PREV_CONTR_FLAG Column in the STG_LOAN_CONTRACTS Table and mapped to the FCT_COMMON_ACCOUNT_SUMMARY.F_DEBT_PREV_CONTR_FLAG Column in the T2T T2T_STG_LOANS_CAS.

·        Added the mappings for the T2T T2T_STG_INVESTMENTS_CAS. Mapped the STG_INVESTMENTS.V_INSTRUMENT_CODE Column to the FCT_COMMON_ACCOUNT_SUMMARY.N_UNDERLYING_INSTR_TYPE_SKEY Column.

32376465

T2T MAPPING MISSING FOR FCT_PARTY_DETAILS.N_DELQ_LIFE_TIMES

Mapped the STG_PARTY_DETAILS.N_DELQ_LIFE_TIMES Column to the FCT_PARTY_DETAILS.N_DELQ_LIFE_TIMES Column.

32376313

STG_CASA.F_ATS_ACC_FLAG DEFINITION (COLUMN COMMENT)

Modified the STG_CASA.F_ATS_ACC_FLAG Column Description.

32360989

CCR_STG-FORWARDS- CAS T2T MAPPING MISSING FOR N_D_CUST_INDUSTRY_SKEY

Added the missing mapping from the FCT_COMMON_ACCOUNT_SUMMARY.N_D_CUST_INDUSTRY_SKEY Column to the STG_FORWARDS.V_CUST_REF_CODE Column.

32360188

N_EXP_SENIORITY COLUMN IN PP TABLES

Modified the Mapping Expression for the FCT_COMMON_ACCOUNT_SUMMARY.N_ACCT_SENIORITY Column in the following T2Ts:

·        T2T_STG_BILLS_CAS

·        T2T_STG_BORROWINGS_CAS

·        T2T_STG_CARDS_CAS

·        T2T_STG_COMMITMENT_CONTRACTS_CAS

·        T2T_STG_FORWARDS_CAS

·        T2T_STG_FUTURES_CAS

·        T2T_STG_INVESTMENTS_CAS

·        T2T_STG_LC_CAS

·        T2T_STG_LOANS_CAS

·        T2T_STG_MM_CAS

·        T2T_STG_OPTIONS_CAS

·        T2T_STG_REPO_CONTRACTS_CAS

32323192

T2T FOR F_MARKED_PAY_OBLIGTNS_BY_VIE FOR CARDS AND OVERDRAFTS

Mapped the following Columns in the T2Ts T2T_STG_CARDS_CAS and T2T_STG_OD_CAS respectively:

·        FCT_COMMON_ACCOUNT_SUMMARY.F_MARKED_PAY_OBLIGTNS_BY_VIE to STG_CARDS.F_MARKED_PAY_OBLIGTNS_BY_VIE

·        FCT_COMMON_ACCOUNT_SUMMARY.F_MARKED_PAY_OBLIGTNS_BY_VIE to STG_OD_ACCOUNTS.F_MARKED_PAY_OBLIGTNS_BY_VIE

32297004

CAS -T2T -MAPPING MISSING FOR LTV

Mapped the N_EXP_LTV_RATIO Column from the STG_MM_CONTRACTS, STG_OPTION_CONTRACTS, and STG_SWAPS_CONTRACTS Tables to the FCT_COMMON_ACCOUNT_SUMMARY.N_CURR_LTV Table in the T2Ts T2T_STG_MM_CAS, T2T_STG_OPTIONS_CAS, and T2T_STG_SWAPS_CONTRACTS_CAS respectively.

32257959

HC-S/RC-S: T2T FROM STG_LEASES_CONTRACTS TO FCT_COMMON_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL

Mapped the FCT_COMMON_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL Column to the STG_LEASES_CONTRACTS.N_EOP_CURR_PRIN_BAL Column in the T2T T2T_STG_LEASES_CONTRACTS_CAS.

32252888

FSDF UPDATES REQUIRED FOR T2T_FCT_MORT_SERV_RIGHTS

Mapped the N_MSR_BOOK_VALUE_AMOUNT, N_MSR_BOOK_VALUE_AMOUNT_RCY, N_MSR_FAIR_VALUE_AMOUNT_RCY, V_ISO_CURRENCY_CD, and V_REPORTING_CCY_CODE Columns for the FCT_MORT_SERV_RIGHTS Table in the T2T T2T_FCT_MORT_SERV_RIGHTS.
Mapped the FCT_COMMON_ACCOUNT_SUMMARY.N_PROD_BALANCE_SHEET_CAT_SKEY Column from the STG_OTHER_ASSETS Table based on the V_PROD_CODE Column (Join with the DIM_PRODUCT and DIM_BALANCE_SHEET_CATEGORY Tables).

32233187

COMPLETE OFSAA DATA ORIGIN CONFIGURATION

Standardize the Logical Name of the Columns V_DATA_ORIGIN, V_DATA_SOURCE_CODE, and V_DATA_SOURCE_CD to "Data Origin".
Added the V_DATA_ORIGIN Column in all the Stage Tables, where one of the above-mentioned Columns are not available and then mapped the Column to the Results Area. If the Result Table is a Dimension, the Column Value is stored as a Code, and if the Result Table is a Fact Table, the corresponding Surrogate Key is added.

32216039

V_PUPOSE NEEDS TO BE ADDED AS A PART OF PK IN FCT_PARTY_RATING_DETAILS

Updated the Null Values in the FCT_PARTY_RATING_DETAILS.V_PURPOSE Column with the Default Value DOMESTIC (existing NULL Value is also updated as DOMESTIC) and then marked the Column as a Primary Key.

32212709

DEFINITION UPDATE.STG_INVESTMENTS.V_UNDERLYING_GUARANTOR_ID AND V_UNDERLYING_ISSUER_CODE DEFINITION UPDATE

Enhanced the STG_INVESTMENTS.V_UNDERLYING_GUARANTOR_ID and STG_INVESTMENTS.V_UNDERLYING_ISSUER_CODE Column Descriptions.

32199609

F_EMBEDDED_OPTIONS_FLAG SOURCING FROM SICM

Modified the Mapping for the Column FCT_COMMON_ACCOUNT_SUMMARY.F_EMBEDDED_OPTIONS_FLAG in the T2T T2T_STG_INVESTMENTS_CAS.

32187672

DEFINITION FOR STG_INVESTMENTS.N_AVERAGE_MATURITY_DAYS REQUIRES MORE DETAIL

Enhanced the STG_INVESTMENTS.N_AVERAGE_MATURITY_DAYS Column Description.

32187502

DEFINITION ENHANCEMENT FOR N_PERCENT_ENCUMBERED

Enhanced the N_PERCENT_ENCUMBERED Column Description.

32179794

FUNCTIONAL USAGE OF 2 COLUMNS IN STG_LOAN_CONTRACTS

In the STG_LOAN_CONTRACTS Table, deprecated the F_CALLABLE_FLAG Column because it is a duplicate of the F_CALL_OPTION_FLAG Column.

32147826

FCT_COMMON_ACCOUNT_SUMMARY.F_SIGHT_USANCE HAVE INCORRECT T2T EXPRESSION

Created direct mapping for the F_SIGHT_USANCE Column (Sight or Usance) of the LC Contracts in the T2T_STG_LC_CAS.

32111663

DEFINITION OF REPAYER CODE IN STAGE LOAN CONTRACTS

Enhanced the STG_LOAN_CONTRACTS.V_REPAYER_CODE Column Description.

32110030

T2T_STG_OTHER_ASSETS FAILING WITH ORA ERRORS IN FSDF 8093.

Added the N_LOAD_RUN_ID Column in the STG_OTHER_ASSETS Table and mapped it to the FCT_COMMON_ACCOUNT_SUMMARY.N_LOAD_RUN_ID Column.

32101213

V_ISSUER_CODE DEFINITION UPDATE

Enhanced the V_ISSUER_CODE Column Description except in the STG_MITIGANTS Table.

Enhanced the STG_MITIGANTS.V_GUARANTOR_CODE Column Description.

32100914

T2T LOGIC IS FAILING TO POPULATE FCT_SEC_COMDTY_ACCOUNT_SUMMARY FROM STG_CREDIT_DERIVATIVES

Modified the Mapping for the Column FCT_SEC_COMDTY_ACCT_SUMMARY.N_CUST_SKEY in the T2T T2T_FSCAS_STG_CREDIT_DERIVATIVES.

32090758

MISSING T2T FOR FCT_COMMON_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL FROM STG_BILLS_CONTRACTS

Mapped the STG_BILLS_CONTRACTS.N_EOP_CURR_PRIN_BAL Column to the FCT_COMMON_ACCOUNT_SUMMARY.N_EOP_PRIN_BAL Column.

32072157

STG_PAYMENT_ACTIVITY - FIELD DEFINITIONS MISMATCH AND FK MISSING.

Enhanced the Column Descriptions in the STG_PAYMENT_ACTIVITY Table.

31900723

STG_CREDIT_LINE_DETAILS.D_INT_NON_ACCRUAL_DATE REQUIRES DEFINITION UPDATE

Enhanced the STG_CREDIT_LINE_DETAILS.D_INT_NON_ACCRUAL_DATE Column Description.

31864357

OOTB T2T FOR FCT_INSTRUMENT_CONTRACT_DTL

Added a new T2T T2T_FCT_INSTRUMENT_CONTRACT_DTL to load the FCT_INSTRUMENT_CONTRACT_DTL Table from the STG_INSTRUMENT_CONTRACT_DTL Table.

31768346

STG_LOAN_CONTRACTS N_DUE_INTEREST NEEDS TO BE REPLACED WITH N_INSTAL_INT_AMT IN FCAS T2T

Added the Mapping for the N_CUST_SKEY Column in the T2T T2T_FCT_APPLICATION.

31757266

MPPING CONCERNS WITH RESPECT TO STG_CARDS.N_NO_ADD_ON_CARDS

Modified the Mapping for the Columns FCT_CARDS_SUMMARY.N_COUNT_OF_AUTHORIZED_USERS and FCT_CARDS_SERVICED.N_COUNT_OF_AUTHORIZED_USERS in the T2T T2T_FCT_CARDS_SERVICED and T2T_FCT_CARDS_SUMMARY.

31750773

REQUESTING TO ADD NEW COLUMNS IN STG_MANAGED_INV_ADV

·        Added the Mappings for the Columns V_OFFER_CODE and V_TREATMENT_CODE in the following SCDs:

§       SCD-188-DIM_ACCOUNT-STG_ANNUITY_CONTRACTS_V

§       SCD-189-DIM_ACCOUNT-STG_BILLS_CONTRACTS_V

§       SCD-191-DIM_ACCOUNT-STG_CARDS_V

§       SCD-192-DIM_ACCOUNT-STG_CASA_V

§       SCD-193-DIM_ACCOUNT-STG_COMMITMENT_CONTRACTS

§       SCD-198-DIM_ACCOUNT-STG_INVESTMENTS_V

§       SCD-199-DIM_ACCOUNT-STG_LC_CONTRACTS_V

§       SCD-200-DIM_ACCOUNT-STG_LEASES_CONTRACTS_V

§       SCD-201-DIM_ACCOUNT-STG_LOAN_CONTRACTS_V

§       SCD-202-DIM_ACCOUNT-STG_MM_CONTRACTS_V

§       SCD-203-DIM_ACCOUNT-STG_MUTUAL_FUNDS_V

§       SCD-204-DIM_ACCOUNT-STG_OD_ACCOUNTS_V

§       SCD-207-DIM_ACCOUNT-STG_RETIREMENT_ACCOUNTS

§       SCD-209-DIM_ACCOUNT-STG_TD_CONTRACTS_V

§       SCD-210-DIM_ACCOUNT-STG_TRUSTS

§       SCD-264-DIM_ACCOUNT-STG_TRADING_ACCOUNT_V

§       SCD-350-DIM_ACCOUNT-STG_CUSTODIAL_ACCOUNTS_V

§       SCD-351-DIM_ACCOUNT-STG_MANAGED_INV_ADV_V

§       SCD-352-DIM_ACCOUNT-STG_MERCHANT_BANKING_V

§       SCD-400-DIM_ACCOUNT-STG_MERCHANT_CARDS_V

·        Added the F_IRIA_FLAG Column in the Tables DIM_INVESTMENT_ADVISOR and STG_INVESTMENT_ADVISOR_MASTER, and mapped the Column STG_INVESTMENT_ADVISOR_MASTER.F_IRIA_FLAG to the Column DIM_INVESTMENT_ADVISOR.F_IRIA_FLAG in the SCD-984.

·        Added the Columns V_DISCRETION_AUTH_CODE and V_PROXY_VOTING_RIGHT_CODE in the Tables FCT_PARTY_PARTY_ACCT_RELTNSHP and STG_PARTY_PARTY_ACCT_RELTNSHP. Mapped the following Columns in the T2T T2T_FCT_PARTY_PARTY_ACCT_RELTNSHP:

§       FCT_PARTY_PARTY_ACCT_RELTNSHP.V_DISCRETION_AUTH_CODE to STG_PARTY_PARTY_ACCT_RELTNSHP.V_DISCRETION_AUTH_CODE

§       FCT_PARTY_PARTY_ACCT_RELTNSHP.V_PROXY_VOTING_RIGHT_CODE to STG_PARTY_PARTY_ACCT_RELTNSHP.V_PROXY_VOTING_RIGHT_CODE

·        Added the Columns N_UNSETTLED_QUANTITY, N_UNSETTLED_TRADE_BALANCE, and D_UNSETTLED_LAST_TRADE_DATE in the Tables FCT_SEC_COMDTY_ACCT_SUMMARY and STG_INVESTMENTS. Mapped the following Columns in the T2T T2T_FSCAS_STG_INVESTMENTS:

§       FCT_SEC_COMDTY_ACCT_SUMMARY.N_UNSETTLED_QUANTITY to STG_INVESTMENTS.N_UNSETTLED_QUANTITY

§       FCT_SEC_COMDTY_ACCT_SUMMARY.N_UNSETTLED_TRADE_BALANCE to STG_INVESTMENTS.N_UNSETTLED_TRADE_BALANCE

§       FCT_SEC_COMDTY_ACCT_SUMMARY.D_UNSETTLED_LAST_TRADE_DATE to STG_INVESTMENTS.D_UNSETTLED_LAST_TRADE_DATE

·        Added the Columns N_UNSETTLED_QUANTITY, N_UNSETTLED_TRADE_BALANCE, D_UNSETTLED_LAST_TRADE_DATE, and F_MANAGED_ACCOUNT_FLAG in the tables FCT_ACCOUNT_POSITION and STG_ACCOUNT_POSITION. Mapped the following Columns in the T2T T2T_FCT_ACCOUNT_POSITION:

§       FCT_ACCOUNT_POSITION.N_UNSETTLED_QUANTITY to STG_ACCOUNT_POSITION.N_UNSETTLED_QUANTITY

§       FCT_ACCOUNT_POSITION.N_UNSETTLED_TRADE_BALANCE to STG_ACCOUNT_POSITION.N_UNSETTLE.D_TRADE_BALANCE

§       FCT_ACCOUNT_POSITION.D_UNSETTLED_LAST_TRADE_DATE to STG_ACCOUNT_POSITION.D_UNSETTLED_LAST_TRADE_DATE

§       FCT_ACCOUNT_POSITION.F_MANAGED_ACCOUNT_FLAG to STG_ACCOUNT_POSITION.F_MANAGED_ACCOUNT_FLAG

31635601

F_LATEST_RECORD_INDICATOR FOR REFERENTIAL INTEGRITY DATA QUALITY CHECKS

Added the Filters DIM_COUNTRY.D_RECORD_START_DATE and DIM_COUNTRY.D_RECORD_END_DATE in all the Data Quality Rules with Referential Integrity Check. This Filter appears in the V_DETL_SQL Column of the DQ_CHECK_MASTER Table.

31599165

CLARIFICATION: APPROPRIATE COLUMN FOR INTEREST INCOME AFTER ACCOUNT GOES IN NON ACCRUAL STAGE

Added the Columns N_DEF_INT_REVERSAL_AMT and N_ORIG_DEF_INT_REVERSAL_AMT in the Tables STG_LOAN_CONTRACTS, STG_LEASES_CONTRACTS, STG_OD_ACCOUNTS, STG_INVESTMENTS, and STG_CREDIT_PARTCPN_DETAILS to capture Amount, and mapped the Columns in the T2Ts T2T_STG_LOANS_CAS, T2T_STG_LEASES_CONTRACTS_CAS, T2T_STG_OD_CAS, T2T_STG_INVESTMENTS_CAS, and T2T_STG_LC_CAS respectively.

30949648

T2T - FLOW FOR D_INDEMNIFIED_DATE FROM PROPDUCT PROCESSOR TABLES MISSING

·        Deprecated the Column FCT_COMMON_ACCOUNT_SUMMARY.D_INDEMNIFIED_DATE.

·        Added the D_INDEMNIFICATION_DATE Column to the TABLES STG_OD_ACCOUNTS, STG_REPO_CONTRACTS and STG_LEASES_CONTRACTS, and mapped the D_INDEMNIFICATION_DATE Column from the mentioned Stage Tables to the Column FCT_COMMON_ACCOUNT_SUMMARY.N_INDEMNIFICATION_DATE_SKEY.

30919745

STG_FX_CONTRACTS DEFINITION SHOULD BE ENHANCED TO INCLUDE ALL SOPT CONTRACTS

Enhanced the STG_FX_CONTRACTS Table Description.

30835943

V_HOLDING_TYPE - DEFINITION UPDATE

Enhanced the V_HOLDING_TYPE Column Description.

30829899

STG_ADDRESS_MASTER.V_ADD_ATTENTION_LINE: INCREASE COLUMN LENGTH TO 255

Increased the Data Type length of the Columns STG_ADDRESS_MASTER.V_ADD_ATTENTION_LINE and DIM_ADDRESS.V_ADD_ATTENTION_LINE to VARCHAR2(255).

30814209

DEFINITION ENHANCEMENT FOR STG_SWAPS_CONTRACTS.N_NOTIONAL_PRINCIPAL_RCV/PAY

Enhanced the Description of the Columns STG_SWAPS_CONTRACTS.N_NOTIONAL_PRINCIPAL_RCV and STG_SWAPS_CONTRACTS.N_NOTIONAL_PRINCIPAL_PAY.

30737271

FSDF:807: COUNTRY NAME DOESN'T MATCH THE ISO COUNTRY NAME IN DIM_COUNTRY

Updated the Country Name Values (V_COUNTRY_NAME Column) in the DIM_COUNTRY Table as per the ISO Standards except the Barthélemy and RE Réunion Names because there are Special Characters in these Code Names.

30603022

RE-PRICING FREQUENCY - LIST OF VALUES AND CONVERSION RELATED ISSUES

Modified the Expression for the Column FCT_LOAN_ACCOUNT_SUMMARY.N_REPRICING_FREQ_MON in the T2T T2T_FLAS_STG_LEASES_CONTRACTS to represent the value in Months.

30587655

INCONSISTENT SOURCE FIELDS USED : FCT_LOAN_ACCOUNT_SUMMARY.N_INTIAL_ARM_RATE_TERM_MON

Added the D_ORIG_REPRICING_DATE Column in the STG_LEASES_CONTRACTS Table and updated the T2T T2T_FLAS_STG_LEASES_CONTRACTS.

30585783

INCONSISTENT ATTRIBUTE MAPPING+FCT_COMMON_ACCOUNT_SUMMARYN_ORIGINATION_DATE_SKEY

Modified the Mapping for TO_NUMBER in the Column FCT_COMMON_ACCOUNT_SUMMARY.N_ORIGINATION_DATE_SKEY in the T2T T2T_STG_OD_CAS.

30580917

INCORRECT EXPRESSION FOR POPULATING N_REPRICING_FREQ_MON IN FCT_CREDIT_LINE

Modified the Mapping in the Column FCT_CREDIT_LINE.N_REPRICING_FREQ_MON in the T2T T2T_FCT_CREDIT_LINE to represent the Value in Months.

30566329

FCT_LOAN_ACCOUNT_SUMMARYN_ARM_ORIGINATION_MARGIN

Enhanced the N_ARM_ORIGINATION_MARGIN Column Description.

30294183

DATA TYPE MISMATCH FOR COLLATERAL AREA ATTRIBUTE

Increased the Data Type length of the N_COLL_AREA Column to NUMBER(30,3).

30272644

HOW HIERARCHY INFORMATION CAN BE LOADED/PROCESSED FOR KEY DIMENSIONS.

Extended the Tables DIM_PRODUCT and STG_PRODUCT_MASTER to capture Product Levels upto 20, and updated the SCD-78-DIM_PRODUCT-STG_PRODUCT_MASTER.

30151403

OFSAA PARTY ROLES STANDARDIZATION

·        Created the DIM_STD_PARTY_ROLE Table to store the Standard Seeded Values.

·        Created the STG_PARTY_ROLE_MASTER Table to source the Values of the Bank, which will be loaded to the DIM_PARTY_ROLE Table by adding a new SCD.

·        Created the T2T T2T_FSI_PARTY_ROLE_MAP to load the FSI_PARTY_ROLE_MAP Table from the STG_PARTY_ROLE_MAP Table.

·        Created two Hierarchies HCMDF025 and HCMDF026 that uses the Mapper 1627460156455. This Mapper maps Party Role to Standard Party Roles in the SCD-1012-DIM_PARTY_ROLE-STG_PARTY_ROLE_MASTER.

§       Created the Map Table MAP_PARTY_R_STD_PARTY_R.

§       Created a Mapper T2T T2T_FSI_PARTY_R_STD_PARTY_R_HIST.

29428653

HOME EQUITY LOANS & HOME EQUITY LINES OF CREDIT - USAGE OF STAGE CREDIT LINES TABLE

Updated the Banking Product to Product Processor Mapping File with the Product Group HELOC to map the Stage Loan Contracts Table.

29027668

CLARIFICATION ON N_DEFERRED_CUR_BAL VS N_DEF_CUR_PREM_DISC

Deprecated the N_DEFERRED_CUR_BAL Column because it has the same Description and functional purpose as that of the N_DEF_CUR_PREM_DISC Column.

28463170

NEED TO STANDARDISATION OF PHYSICAL ATTRIBUTES IN THE MODEL

Modified the Logical Name of the N_FLOAT_SPREAD Column to Floating Rate Spread and of the N_FLOATING_RATE_SPREAD Column to Floating Rate Spread.

28167921

RC-T: N_ASSET_MTM_VALUE_RCY IS NOT POPULATED

Enhanced the T2T T2T_FFSIS_STG_TRUSTS to map the following Columns:

·        FCT_FIDUCIARY_SERV_INVST_SUMM.N_ASSET_MTM_VALUE to STG_TRUSTS.N_EOP_BAL

·        FCT_FIDUCIARY_SERV_INVST_SUMM.N_ASSET_MTM_VALUE_RCY to STG_TRUSTS.N_EOP_BAL

26810768

ADDING 'F_PRIME_BROKERAGE_FLAG' COLUMN TO STG_LOAN_CONTRACTS TABLE

Mapped the Column STG_LOAN_CONTRACTS.F_PRIME_BROKERAGE_FLAG to the Column FCAS.F_PRIME_BROKERAGE_FLAG in the T2T T2T_STG_LOANS_CAS.

26029526

LOAN EFFECTIVE DATE COLUMN AMBIGUITY IN STG_LOAN_CONTRACTS.

Added the Mapping for the Columns FCT_COMMON_ACCOUNT_SUMMARY.N_START_DATE_SKEY and FCT_COMMON_ACCOUNT_SUMMARY.D_END_OF_INTEREST_ONLY_PERIOD in the T2T T2T_STG_LOANS_CAS.

Added the Mapping for the Columns FCT_LOAN_ACCOUNT_SUMMARY.N_INTIAL_ARM_RATE_TERM_MON and FCT_LOAN_ACCOUNT_SUMMARY.N_PREPMT_PENALTY_TERM_MON in the T2T T2T_FLAS_STG_LOAN_CONTRACTS.

22973677

NAME COLUMN DATA SIZE TO BE INCREASED

Increased the Data Type length of the Column V_DOCUMENT_NAME to VARCHAR2(255).