RG_TASK_HIER_VW

(SQL View)
 Index Back

View Tasks of Change Request

Change Request work view of Tasks associated to the change request

SELECT DISTINCT TL.CHANGE_REQUEST_ID , TL.BUSINESS_UNIT , TL.RG_CHANGE_STATE , TP.CHANGE_STATUS , TL.TASK_GRP_ID , TT.TASK_ID , T.DESCR60 , T.TASK_STATUS , T.START_DATE , T.END_DATE FROM PS_RG_CHG_PHS_TSK TL , PS_RB_TGRP_TSK TT , PS_RB_TSK T , PS_RG_CHANGE_STATE TP WHERE TL.TASK_GRP_ID = TT.TASK_GRP_ID AND TT.TASK_ID = T.TASK_ID AND TP.CHANGE_REQUEST_ID = TL.CHANGE_REQUEST_ID AND TP.BUSINESS_UNIT = TL.BUSINESS_UNIT AND TP.RG_CHANGE_STATE = TL.RG_CHANGE_STATE AND T.TASK_STATUS <> 'CNCL'

  • Related Language Record: RG_TSK_HIER_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 RG_CHANGE_STATE Character(4) VARCHAR2(4) NOT NULL Change request change State / Phase
    CANC=Canceled
    COMP=Complete
    DEV=Development
    HOLD=On Hold
    IMPL=Implementation
    PEND=Change Pending
    POST=Postmortem Review
    PROP=Proposed
    REJ=Rejected
    RETN=Return for More Information
    REVW=Review

    Prompt Table: RG_UD_REQ_STATE

    4 CHANGE_STATUS Character(4) VARCHAR2(4) NOT NULL status of a Change Request in Change Management application
    5 TASK_GRP_ID Number(10,0) DECIMAL(10) NOT NULL Task Group ID. Key for Task Group. Used by Task Management.

    Prompt Table: RB_TGRP

    6 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

    Prompt Table: RB_TSK

    7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    8 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
    CMPL=Completed
    CNCL=Canceled
    INPR=In Progress
    OPEN=Open
    9 START_DATE Date(10) DATE Start Date for Gen Standing PO
    10 END_DATE Date(10) DATE End date field to store an end date.