RG_CHG_TASK_VW

(SQL View)
 Index Back

View Tasks of Change Request

Change Request work view of Tasks associated to the change request

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

  • Related Language Record: RG_CHG_TASK_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 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

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

    Prompt Table: RB_TSK

    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    7 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
    CMPL=Completed
    CNCL=Canceled
    INPR=In Progress
    OPEN=Open
    8 START_DATE Date(10) DATE Start Date for Gen Standing PO
    9 END_DATE Date(10) DATE End date field to store an end date.
    10 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"