MTM_PRG_FILEX_V (SQL View)	Index Back
mtm_program filexp param view vIEW TO SELECT ALL THE PROGRAMS, UNDERLYING filexport definitions AND their PARAMETERS.

MTM_PRG_FILEX_V

(SQL View)

mtm_program filexp param view

vIEW TO SELECT ALL THE PROGRAMS, UNDERLYING filexport definitions AND their PARAMETERS.

SELECT DISTINCT a.mtm_vendor_nm , c.mtm_program_nm , c.seq_num , c.mtm_func_seq , c.mtm_parm_seq , b.mtm_func_nm , b.mtm_map_type , b.mtm_fncall_txt , c.mtm_param_nm , c.mtm_parmeval_type , c.mtm_user_constant , c.mtm_sqlcntrl_id , c.mtm_data_type , c.mtm_transl_yes_no , a.tr_stage_tbl_recnm , c.tr_filex_fld_updat FROM ps_mtm_pg_parm_v c , PS_MTM_PG_VNDR_V a , ps_mtm_pg_func_v b WHERE b.mtm_program_nm = a.mtm_program_nm AND c.mtm_program_nm = a.mtm_program_nm AND b.mtm_program_nm = c.mtm_program_nm AND b.seq_num = c.seq_num AND b.mtm_func_seq = c.mtm_func_seq AND a.mtm_vendor_nm = b.mtm_vendor_nm AND b.mtm_vendor_nm = c.mtm_vendor_nm AND b.mtm_map_type = 'FE'

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

8 MTM_FNCALL_TXT Character(254) VARCHAR2(254) NOT NULL Represents the user definition of a analytics function call.

9 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

10 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

11 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

12 MTM_SQLCNTRL_ID Character(20) VARCHAR2(20) NOT NULL The system code used to identify a Treasury MTM SQL statement

13 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

14 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

15 TR_STAGE_TBL_RECNM Character(15) VARCHAR2(15) NOT NULL An internal work field that contains the EDI staging table name.

16 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

#	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_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
8	MTM_FNCALL_TXT	Character(254)	VARCHAR2(254) NOT NULL	Represents the user definition of a analytics function call.
9	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
10	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
11	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
12	MTM_SQLCNTRL_ID	Character(20)	VARCHAR2(20) NOT NULL	The system code used to identify a Treasury MTM SQL statement
13	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
14	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
15	TR_STAGE_TBL_RECNM	Character(15)	VARCHAR2(15) NOT NULL	An internal work field that contains the EDI staging table name.
16	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