MTM_VENDOR_NMPrompt Table: MTM_VEND_FNC_VW
MTM_FUNC_NMPrompt Table: MTM_VENDFUNC_VW
MTM_FUNC_SEQMTM_FNDEF_VW(SQL View) |
Index Back |
|---|---|
MTM Ext. Function HeaderMark to market function definition table. Defines the header for a function |
| SELECT DISTINCT mtm_vendor_nm , mtm_func_nm , mtm_func_seq , mtm_fncall_txt , mtm_macro_txt , descr FROM PS_MTM_FNDEFN_TBL |
| # | 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 | 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 |
| 4 | MTM_FNCALL_TXT | Character(254) | VARCHAR2(254) NOT NULL | Represents the user definition of a analytics function call. |
| 5 | MTM_MACRO_TXT | Character(254) | VARCHAR2(254) NOT NULL | Represents the literal Microsoft Excel text content required to invoke a macro function associated with a c |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |