EMPLIDPrompt Table: PERSON
EMPL_RCDEFFDTDefault Value: %date
GVT_PERF_PLANGVT_PERF_ELEMNTPrompt Table: REVW_RATING_TBL
GVT_EMP_ELEMNT(SQL Table) |
Index Back |
|---|---|
Performance Element (Obsolete)OBSOLETE! This table is obsolete as of Release 8.4. It contains "frozen" data that was not upgraded. It is retained for historical queries only and should not be edited. This table is no longer maintained by PeopleSoft and will be dropped during a subsequent release. -------------------------------------------------- Use EMPLOYEE_REVIEW to record dates and results of performance reviews for an employee. You can create multiple EMPLOYEE_REVIEW records for an employee. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GVT_PERF_PLAN |
Character(8) | VARCHAR2(8) NOT NULL | Performance Plan |
| 5 | GVT_PERF_ELEMNT |
Character(2) | VARCHAR2(2) NOT NULL | Performance Element Number |
| 6 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |