EP_WT_RESULTS (SQL Table)	Index Back
Writing Tools Results Record This record is used to consolidate the real time results from the four different writing tools into a suggested results page. This table never holds any data, but must be created as a table for certain peoplecode to function properly. This table is also referenced on each of the advanced search pages within the writing tools, and performs the same job of consolidating the results.

EP_WT_RESULTS

(SQL Table)

Writing Tools Results Record

This record is used to consolidate the real time results from the four different writing tools into a suggested results page. This table never holds any data, but must be created as a table for certain peoplecode to function properly. This table is also referenced on each of the advanced search pages within the writing tools, and performs the same job of consolidating the results.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_SUGGEST_RESULT Long Character CLOB Suggested Results Test

2 EP_WRT_SRC Character(1) VARCHAR2(1) NOT NULL Tip Source
C=Other Evaluators' Comments
D=Development Tips
P=Performance Notes
S=Suggested Results
W=Results Writer

3 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier

4 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID
Prompt Table: EP_REVWR_ID_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_SUGGEST_RESULT	Long Character	CLOB	Suggested Results Test
2	EP_WRT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Tip Source C=Other Evaluators' Comments D=Development Tips P=Performance Notes S=Suggested Results W=Results Writer
3	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier
4	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID Prompt Table: EP_REVWR_ID_VW