RB_TGRP_TSK_VW

(SQL View)
 Index Back

Task Group Tasks View

View all Tasks that are in a Task Group

SELECT TG.TASK_GRP_ID , TG.TASK_ID , T.TASK_TYPE , T.TASK_STATUS , T.TASK_PRIORITY , TA.PERSON_ID_ASSIGNEE , T.START_DATE , T.END_DATE , T.DESCR60 FROM PS_RB_TGRP_TSK TG , PS_RB_TSK T , PS_RB_TSK_ASGN TA WHERE TG.TASK_ID = T.TASK_ID AND T.TASK_ID = TA.TASK_ID (+)

  • Related Language Record: RB_TGRP_TSK_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_GRP_ID Number(10,0) DECIMAL(10) NOT NULL Task Group ID. Key for Task Group. Used by Task Management.
    2 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

    Prompt Table: RB_TSK

    3 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

    Prompt Table: RB_TSK_TYPE

    4 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
    CMPL=Completed
    CNCL=Canceled
    INPR=In Progress
    OPEN=Open
    5 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.

    Prompt Table: RB_TSK_PRTY_TBL

    6 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    7 START_DATE Date(10) DATE Start Date
    8 END_DATE Date(10) DATE End date field to store an end date.
    9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description