RB_TSK_COMP_VW1

(SQL View)
 Index Back

Tasks for a company View.

Tasks for a company View. Used by Mobile Task Management.

SELECT DISTINCT CO.SETID , CO.COMPANYID , T.TASK_ID , TC.BO_ID_CUST , TC.ROLE_TYPE_ID_CUST FROM PS_RB_TSK T , PS_RB_TSK_CNTCT TC , PS_RD_COMPANY CO WHERE TC.BO_ID_CUST = CO.BO_ID AND T.TASK_ID = TC.TASK_ID UNION SELECT DISTINCT CO.SETID , CO.COMPANYID , T.TASK_ID , TA.BO_ID_CUST , TA.ROLE_TYPE_ID_CUST FROM PS_RB_TSK T , PS_RB_TSK_ASGN TA , PS_RD_COMPANY CO WHERE TA.BO_ID_CUST = CO.BO_ID AND T.TASK_ID = TA.TASK_ID AND TA.OWNER = 'N' AND TA.BO_ID_CUST NOT IN ( SELECT T1.BO_ID_CUST FROM PS_RB_TSK_CNTCT T1 WHERE T1.TASK_ID=TA.TASK_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID

Default Value: NEXT

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

Default Value: 999999999999

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