RB_TSK_LIST_LVW

(SQL View)
 Index Back

View for Task List

View for Task List. Used By Task Management.

SELECT T.TASK_ID , TL.LANGUAGE_CD , T.DESCR60 FROM PS_RB_TSK T , PS_RB_TSK_TYPE TT , PS_RB_TSK_TYPE_LNG TL , PS_RB_TSK_PRTY_TBL TP WHERE T.TASK_TYPE = TT.TASK_TYPE AND TL.TASK_TYPE = TL.TASK_TYPE AND T.TASK_PRIORITY=TP.TASK_PRIORITY AND TT.SHOW_IN_LIST_FLG = 'Y'

  • Related Language Record for RB_TSK_LIST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description