MTM_SQL_CTRL

(SQL Table)
 Index Back

MTM SQL eval Table

MTM table that has all the SQL statements used in the MTM/Risk management process.

  • Related Language Record: MTM_SQL_CN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MTM_SQLCNTRL_ID Character(20) VARCHAR2(20) NOT NULL The system code used to identify a Treasury MTM SQL statement

    Prompt Table: MTM_SQLCTRL_VW

    2 MTM_SQL_TYPE Character(1) VARCHAR2(1) NOT NULL Does the MTM SQL statement Save to the database ("U" - UPDATE/INSERT/DELETE), or Select from the database ("R")
    R=Select from Database
    U=Save to Database

    Default Value: R

    3 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

    Default Value: 00

    4 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

    Prompt Table: MTM_STRUC_DEFN

    5 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
    6 MTM_SENS_SQL_EXE Character(1) VARCHAR2(1) NOT NULL This field allows the user to determine whether the particular SQL statement is being used at the Portfolio level or at any other level.

    Y/N Table Edit

    Default Value: N

    7 MTM_SQL_CTRL_ID_2 Character(20) VARCHAR2(20) NOT NULL Evaluation SQL ID

    Prompt Table: MTM_SQLCTRL_VW

    8 SQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.