SETIDGRADEEFFDTDefault Value: %date
LANGUAGE_CDSAL_GRADEMC_LNG(SQL View) |
Index Back |
|---|---|
Salary Grade - Keyed by GradeSAL_GRADE_TBL is the reference table for salary ranges. The mimimum, midpoint, and maximum salary are used to calculate compa ratio and percent of range. Several edits are done in the system to warn that an employee is over the maximum or under the mimimum for their salary grade. |
| select A.SETID ,a.grade , a.effdt ,a.language_cd , a.descr from PS_SAL_GRADE_LANG a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | GRADE |
Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |