EMPLIDPrompt Table: PERSON
EMPL_RCDGVT_PIP_STATUS_DTDefault Value: %date
GVT_PIP_STATUSI=In Progress
S=Satisfactory
U=Unsatisfactory
Y/N Table Edit
Default Value: N
GVT_EMPL_PIP(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. |
| # | 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 | GVT_PIP_STATUS_DT |
Date(10) | DATE NOT NULL |
Status Date
Default Value: %date |
| 4 | GVT_PIP_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
PIP Status
I=In Progress S=Satisfactory U=Unsatisfactory |
| 5 | REVIEW_FROM_DT | Date(10) | DATE | Review Period From |
| 6 | REVIEW_THRU_DT | Date(10) | DATE | Review Period To |
| 7 | GVT_PIP_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
PIP Completed
Y/N Table Edit Default Value: N |
| 8 | COMMENTS | Long Character | CLOB | Comment |