MTM_PROG_FNPARM

#	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.
2	MTM_PROGRAM_NM	Character(30)	VARCHAR2(30) NOT NULL	MTM Valuation/Analytic processing program
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	MTM_FUNC_SEQ	Number(2,0)	SMALLINT NOT NULL	A sequential value utilized in order to determine the calling or submission sequence of a series of a
5	MTM_PARM_SEQ	Number(2,0)	SMALLINT NOT NULL	Parameter Sequence
6	MTM_FUNC_NM	Character(30)	VARCHAR2(30) NOT NULL	The user defined name for a given analytics function.
7	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
8	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
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
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_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
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