PTLT_PROJ_CI_VW

(SQL View)
 Index Back

Project Excel to CI View

View of Tasks with available Component Interfaces for a project. Used for Excel to CI Template generation.

SELECT A.PTLT_PROJ_NAME , A.PTLT_TASK_SEQNO , A.PTLT_TASK_CODE , A.PTLT_TASK_NAME , A.NAVIGATION , C.PTLT_CI_NAME FROM %Table(PTLT_PROJ_TASK) A , %Table(PTLT_TASK) B , %Table(PTLT_TASK_LOAD) C WHERE A.PTLT_TASK_CODE = B.PTLT_TASK_CODE AND B.PTLT_TASK_CODE = C.PTLT_TASK_CODE AND B.PTLT_TASK_TYPE = 'C' AND C.PTLT_LOAD_METHOD = 'CMPI' AND C.SELECT_FLAG = 'Y' 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 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 PTLT_TASK_SEQNO Number(9,3) DECIMAL(8,3) NOT NULL Task ID
3 PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
4 PTLT_TASK_NAME Character(30) VARCHAR2(30) NOT NULL Task Name
5 NAVIGATION Character(254) VARCHAR2(254) NOT NULL Navigation
6 PTLT_CI_NAME Character(30) VARCHAR2(30) NOT NULL Component Interface