RG_CHANGE_SRCH

(SQL View)
 Index Back

Change Request search

Change management change request search record

SELECT A.CHANGE_REQUEST_ID , A.BUSINESS_UNIT , A.RG_SUMMARY , A.BO_ID_REQUESTOR , A.ROLE_TYPE_ID_REQ , NR.NAME , NR.BO_NAME_DISPLAY , NR.LAST_NAME_SRCH , NR.FIRST_NAME_SRCH , A.BO_ID_OWNER , A.BO_ROLE_TYPE_ID , NW.NAME , NW.BO_NAME_DISPLAY , NW.LAST_NAME_SRCH , NW.FIRST_NAME_SRCH , A.ROW_ADDED_DTTM , A.RG_CATEGORY , A.RG_PRIORITY , A.RG_REQUEST_TYPE , A.RG_REQ_SUB_TYPE , A.RG_CHANGE_STATE , A.CHANGE_STATUS , A.RG_REASON , A.RG_IMPACT , A.START_DT , A.END_DT , A.REQUESTED_BY_DT , %DatePart(A.CLOSED_DTTM) , A.SYNCID FROM PS_RG_CHANGE_REQST A , PS_BO_NAME NR , PS_BO_NAME NW WHERE NR.BO_ID = A.BO_ID_REQUESTOR AND NR.PRIMARY_IND = 'Y' AND A.BO_ID_OWNER = NW.BO_ID (+) AND 'Y' = NW.PRIMARY_IND (+)

# 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

Prompt Table: RG_CHANGE_REQST

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RG_NONVW

3 RG_SUMMARY Character(80) VARCHAR2(80) NOT NULL Summary description of a Change Request
4 BO_ID_REQUESTOR Number(31,0) DECIMAL(31) NOT NULL Change Requester Identification number
5 ROLE_TYPE_ID_REQ Number(12,0) DECIMAL(12) NOT NULL Change Management application Requester Role Type ID
6 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Business Name Display. BO_NAME.NAME_DISPLAY
7 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
10 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
11 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID
12 NAME_DISPLAY2 Character(50) VARCHAR2(50) NOT NULL name
13 BO_NAME_DISPLAY_2 Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
14 LAST_NAMEO_SRCH Character(30) VARCHAR2(30) NOT NULL search field on last name of owner
15 FIRST_NAMEO_SRCH Character(30) VARCHAR2(30) NOT NULL Search field for first name of Owner
16 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
17 RG_CATEGORY Character(4) VARCHAR2(4) NOT NULL change management change Request Category

Prompt Table: RG_UD_REQ_CATGY

18 RG_PRIORITY Character(4) VARCHAR2(4) NOT NULL change management

Prompt Table: RG_UD_REQ_PRTY

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

Prompt Table: RG_UD_REQ_TYPE

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

Prompt Table: RG_UD_REQ_SUBTY

21 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

22 CHANGE_STATUS Character(4) VARCHAR2(4) NOT NULL status of a Change Request in Change Management application

Prompt Table: RG_UD_REQ_STATU

23 RG_REASON Character(4) VARCHAR2(4) NOT NULL Business Reason for Change request

Prompt Table: RG_UD_REQ_BUSR

24 RG_IMPACT Character(4) VARCHAR2(4) NOT NULL Impact of a Change request..........

Prompt Table: RG_UD_REQ_IMPCT

25 START_DT Date(10) DATE Start date field to store start date value.
26 END_DT Date(10) DATE This field stores the end date values.
27 REQUESTED_BY_DT Date(10) DATE Change Management Requested By Date on a Change Request. (the requested completion date of the Change Request)
28 CLOSED_DATE Date(10) DATE Date Closed
29 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.