EP_DBG_DIAG_VW

(SQL View)
Index Back

Calc Debugger Diagnostic View

This is a view on the Calc Debugger results - used by the Diagnostic Plug-In for ePerformance.

SELECT EP_APPRAISAL_ID , EP_ROLE , EP_DEBUG_SEQ_NUM , DATETIME_STAMP , EP_CALC_FUNCTION , EP_SECTION_TYPE , EP_TITLE , RATING_MODEL , EP_CALC_METHOD , REVIEW_RATING , EP_RATING , REVIEW_POINTS , EP_DEBUG_ENTRY_TYP , EP_DESCR254 FROM PS_EP_DEBUG_DTL

# 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
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 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
5 EP_CALC_FUNCTION Character(30) VARCHAR2(30) NOT NULL Calculate Function field
6 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type

Prompt Table: EP_SECTION_DEFN

7 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
8 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
9 EP_CALC_METHOD Character(1) VARCHAR2(1) NOT NULL Calculation method used - Summary, Average, Review Band
A=Average
R=Review Band
S=Summation
10 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
11 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating
12 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points
13 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

14 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance