RSK_GRP_FRMA_VW

(SQL View)
 Index Back

Repository for firm-wide analy

This table contains the results of ERM firm-wide analysis

SELECT B.BUSINESS_UNIT , B.MTM_FN_USAGE , B.RSK_ANL_TYPE , B.EFFDT , B.SEQNUM , B.CURRENCY_CD FROM PS_RSK_FRM_ANL_TBL B WHERE B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_RSK_FRM_ANL_TBL C WHERE C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.MTM_FN_USAGE = B.MTM_FN_USAGE AND C.RSK_ANL_TYPE = B.RSK_ANL_TYPE AND C.EFFDT <=%CurrentDateIn) AND B.SEQNUM = ( SELECT MAX(D.SEQNUM) FROM PS_RSK_FRM_ANL_TBL D WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.MTM_FN_USAGE = B.MTM_FN_USAGE AND D.RSK_ANL_TYPE = B.RSK_ANL_TYPE AND D.EFFDT = B.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 MTM_FN_USAGE Character(2) VARCHAR2(2) NOT NULL This field specifies the specific analytic operation/function to be performed on that instrument type
00=MTM
01=Firm-wide Analysis
02=Convexity
03=Duration
04=MTM-A
05=File Export
06=Delta
07=Risk Measures
08=Sensitivity Analysis
09=Market Risk
10=Credit Risk
11=Operational Risk
12=Strategic Risk
13=Other
3 RSK_ANL_TYPE Character(15) VARCHAR2(15) NOT NULL Firm-wide analysis type
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code