GPS_ORGACCS_TMP(SQL Table) |
Index Back |
|---|---|
GPS Budget System AccessThe accessibility of organizational details of a particular budgeting system. |
| # | 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
Prompt Table: GPS_ORG_ACS_TBL |
| 4 | GPS_LEVEL | Number(1,0) | SMALLINT NOT NULL | Level |
| 5 | GPS_VALUE | Character(8) | VARCHAR2(8) NOT NULL | Value |
| 6 | GPS_PARENT | Character(8) | VARCHAR2(8) NOT NULL | Parent Value |