My Oracle Support Banner

STG_INVESTMENTS - Data Element Clarifications/Alternate Sourcing (Doc ID 2709897.1)

Last updated on JUNE 23, 2021

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and later
Information in this document applies to any platform.

Goal

Version: RRS 8094, SVF Jan2020

Issue:
1) STG_INVESTMENTS.D_TEASER_END_DATE - (SVF Usage :RC-O)
>> How is teaser end date applicable to investment? Should be removed from DE/SVF documentation

2) STG_INVESTMENTS.V_SECURITIES_GUARANTOR_CD - (SVF Usage :RC,RC-B,RC-D,RC-H,RC-L,RC-N,RC-O,HC,HC-B,HC-D,HC-L,HC-N,009-A,009-C,009-D,009-L,009A-A,2886B-RC,2886B-RC-B,2886B-RC-D,2886B-RC-L,2886B-RC-N,12-A,12-B,12-C,12-D) >>What is the purpose of this element when there is v_guarantor_id?

3) STG_INVESTMENTS.F_TROUBLED_DEBT_RESTRUCRE_FLAG - (SVF Usage :RC-C,RC-N,HC-C,HC-N,2886B-RC-C,2886B-RC-N,12-A,12-B,12-C,12-D)
Current categorization :Data Foundation master and control data elements
>>It is not a master table, required review of categorization or removal from SVF

4) STG_INVESTMENTS.N_ALLOC_TRANS_RISK_RESERVE - (SVF Usage :RI-B,HI-B)
Current categorization :Rollup from Peer schedule
>>No peer schedule using the data element

5) a) STG_INVESTMENTS.N_RATE_CAP_LIFE
  b) STG_INVESTMENTS.N_RATE_FLOOR_LIFE
SVF Usage :RC-B,HC-B,HC-H,030-Summary,2028-D,2314-BS,2314-BS-M,2502-Q,2510-SUMMARY,2644-SUMMARY,11-BS,11-BS-M,12-A,12-B,12-C,12-D,8-SUMMARY,9LP-PC,9LP-PC-B
>>What is the requirement if usage is replaced by STG_EMBEDDED_OPTION_SCHEDULE? Should be removed from DE/SVF documentation

6) STG_INVESTMENTS.F_GUAR_BY_SOVERIGN_IND - (SVF Usage :RC-H)
Current categorization :Rollup from Peer schedule
>>No peer schedule using the data element

7) STG_INVESTMENTS.N_MKT_VALUE - (SVF Usage :14Q-B)
>>What is the requirement if usage is replaced by Fair value? Should be removed from DE/SVF documentation

8) STG_INVESTMENTS.V_BOOK_TYPE - (SVF Usage :RC-R,HC-R,14Q-D,2886B-RC-R,12-A,12-B,12-C,12-D)
>>What is the requirement if usage is replaced by v_holding_type? Should be removed from DE/SVF documentation
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.