PTLT_PROJ_NAMEPTLT_TASK_SEQNOPTLT_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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |