MTM_FNPARM_TBL

(SQL Table)
Index Back

MTM Ext Function Detail

Mapping 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