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 Record |
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 |