RSK_GRP_FRM_TBL(SQL Table) |
Index Back |
|---|---|
Repository for firm-wide analyThis table contains the results of ERM firm-wide analysis |
| # | 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 | RSK_ANL_GROUP |
Character(15) | VARCHAR2(15) NOT NULL | Group ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | 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 |
| 5 | RSK_ANL_TYPE |
Character(15) | VARCHAR2(15) NOT NULL | Firm-wide analysis type |
| 6 | EFFDT |
Date(10) | DATE | Effective Date |
| 7 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | RSK_ANL_VAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The calculated amount of the analysis done at the firm wide level. |