MERIT_SCALEEFFDTMERIT_GROUPMERIT_GROUP_TBL(SQL Table) |
Index Back |
|---|---|
Merit Group Tbl (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. -------------------------------------------------- Merit Group Tbl - Employee review |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERIT_SCALE |
Character(4) | VARCHAR2(4) NOT NULL | Merit Scale |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | MERIT_GROUP |
Character(3) | VARCHAR2(3) NOT NULL | Merit Lookup Group |
| 4 | FROM_POINTS | Number(3,0) | SMALLINT NOT NULL | From Points |
| 5 | TO_POINTS | Number(3,0) | SMALLINT NOT NULL | To Points |
| 6 | PCT_PER_POINT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent per point |
| 7 | RATE_CODE_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Rate Code Group Name |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | AMOUNT_PER_POINT | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount per point |
| 10 | SAL_PTS_PER_POINT | Number(5,0) | INTEGER NOT NULL | Salary Points Per Point |
| 11 | REVIEW_BAND_CD | Character(1) | VARCHAR2(1) NOT NULL | Review Band |
| 12 | ELIGIBILITY_POINTS | Number(5,1) | DECIMAL(4,1) NOT NULL | This field represents the minimum number of review points that must be met for an employee to graduate out of the grade |