GPS_BY_PTYPE(SQL View) |
Index Back |
|---|
| SELECT dtl.setid ,dtl.gps_bdg_system ,dtl.GPS_VALUE , tbl.GPS_POST_TYPE , org.descr50 FROM PS_GPS_POSTTYP_DTL dtl , PS_GPS_POSTTYP_TBL tbl , PS_GPS_ORG org WHERE org.GPS_LEVEL = tbl.GPS_LEVELS AND org.SETID = dtl.SETID AND org.GPS_BDG_SYSTEM = dtl.GPS_BDG_SYSTEM AND org.GPS_VALUE = dtl.GPS_VALUE AND org.effdt = ( SELECT MAX(sub.effdt) FROM ps_gps_org sub WHERE sub.setid = org.setid AND sub.gps_bdg_system = org.gps_bdg_system AND sub.gps_level = org.gps_level AND sub.gps_value = org.gps_value AND sub.effdt <= %CurrentDateIn) AND tbl.SETID = dtl.SETID AND tbl.GPS_BDG_SYSTEM = dtl.GPS_BDG_SYSTEM AND tbl.GPS_POST_TYPE = dtl.GPS_POST_TYPE AND tbl.EFFDT = dtl.effdt AND dtl.EFFDT = ( SELECT MAX(sub3.EFFDT) FROM PS_GPS_POSTTYP_TBL sub3 WHERE sub3.SETID = dtl.SETID AND sub3.GPS_BDG_SYSTEM = dtl.GPS_BDG_SYSTEM AND sub3.GPS_POST_TYPE = dtl.GPS_POST_TYPE AND sub3.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | GPS_BDG_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL |
Budgeting System
D=Doppik K=Kameralistik O=Other |
| 3 | GPS_VALUE | Character(8) | VARCHAR2(8) NOT NULL | Value |
| 4 | 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) |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |