RB_TSK_LST_CNT

(SQL View)
 Index Back

Tasks for a Contact View.

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

SELECT T.SYNCID , TC.PERSON_ID_CNTCT , TC.BO_ID_CONTACT , TC.ROLE_TYPE_ID_CNTCT , TC.BO_ID_CUST , TC.ROLE_TYPE_ID_CUST , TC.PRIMARY_IND FROM PS_RB_TSK T , PS_RB_TSK_CNTCT TC WHERE T.TASK_ID = TC.TASK_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2 PERSON_ID_CNTCT Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RD_PERSON_PN_VW

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
7 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

Y/N Table Edit

Default Value: N