MTM_PRG_FNSTRUC (SQL View)	Index Back
Mtm prog Func rslt Struct View View to hold the structured results of analytic functions and map them to the program

MTM_PRG_FNSTRUC

(SQL View)

Mtm prog Func rslt Struct View

View to hold the structured results of analytic functions and map them to the program

select d.mtm_vendor_nm, d.mtm_program_nm, d.seq_num, c.mtm_struct, b.mtm_struc_seq, b.mtm_fld_nm, b.mtm_data_type from ps_mtm_struc_parm b, ps_mtm_func_hdr c, PS_MTM_PROG_STEP d where c.mtm_vendor_nm = d.mtm_vendor_nm and c.mtm_func_nm = d.mtm_func_nm and c.mtm_ret_value = '03' and b.mtm_struct = c.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_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

5 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

6 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

7 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_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
5	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
6	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
7	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