PTAI_TASKS_VW

 index back

Action Items in Tasks

Action Items for Tasks pagelet
SELECT A.PTAI_ITEM_ID , A.PTAI_LABEL , A.PTAI_DESCRLONG , A.PTAI_LIST_ID , B.PORTAL_NAME , A.PTAI_PRIORITY , A.PTAI_STATUS , A.PTAI_DUE_DATE , A.PTAI_DUE_DATE , A.PTAI_ASSIGN_DT , A.PTAI_ASSIGN_OPRID , A.PTAI_CATEGORY , A.PTAI_RES_DATE , A.PTAI_RES_OPRID , A.CREATED_DTTM , A.CREATEOPRID , A.LAST_UPDATE_DTTM , A.LASTUPDOPRID FROM PS_PTAI_ITEM A , PS_PTAI_LIST B WHERE B.PTAI_LIST_ID = A.PTAI_LIST_ID

  • Related language record: PTAI_TASKS_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
    PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    PTAI_DESCRLONG Long Character CLOB Action Items - Long Description
    PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Prompt Table: PSPRDMDEFN

    PTAI_PRIORITY Character(1) VARCHAR2(1) NOT NULL Action Items - Priority
    1=Low Priority
    2=Medium Priority
    3=High Priority
    PTAI_STATUS Character(1) VARCHAR2(1) NOT NULL Action Items - Status
    0=Not Assigned
    1=Assigned
    2=In Progress
    3=On Hold
    4=Completed
    5=Cancelled
    6=Denied
    PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
    PTAI_SORT_DATE Date(10) DATE Action Items - Sort Date (used for sorting purposes since Due Date can be null)
    PTAI_ASSIGN_DT Date(10) DATE Action Items - Assigned Date
    PTAI_ASSIGN_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Assigned to User
    PTAI_CATEGORY Character(30) VARCHAR2(30) NOT NULL Action Items - Category
    PTAI_RES_DATE Date(10) DATE Action Items - Resolve/Complete Date
    PTAI_RES_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Resolved By User
    CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    LAST_UPDATE_DTTM 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.
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20