PTLT_PROJDTL_VW

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 NameField TypeColumn TypeDescription
PTLT_PROJ_NAMECharacter(15)VARCHAR2(15) NOT NULLUsed in Setup Manager v2.0 for Implementation Project Name.
DESCR50Character(50)VARCHAR2(50) NOT NULLDescription of length 50
PTLT_TASK_SEQNONumber(9,3)DECIMAL(8,3) NOT NULLTask ID
PTLT_TASK_NAMECharacter(30)VARCHAR2(30) NOT NULLTask Name
DESCR254_MIXEDCharacter(254)VARCHAR2(254) NOT NULLDescription
PTLT_LOAD_METHODCharacter(4)VARCHAR2(4) NOT NULLMethod of loading - has translates
CMPI=Component Interface
ETL=ETL
ONLN=Online
OTHR=Other
PTLT_METHOD_NAMECharacter(30)VARCHAR2(30) NOT NULLMethod Name
PTLT_CI_NAMECharacter(30)VARCHAR2(30) NOT NULLComponent Interface
PTLT_DETAILSLong CharacterCLOBMore Details
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PTLT_TASK_CODE2Character(30)VARCHAR2(30) NOT NULLTask Code
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
PTLT_SEQNONumber(5,0)INTEGER NOT NULLSequence Number used specifically for lifecycle tools
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19