MTM_EXCL_SRH_VW

(SQL View)
Index Back

Analytic functions for Excel

View over analytic functions that are used in Excel

select mtm_vendor_nm, mtm_func_nm, mtm_map_type, mtm_wrkbook_nm, descr from PS_MTM_FUNC_HDR where mtm_map_type = 'FN'

  • 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_FIL_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 MTM_WRKBOOK_NM Character(30) VARCHAR2(30) NOT NULL The Microsoft Excel workbook that contains the associated third party analytics function.
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description