INSTR_MTMFNC_VW(SQL View) |
Index Back |
|---|---|
Instrument MTM Function ViewMark to Market and Instrument type mapping tool. Used to define the supplier and program to use for a specific model and function usage. |
| SELECT i.setid ,i.instrument_type ,i.mtm_fn_usage ,i.mtm_model ,i.mtm_vendor_nm ,i.mtm_program_nm FROM PS_INSTR_MTM_FNC_H i |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | INSTRUMENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Instrument type |
| 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 | MTM_MODEL |
Character(10) | VARCHAR2(10) NOT NULL | Represents a more granular method by which to establish diverse analytics function usages for a given finan |
| 5 | MTM_VENDOR_NM | Character(20) | VARCHAR2(20) NOT NULL |
3rd party analytics vendor used for valuation and analytics.
Prompt Table: %EDITTABLE |
| 6 | MTM_PROGRAM_NM | Character(30) | VARCHAR2(30) NOT NULL |
MTM Valuation/Analytic processing program
Prompt Table: MTM_PROG_DEFN |