PTLT_PROJ_UPG

(SQL Table)
Index Back

Project Task List

Setup Manager - Project Task List.

# 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_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
3 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
4 NAVIGATION Character(254) VARCHAR2(254) NOT NULL Navigation
5 PTLT_SEQNO Number(5,0) INTEGER NOT NULL Sequence Number used specifically for lifecycle tools
6 PTLT_SEC_SEQNO Number(5,0) INTEGER NOT NULL Secondary Sequence field for Setup Component definition in Setup Manager
7 PTLT_TASK_NAME Character(30) VARCHAR2(30) NOT NULL Task Name
8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 PTLT_PROD_CD_LIST Character(100) VARCHAR2(100) NOT NULL Product Code List for Result Set page in Setup Manager
10 PTLT_LOAD_METHOD Character(4) VARCHAR2(4) NOT NULL Method of loading - has translates
CMPI=Component Interface
ETL=ETL
ONLN=Online
OTHR=Other
11 PTLT_ASSIGNED_TO Character(50) VARCHAR2(50) NOT NULL Assignment field in Result Set page in Setup Manager
12 PTLT_START_DATE Date(10) DATE Start date field for Result Set page in Setup Manager
13 PTLT_END_DATE Date(10) DATE End date field for Result Set page in Setup Manager
14 PTLT_DISCUSSION Long Character CLOB Long Text Fields for Discussion
15 PTLT_PCT_COMPLETE Number(3,0) SMALLINT NOT NULL Percentage Complete field for Result Set page in Setup Manager
16 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.
17 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.
18 PTLT_TASK_SEQNOF Number(9,3) DECIMAL(8,3) NOT NULL