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
SAL_MATRIX_PCT(SQL Table) |
Index Back |
|---|---|
Salary Matrix Percent TableSAL_MATRIX_PCT is the record in which the acceptable percentage ranges for salary increases are stored for each rating and quartile through the salary range. The quartile represents the position in range calculated using the salary grade table. |
| # | 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_MIN | Number(4,1) | DECIMAL(3,1) NOT NULL | Below Minimum Mimimum Increase |
| 6 | BELOW_MINIMUM_MAX | Number(4,1) | DECIMAL(3,1) NOT NULL | Below Minimum Maximum Increase |
| 7 | QUARTILE1_MIN | Number(4,1) | DECIMAL(3,1) NOT NULL | First Quartile Miminum |
| 8 | QUARTILE1_MAX | Number(4,1) | DECIMAL(3,1) NOT NULL | First Quartile Maximum |
| 9 | QUARTILE2_MIN | Number(4,1) | DECIMAL(3,1) NOT NULL | Second Quartile Minimum |
| 10 | QUARTILE2_MAX | Number(4,1) | DECIMAL(3,1) NOT NULL | Second Quartile Maximum |
| 11 | QUARTILE3_MIN | Number(4,1) | DECIMAL(3,1) NOT NULL | Third Quartile Minimum |
| 12 | QUARTILE3_MAX | Number(4,1) | DECIMAL(3,1) NOT NULL | Third Quartile Maximum |
| 13 | QUARTILE4_MIN | Number(4,1) | DECIMAL(3,1) NOT NULL | Fourth Quartile Minimum |
| 14 | QUARTILE4_MAX | Number(4,1) | DECIMAL(3,1) NOT NULL | Fourth Quartile Maximum |