RATING_SCALEPrompt Table: REVW_SCALE_TBL
EFFDTDefault Value: %date
COMPETENCYPrompt Table: COMPETENCY_TBL
SEQ_NUMREVW_FACTOR_TBL(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_FACTOR_TBL is used for weighting factors associated with rating scales. These table values are normally enetered only when all employees associated with a rating scale will be evaluated using the same factors or when some factors are determined to be so important that all employees will be evaluated regardless of their job and the rating scale used. An example of the latter would be a company where the corporate culture defines teamwork as being important at every level. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RATING_SCALE |
Character(4) | VARCHAR2(4) NOT NULL |
Rating Scale
Prompt Table: REVW_SCALE_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | FACTOR_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Factor Weight |