MTM_PARM_DEFN (SQL Table)	Index Back
MTM Parameter Name Table This table stores the supplier parameter definitions that are needed to run the analytic programs and functions

MTM_PARM_DEFN

(SQL Table)

MTM Parameter Name Table

This table stores the supplier parameter definitions that are needed to run the analytic programs and functions

Related Language Record: MTM_PARM_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_DESC_V

2 MTM_PARAM_NM Character(20) VARCHAR2(20) NOT NULL The user defined data parameter name assigned to a specific datum associated with Treasury product deal
Prompt Table: MTM_PARMNM_VW

3 MTM_DATA_TYPE Character(2) VARCHAR2(2) NOT NULL The underlying database field datatype for those fields utilized in the Treasury risk module.
00=Number
01=Character
02=Date
03=Structure
Default Value: 00

4 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

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

6 TR_PARAM_USAGE Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given analytics function parameter definition is to be utilized
A=Analytics
E=Export
Default Value: A

7 TR_FILEX_FLD_UPDAT Character(20) VARCHAR2(20) NOT NULL An internal work field that contains parameter data required to execute the deal data export p
Prompt Table: TR_PSREC_PAR_VW

8 MTM_SQLCNTRL_ID Character(20) VARCHAR2(20) NOT NULL The system code used to identify a Treasury MTM SQL statement
Prompt Table: MTM_SQL_SLCT_VW

9 MTM_PARMEVAL_TYPE Character(1) VARCHAR2(1) NOT NULL "Represents the source of the treasury data submitted to a third party analytics function; the sou
C=Use Constant
S=Use SQL
V=Use Variable
Default Value: S
Prompt Table: MTM_PAREVAL_XLT

10 MTM_USER_CONSTANT Character(20) VARCHAR2(20) NOT NULL A user defined static constant value that may be passed as an input parameter to a third party analytics

11 MTM_PARM_CELL_LOC Character(30) VARCHAR2(30) NOT NULL The designated Microsoft Excel cell address location in which an enabled third party analytics function

12 MTM_VARIABLE_NAME Character(20) VARCHAR2(20) NOT NULL MTM Variable name. Used in the post processing of analytic valuation

13 MTM_TRANSL_YES_NO Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that a parameter input for a given analytics function is to be translate
Y/N Table Edit
Default Value: N

#	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_DESC_V
2	MTM_PARAM_NM	Character(20)	VARCHAR2(20) NOT NULL	The user defined data parameter name assigned to a specific datum associated with Treasury product deal Prompt Table: MTM_PARMNM_VW
3	MTM_DATA_TYPE	Character(2)	VARCHAR2(2) NOT NULL	The underlying database field datatype for those fields utilized in the Treasury risk module. 00=Number 01=Character 02=Date 03=Structure Default Value: 00
4	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
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	TR_PARAM_USAGE	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a given analytics function parameter definition is to be utilized A=Analytics E=Export Default Value: A
7	TR_FILEX_FLD_UPDAT	Character(20)	VARCHAR2(20) NOT NULL	An internal work field that contains parameter data required to execute the deal data export p Prompt Table: TR_PSREC_PAR_VW
8	MTM_SQLCNTRL_ID	Character(20)	VARCHAR2(20) NOT NULL	The system code used to identify a Treasury MTM SQL statement Prompt Table: MTM_SQL_SLCT_VW
9	MTM_PARMEVAL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	"Represents the source of the treasury data submitted to a third party analytics function; the sou C=Use Constant S=Use SQL V=Use Variable Default Value: S Prompt Table: MTM_PAREVAL_XLT
10	MTM_USER_CONSTANT	Character(20)	VARCHAR2(20) NOT NULL	A user defined static constant value that may be passed as an input parameter to a third party analytics
11	MTM_PARM_CELL_LOC	Character(30)	VARCHAR2(30) NOT NULL	The designated Microsoft Excel cell address location in which an enabled third party analytics function
12	MTM_VARIABLE_NAME	Character(20)	VARCHAR2(20) NOT NULL	MTM Variable name. Used in the post processing of analytic valuation
13	MTM_TRANSL_YES_NO	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that a parameter input for a given analytics function is to be translate Y/N Table Edit Default Value: N