EMPLIDPrompt Table: PERSON
EMPL_RCDEFFDTEVALUATION_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
SEQ_NUMCOMPETENCYLANGUAGE_CDRW_REWERCMP_LNG(SQL Table) |
Index Back |
|---|---|
Rvw Factors Rel Lng (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 REVW_REVWER_CMP. REVW_REVWER_CMP allows for employee ratings using various weighted factors. Each factor is rated individually and a weighted average is calculated. |
| # | 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 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
Prompt Table: PERSON |
| 6 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 8 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | COMMENTS | Long Character | CLOB | Comment |