SETIDGRADEEFFDTDefault Value: %date
FT_SAL_GRADE_VW(SQL View) |
Index Back |
|---|---|
Current Salary Ranges by GradeSAL_GRADE_VW is a view of the Salary Grade table which retrieves current ranges. It is used in the Salary Administration application. |
| SELECT DISTINCT A.SETID ,A.GRADE , MIN(A.EFFDT) FROM PS_SAL_GRADE_TBL A WHERE A.EFFDT = ( SELECT MIN(B.EFFDT) FROM PS_SAL_GRADE_TBL B WHERE B.GRADE = A.GRADE AND B.EFFDT = A.EFFDT) GROUP BY A.SETID,A.GRADE |
| # | 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 |
Effective Date
Default Value: %date |