MTM_FUNC_HDR (SQL Table)	Index Back
MTM Ext. Function Header Mark to market function definition table. Defines the header for a function.

MTM_FUNC_HDR

(SQL Table)

MTM Ext. Function Header

Mark to market function definition table. Defines the header for a function.

Related Language Record: MTM_FN_HDR_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MTM_VENDOR_NM Character(20) VARCHAR2(20) NOT NULL 3rd party analytics vendor used for valuation and analytics.
Prompt Table: MTM_VEND_FNC_VW

2 MTM_FUNC_NM Character(30) VARCHAR2(30) NOT NULL The user defined name for a given analytics function.
Prompt Table: MTM_VENDFUNC_VW

3 MTM_MAP_TYPE Character(2) VARCHAR2(2) NOT NULL The technical interface method utilized by the Treasury product to submit and receive third party analytic
CO=COM Functions
FE=File Export
FN=Function
FS=FSI Functions

4 MTM_ADDIN_FLAG Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a Microsoft Excel Add-In is required in order to utilize a given third part
Y/N Table Edit

5 MTM_ACCESS_INFO Character(40) VARCHAR2(40) NOT NULL The Microsoft Excel Add-In file directory and file name required to access third party analytics softwar

6 MTM_WRKBOOK_NM Character(30) VARCHAR2(30) NOT NULL The Microsoft Excel workbook that contains the associated third party analytics function.

7 MTM_WRKSHT_NM Character(20) VARCHAR2(20) NOT NULL The Microsoft Excel worksheet that contains the associated third party analytics function.

8 MTM_RET_VALUE Character(3) VARCHAR2(3) NOT NULL The analytic value returned from a third party analytics function call and stored within the Treasury product
00=Number
01=Character
02=Date
03=Structure
Default Value: 00

9 MTM_OUTPUT_RNG_NM Character(20) VARCHAR2(20) NOT NULL Represents the designated cell range for output results from a third party analytics function when the access method is Excel Addin

10 MTM_STRUCT Character(20) VARCHAR2(20) NOT NULL A unique key identifier value that represents a complex data object (rows and columns) intended to contain mult
Prompt Table: MTM_STRUC_DEFN

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

12 MTM_FUNC_COMMENTS Long Character CLOB The user descriptive comments associated with a given analytics function definition.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MTM_VENDOR_NM	Character(20)	VARCHAR2(20) NOT NULL	3rd party analytics vendor used for valuation and analytics. Prompt Table: MTM_VEND_FNC_VW
2	MTM_FUNC_NM	Character(30)	VARCHAR2(30) NOT NULL	The user defined name for a given analytics function. Prompt Table: MTM_VENDFUNC_VW
3	MTM_MAP_TYPE	Character(2)	VARCHAR2(2) NOT NULL	The technical interface method utilized by the Treasury product to submit and receive third party analytic CO=COM Functions FE=File Export FN=Function FS=FSI Functions
4	MTM_ADDIN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a Microsoft Excel Add-In is required in order to utilize a given third part Y/N Table Edit
5	MTM_ACCESS_INFO	Character(40)	VARCHAR2(40) NOT NULL	The Microsoft Excel Add-In file directory and file name required to access third party analytics softwar
6	MTM_WRKBOOK_NM	Character(30)	VARCHAR2(30) NOT NULL	The Microsoft Excel workbook that contains the associated third party analytics function.
7	MTM_WRKSHT_NM	Character(20)	VARCHAR2(20) NOT NULL	The Microsoft Excel worksheet that contains the associated third party analytics function.
8	MTM_RET_VALUE	Character(3)	VARCHAR2(3) NOT NULL	The analytic value returned from a third party analytics function call and stored within the Treasury product 00=Number 01=Character 02=Date 03=Structure Default Value: 00
9	MTM_OUTPUT_RNG_NM	Character(20)	VARCHAR2(20) NOT NULL	Represents the designated cell range for output results from a third party analytics function when the access method is Excel Addin
10	MTM_STRUCT	Character(20)	VARCHAR2(20) NOT NULL	A unique key identifier value that represents a complex data object (rows and columns) intended to contain mult Prompt Table: MTM_STRUC_DEFN
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	MTM_FUNC_COMMENTS	Long Character	CLOB	The user descriptive comments associated with a given analytics function definition.