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