EMPLIDEMPL_RCDGVT_PIP_STATUS_DTGVT_PIP_STATUSI=In Progress
S=Satisfactory
U=Unsatisfactory
LANGUAGE_CDGVT_EMPL_P_LANG(SQL Table) |
Index Back |
|---|---|
Perf Improvement Pd (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. Related Language record for GVT_EMPL_PIP. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | GVT_PIP_STATUS_DT |
Date(10) | DATE NOT NULL | Status Date |
| 4 | GVT_PIP_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
PIP Status
I=In Progress S=Satisfactory U=Unsatisfactory |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | COMMENTS | Long Character | CLOB | Comment |