EMPLIDPrompt Table: PERSON
EMPL_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_IDPrompt Table: PERSON
LANGUAGE_CDRW_REVIEWER_LNG(SQL Table) |
Index Back |
|---|---|
Rvw Participants RL (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_REVIEWERS. 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
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 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
Prompt Table: PERSON |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | COMMENTS | Long Character | CLOB | Comment |