RB_TSK_PERS_VW1

(SQL View)
 Index Back

View for Person

Task view for Lead Component. Used by Lead Component.

SELECT DISTINCT TC.PERSON_ID_CNTCT AS PERSON_ID , T.TASK_ID , TC.BO_ID_CONTACT , TC.ROLE_TYPE_ID_CNTCT , TC.BO_ID_CUST , TC.ROLE_TYPE_ID_CUST FROM PS_RB_TSK T , PS_RB_TSK_CNTCT TC , PS_RD_PERSON P WHERE TC.PERSON_ID_CNTCT = P.PERSON_ID AND T.TASK_ID = TC.TASK_ID UNION SELECT DISTINCT TA.PERSON_ID_ASSIGNEE AS PERSON_ID , T.TASK_ID , TA.BO_ID_CONTACT , TA.ROLE_TYPE_ID_CNTCT , TA.BO_ID_CUST , TA.ROLE_TYPE_ID_CUST FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA , PS_RD_PERSON P WHERE TA.PERSON_ID_ASSIGNEE = P.PERSON_ID AND T.TASK_ID = TA.TASK_ID AND TA.OWNER = 'N' AND TA.BO_ID_CONTACT NOT IN ( SELECT T1.BO_ID_CONTACT FROM PS_RB_TSK_CNTCT T1 WHERE T1.TASK_ID=TA.TASK_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Default Value: NEXT

2 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

Default Value: 999999999999

3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
5 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
6 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer