MTM_SQL_SAVE_VW (SQL View)	Index Back
MTM Save SQL Prompt View MTM SQL statements that Save (INSERT/UPDATE/DELETE) data to the database (used as Save SQL)

MTM_SQL_SAVE_VW

(SQL View)

MTM Save SQL Prompt View

MTM SQL statements that Save (INSERT/UPDATE/DELETE) data to the database (used as Save SQL)

select mtm_sqlcntrl_id ,descr150_mixed from PS_MTM_SQL_CTRL where mtm_sql_type = 'U'

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