EP_DEBUG_DTL (SQL Table)	Index Back
Calculation Debug Details This table is used to store the output of the ePerformance Rating Calculation Debugger.

EP_DEBUG_DTL

(SQL Table)

Calculation Debug Details

This table is used to store the output of the ePerformance Rating Calculation Debugger.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

2 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier
Prompt Table: EP_ROLE_TBL

3 EP_DEBUG_SEQ_NUM Number(4,0) SMALLINT NOT NULL Used as lowest-order the unique key for the ePerformance Debug/Trace dump table.

4 EP_DEBUG_PARENT Number(4,0) SMALLINT NOT NULL Identifies the parent row for the nested debug/trace row.

5 EP_DEBUG_LEVEL Number(2,0) SMALLINT NOT NULL Identifies the nesting level of the debug/trace row

6 EP_DEBUG_EXP_COLL Character(1) VARCHAR2(1) NOT NULL Indicates whether this debug/trace row can be expanded to show children (+) or collapsed to hide children (-).

7 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

8 EP_CALC_FUNCTION Character(30) VARCHAR2(30) NOT NULL Calculate Function field

9 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type
Prompt Table: EP_SECTION_DEFN

10 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item

11 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

12 EP_CALC_METHOD Character(1) VARCHAR2(1) NOT NULL Calculation method used - Summary, Average, Review Band
A=Average
R=Review Band
S=Summation

13 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

14 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating

15 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points

16 EP_DEBUG_ENTRY_TYP Character(1) VARCHAR2(1) NOT NULL Identifies the type of entry in the ePerformance Debug/Trace Log. Example: (T)race entry, (W)arning entry, (E)rror entry.
E=Error
I=Informational
T=Trace
W=Warning
Default Value: T

17 EP_DESCR254 Long Character(1325) VARCHAR2(1325) 1325 character description field used in ePerformance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier Prompt Table: EP_ROLE_TBL
3	EP_DEBUG_SEQ_NUM	Number(4,0)	SMALLINT NOT NULL	Used as lowest-order the unique key for the ePerformance Debug/Trace dump table.
4	EP_DEBUG_PARENT	Number(4,0)	SMALLINT NOT NULL	Identifies the parent row for the nested debug/trace row.
5	EP_DEBUG_LEVEL	Number(2,0)	SMALLINT NOT NULL	Identifies the nesting level of the debug/trace row
6	EP_DEBUG_EXP_COLL	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether this debug/trace row can be expanded to show children (+) or collapsed to hide children (-).
7	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
8	EP_CALC_FUNCTION	Character(30)	VARCHAR2(30) NOT NULL	Calculate Function field
9	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type Prompt Table: EP_SECTION_DEFN
10	EP_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Title of an item
11	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
12	EP_CALC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Calculation method used - Summary, Average, Review Band A=Average R=Review Band S=Summation
13	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
14	EP_RATING	Number(6,2)	DECIMAL(5,2) NOT NULL	Rating
15	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
16	EP_DEBUG_ENTRY_TYP	Character(1)	VARCHAR2(1) NOT NULL	Identifies the type of entry in the ePerformance Debug/Trace Log. Example: (T)race entry, (W)arning entry, (E)rror entry. E=Error I=Informational T=Trace W=Warning Default Value: T
17	EP_DESCR254	Long Character(1325)	VARCHAR2(1325)	1325 character description field used in ePerformance