OPRIDSETIDGPS_ROWID1=Without University Degree
2=With University Degree
ED=Simple Service
GD=Upper Service
HD=Supreme Service
MD=Midrange Service
GPS_SCRTYPM1_VW(SQL View) |
Index Back |
|---|---|
GPS Security by BDG Systemensures security by budgeting system and service class group can be implemented |
| SELECT opr.OPRID ,ORG.SETID ,ORG.GPS_ROWID ,ORG.GPS_SC_GROUP FROM PSOPRDEFN OPR ,PS_GPS_ORG_ACS_DTL ORG WHERE 1=1 AND (EXISTS ( SELECT 'X' FROM PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE CLS.SCRTY_SET_CD = 'GPSPOST' AND CLS.SCRTY_TYPE_CD = '037' AND CLS.SCRTY_KEY1 = ORG.SETID AND CLS.SCRTY_KEY2 = ORG.GPS_BDG_SYSTEM AND CLS.SCRTY_KEY3 = ORG.GPS_SCRY_TREE_NAME AND SOC.OPRID=OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND SOC.CLASSID = OPR.ROWSECCLASS AND SOC.SEC_RSC_FLG <> '2' AND ORG.ACCESSIBLE = 'Y' ) OR EXISTS ( SELECT 'X' FROM PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE CLS.SCRTY_SET_CD = 'GPSPOST' AND CLS.SCRTY_TYPE_CD = '037' AND CLS.SCRTY_KEY1 = ORG.SETID AND CLS.SCRTY_KEY2 = ORG.GPS_BDG_SYSTEM AND CLS.SCRTY_KEY3 = ORG.GPS_SCRY_TREE_NAME AND SOC.OPRID=OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND SOC.SEC_RSC_FLG ='2' AND ORG.ACCESSIBLE = 'Y')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | GPS_ROWID |
Character(45) | VARCHAR2(45) NOT NULL | RowID, a condensed version of the key fields of a budgeting system |
| 4 | 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 |