RB_TSK_CALPG_VW (SQL View)	Index Back
Calendar-Prov Grp Own/Assign My Calendar tasks for provider groups. There may or may not be an individual also assigned to the task.

RB_TSK_CALPG_VW

(SQL View)

Calendar-Prov Grp Own/Assign

My Calendar tasks for provider groups. There may or may not be an individual also assigned to the task.

SELECT T.PERSON_ID_OWNER , T.START_DATE , T.START_TIME , T.TASK_ID , T.END_DATE , T.END_TIME , T.DESCR60 , T.TASK_LOCATION , T.PERSON_ID_OWNER , T.PRIVATE_FLG , T.TASK_STATUS , T.TASK_STATUS , TY.IMAGE_NAME , T.TIMEZONE , ' ' , ' ' , '0' FROM PS_RB_TSK T , PS_RB_TSK_TYPE TY WHERE 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')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

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

3 START_TIME Time(15) TIMESTAMP Start of Shift

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

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

6 END_TIME Time(15) TIMESTAMP End of Shift

7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

8 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.

9 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

10 PRIVATE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate the Task is Private. Used by Task Management.

11 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
CMPL=Completed
CNCL=Canceled
INPR=In Progress
OPEN=Open

12 TASK_ASGN_STATUS Character(4) VARCHAR2(4) NOT NULL Task Assignment Status. Used by Task Management.
ACPT=Accepted
CMPL=Completed
DCLN=Declined
OPEN=Assigned

13 IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.

14 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

15 DELEGATED_FLG Character(1) VARCHAR2(1) NOT NULL an indicator that a task is delegated used in My Calendar...

16 READONLY Character(1) VARCHAR2(1) NOT NULL Read Only

17 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID_ASSIGNEE	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
3	START_TIME	Time(15)	TIMESTAMP	Start of Shift
4	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
5	END_DATE	Date(10)	DATE	End date field to store an end date.
6	END_TIME	Time(15)	TIMESTAMP	End of Shift
7	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
8	TASK_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Task Location. Used by Task Management.
9	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
10	PRIVATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate the Task is Private. Used by Task Management.
11	TASK_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Status CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open
12	TASK_ASGN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Task Assignment Status. Used by Task Management. ACPT=Accepted CMPL=Completed DCLN=Declined OPEN=Assigned
13	IMAGE_NAME	Character(30)	VARCHAR2(30) NOT NULL	The name of images used in Personalizations explanations.
14	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
15	DELEGATED_FLG	Character(1)	VARCHAR2(1) NOT NULL	an indicator that a task is delegated used in My Calendar...
16	READONLY	Character(1)	VARCHAR2(1) NOT NULL	Read Only
17	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID