SETIDJOBCODESETID_SALARYSAL_ADMIN_PLANGRADEJOB_ADM_PLN_VW(SQL View) |
Index Back |
|---|---|
Job Ranking-Crnt Salary RangesJOB_ADM_PLN_VW is a dynamic SQL statement which retrieves the combinations of Salary Administration Plan and Grade which currently exist for employees in a particular Job Code from the JOBCODE_RANK view. JOBCODE_RANK is a view of the Job record which selects employees by Job Code and Salary Administration Plan and ranks them in descending order by annual salary within currency. It is used in the Salary Administration application. |
| SELECT DISTINCT A.SETID , A.JOBCODE , A.SETID_SALARY , A.SAL_ADMIN_PLAN , A.GRADE , A.STEP FROM PS_JOBCODE_RANK A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | SETID_SALARY |
Character(5) | VARCHAR2(5) NOT NULL | Salary SetID |
| 4 | SAL_ADMIN_PLAN |
Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 5 | GRADE |
Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 6 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |