RG_P_TPL_PHS_VW

(SQL View)
 Index Back

Phase Model Detail Table

Change Request Phase Model Detail table

SELECT A.SETID , A.MODEL_ID , A.SEQ_NBR , A.RG_CHANGE_STATE , C.DESCR50 , B.DESCR , A.PHASE_DUR_DAYS , A.PHASE_DUR_HOURS , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID FROM PS_RG_PHS_MODL_DTL A , PS_RG_PHS_MODL_HDR B , PS_RG_UD_REQ_STATE C WHERE A.SETID = B.SETID AND A.MODEL_ID = B.MODEL_ID AND A.SETID = C.SETID AND A.RG_CHANGE_STATE = C.RG_CHANGE_STATE

  • Related Language Record: RG_P_TPL_PHS_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_OPRVW

    2 MODEL_ID Character(15) VARCHAR2(15) NOT NULL Model Id used in Change Management Phase Models
    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    4 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_STATE_VW

    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 PHASE_DUR_DAYS Number(4,0) SMALLINT NOT NULL Phase Duration in Days for Change Management
    8 PHASE_DUR_HOURS Number(3,0) SMALLINT NOT NULL Phase Duration Hours for Change Management Phase Models
    9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    10 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.