EP_DBG_DIAG_VW(SQL View) |
Index Back |
---|---|
Calc Debugger Diagnostic ViewThis 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 |