COMPETENCYREVIEW_RATINGPrompt Table: REVW_RATING_TBL
C=Other Evaluators' Comments
D=Development Tips
P=Performance Notes
S=Suggested Results
W=Results Writer
EP_CMPDEVTIP_VW(SQL View) |
Index Back |
|---|
| SELECT COMPETENCY , REVIEW_RATING ,'D' , EP_DEV_TIP_DESCR FROM PS_EP_COMP_DEV_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |
| 3 | 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 |
| 4 | EP_SUGGEST_RESULT | Long Character | CLOB | Suggested Results Test |