RB_TSK_PRICNT_V (SQL View)	Index Back
Task Contacts. Holds the relationship between the Tasks and the Contacts associated to the Task.

RB_TSK_PRICNT_V

(SQL View)

Task Contacts.

Holds the relationship between the Tasks and the Contacts associated to the Task.

SELECT TASK_ID , PERSON_ID_CNTCT , PRIMARY_IND , BO_NAME_DISPLAY FROM PS_RB_TSK_CNTCT TC , PS_RD_PRSN_PNM_VW PN WHERE TC.PERSON_ID_CNTCT = PN.PERSON_ID AND TC.PRIMARY_IND = '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_CNTCT Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RD_PERSON_PN_VW

3 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

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	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_CNTCT	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RD_PERSON_PN_VW
3	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
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object