PTLT_PROJ_UPG

index back

Project Task List

Setup Manager - Project Task List.

PeopleSoft Field NameField TypeColumn TypeDescription
PTLT_PROJ_NAMECharacter(15)VARCHAR2(15) NOT NULLUsed in Setup Manager v2.0 for Implementation Project Name.
PTLT_TASK_CODECharacter(30)VARCHAR2(30) NOT NULLTask Code
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
NAVIGATIONCharacter(254)VARCHAR2(254) NOT NULLNavigation
PTLT_SEQNONumber(5,0)INTEGER NOT NULLSequence Number used specifically for lifecycle tools
PTLT_SEC_SEQNONumber(5,0)INTEGER NOT NULLSecondary Sequence field for Setup Component definition in Setup Manager
PTLT_TASK_NAMECharacter(30)VARCHAR2(30) NOT NULLTask Name
DESCR254_MIXEDCharacter(254)VARCHAR2(254) NOT NULLDescription
PTLT_PROD_CD_LISTCharacter(100)VARCHAR2(100) NOT NULLProduct Code List for Result Set page in Setup Manager
PTLT_LOAD_METHODCharacter(4)VARCHAR2(4) NOT NULLMethod of loading - has translates
CMPI=Component Interface
ETL=ETL
ONLN=Online
OTHR=Other
PTLT_ASSIGNED_TOCharacter(50)VARCHAR2(50) NOT NULLAssignment field in Result Set page in Setup Manager
PTLT_START_DATEDate(10)DATEStart date field for Result Set page in Setup Manager
PTLT_END_DATEDate(10)DATEEnd date field for Result Set page in Setup Manager
PTLT_DISCUSSIONLong CharacterCLOBLong Text Fields for Discussion
PTLT_PCT_COMPLETENumber(3,0)SMALLINT NOT NULLPercentage Complete field for Result Set page in Setup Manager
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
PTLT_TASK_SEQNOFNumber(9,3)DECIMAL(8,3) NOT NULL
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19