TR_PORT_MODL_VW

(SQL View)
 Index Back

MTM Port. Instr. model view

Mark To Market and Instrument type mapping tool. Used to define the specific model and function useage.

SELECT DISTINCT A.MTM_FN_USAGE, A.MTM_MODEL FROM PS_INSTR_MTM_FNC_H A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 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