MTM_PROG_STEP(SQL Table) |
Index Back |
|---|---|
MTM Program StepsMTM Processing Program Steps. 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. |
| # | 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 |