RG_CHG_STAT_LVW

(SQL View)
 Index Back

View State table

View State table with description of values related language

SELECT A.CHANGE_REQUEST_ID , A.BUSINESS_UNIT , B.LANGUAGE_CD , A.RG_CHANGE_STATE , B.DESCR50 FROM PS_RG_CHANGE_STATE A , PS_RG_UD_RQ_STAT_L B , PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'RG_UD_REQ_STATE' AND C.SETID = B.SETID AND B.RG_CHANGE_STATE = A.RG_CHANGE_STATE

  • Related Language Record for RG_CHG_STATE_VW

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