GPS_GRADE_TBL(SQL Table) |
Index Back |
|---|---|
GPS Grades for postsholds grades as used for post management. SEQ_NBR defines sort order for prompting, gps_pers_type identifies a grade to be of type civil servant or employee. FIeld Grade connects the grade with the grade in table SAL_GRADE_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_05 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPS_GRADE |
Character(8) | VARCHAR2(8) NOT NULL | Salary Grade. |
| 4 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | 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. |
| 6 | 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 Default Value: C |
| 7 | GPS_SC_GROUP | Character(4) | VARCHAR2(4) NOT NULL |
This field is used to define Service Class Group values.
1=Without University Degree 2=With University Degree ED=Simple Service GD=Upper Service HD=Supreme Service MD=Midrange Service |
| 8 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: GPS_SAL_GRD_VLD |
| 9 | GPS_ALLOWANCE | Character(1) | VARCHAR2(1) NOT NULL |
allowance Flag
Y/N Table Edit Default Value: N |