PTLT_PROJFEATVW

index back

Project Feature View


SELECT DISTINCT A.PTLT_PROJ_NAME , B.PTLT_TASK_SEQNO , A.DESCR50 , B.PTLT_TASK_NAME , B.DESCR254_MIXED , D.PTLT_FEATURE_CODE , D.PTLT_FEATURE FROM %Table(PTLT_PROJ_DEFN) A , %Table(PTLT_PROJ_TASK) B , %Table(PTLT_ASSGN_TASK) C , %Table(PTLT_FEATURE) D WHERE A.PTLT_PROJ_NAME = B.PTLT_PROJ_NAME AND B.PTLT_TASK_CODE = C.PTLT_TASK_CODE AND C.PTLT_FEATURE_CODE = D.PTLT_FEATURE_CODE

PeopleSoft Field Name Field Type Column Type Description
PTLT_PROJ_NAME Character(15) VARCHAR2(15) NOT NULL Used in Setup Manager v2.0 for Implementation Project Name.
PTLT_TASK_SEQNO Number(9,3) DECIMAL(8,3) NOT NULL Task ID
DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
PTLT_TASK_NAME Character(30) VARCHAR2(30) NOT NULL Task Name
DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
PTLT_FEATURE_CODE Character(10) VARCHAR2(10) NOT NULL Unique code identifying a feature
PTLT_FEATURE Character(50) VARCHAR2(50) NOT NULL Defintion of a feature
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19