EP_RPT_STS_SUM (SQL Table)	Index Back
Basis for Status Summary Chart Provides data for Status Summary pie chart.

EP_RPT_STS_SUM

(SQL Table)

Basis for Status Summary Chart

Provides data for Status Summary pie chart.

# 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 EP_REVIEW_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged
AR=Available for Review
CA=Cancelled
CO=Completed
IP=In Progress
NS=Not Started
RH=Review Held

4 EP_STATUS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Review Status Pct

#	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	EP_REVIEW_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately. AK=Acknowledged AR=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held
4	EP_STATUS_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Review Status Pct