PTLT_PROJDTL_VW

(SQL View)
 Index Back

Project Load Mtd Details View


SELECT A.PTLT_PROJ_NAME , A.DESCR50 , B.PTLT_TASK_SEQNO , B.PTLT_TASK_NAME , B.DESCR254_MIXED , D.PTLT_LOAD_METHOD , D.PTLT_METHOD_NAME , D.PTLT_CI_NAME , D.PTLT_DISCUSSION , D.PORTAL_NAME , D.PTLT_TASK_CODE2 , D.MENUNAME , D.PTLT_SEQNO FROM %Table(PTLT_PROJ_DEFN) A , %Table(PTLT_PROJ_TASK) B , %Table(PTLT_TASK) C , %Table(PTLT_TASK_LOAD) D WHERE A.PTLT_PROJ_NAME = B.PTLT_PROJ_NAME AND B.PTLT_TASK_CODE = C.PTLT_TASK_CODE AND C.PTLT_TASK_TYPE = 'C' AND C.PTLT_TASK_CODE = D.PTLT_TASK_CODE AND D.SELECT_FLAG = 'Y'

# 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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
3 PTLT_TASK_SEQNO Number(9,3) DECIMAL(8,3) NOT NULL Task ID
4 PTLT_TASK_NAME Character(30) VARCHAR2(30) NOT NULL Task Name
5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
6 PTLT_LOAD_METHOD Character(4) VARCHAR2(4) NOT NULL Method of loading - has translates
CMPI=Component Interface
ETL=ETL
ONLN=Online
OTHR=Other
7 PTLT_METHOD_NAME Character(30) VARCHAR2(30) NOT NULL Method Name
8 PTLT_CI_NAME Character(30) VARCHAR2(30) NOT NULL Component Interface
9 PTLT_DETAILS Long Character CLOB More Details
10 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
11 PTLT_TASK_CODE2 Character(30) VARCHAR2(30) NOT NULL Task Code
12 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
13 PTLT_SEQNO Number(5,0) INTEGER NOT NULL Sequence Number used specifically for lifecycle tools