SETIDPrompt Table: SET_VLD_HR_05
GPS_BDG_SYSTEMD=Doppik
K=Kameralistik
O=Other
GPS_SCRY_TREE_NAMEGPS_ORGACCSS_VW(SQL View) |
Index Back |
|---|---|
GPS security viewused to join gps post management security |
| SELECT DISTINCT setid ,gps_bdg_system ,gps_scry_tree_name FROM PS_GPS_ORG_ACCESS |
| # | 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 | GPS_BDG_SYSTEM |
Character(1) | VARCHAR2(1) NOT NULL |
Budgeting System
D=Doppik K=Kameralistik O=Other |
| 3 | GPS_SCRY_TREE_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Security Tree Name for GPS |