RQ_CHANGE_VW

(SQL View)
 Index Back

Change Request View

for lookup of Change Request view for lookup

SELECT BUSINESS_UNIT , CHANGE_REQUEST_ID , CHANGE_STATUS , RG_REQUEST_TYPE , RG_REQ_SUB_TYPE , RG_SUMMARY FROM PS_RG_CHANGE_REQST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RG Character(5) VARCHAR2(5) NOT NULL business unit for change management
2 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request
3 CHANGE_STATUS Character(4) VARCHAR2(4) NOT NULL status of a Change Request in Change Management application

Prompt Table: RG_UD_REQ_STATU

4 RG_REQUEST_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management Type of Change Request.

Prompt Table: RG_UD_REQ_TYPE

5 RG_REQ_SUB_TYPE Character(4) VARCHAR2(4) NOT NULL Change Management change Request Sub Type

Prompt Table: RG_UD_REQ_SUBTY

6 RG_SUMMARY Character(80) VARCHAR2(80) NOT NULL Summary description of a Change Request