EP_RPT_SNAP_DTL (SQL Table)	Index Back
Report Snapshot Dtl Rec Stores detail review information extracted during the Report Snapshot Summary process. The drill-down for the Status Summary and Rating Distribution charts is references this data.

EP_RPT_SNAP_DTL

(SQL Table)

Report Snapshot Dtl Rec

Stores detail review information extracted during the Report Snapshot Summary process. The drill-down for the Status Summary and Rating Distribution charts is references this data.

# 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_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

4 EP_PRELIM_GRP Number(3,0) SMALLINT NOT NULL Preliminary Rating Grp

5 EP_FINAL_GRP Number(3,0) SMALLINT NOT NULL Final Rating Group

#	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_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
4	EP_PRELIM_GRP	Number(3,0)	SMALLINT NOT NULL	Preliminary Rating Grp
5	EP_FINAL_GRP	Number(3,0)	SMALLINT NOT NULL	Final Rating Group