PTLT_PROJ_UPG

index back

Project Task List

Setup Manager - Project Task List.

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_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
NAVIGATION Character(254) VARCHAR2(254) NOT NULL Navigation
PTLT_SEQNO Number(5,0) INTEGER NOT NULL Sequence Number used specifically for lifecycle tools
PTLT_SEC_SEQNO Number(5,0) INTEGER NOT NULL Secondary Sequence field for Setup Component definition in Setup Manager
PTLT_TASK_NAME Character(30) VARCHAR2(30) NOT NULL Task Name
DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
PTLT_PROD_CD_LIST Character(100) VARCHAR2(100) NOT NULL Product Code List for Result Set page in Setup Manager
PTLT_LOAD_METHOD Character(4) VARCHAR2(4) NOT NULL Method of loading - has translates
CMPI=Component Interface
ETL=ETL
ONLN=Online
OTHR=Other
PTLT_ASSIGNED_TO Character(50) VARCHAR2(50) NOT NULL Assignment field in Result Set page in Setup Manager
PTLT_START_DATE Date(10) DATE Start date field for Result Set page in Setup Manager
PTLT_END_DATE Date(10) DATE End date field for Result Set page in Setup Manager
PTLT_DISCUSSION Long Character CLOB Long Text Fields for Discussion
PTLT_PCT_COMPLETE Number(3,0) SMALLINT NOT NULL Percentage Complete field for Result Set page in Setup Manager
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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_SEQNOF Number(9,3) DECIMAL(8,3) NOT NULL
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19