SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL
SALARY_MATRIX_CDPrompt Table: SAL_MATRIX_TBL
EFFDTDefault Value: %date
REVIEW_RATINGPrompt Table: REVW_RATING_TBL
QUA_PCT_TBL_JPN(SQL Table) |
Index Back |
|---|---|
Quartile Percent TableThis record is supposed to be used to define salary increase rate based on (currently existing) Salary Matrix Code and Review-Band. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 2 | SALARY_MATRIX_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Salary Matrix Code
Prompt Table: SAL_MATRIX_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |
| 5 | BELOW_MINIMUM | Number(4,1) | DECIMAL(3,1) NOT NULL | Below Minimum |
| 6 | QUARTILE1 | Number(4,1) | DECIMAL(3,1) NOT NULL | First Quartile |
| 7 | QUARTILE2 | Number(4,1) | DECIMAL(3,1) NOT NULL | Second Quartile |
| 8 | QUARTILE3 | Number(4,1) | DECIMAL(3,1) NOT NULL | Third Quartile |
| 9 | QUARTILE4 | Number(4,1) | DECIMAL(3,1) NOT NULL | Fourth Quartile |