MTM_FLE_SRCH_VW (SQL View)	Index Back
Analytic functions for FileExp View over analytic functions that are used in File Export Functions

MTM_FLE_SRCH_VW

(SQL View)

Analytic functions for FileExp

View over analytic functions that are used in File Export Functions

SELECT mtm_vendor_nm , mtm_func_nm , mtm_map_type , descr FROM PS_MTM_FUNC_HDR WHERE mtm_map_type = 'FE'

Related Language Record: MTM_FN_HDR_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_FLE_VW

2 MTM_FUNC_NM Character(30) VARCHAR2(30) NOT NULL The user defined name for a given analytics function.
Prompt Table: MTM_V_FILEXP_VW

3 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
Default Value: FN

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

#	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_FLE_VW
2	MTM_FUNC_NM	Character(30)	VARCHAR2(30) NOT NULL	The user defined name for a given analytics function. Prompt Table: MTM_V_FILEXP_VW
3	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 Default Value: FN
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description