RBW_TASK_LIST

(SQL View)
Index Back

Task View Calendar

My Calendar Task View for assignees

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 , TYP.DESCR , T.TASK_STATUS , TYP.SHOW_IN_CAL_FLG FROM PS_RB_TSK_ASGN TA , PS_RB_TSK T , PS_RB_TSK_TYPE TYP WHERE TA.TASK_ID = T.TASK_ID AND TYP.TASK_TYPE = T.TASK_TYPE AND TYP.ACTIVE_FLG = 'Y' AND TYP.SHOW_IN_LIST_FLG = 'Y' AND T.TASK_STATUS NOT IN ('CNCL', 'CMPL')

  • Related Language Record: RBW_TSK_LST_LNG
  • # 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 TASKDESCR Character(30) VARCHAR2(30) NOT NULL Task Description
    12 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
    CMPL=Completed
    CNCL=Canceled
    INPR=In Progress
    OPEN=Open
    13 SHOW_IN_CAL_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate if the Task should be shown in Calendar. Used by Task Management.
    N=No
    Y=Yes