RG_CHANGE_VW

(SQL View)
 Index Back

Change Request view used in IP

Change Requests view used for grid in Installed Product history page, view uses records RG_CHANGE_REQST and RG_CHANGE_PROD.

SELECT A.CHANGE_REQUEST_ID ,A.BUSINESS_UNIT ,A.RG_SUMMARY ,A.CHANGE_STATUS ,A.ROW_ADDED_DTTM ,A.ROW_ADDED_OPRID ,A.CLOSED_DTTM ,B.SETID_PRODUCT ,B.INST_PROD_ID FROM PS_RG_CHANGE_REQST A ,PS_RG_CHANGE_PROD B WHERE A.CHANGE_REQUEST_ID = B.CHANGE_REQUEST_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

# 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 RG_SUMMARY Character(80) VARCHAR2(80) NOT NULL Summary description of a Change Request
4 CHANGE_STATUS Character(4) VARCHAR2(4) NOT NULL status of a Change Request in Change Management application
5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
6 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
7 CLOSED_DTTM DateTime(26) TIMESTAMP Date Time stamp for when the case status category was changed to closed.
8 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
9 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)