PTLT_SETUP_VW (SQL View)	Index Back
Implementation Task List View Used in Setup Manager v2.0. Used as Search Record for Manage Setup Tasks page.

PTLT_SETUP_VW

(SQL View)

Implementation Task List View

Used in Setup Manager v2.0. Used as Search Record for Manage Setup Tasks page.

SELECT PTLT_PROJ_NAME , DESCR50 , IN_PROCESS_FLG FROM %Table(PTLT_PROJ_DEFN) WHERE PTLT_PROJ_NAME IN ( SELECT DISTINCT PTLT_PROJ_NAME FROM %Table(PTLT_PROJ_TASK))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTLT_PROJ_NAME Character(15) VARCHAR2(15) NOT NULL Used in Setup Manager v2.0 for Implementation Project Name.

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTLT_PROJ_NAME	Character(15)	VARCHAR2(15) NOT NULL	Used in Setup Manager v2.0 for Implementation Project Name.
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In Process