RG_CHG_MET_VW (SQL View)	Index Back
Change Request Metrics ACE Input view for Change Request Metrics ACE report

RG_CHG_MET_VW

(SQL View)

Change Request Metrics ACE

Input view for Change Request Metrics ACE report

SELECT C.PROBINST , A.RG_BU_DESCR , A.RC_DEPT_DESCR , A.RC_LOC_DESCR , A.RG_PRIORITY_DESCR , A.RG_CATEGORY_DESCR , A.RG_IMPACT_DESCR , A.RG_STATUS_DESCR , D.BAM_DATE , COUNT (*) FROM PS_RG_CHG_MET_BAM A , PS_RG_BAM_RUN_CTL B , PS_RG_BAM_RUN_INST C , PS_RB_BAM_WEEKS D WHERE B.OPRID = C.OPRID AND B.RUN_CNTL_ID = C.RUN_CNTL_ID AND A.UUID_RAW = C.UUID_RAW AND %DateOut(%DatePart(A.ROW_ADDED_DTTM)) <= %DateOut(D.TO_DATE) AND %DateOut(%DatePart(A.ROW_ADDED_DTTM)) >= %DateOut(D.FROM_DATE) AND %DateOut(%DatePart(A.ROW_ADDED_DTTM)) <= %DateOut(B.END_DATE) AND %DateOut(%DatePart(A.ROW_ADDED_DTTM)) >= %DateOut(B.START_DATE) GROUP BY C.PROBINST, A.RG_BU_DESCR , A.RC_DEPT_DESCR , A.RC_LOC_DESCR , A.RG_PRIORITY_DESCR , A.RG_CATEGORY_DESCR , A.RG_IMPACT_DESCR , A.RG_STATUS_DESCR, D.BAM_DATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

2 RG_BU_DESCR Character(50) VARCHAR2(50) NOT NULL Field used by Change Management in BAM reports.

3 RC_DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description to be displayed on HelpDesk page.

4 RC_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Descripton of the Location to be displayed in helpdesk page.

5 RG_PRIORITY_DESCR Character(50) VARCHAR2(50) NOT NULL Field used by Change Management for BAM reports.

6 RG_CATEGORY_DESCR Character(50) VARCHAR2(50) NOT NULL Field used by Change Management for BAM reports.

7 RG_IMPACT_DESCR Character(50) VARCHAR2(50) NOT NULL Field used for Change Management for BAM reports.

8 RG_STATUS_DESCR Character(50) VARCHAR2(50) NOT NULL Field used by Change Management for BAM reports.

9 BAM_DATE Character(10) VARCHAR2(10) NOT NULL This is a Date field, to be used in BAM.

10 NUMBER_OF_REQUESTS Number(6,0) INTEGER NOT NULL Number of Inserts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	RG_BU_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used by Change Management in BAM reports.
3	RC_DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department Description to be displayed on HelpDesk page.
4	RC_LOC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Descripton of the Location to be displayed in helpdesk page.
5	RG_PRIORITY_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used by Change Management for BAM reports.
6	RG_CATEGORY_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used by Change Management for BAM reports.
7	RG_IMPACT_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used for Change Management for BAM reports.
8	RG_STATUS_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used by Change Management for BAM reports.
9	BAM_DATE	Character(10)	VARCHAR2(10) NOT NULL	This is a Date field, to be used in BAM.
10	NUMBER_OF_REQUESTS	Number(6,0)	INTEGER NOT NULL	Number of Inserts