EMPLIDEMPL_RCDEFFDTDefault Value: %date
GOAL_NBRLANGUAGE_CDREV_GOALS_LNG(SQL Table) |
Index Back |
|---|---|
Rvw Goals Rel Lang (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. -------------------------------------------------- Related Language Table of REVIEW_GOALS. 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 Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GOAL_NBR |
Number(2,0) | SMALLINT NOT NULL | Goal Number |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | CAREER_GOAL | Character(40) | VARCHAR2(40) NOT NULL | Career Goal |