GPS_ATSTF_SEQEMPLIDEMPL_RCDSETIDPrompt Table: SET_VLD_HR_02
Prompt Table: DEPT_TBL
1=Without University Degree
2=With University Degree
ED=Simple Service
GD=Upper Service
HD=Supreme Service
MD=Midrange Service
C=Civil Servant
E=Employee
GPS_ATSTF_RS_V2(SQL View) |
Index Back |
|---|---|
GPS autostaff result ViewGPS autostaff result View(show succesfull result) |
| SELECT DISTINCT aeee.gps_atstf_seq ,aeee.emplid , aeee.empl_rcd , aeee.setid , allee.grade , allee.deptid , allee.fte ,aeee.gps_vacant_fte ,allee.jobcode ,allee.position_nbr ,allee.gps_sc_group ,allee.gps_pers_type ,allee.gps_csr_cd ,allee.gps_cost_Center_cd ,allee.location FROM ps_gps_atstf_ee aeee , %Table(gps_stf_alee_v2) allee WHERE aeee.setid = allee.setid AND aeee.emplid = allee.emplid AND aeee.empl_rcd = allee.empl_rcd AND gps_vacant_fte>0 AND ALLEE.GPS_GRADE = ( SELECT MAX(GPS_GRADE) FROM %Table(gps_stf_alee_v2) EE2 WHERE ALLEE.EMPLID = EE2.EMPLID AND ALLEE.EMPL_RCD = EE2.EMPL_RCD AND ALLEE.SETID = EE2.SETID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPS_ATSTF_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Auto-Staffing Sequence |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_02 |
| 5 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 7 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
| 8 | GPS_VACANT_FTE | Number(13,6) | DECIMAL(12,6) NOT NULL | GPS displays the total number of vacant FTE o person |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 11 | 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 |
| 12 | 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 |
| 13 | GPS_CSR_CD | Character(15) | VARCHAR2(15) NOT NULL | This field is used to define Civil Service Ranks. |
| 14 | GPS_COST_CENTER_CD | Character(15) | VARCHAR2(15) NOT NULL | German Public Sector Cost Center. |
| 15 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |