RB_TSK_ASGN_VW2

(SQL View)
 Index Back

Active Task Assignee View

This view returns all active task assignees, as well as the task owner and overall task status.

SELECT B.TASK_ID , B.PERSON_ID_ASSIGNEE , A.TASK_STATUS , A.PERSON_ID_OWNER , B.TASK_ASGN_STATUS , B.OWNER , B.READ_SW FROM PS_RB_TSK A , PS_RB_TSK_ASGN B , PS_RB_TSK_TYPE C WHERE B.TASK_ID = A.TASK_ID AND C.TASK_TYPE = A.TASK_TYPE AND A.TASK_STATUS IN ('INPR', 'OPEN') AND C.SHOW_IN_LIST_FLG = 'Y'

# 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
3 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
CMPL=Completed
CNCL=Canceled
INPR=In Progress
OPEN=Open
4 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
5 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
ACPT=Accepted
CMPL=Completed
DCLN=Declined
OPEN=Assigned
6 OWNER Character(1) VARCHAR2(1) NOT NULL Owner
N=No
Y=Yes
7 READ_SW Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether a CRM worklist notification has been read by the user.

Y/N Table Edit