MTM_PG_FUNC_V(SQL View) |
Index Back |
|---|---|
MTM PROGRAM FUNC DEFN/DETL VWDefines the program function defn/detail data for revaluation. |
| SELECT a.mtm_vendor_nm , a.mtm_program_nm , a.seq_num , e.mtm_func_seq , a.mtm_func_nm , d.mtm_addin_flag , d.mtm_access_info , d.mtm_wrkbook_nm , d.mtm_wrksht_nm , d.mtm_ret_value , d.mtm_output_rng_nm , d.mtm_struct , d.mtm_map_type , e.mtm_fn_cell_loc , e.mtm_fnexec_txt , e.mtm_fncall_txt , e.mtm_macro_txt , e.mtm_fn_object_nm , e.mtm_fnc_or_prop , e.mtm_property_nm , e.mtm_error_ret_val FROM PS_MTM_PROG_STEP a , ps_mtm_func_hdr d , ps_mtm_fndefn_tbl e WHERE d.mtm_vendor_nm = a.mtm_vendor_nm AND d.mtm_func_nm = a.mtm_func_nm AND e.mtm_vendor_nm = a.mtm_vendor_nm AND e.mtm_func_nm = a.mtm_func_nm |
| # | 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_FUNC_NM | Character(30) | VARCHAR2(30) NOT NULL | The user defined name for a given analytics function. |
| 6 | 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 |
| 7 | 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 |
| 8 | MTM_WRKBOOK_NM | Character(30) | VARCHAR2(30) NOT NULL | The Microsoft Excel workbook that contains the associated third party analytics function. |
| 9 | MTM_WRKSHT_NM | Character(20) | VARCHAR2(20) NOT NULL | The Microsoft Excel worksheet that contains the associated third party analytics function. |
| 10 | 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 |
| 11 | 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 |
| 12 | 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 |
| 13 | 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 |
| 14 | 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 |
| 15 | MTM_FNEXEC_TXT | Character(254) | VARCHAR2(254) NOT NULL | An internal field that contains specialized PeopleCode dedicated to converting a user de |
| 16 | MTM_FNCALL_TXT | Character(254) | VARCHAR2(254) NOT NULL | Represents the user definition of a analytics function call. |
| 17 | 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 |
| 18 | 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 |
| 19 | 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 |
| 20 | MTM_PROPERTY_NM | Character(30) | VARCHAR2(30) NOT NULL | Property Name |
| 21 | 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 |