RATING_SCALEEFFDTCOMPETENCYSEQ_NUMREVIEW_RATINGPrompt Table: REVW_RATING_TBL
REVW_FCT_PT_TBL(SQL Table) |
Index Back |
|---|---|
Rvw Factor Points (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. -------------------------------------------------- Review Factor Points Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RATING_SCALE |
Character(4) | VARCHAR2(4) NOT NULL | Rating Scale |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |
| 6 | REVIEW_POINTS | Number(3,0) | SMALLINT NOT NULL | Review Points |