PSARCH_IDPSARCH_BATCHNUMEP_APPRAISAL_IDREVIEWER_IDPrompt Table: PERSON_NAME
B=Subordinate
C=Customer
E=Executive Committee
M=Mentor
P=Peer
S=Supervisor/Manager
GVT_EP_CMNT_HST(SQL Table) |
Index Back |
|---|---|
Federal Rvw Comments ArchiveThe 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 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 4 | REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table: PERSON_NAME |
| 5 | 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 |
| 6 | COMMENTS | Long Character | CLOB | Comment |