| # |
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
|
| 2 |
GPS_BDG_SYSTEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Budgeting System
D=Doppik
K=Kameralistik
O=Other
|
| 3 |
GPS_POST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Post Type
AND=Other (Civil Service)
ANE=Other (Employee)
ANG=Public Sector Employee
ANW=Civil Servant on Recall
AZU=Apprentice
BEA=Civil Servant
ERE=Replacement Post (Employee)
ERS=Replacement Post (Civil Serv.)
LEB=Empty Post (Civil Service)
LEE=Empty Post (Employee)
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
GPS_PERS_TYPE_MAP |
Character(1) |
VARCHAR2(1) NOT NULL |
association to person type. A post type can be associated with a person type of Civil Servant, a person type of employee or to both.
C=Civil Servant
E=Employee
Default Value: C
|
| 7 |
GPS_TYPE_AVAILABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Type availability. Through which phases a post type is available.
1=Planning Phase
2=Administration Phase
3=Both
Default Value: 1
|
| 8 |
GPS_LEVELS |
Number(1,0) |
SMALLINT NOT NULL |
amount of levels
|