RG_UD_STATE_LVW

(SQL View)
 Index Back

View Phases

View Phases without regard to set id related language

SELECT DISTINCT A.SETID , A.RG_CHANGE_STATE , A.LANGUAGE_CD , A.DESCR50 FROM PS_RG_UD_RQ_STAT_L A , PS_RG_UD_REQ_STATE B WHERE A.SETID = B.SETID AND A.RG_CHANGE_STATE = B.RG_CHANGE_STATE UNION SELECT C.SETID , C.RG_CHANGE_STATE , ' ' , C.DESCR50 FROM PS_RG_UD_REQ_STATE C WHERE C.RG_CHANGE_STATE NOT IN ( SELECT D.RG_CHANGE_STATE FROM PS_RG_UD_RQ_STAT_L D WHERE D.SETID = C.SETID AND D.RG_CHANGE_STATE = C.RG_CHANGE_STATE)

  • Related Language Record for RG_UD_STATE_VW

    • # 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.
    2 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
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50