MTM_VENDOR_NMPrompt Table: MTM_VEND_FNC_VW
MTM_FUNC_NMPrompt Table: MTM_VENDFUNC_VW
MTM_FUNCDEFN_VW(SQL View) |
Index Back |
|---|---|
MTM Function Search RecordSearch record over supplier table that give analytic functions |
| select mtm_vendor_nm, mtm_func_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_FNC_VW |
| 2 | MTM_FUNC_NM |
Character(30) | VARCHAR2(30) NOT NULL |
The user defined name for a given analytics function.
Prompt Table: MTM_VENDFUNC_VW |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |