EP_RPT_SUM_SRCH (SQL View)	Index Back
eP Reporting Search Record Search record for ePerformance charts. The user can see the groups depending on the security of the group.

EP_RPT_SUM_SRCH

(SQL View)

eP Reporting Search Record

Search record for ePerformance charts. The user can see the groups depending on the security of the group.

SELECT B.GB_GROUP_ID , C.EP_REVIEW_TYPE , A.GB_OPRID , B.PNLGRPNAME FROM PS_GB_SECGRPOPR_TB A , PS_GB_SECPNLG_TBL B , PS_EP_RPT_SUM_HDR C WHERE A.GB_GROUP_ID = B.GB_GROUP_ID AND A.GB_OPRID = B.GB_OPRID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GB_SECGRPOPR_TB WHERE A.GB_GROUP_ID = GB_GROUP_ID AND A.GB_OPRID = GB_OPRID AND EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND C.GB_GROUP_ID = B.GB_GROUP_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

2 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name