MTM_FNPARM_TBL(SQL Table) |
Index Back |
---|---|
MTM Ext Function DetailMapping Tool, parameter definition |
# | 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. |
2 | MTM_FUNC_NM | Character(30) | VARCHAR2(30) NOT NULL | The user defined name for a given analytics function. |
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 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
5 | MTM_PARAM_NM | Character(20) | VARCHAR2(20) NOT NULL |
The user defined data parameter name assigned to a specific datum associated with Treasury product deal
Prompt Table: MTM_PARMNM_VW |
6 | MTM_ABSOLUTE_VALUE | Character(1) | VARCHAR2(1) NOT NULL |
Take the Absolute Value of the MTM parameter and pass that to the function (used when the function does not like signed numbers)
Y/N Table Edit Default Value: N |
7 | REQUIRED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Book is Required
Y/N Table Edit Default Value: N |
8 | 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 Prompt Table: MTM_VNM_MAP_VW |
9 | MTM_PARM_CELL_LOC | Character(30) | VARCHAR2(30) NOT NULL | The designated Microsoft Excel cell address location in which an enabled third party analytics function |
10 | MTM_VARIABLE_NAME | Character(20) | VARCHAR2(20) NOT NULL | MTM Variable name. Used in the post processing of analytic valuation |
11 | PASSBYREF_OR_VALUE | Character(2) | VARCHAR2(2) NOT NULL |
Indicates whether an analytic function parameter is passed by reference or its direct val
00=Reference 01=Value |