RB_TSK_CAL_ASGN (SQL View)	Index Back
get the all invitee get the all the invitee for the task created

RB_TSK_CAL_ASGN

(SQL View)

get the all invitee

get the all the invitee for the task created

SELECT A.TASK_ID , A.PERSON_ID_ASSIGNEE , B.BO_NAME_DISPLAY , T.START_DATE , T.START_TIME , T.END_DATE , T.END_TIME FROM PS_RB_TSK_ASGN A , PS_RB_TSK T , PS_RB_TSK_TYPE TY , PS_RD_PERSON_NAME B WHERE A.TASK_ID = T.TASK_ID AND T.TASK_TYPE = TY.TASK_TYPE AND TY.SHOW_IN_CAL_FLG = 'Y' AND T.START_DATE IS NOT NULL AND T.START_TIME IS NOT NULL AND T.END_DATE IS NOT NULL AND T.END_TIME IS NOT NULL AND T.TASK_STATUS NOT IN ('CNCL') AND A.PERSON_ID_ASSIGNEE = B.PERSON_ID

# 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_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

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

4 START_DATE Date(10) DATE Start Date for Gen Standing PO

5 START_TIME Time(15) TIMESTAMP Start of Shift

6 END_DATE Date(10) DATE End date field to store an end date.

7 END_TIME Time(15) TIMESTAMP End of Shift

#	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_ASSIGNEE	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
4	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
5	START_TIME	Time(15)	TIMESTAMP	Start of Shift
6	END_DATE	Date(10)	DATE	End date field to store an end date.
7	END_TIME	Time(15)	TIMESTAMP	End of Shift