RB_TSK_CALP_VW

(SQL View)
 Index Back

Calendar-Prov Grp Delegated

My Calendar Task View for Provider Group owned Tasks with no Owner ID person

SELECT M.PERSON_ID , %subrec(RB_TSK_CAL_SBR,T) , ' ' , TY.IMAGE_NAME , T.TIMEZONE , 'D' , D.READONLY , D.PERSON_ID FROM PS_RB_TSK T , PS_RB_TSK_TYPE TY , PS_RB_TSK_DELEGATE D , PS_RF_GRP_MEMBER M WHERE %Substring(D.TSK_DELEGATE_ID,1,10) = M.PROVIDER_GRP_ID AND M.PROVIDER_GRP_ID = T.PROVIDER_GRP_ID AND M.SETID = T.SETID_PROV_GRP AND M.STATUS = 'A' AND M.PERSON_ID <> D.PERSON_ID AND %DateOut(D.START_DT) <= %CurrentDateOut AND %DateOut(D.END_DT) >= %CurrentDateOut AND (D.TASK_TYPE = 'A11-ALL' OR D.TASK_TYPE = T.TASK_TYPE) AND (D.TSK_INCL_PRIVT_FLG = 'Y' OR T.PRIVATE_FLG = 'N') AND D.TSK_DELEGATE_TYPE = 'P' AND T.TASK_TYPE = TY.TASK_TYPE AND TY.SHOW_IN_CAL_FLG = 'Y' AND TY.SHOW_IN_LIST_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 T.PERSON_ID_OWNER = ' '

# 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