PTAI_TASKS_VW

(SQL View)
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 PeopleSoft Field Type Database Column Type Description
    1 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
    2 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    3 PTAI_DESCRLONG Long Character CLOB Action Items - Long Description
    4 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    5 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Prompt Table: PSPRDMDEFN

    6 PTAI_PRIORITY Character(1) VARCHAR2(1) NOT NULL Action Items - Priority
    1=Low Priority
    2=Medium Priority
    3=High Priority
    7 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
    8 PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
    9 PTAI_SORT_DATE Date(10) DATE Action Items - Sort Date (used for sorting purposes since Due Date can be null)
    10 PTAI_ASSIGN_DT Date(10) DATE Action Items - Assigned Date
    11 PTAI_ASSIGN_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Assigned to User
    12 PTAI_CATEGORY Character(30) VARCHAR2(30) NOT NULL Action Items - Category
    13 PTAI_RES_DATE Date(10) DATE Action Items - Resolve/Complete Date
    14 PTAI_RES_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Resolved By User
    15 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    16 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    17 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.
    18 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.