INSTR_MTM_FNC_H (SQL Table)	Index Back
Mtm Data Src Map Header Table Mark To Market and Instrument type mapping tool. Used to define the supplier to use for a specific model and function useage.

INSTR_MTM_FNC_H

(SQL Table)

Mtm Data Src Map Header Table

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

# 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
Prompt Table: INSTR_MTM_MDL_V

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

7 OPT_TRANSACT_LINE Number(3,0) SMALLINT NOT NULL Points to the line in a deal which the current line underlies. That is, the line number pointed to by this field must be either exercised or settled physically for the line containing this field to become 'real'.

#	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 Prompt Table: INSTR_MTM_MDL_V
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
7	OPT_TRANSACT_LINE	Number(3,0)	SMALLINT NOT NULL	Points to the line in a deal which the current line underlies. That is, the line number pointed to by this field must be either exercised or settled physically for the line containing this field to become 'real'.