PTLT_PROJ_DM_VW

index back

Project Datamover vw

View of Component Tasks for a project. Used for Datamover generation.
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 NameField TypeColumn TypeDescription
PTLT_PROJ_NAMECharacter(15)VARCHAR2(15) NOT NULLUsed in Setup Manager v2.0 for Implementation Project Name.
PTLT_TASK_SEQNONumber(9,3)DECIMAL(8,3) NOT NULLTask ID
PTLT_TASK_CODECharacter(30)VARCHAR2(30) NOT NULLTask Code
PTLT_TASK_NAMECharacter(30)VARCHAR2(30) NOT NULLTask Name
NAVIGATIONCharacter(254)VARCHAR2(254) NOT NULLNavigation
PTLT_NODMS_FLAGCharacter(1)VARCHAR2(1) NOT NULLFlag to disable data mover exporting
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19