RG_STAT_INT_VW

(SQL View)
 Index Back

Change Status Interested Party

Shows interested parties by the status and phase of interest. Values of 'All' for the phase indicate that they are interested in all phases of the change request.

SELECT B.CHANGE_REQUEST_ID , B.BUSINESS_UNIT , B.CHANGE_STATUS , B.RG_CHANGE_STATE , C. BO_ID , D.PERSON_ID , C.ROLE_TYPE_ID FROM PS_RG_CHANGE_STATE B , PS_RG_CHANGE_INTR C , PS_RD_PERSON D WHERE B.CHANGE_REQUEST_ID = C.CHANGE_REQUEST_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.BO_ID = D.BO_ID AND (B.RG_CHANGE_STATE = C.RG_CHANGE_STATE OR C.RG_CHANGE_STATE = 'ALL')

# 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 CHANGE_STATUS Character(4) VARCHAR2(4) NOT NULL status of a Change Request in Change Management application
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 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
6 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
7 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID