| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
GPS_POST_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
GPS post id
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 6 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 7 |
GPS_DIVIDED_FRAC |
Number(2,0) |
SMALLINT NOT NULL |
Number of EE splitted .
|
| 8 |
GPS_ATSTF_RSV_INCL |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved post included
|
| 9 |
GPS_ATSTF_MAX_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Maximum number of posts a person can be assigned to.
|
| 10 |
GPS_ATSTF_HGA |
Character(1) |
VARCHAR2(1) NOT NULL |
Are Posts with lower grade allowed
Y/N Table Edit
|
| 11 |
GPS_ATSTF_PSE_AL |
Character(1) |
VARCHAR2(1) NOT NULL |
PSE employees allowed to be assigned to CS posts
Y/N Table Edit
|
| 12 |
UPDATE_ROW_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Row Number
|
| 13 |
GPS_COMMENT |
Character(254) |
VARCHAR2(254) NOT NULL |
GPS comments
|
| 14 |
GPS_ATSTF_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Type
C=Perform Custom Process
E=Automatic Staffing for All
|
| 15 |
GPS_PERS_TYPE |
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
|
| 16 |
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
|
| 17 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 18 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 19 |
GPS_ATSTF_ROUND |
Number(1,0) |
SMALLINT NOT NULL |
Used in GPS auto staffing process.store round of staffing.
Default Value: 0
|
| 20 |
GPS_ATSTF_MAXROUND |
Number(1,0) |
SMALLINT NOT NULL |
Used in GPS auto staffing process.store round of staffing.
|
| 21 |
GPS_ATSTF_SEQ |
Number(10,0) |
DECIMAL(10) NOT NULL |
Auto-Staffing Sequence
|
| 22 |
GPS_COST_CENTER_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
German Public Sector Cost Center.
|
| 23 |
GPS_RANKING_SEQ |
Number(5,0) |
INTEGER NOT NULL |
GPS Post Grade Ranking Sequence, This field will be used to determine the actual ranking of the grade.
|
| 24 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 25 |
GPS_VACANT_FTE |
Number(13,6) |
DECIMAL(12,6) NOT NULL |
GPS displays the total number of vacant FTE o person
|
| 26 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 27 |
GPS_FRACTION |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
GPS Fraction
|
| 28 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 29 |
AE_ROW_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
in Scroll
|
| 30 |
GPS_ATSTF_ROW_CNT |
Number(5,0) |
INTEGER NOT NULL |
stroe proceed row count in auto staffing AE.
|
| 31 |
GPS_ATSTF_RD_DESC |
Character(200) |
VARCHAR2(200) NOT NULL |
auto staffing ae round descriptions.
|
| 32 |
GPS_POST_PLN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Plan TYpe
0=Base Plan
1=1. Amendment Plan
2=2. Amendment Plan
3=3. Amendment Plan
4=4. Amendment Plan
|
| 33 |
GPS_ROWID |
Character(45) |
VARCHAR2(45) NOT NULL |
RowID, a condensed version of the key fields of a budgeting system
|
| 34 |
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)
|
| 35 |
GPS_GRADE |
Character(8) |
VARCHAR2(8) NOT NULL |
Salary Grade.
|
| 36 |
GPS_RANK |
Character(15) |
VARCHAR2(15) NOT NULL |
Rank for GPS
|
| 37 |
YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Character field to represent a year
|
| 38 |
GPS_DESCR2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description 2
|
| 39 |
GPS_CSR_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
This field is used to define Civil Service Ranks.
|