MTM_PRG_PARSTRC (SQL View)	Index Back
Mtm prog Parm Structure View View to hold the structured parameters of anlytic functions and map them to the program

MTM_PRG_PARSTRC

(SQL View)

Mtm prog Parm Structure View

View to hold the structured parameters of anlytic functions and map them to the program

select c.mtm_vendor_nm, c.mtm_program_nm, c.seq_num, c.mtm_func_seq, c.mtm_parm_seq, a.mtm_struct, a.mtm_struc_seq, b.mtm_param_nm, a.mtm_fld_nm, a.mtm_data_type from ps_mtm_struc_parm a, ps_mtm_parm_defn b, PS_MTM_PROG_FNPARM c where b.mtm_vendor_nm = c.mtm_vendor_nm and b.mtm_param_nm = c.mtm_param_nm and b.mtm_data_type = '03' and a.mtm_struct = b.mtm_struct

# 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_PROGRAM_NM Character(30) VARCHAR2(30) NOT NULL MTM Valuation/Analytic processing program

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Prompt Table: MTM_FNPARM_TBL

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_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_PARM

7 MTM_STRUC_SEQ Number(3,0) SMALLINT NOT NULL A sequential value utilized to identify the number of rows contained in an analytics parameter structure matr

8 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

9 MTM_FLD_NM Character(20) VARCHAR2(20) NOT NULL A database field name utilized in describing a matrix component of a user defined analytics input data structu

10 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

#	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_PROGRAM_NM	Character(30)	VARCHAR2(30) NOT NULL	MTM Valuation/Analytic processing program
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Prompt Table: MTM_FNPARM_TBL
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_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_PARM
7	MTM_STRUC_SEQ	Number(3,0)	SMALLINT NOT NULL	A sequential value utilized to identify the number of rows contained in an analytics parameter structure matr
8	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
9	MTM_FLD_NM	Character(20)	VARCHAR2(20) NOT NULL	A database field name utilized in describing a matrix component of a user defined analytics input data structu
10	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