MERIT_SCALEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
MERIT_SCALE_TBL(SQL Table) |
Index Back |
|---|---|
Merit Scale Lookup (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. -------------------------------------------------- The Merit Scale Lookup Table is used to convert the review points earned by an employee into either a flat amount, a percentage or salary points by looking into the Merit Group Table. |
| # | 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
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 |