EMPLIDEMPL_RCDEFFDTEVALUATION_TYPEA=Approved/Official
B=Subordinate
C=Customer
E=Executive Committee
L=Learning
M=Mentor
P=Peer
R=Supervisor/Manager
S=Self
REVIEWER_IDSEQ_NUMCOMPETENCYDefault Value: %Date
REVW_REVWER_CMP(SQL Table) |
Index Back |
|---|---|
Perf Review Factors (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. -------------------------------------------------- REVW_REVWER_CMP allows for employee ratings using various weighted factors. Each factor is rated individually and a weighted average rating is calculated. |
| # | 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 |
| 4 | EVALUATION_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Type
A=Approved/Official B=Subordinate C=Customer E=Executive Committee L=Learning M=Mentor P=Peer R=Supervisor/Manager S=Self |
| 5 | REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 6 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 8 | FACTOR_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Factor Weight |
| 9 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 10 | TOTAL_EE_POINTS | Number(3,0) | SMALLINT NOT NULL | Total Review Points |
| 11 | FP_REV_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 12 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |
| 13 | COMMENTS | Long Character | CLOB | Comment |