GPS_ORG_ACS_SC(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
Default Value: OPR_DEF_TBL_HR.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 |
| 7 | 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 |
| 8 | ACCESSIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Accessible
Y/N Table Edit Default Value: N |
| 9 | GPS_CASCADE | Character(1) | VARCHAR2(1) NOT NULL |
The flag used in security setup, possible values are:
Y: Cascade
N: Only current level
N=Only Current Level Y=Cascade Default Value: Y |