PV_WORKLIST_VW

(SQL View)
 Index Back

Worklist Entry


SELECT A.OPRID , A.INSTANCEID , A.BUSPROCNAME , A.WORKLISTNAME ,A.INSTTIMEOUTDTTM ,'1' , 'Work item from ' %Concat B.ROLEUSER ,'1' FROM PSWORKLIST A , PS_PV_REQ_USER_VW B WHERE A.INSTANCEID= B.INSTANCEID AND A.WORKLISTNAME = B.WORKLISTNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.INSTSTATUS < 2

  • Parent record: PSBUSPROCDEFN

    • # 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 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
    3 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
    4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
    5 DTTM_DUE DateTime(26) TIMESTAMP Date/Time Due
    6 PRIORITY_LABEL Character(1) VARCHAR2(1) NOT NULL Priority
    7 TASK_DESC Character(80) VARCHAR2(80) NOT NULL Task Description
    8 PV_STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    1=Pending
    2=On Hold
    3=In Process
    4=Completed