MTM_PROG_STEP_V(SQL View) |
Index Back |
|---|---|
MTM Program Steps ViewMTM Processing Program Steps view. The steps can call Analytic Functions, execute SQL statements, perform arithmetic operations, and use temporary variables to pass results of one step to the next. This view primarily serves for populating the panel scroll that runs the deal analytics. |
| select mtm_vendor_nm, mtm_program_nm, seq_num, mtm_operand_type, mtm_operand_type_2, mtm_operator_type, mtm_user_constant, mtm_usr_constant_2, mtm_func_nm, mtm_sqlcntrl_id, mtm_sql_ctrl_id_2, mtm_variable_name, mtm_variable_nm_2, mtm_tmp_variable, mtm_save_flag, mtm_sql_ctrl_id_3 from PS_MTM_PROG_STEP |
| # | 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
Default Value: 1 |
| 4 | MTM_OPERAND_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
MTM Processing Operand Type 1
A=Function C=Constant S=SQL V=Variable |
| 5 | MTM_OPERAND_TYPE_2 | Character(1) | VARCHAR2(1) NOT NULL |
MTM Processing Operand Type 2.
(It doesn't have an Analytic XLAT)
C=Constant S=SQL V=Variable |
| 6 | MTM_OPERATOR_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Post Processing Operator Type
ADD=Add DIV=Divide EXP=Exponent LOG=Logarithm LOP=Loop MAX=Maximum MIN=Minimum MLS=Multiply by Sign MUL=Multiply RET=Return SUB=Subtract |
| 7 | 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 |
| 8 | MTM_USR_CONSTANT_2 | Character(20) | VARCHAR2(20) NOT NULL | Constant |
| 9 | MTM_FUNC_NM | Character(30) | VARCHAR2(30) NOT NULL |
The user defined name for a given analytics function.
Prompt Table: MTM_FUNC_HDR |
| 10 | MTM_SQLCNTRL_ID | Character(20) | VARCHAR2(20) NOT NULL |
The system code used to identify a Treasury MTM SQL statement
Prompt Table: MTM_SQL_SLCT_VW |
| 11 | MTM_SQL_CTRL_ID_2 | Character(20) | VARCHAR2(20) NOT NULL |
Evaluation SQL ID
Prompt Table: MTM_SQL_SLCT_VW |
| 12 | MTM_VARIABLE_NAME | Character(20) | VARCHAR2(20) NOT NULL | MTM Variable name. Used in the post processing of analytic valuation |
| 13 | MTM_VARIABLE_NM_2 | Character(20) | VARCHAR2(20) NOT NULL | MTM Variable name. Used in the post processing of analytic valuation |
| 14 | MTM_TMP_VARIABLE | Character(30) | VARCHAR2(30) NOT NULL | Tempory Variable to store the resultant of two arithmatic operations for that program step. |
| 15 | MTM_SAVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Analytics results save yes no flag.
If Yes, then the result of the program step (the result Variable) will be saved to the database using the Save SQL.
Y/N Table Edit Default Value: N |
| 16 | MTM_SQL_CTRL_ID_3 | Character(20) | VARCHAR2(20) NOT NULL |
Evaluation SQL ID
Prompt Table: MTM_SQL_SAVE_VW |