EMPLIDEMPL_RCDEFFDTDefault Value: %DATE
EVALUATION_TYPEA=Approved/Official
B=Subordinate
C=Customer
E=Executive Committee
L=Learning
M=Mentor
P=Peer
R=Supervisor/Manager
S=Self
REVIEWER_IDREVIEW_REVIEWER(SQL Table) |
Index Back |
|---|---|
Rvw Participants (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. -------------------------------------------------- In this record each reviewer id, the evaluation type and the weight of each reviewer in the review will be stored. |
| # | 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 | 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 | FACTOR_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Factor Weight |
| 7 | TOTAL_EE_POINTS | Number(3,0) | SMALLINT NOT NULL | Total Review Points |
| 8 | FINAL_RVW_BAND_CD | Character(1) | VARCHAR2(1) NOT NULL | Final Review Band |
| 9 | COMMENTS | Long Character | CLOB | Comment |