PTAI_ITEM_GVW

index back

Action Items Grid

Action Items Grid View - used for Inquiry (includes assigned to as well as privs)
SELECT D.OPRID , 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 , B.PTAI_ACTIVE_FLG FROM PS_PTAI_ITEM A , PS_PTAI_LIST B , PSOPRDEFN D WHERE B.PTAI_LIST_ID = A.PTAI_LIST_ID AND (EXISTS ( SELECT 'X' FROM PS_PTAI_LIST_PRIV F WHERE F.PTAI_LIST_ID = A.PTAI_LIST_ID AND EXISTS ( SELECT 'X' FROM PSROLEUSER X WHERE X.ROLEUSER = D.OPRID AND ((F.PTAI_MBR_TYPE = 'USER' AND F.PTAI_MBR_NAME = X.ROLEUSER) OR (F.PTAI_MBR_TYPE = 'ROLE' AND F.PTAI_MBR_NAME = X.ROLENAME)))) OR A.PTAI_ASSIGN_OPRID = D.OPRID)

  • Related language record: PTAI_ITEM_GLVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PTAI_ITEM_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item ID
    PTAI_LABELCharacter(100)VARCHAR2(100) NOT NULLAction Items - Label
    PTAI_DESCRLONGLong CharacterCLOBAction Items - Long Description
    PTAI_LIST_IDCharacter(31)VARCHAR2(31) NOT NULLAction Items - Action Item List ID
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).

    Prompt Table: PSPRDMDEFN

    PTAI_PRIORITYCharacter(1)VARCHAR2(1) NOT NULLAction Items - Priority
    1=Low Priority
    2=Medium Priority
    3=High Priority
    PTAI_STATUSCharacter(1)VARCHAR2(1) NOT NULLAction Items - Status
    0=Not Assigned
    1=Assigned
    2=In Progress
    3=On Hold
    4=Completed
    5=Cancelled
    PTAI_DUE_DATEDate(10)DATEAction Items - Due Date
    PTAI_SORT_DATEDate(10)DATEAction Items - Sort Date (used for sorting purposes since Due Date can be null)
    PTAI_ASSIGN_DTDate(10)DATEAction Items - Assigned Date
    PTAI_ASSIGN_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAction Items - Assigned to User
    PTAI_CATEGORYCharacter(30)VARCHAR2(30) NOT NULLAction Items - Category
    PTAI_RES_DATEDate(10)DATEAction Items - Resolve/Complete Date
    PTAI_RES_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAction Items - Resolved By User
    CREATED_DTTMDateTime(26)TIMESTAMPCreated Datetime
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    LAST_UPDATE_DTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    PTAI_ACTIVE_FLGCharacter(1)VARCHAR2(1) NOT NULLAction Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19