EP_APPRAISAL_IDREVIEWER_IDPrompt Table: PERSON_NAME
B=Subordinate
C=Customer
E=Executive Committee
M=Mentor
P=Peer
S=Supervisor/Manager
GVT_EP_COMMENTS(SQL Table) |
Index Back |
|---|---|
Federal Review CommentsThe federal HR Administrator uses this record to store comments from other reviewers for an employee's performance review. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 2 | REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table: PERSON_NAME |
| 3 | GVT_EP_REVW_ROLE | Character(1) | VARCHAR2(1) NOT NULL |
Federal Reviewer Roles used in Employee Review
B=Subordinate C=Customer E=Executive Committee M=Mentor P=Peer S=Supervisor/Manager |
| 4 | COMMENTS | Long Character | CLOB | Comment |