PTAI_ITEM_SVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
    3 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    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_SEQ Number(4,0) SMALLINT NOT NULL Sequence
    7 PTCS_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID (see PSPTCSSRVDEFN).
    8 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
    9 PTAI_TARGET Character(1) VARCHAR2(1) NOT NULL Target
    M=Modal
    N=New Window
    T=Target Frame
    10 PTAI_PRIORITY Character(1) VARCHAR2(1) NOT NULL Action Items - Priority
    1=Low Priority
    2=Medium Priority
    3=High Priority
    11 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
    12 PTAI_DUE_DATE Date(10) DATE Action Items - Due Date
    13 PTAI_CATEGORY Character(30) VARCHAR2(30) NOT NULL Action Items - Category
    14 PTAI_ASSIGN_OPRID Character(30) VARCHAR2(30) NOT NULL Action Items - Assigned to User
    15 PTAI_ASSIGN_TYPE Character(4) VARCHAR2(4) NOT NULL Assign Type
    EMAL=E-Mail
    ROLE=Role
    USER=User
    16 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    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.
    19 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    20 PTAI_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Action Item Active Flag
    N=Display Inactive Lists
    Y=Display Active Lists
    21 PTAI_PARENT_ACTION Character(31) VARCHAR2(31) NOT NULL Controller Action