PTLT_PROJ_TASK

(SQL Table)
Index Back

Project Task List

Setup Manager - Project Task List.

  • Related Language Record: PTLT_PROJ_TSK_L
  • # 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_SEQNO Number(9,3) DECIMAL(8,3) NOT NULL Task ID
    3 PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
    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_ASSIGNED_TO Character(50) VARCHAR2(50) NOT NULL Assignment field in Result Set page in Setup Manager
    8 PTLT_START_DATE Date(10) DATE Start date field for Result Set page in Setup Manager
    9 PTLT_END_DATE Date(10) DATE End date field for Result Set page in Setup Manager
    10 PTLT_PCT_COMPLETE Number(3,0) SMALLINT NOT NULL Percentage Complete field for Result Set page in Setup Manager
    11 NAVIGATION Character(254) VARCHAR2(254) NOT NULL Navigation
    12 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    13 PTLT_TASK_CODE2 Character(30) VARCHAR2(30) NOT NULL Task Code
    14 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    15 PTLT_PROD_CD_LIST Character(100) VARCHAR2(100) NOT NULL Product Code List for Result Set page in Setup Manager
    16 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.
    17 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.
    18 PTLT_DISCUSSION Long Character CLOB Long Text Fields for Discussion