MTM_SQL_SLCT_VW (SQL View)	Index Back
MTM Select SQL Prompt View MTM SQL statements that Retrieve data from the database (used as Parameter SQL, and Operand SQL).

MTM_SQL_SLCT_VW

(SQL View)

MTM Select SQL Prompt View

MTM SQL statements that Retrieve data from the database (used as Parameter SQL, and Operand SQL).

SELECT mtm_sqlcntrl_id , mtm_ret_value , mtm_struct , descr150_mixed FROM PS_MTM_SQL_CTRL WHERE mtm_sql_type = 'R'

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_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

3 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

4 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description

#	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_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
3	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
4	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description