PTAI_ITEM_SVW

index back

Action Items View

Action Items View - used for Browse
SELECT D.OPRID , A.PTAI_ITEM_ID , A.PTAI_LABEL , A.PTAI_LIST_ID , B.PORTAL_NAME , A.PTAI_SEQ , A.PTCS_SERVICEID , A.PTAI_TYPE , A.PTAI_TARGET , A.PTAI_PRIORITY , A.PTAI_STATUS , A.PTAI_DUE_DATE , A.PTAI_CATEGORY , A.PTAI_ASSIGN_OPRID ,A.PTAI_ASSIGN_TYPE , D.OPRDEFNDESC , A.LAST_UPDATE_DTTM , A.LASTUPDOPRID , A.CREATEOPRID , B.PTAI_ACTIVE_FLG , C.PTAI_PARENT_ACTION FROM PS_PTAI_ITEM A , PS_PTAI_LIST B , PSOPRDEFN D , PS_PTAI_HIER C WHERE B.PTAI_LIST_ID = A.PTAI_LIST_ID AND C.PTAI_ITEM_ID= A.PTAI_ITEM_ID AND (EXISTS ( SELECT 'X' FROM PS_PTAI_LIST_PRIV F WHERE F.PTAI_LIST_ID = A.PTAI_LIST_ID AND F.PTAI_PRIVSET_ID ='PTAI_CONTRIBUTOR' 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)))))

  • Related language record: PTAI_ITEM_SLVW
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    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_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_SEQ Number(4,0) SMALLINT NOT NULL Sequence
    PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
    PTAI_TYPE Character(1) VARCHAR2(1) NOT NULL Type
    A=App Class URL
    C=PS Component
    M=Manual
    N=Non PeopleSoft URL
    P=Process
    Q=PS Query
    S=PS Script
    PTAI_TARGET Character(1) VARCHAR2(1) NOT NULL Target
    M=Modal
    N=New Window
    T=Target Frame
    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
    PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
    PTAI_CATEGORY Character(30) VARCHAR2(30) NOT NULL Action Items - Category
    PTAI_ASSIGN_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Assigned to User
    PTAI_ASSIGN_TYPE Character(4) VARCHAR2(4) NOT NULL Assign Type
    ROLE=Role
    USER=User
    OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    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.
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    PTAI_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Action Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists
    PTAI_PARENT_ACTION Character(31) VARCHAR2(31) NOT NULL Controller Action
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19