MTM_PRG_FNPAR_V(SQL View) |
Index Back |
|---|---|
mtm_program func param viewVIEW TO SELECT ALL THE PROGRAMS, UNDERLYING FUNCTIONS AND THEIR PARAMETERS |
| SELECT a.mtm_vendor_nm , c.mtm_program_nm , c.seq_num , c.mtm_func_seq , c.mtm_parm_seq , b.mtm_func_nm , b.mtm_addin_flag , b.mtm_access_info , a.mtm_fn_or_mcro_flg , a.mtm_wrkbook_flag , b.mtm_wrkbook_nm , b.mtm_wrksht_nm , b.mtm_ret_value , b.mtm_output_rng_nm , b.mtm_struct , b.mtm_map_type , b.mtm_fn_cell_loc , b.mtm_fnexec_txt , b.mtm_fncall_txt , b.mtm_macro_txt , b.mtm_fn_object_nm , b.mtm_fnc_or_prop , b.mtm_property_nm , b.mtm_error_ret_val , c.mtm_param_nm , c.mtm_parmeval_type , c.mtm_user_constant , c.mtm_sqlcntrl_id , c.mtm_variable_name , c.mtm_parm_cell_loc , c.required_sw , c.mtm_absolute_value , c.mtm_data_type , c.mtm_transl_yes_no FROM PS_MTM_PG_VNDR_V a , ps_mtm_pg_func_v b , ps_mtm_pg_par_anl c WHERE b.mtm_vendor_nm = a.mtm_vendor_nm AND b.mtm_program_nm = a.mtm_program_nm AND c.mtm_vendor_nm = b.mtm_vendor_nm AND c.mtm_program_nm = b.mtm_program_nm AND c.seq_num = b.seq_num AND c.mtm_func_seq = b.mtm_func_seq |
| # | 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_PROGRAM_NM |
Character(30) | VARCHAR2(30) NOT NULL | MTM Valuation/Analytic processing program |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | 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 |
| 5 | MTM_PARM_SEQ |
Number(2,0) | SMALLINT NOT NULL | Parameter Sequence |
| 6 | MTM_FUNC_NM | Character(30) | VARCHAR2(30) NOT NULL | The user defined name for a given analytics function. |
| 7 | MTM_ADDIN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Allows the user to indicate whether a Microsoft Excel Add-In is required in order to utilize a given third part |
| 8 | MTM_ACCESS_INFO | Character(40) | VARCHAR2(40) NOT NULL | The Microsoft Excel Add-In file directory and file name required to access third party analytics softwar |
| 9 | MTM_FN_OR_MCRO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to designate whether a Microsoft Excel-based third party analytics solution
F=Function M=Macro |
| 10 | MTM_WRKBOOK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Allows the user to indicate that a Microsoft Excel workbook object is required in order to execut |
| 11 | MTM_WRKBOOK_NM | Character(30) | VARCHAR2(30) NOT NULL | The Microsoft Excel workbook that contains the associated third party analytics function. |
| 12 | MTM_WRKSHT_NM | Character(20) | VARCHAR2(20) NOT NULL | The Microsoft Excel worksheet that contains the associated third party analytics function. |
| 13 | MTM_RET_VALUE | Character(3) | VARCHAR2(3) NOT NULL |
The analytic value returned from a third party analytics function call and stored within the Treasury product
00=Number 01=Character 02=Date 03=Structure |
| 14 | MTM_OUTPUT_RNG_NM | Character(20) | VARCHAR2(20) NOT NULL | Represents the designated cell range for output results from a third party analytics function when the access method is Excel Addin |
| 15 | MTM_STRUCT | Character(20) | VARCHAR2(20) NOT NULL | A unique key identifier value that represents a complex data object (rows and columns) intended to contain mult |
| 16 | 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 |
| 17 | MTM_FN_CELL_LOC | Character(30) | VARCHAR2(30) NOT NULL | The user defined Microsoft Excel spreadsheet excel location where a compatible third party analytic funct |
| 18 | MTM_FNEXEC_TXT | Character(254) | VARCHAR2(254) NOT NULL | An internal field that contains specialized PeopleCode dedicated to converting a user de |
| 19 | MTM_FNCALL_TXT | Character(254) | VARCHAR2(254) NOT NULL | Represents the user definition of a analytics function call. |
| 20 | 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 |
| 21 | MTM_FN_OBJECT_NM | Character(64) | VARCHAR2(64) NOT NULL | COM Object name. Used for creating and instantiating a COM enabled dll of analytic functions |
| 22 | MTM_FNC_OR_PROP | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if a COM sub-"function" is a Method (function call) or a Property (can be Get or Set property)
G=Get Property M=Method S=Set Property |
| 23 | MTM_PROPERTY_NM | Character(30) | VARCHAR2(30) NOT NULL | Property Name |
| 24 | MTM_ERROR_RET_VAL | Character(2) | VARCHAR2(2) NOT NULL |
Allows an Analytic function return value to be checked for error conditions
!0=Not Zero <0=Less than Zero =0=Null >0=Greater than Zero |
| 25 | 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 |
| 26 | MTM_PARMEVAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
"Represents the source of the treasury data submitted to a third party analytics function; the sou
C=Use Constant S=Use SQL V=Use Variable |
| 27 | MTM_USER_CONSTANT | Character(20) | VARCHAR2(20) NOT NULL | A user defined static constant value that may be passed as an input parameter to a third party analytics |
| 28 | MTM_SQLCNTRL_ID | Character(20) | VARCHAR2(20) NOT NULL | The system code used to identify a Treasury MTM SQL statement |
| 29 | MTM_VARIABLE_NAME | Character(20) | VARCHAR2(20) NOT NULL | MTM Variable name. Used in the post processing of analytic valuation |
| 30 | 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 |
| 31 | REQUIRED_SW | Character(1) | VARCHAR2(1) NOT NULL | Book is Required |
| 32 | 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) |
| 33 | MTM_DATA_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
The underlying database field datatype for those fields utilized in the Treasury risk module.
00=Number 01=Character 02=Date 03=Structure |
| 34 | MTM_TRANSL_YES_NO | Character(1) | VARCHAR2(1) NOT NULL | Allows the user to indicate that a parameter input for a given analytics function is to be translate |