RB_TSK_PRSNREL

(SQL View)
Index Back

View to get relationships.

View to get customer relationships for a contact. Used by Task Management.

SELECT DISTINCT a.BO_ID_1 , a.ROLE_TYPE_ID_1 , a.BO_ID_2 , a.ROLE_TYPE_ID_2 , b.BO_NAME , b.BO_NAME_DISPLAY FROM PS_BO_REL a , PS_BO_NAME_PRIM_VW b WHERE a.BO_ID_2 = b.BO_ID AND START_DT <= %CurrentDateIn AND END_DT > %CurrentDateIn AND REL_TYPE_ID IN (9, 10, 13, 14, 46, 47)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
2 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
5 CUST_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to represent the customer name
6 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object