RB_TSK_CAL_VW

(SQL View)
 Index Back

Calendar-Individual Own/Assign

My Calendar Tasks: Used to retrieve tasks for an individual that either owns or is assigned to the task.

SELECT TA.PERSON_ID_ASSIGNEE , 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 , TA.TASK_ASGN_STATUS , TY.IMAGE_NAME , T.TIMEZONE , ' ' , ' ' , '0' FROM PS_RB_TSK_ASGN TA , PS_RB_TSK T , PS_RB_TSK_TYPE TY WHERE TA.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 (TA.OWNER = 'Y' OR (TA.OWNER <> 'Y' AND TA.TASK_ASGN_STATUS IN ('ACPT', 'CMPL')))

  • Related Language Record: RB_TSK_CAL_LVW

    • # 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