SETIDEFFDTDefault Value: %date
GPS_GRADEC=Civil Servant
E=Employee
GPS_GRADEMAP_VW(SQL View) |
Index Back |
|---|
| SELECT grd.setid ,map.effdt ,grd.gps_grade , map.gps_grade , map.gps_grade_ee ,grd.seq_nbr ,grd.gps_ranking_seq ,grd.gps_pers_type ,grd.grade ,grd.gps_allowance FROM PS_GPS_GRADE_TBL grd , ps_gps_grade_map map WHERE grd.setid = map.setid AND (grd.gps_grade = map.gps_grade OR grd.gps_grade = map.gps_grade_ee) AND grd.effdt = ( SELECT MAX(sub2.effdt) FROM PS_GPS_GRADE_TBL sub2 WHERE sub2.setid = grd.setid AND sub2.gps_grade = grd.gps_grade AND sub2.effdt <= map.effdt) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPS_GRADE |
Character(8) | VARCHAR2(8) NOT NULL | Salary Grade. |
| 4 | GPS_GRADE_CS | Character(8) | VARCHAR2(8) NOT NULL | Grade in Post Managment |
| 5 | GPS_GRADE_EE | Character(8) | VARCHAR2(8) NOT NULL | Grade in Post Managment |
| 6 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | GPS_RANKING_SEQ | Number(5,0) | INTEGER NOT NULL | GPS Post Grade Ranking Sequence, This field will be used to determine the actual ranking of the grade. |
| 8 | GPS_PERS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
association to person type. A post type can be associated with a person type of Civil Servant, a person type of employee or to both.
C=Civil Servant E=Employee |
| 9 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 10 | GPS_ALLOWANCE | Character(1) | VARCHAR2(1) NOT NULL | allowance Flag |