RG_CHGREQ_PHSVW

(SQL View)
 Index Back

Change Request View

Retrieves phase code of tasks associated with change requests.

SELECT A.SYNCID , A.CHANGE_REQUEST_ID , A.BUSINESS_UNIT , B.RG_CHANGE_STATE FROM PS_RG_CHANGE_REQST A , PS_RG_CHANGE_STATE B WHERE B.CHANGE_REQUEST_ID = A.CHANGE_REQUEST_ID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RG_NONVW

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_REQ_STATE