RB_TSK_CALD_VW

(SQL View)
 Index Back

Calendar-Direct Rpt Delegated

My Calendar for Direct Reports Task View for a person

SELECT S.PERSON_ID , %subrec(RB_TSK_CAL_SBR,T) , TA.TASK_ASGN_STATUS , TY.IMAGE_NAME , T.TIMEZONE , 'D' , D.READONLY , D.PERSON_ID FROM PS_RB_TSK_ASGN TA , PS_RB_TSK T , PS_RB_TSK_TYPE TY , PS_RB_TSK_DELEGATE D , PS_RB_WORKER S WHERE D.DELEGATED_BY_PID = TA.PERSON_ID_ASSIGNEE AND D.DELEGATED_BY_PID = S.SUPERVISOR_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 = 'DT' AND TA.TASK_ID = T.TASK_ID 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 (TA.OWNER = 'Y' OR (TA.OWNER <> 'Y' AND TA.TASK_ASGN_STATUS IN ('ACPT', 'CMPL')))

# 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