PTLT_PROJ_DM_VW

Platform	View Text
Default	SELECT A.PTLT_PROJ_NAME , A.PTLT_TASK_SEQNO , A.PTLT_TASK_CODE , A.PTLT_TASK_NAME , A.NAVIGATION , B.PTLT_NODMS_FLAG FROM %Table(PTLT_PROJ_TASK) A , %Table(PTLT_TASK) B WHERE A.PTLT_TASK_CODE = B.PTLT_TASK_CODE AND B.PTLT_TASK_TYPE = 'C' AND A.PTLT_TASK_SEQNO = ( SELECT MIN(PTLT_TASK_SEQNO) FROM %Table(PTLT_PROJ_TASK) WHERE PTLT_PROJ_NAME = A.PTLT_PROJ_NAME AND PTLT_TASK_CODE = A.PTLT_TASK_CODE)

PeopleSoft Field Name	Description
PTLT_PROJ_NAME	Used in Setup Manager v2.0 for Implementation Project Name.
PTLT_TASK_SEQNO	Task ID
PTLT_TASK_CODE	Task Code
PTLT_TASK_NAME	Task Name
NAVIGATION
PTLT_NODMS_FLAG	Flag to disable data mover exporting

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010