MTM_EXCL_SRH_VW(SQL View) |
Index Back |
---|---|
Analytic functions for ExcelView 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' |
# | 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 |