GPS_POST_SEQ_VW(SQL View) |
Index Back |
|---|---|
GPS Post in Planpost associated with a particular post plan (per year) |
| SELECT SETID ,YEAR ,GPS_POST_PLN_TYPE ,GPS_ROWID ,GPS_GRADE ,GPS_RANK ,GPS_POST_TYPE , SEQ_NBR ,GPS_POST_ID ,EFF_STATUS FROM %Table(GPS_POST) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_02 |
| 2 | YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Character field to represent a year |
| 3 | GPS_POST_PLN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Post Plan TYpe
0=Base Plan 1=1. Amendment Plan 2=2. Amendment Plan 3=3. Amendment Plan 4=4. Amendment Plan |
| 4 | GPS_ROWID |
Character(45) | VARCHAR2(45) NOT NULL | RowID, a condensed version of the key fields of a budgeting system |
| 5 | GPS_GRADE |
Character(8) | VARCHAR2(8) NOT NULL | Salary Grade. |
| 6 | GPS_RANK |
Character(15) | VARCHAR2(15) NOT NULL | Rank for GPS |
| 7 | GPS_POST_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Post Type
AND=Other (Civil Service) ANE=Other (Employee) ANG=Public Sector Employee ANW=Civil Servant on Recall AZU=Apprentice BEA=Civil Servant ERE=Replacement Post (Employee) ERS=Replacement Post (Civil Serv.) LEB=Empty Post (Civil Service) LEE=Empty Post (Employee) |
| 8 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 9 | GPS_POST_ID | Character(8) | VARCHAR2(8) NOT NULL | GPS post id |
| 10 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |