REVW_SCALE_TBL(SQL Table) |
Index Back |
|---|---|
Perf Rvw Rtg Scale (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_SCALE_TBL is a reference table used for rating scales for performance reviews. If multiple scales are used by different parts of the organization, this table will contain one record for each of those rating scales. |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | REVW_SCALE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Review Scale Type
A=Average R=Review Band S=Summation |
| 7 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table: RATING_MDL_TBL |
| 8 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: BASE_RATECD_VW |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Prompt Table: COMP_FREQ_VW |
| 11 | PCT_PER_POINT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent per point |
| 12 | RATE_CODE_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
Rate Code Group Name
Prompt Table: COMPRT_GRP_TBL |
| 13 | AMOUNT_PER_POINT | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount per point |
| 14 | SAL_PTS_PER_POINT | Number(5,0) | INTEGER NOT NULL | Salary Points Per Point |
| 15 | MERIT_SCALE | Character(4) | VARCHAR2(4) NOT NULL |
Merit Scale
Prompt Table: MERIT_SCALE_TBL |
| 16 | AMOUNT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent Amount |
| 17 | POINT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent of Points |