RSK_GRP_FRM_VW(SQL View) |
Index Back |
|---|---|
Repository for firm-wide analyThis table contains the results of ERM firm-wide analysis |
| SELECT A.OPRID , B.BUSINESS_UNIT , B.MTM_FN_USAGE , B.RSK_ANL_TYPE , B.EFFDT , B.SEQNUM , B.CURRENCY_CD FROM PS_RSK_GRP_ANL_TBL A , PS_RSK_FRM_ANL_TBL B WHERE A.BUSINESS_UNIT = A.BUSINESS_UNIT AND A.MTM_FN_USAGE = B.MTM_FN_USAGE AND A.RSK_ANL_TYPE = B.RSK_ANL_TYPE AND A.EFFDT = B.EFFDT AND A.SEQNUM = B.SEQNUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | 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 |
| 4 | RSK_ANL_TYPE |
Character(15) | VARCHAR2(15) NOT NULL | Firm-wide analysis type |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |