RG_TSK_ASGN_VW

(SQL View)
 Index Back

Task Assignee View

Assignee view of a Task used on Task details page of Change Management application

SELECT TA.TASK_ID , TA.PERSON_ID_ASSIGNEE , N.BO_NAME_DISPLAY , TA.TASK_ASGN_STATUS , TA.ROW_ADDED_DTTM , TA.ROW_LASTMANT_DTTM FROM PS_RB_TSK_ASGN TA , PS_RD_PERSON_NAME N WHERE TA.PERSON_ID_ASSIGNEE = N.PERSON_ID AND N.PRIMARY_IND = 'Y' AND TA.OWNER <> '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 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
4 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
ACPT=Accepted
CMPL=Completed
DCLN=Declined
OPEN=Assigned
5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.