RG_RELATION_VW (SQL View)	Index Back
related change request View of related change requests in Change Management

RG_RELATION_VW

(SQL View)

related change request

View of related change requests in Change Management

SELECT A.CHANGE_REQUEST_ID , A.BUSINESS_UNIT , C.RG_RELATION_TYPE , B.RG_HIERARCHICAL_IN , B.RG_PARENT_LBL , B.RG_CHILD_LBL , B.RG_EQUIVALENT_LBL , C.BUSINESS_UNIT , C.CHANGE_REQUEST_ID , C.RELATED_BU , C.RELATED_CHG_REQ_ID , C.ROW_ADDED_DTTM , C.ROW_ADDED_OPRID FROM PS_RG_CHANGE_REQST A , PS_RG_RELATION_TBL B , PS_RG_CHANGE_RCHG C WHERE ((A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.CHANGE_REQUEST_ID = C.CHANGE_REQUEST_ID) OR (A.BUSINESS_UNIT = C.RELATED_BU AND A.CHANGE_REQUEST_ID = C.RELATED_CHG_REQ_ID)) AND B.RG_RELATION_TYPE = C.RG_RELATION_TYPE AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RG_RELATION_TBL')

# 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_RELATION_TYPE Character(5) VARCHAR2(5) NOT NULL Related Change Request Type code
Prompt Table: RG_RELATION_TBL

4 RG_HIERARCHICAL_IN Character(1) VARCHAR2(1) NOT NULL Hierarchical Indicator for change request
N=No
Y=Yes

5 RG_PARENT_LBL Character(15) VARCHAR2(15) NOT NULL Change Request Parent label used in relating change request to one another

6 RG_CHILD_LBL Character(15) VARCHAR2(15) NOT NULL change request child label used in relating change requests to one another

7 RG_EQUIVALENT_LBL Character(15) VARCHAR2(15) NOT NULL equivalent label for change request

8 RG_REL_BU_PARENT Character(5) VARCHAR2(5) NOT NULL Related Chnage Request Business Unit of the parent

9 RG_REL_CHG_PARENT Character(15) VARCHAR2(15) NOT NULL Related Change Request Parent display field

10 RELATED_BU Character(5) VARCHAR2(5) NOT NULL Business Unit

11 RELATED_CHG_REQ_ID Character(15) VARCHAR2(15) NOT NULL Related change request Id when relating one change request to another change request

12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

#	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_RELATION_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Related Change Request Type code Prompt Table: RG_RELATION_TBL
4	RG_HIERARCHICAL_IN	Character(1)	VARCHAR2(1) NOT NULL	Hierarchical Indicator for change request N=No Y=Yes
5	RG_PARENT_LBL	Character(15)	VARCHAR2(15) NOT NULL	Change Request Parent label used in relating change request to one another
6	RG_CHILD_LBL	Character(15)	VARCHAR2(15) NOT NULL	change request child label used in relating change requests to one another
7	RG_EQUIVALENT_LBL	Character(15)	VARCHAR2(15) NOT NULL	equivalent label for change request
8	RG_REL_BU_PARENT	Character(5)	VARCHAR2(5) NOT NULL	Related Chnage Request Business Unit of the parent
9	RG_REL_CHG_PARENT	Character(15)	VARCHAR2(15) NOT NULL	Related Change Request Parent display field
10	RELATED_BU	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
11	RELATED_CHG_REQ_ID	Character(15)	VARCHAR2(15) NOT NULL	Related change request Id when relating one change request to another change request
12	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
13	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.