EMPLOYEE_REVIEW(SQL Table) |
Index Back |
|---|---|
EE Performance Rvws (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 |
| 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 | NEXT_REVIEW_DT | Date(10) | DATE | Next Review Date |
| 5 | REVIEW_FROM_DT | Date(10) | DATE | Review Period From |
| 6 | REVIEW_THRU_DT | Date(10) | DATE | Review Period To |
| 7 | REVIEW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Review Type
A=Self Assesssment B=Both E=Employee Feedback I=Initial Rating M=Interim Rating O=Official Rating P=Performance R=Adjustment Result S=Salary Default Value: S |
| 8 | RATING_SCALE | Character(4) | VARCHAR2(4) NOT NULL | Rating Scale |
| 9 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 10 | TOTAL_EE_AMOUNT | Number(19,6) | DECIMAL(18,6) NOT NULL | Total Review Amount |
| 11 | TOTAL_EE_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL | Total Review Percent |
| 12 | TOTAL_EE_POINTS | Number(3,0) | SMALLINT NOT NULL | Total Review Points |
| 13 | TOTAL_EE_SAL_PTS | Number(5,0) | INTEGER NOT NULL | Total Review Salary Points |
| 14 | EMPL_REVW_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employee Review Status
A=Approved I=Ineligible N=No Increase P=Proposed R=Processed Default Value: P |
| 15 | LOADED_TO_JOB | Character(1) | VARCHAR2(1) NOT NULL |
Loaded to Job
Y/N Table Edit Default Value: N |
| 16 | RES_RVW_BAND_CD | Character(1) | VARCHAR2(1) NOT NULL | Resulting Review Band |
| 17 | FINAL_RVW_BAND_CD | Character(1) | VARCHAR2(1) NOT NULL | Final Review Band |
| 18 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 19 | GVT_OPM_RATING | Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
1=Level I 2=Level II 3=Level III 4=Level IV 5=Level V X=Not Rated Z=Exclusion |
| 20 | FP_REV_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 21 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |