EMPLIDEMPL_RCDEFFDTDefault Value: %date
GOAL_NBRE=Exceeded
M=Met
N=Not Met
Default Value: N
REVIEW_GOALS(SQL Table) |
Index Back |
|---|---|
EE Perf Rvw Goals (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. -------------------------------------------------- REVIEW_GOALS tracks employee goals set for the coming year during a performance review. If these goals remain unmet, they are carried forward to the next year. If they met, record the status and the date completed. |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GOAL_NBR |
Number(2,0) | SMALLINT NOT NULL | Goal Number |
| 5 | CAREER_GOAL | Character(120) | VARCHAR2(120) NOT NULL | Career Goal |
| 6 | GOAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Goal Status
E=Exceeded M=Met N=Not Met Default Value: N |
| 7 | ACT_COMPLETION_DT | Date(10) | DATE | Actual Completion Date |