GPS_ORG_ACS_DTL(SQL Table) |
Index Back |
|---|
| # | 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_ROWID |
Character(45) | VARCHAR2(45) NOT NULL | RowID, a condensed version of the key fields of a budgeting system |
| 5 | 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 |
| 6 | ACCESSIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Accessible
Y/N Table Edit Default Value: N |