RB_TSK_WL_VW

(SQL View)
 Index Back

Task Assignees View

Task Work List of Assignees View. Used for My Work list.

SELECT TA.TASK_ID , P.PERSON_ID ,U.OPRID , 'RB_TSK' , %NumToChar(TA.TASK_ID) , 'WORKLIST' , 'Task Worklist' , 999999999 , CASE WHEN TA.TASK_ASGN_STATUS = 'CMPL' THEN 2 ELSE 0 END , TA.ROW_ADDED_DTTM , %DateTimeNull , TA.ROW_ADDED_OPRID , ' ' , ' ' , T.SYNCID , T.SYNCDTTM , T.TASK_TYPE , T.TASK_STATUS , T.TASK_PRIORITY , 0 , T.DESCR60 , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME , T.PERSON_ID_OWNER , TA.TASK_ASGN_STATUS , CASE WHEN TA.TASK_ASGN_STATUS = 'CMPL' THEN 'Y' ELSE 'N' END FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA , PS_RD_PERSON P , PSOPRALIAS U WHERE T.TASK_ID = TA.TASK_ID AND TA.PERSON_ID_ASSIGNEE = P.PERSON_ID AND P.PERSON_ID = %Substring(U.OPRALIASVALUE,1,15) AND U.OPRALIASTYPE = 'PER' AND TA.TASK_ASGN_STATUS <> 'DCLN'

  • Related Language Record: RB_TSK_WL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.
    2 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RB_WORKER_SRCH

    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
    5 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    6 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
    7 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
    8 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
    9 INSTSTATUS Number(5,0) INTEGER NOT NULL Determines worklist status, available, selected, worked, cancelled
    0=Selected
    1=Open
    2=Worked
    3=Cancelled
    10 INSTAVAILABLEDTTM DateTime(26) TIMESTAMP Datetime worklist instance was made available
    11 INSTTIMEOUTDTTM DateTime(26) TIMESTAMP Datetime that a worklist times out
    12 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    13 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
    1=1-High
    2=2-Medium
    3=3-Low
    14 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    17 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

    Prompt Table: RB_TSK_TYPE

    18 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
    CMPL=Completed
    CNCL=Canceled
    INPR=In Progress
    OPEN=Open
    19 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.
    20 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    21 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    22 START_DATE Date(10) DATE Start Date for Gen Standing PO
    23 START_TIME Time(15) TIMESTAMP Start of Shift
    24 END_DATE Date(10) DATE End date field to store an end date.
    25 END_TIME Time(15) TIMESTAMP End of Shift
    26 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    27 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
    ACPT=Accepted
    CMPL=Completed
    DCLN=Declined
    OPEN=Assigned
    28 SHOW_COMPLETED Character(1) VARCHAR2(1) NOT NULL This field is used to determine whether the worklist should be filtered to show only completed worklist entries.

    Y/N Table Edit