PTLT_PROJ_NAMEPTLT_TASK_SEQNOPTLT_PROJ_DM_VW(SQL View) |
Index Back |
|---|---|
Project Datamover vwView 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 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_NODMS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag to disable data mover exporting |