RB_TSK_PGCAL_VW

(SQL View)
 Index Back

Provider Group Calendar

My Calendar Provider Group Task View for Provider Group owned Tasks

SELECT DISTINCT M.PROVIDER_GRP_ID , %subrec(RB_TSK_CAL_SBR,T) , ' ' , TY.IMAGE_NAME , T.TIMEZONE , 'P' , ' ' , '0' FROM PS_RB_TSK T , PS_RB_TSK_TYPE TY , PS_RF_GRP_MEMBER M WHERE M.PROVIDER_GRP_ID = T.PROVIDER_GRP_ID AND M.SETID = T.SETID_PROV_GRP AND M.STATUS = 'A' AND T.TASK_TYPE = TY.TASK_TYPE AND TY.SHOW_IN_CAL_FLG = 'Y' 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