RB_TSK_CAL_LVW

(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 , TL.LANGUAGE_CD , T.DESCR60 FROM PS_RB_TSK_ASGN TA , PS_RB_TSK T , PS_RB_TSK_TYPE TY ,PS_RB_TSK_LANG TL WHERE TA.TASK_ID = T.TASK_ID AND TA.TASK_ID = TL.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 for RB_TSK_CAL_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description