|
SELECT A.EMPLID ,A.EMPL_RCD ,A.GPS_REMUN_REG ,A.GPS_JG_SC ,A.GPS_JG_JOB ,A.GPS_SC_GROUP ,A.GPS_BDA_DATE ,A.GPS_TRANSN_STEP ,A.GPS_CSR_CD ,A.GPS_FAM_ALLOW_IND ,A.GPS_FA_FTE_PCT ,A.GPS_CASE_GROUP ,A.GPS_PRB_PERIOD ,A.GPS_PRB_END_DT ,A.GPS_PRE_PERIOD ,A.GPS_PRE_END_DT ,A.GPS_NXT_GR_STEP ,A.GPS_NXT_STEP_DT ,A.GPS_PERF_STEP_DT ,A.GPS_STEP_ACTION ,A.GPS_STEP_ACTION_DT ,A.GPS_ALLOW_FLG ,A.GPS_WFS_MUNICIPLTY FROM PS_JOB_GPS A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB_GPS JOB2 WHERE A.EMPLID = JOB2.EMPLID AND A.EMPL_RCD = JOB2.EMPL_RCD AND JOB2.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB_GPS JOB3 WHERE JOB3.EMPLID = A.EMPLID AND JOB3.EMPL_RCD = A.EMPL_RCD AND JOB3.EFFDT = A.EFFDT)
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: JOB.EMPLID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
Default Value: JOB.EMPL_RCD
|
| 3 |
GPS_REMUN_REG |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used for Remuneration Regulation values.
Prompt Table:
GPS_REMREGMAPVW
|
| 4 |
GPS_JG_SC |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used for Job Group/Service Class values.
Prompt Table:
GPS_JGSCMAP_VW
|
| 5 |
GPS_JG_JOB |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to define GPS Job values.
Prompt Table:
GPS_JGJOBMAP_VW
|
| 6 |
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
Prompt Table:
GPS_SCGRPMAP_VW
|
| 7 |
GPS_BDA_DATE |
Date(10) |
DATE |
This field is used define BDA Date for GPS.
|
| 8 |
GPS_TRANSN_STEP |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used as a flag to identify if the GPS employee on a transition step.
Y/N Table Edit
Default Value: N
|
| 9 |
GPS_CSR_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
This field is used to define Civil Service Ranks.
Prompt Table:
GPS_JGSCGRSR_VW
|
| 10 |
GPS_FAM_ALLOW_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate if a person is eligible for family allowance.
Y/N Table Edit
Default Value: N
|
| 11 |
GPS_FA_FTE_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Family Allowance FTE Percentage.
|
| 12 |
GPS_CASE_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to define Case Groups for GPS.
|
| 13 |
GPS_PRB_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to define the Standard Probation Period.
|
| 14 |
GPS_PRB_END_DT |
Date(10) |
DATE |
This field stores the Probation End Date.
|
| 15 |
GPS_PRE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to define Pre-Service Period in Months.
|
| 16 |
GPS_PRE_END_DT |
Date(10) |
DATE |
This field stores the Pre-Service End Date
|
| 17 |
GPS_NXT_GR_STEP |
Number(2,0) |
SMALLINT NOT NULL |
This field stores the Next Grade Step.
|
| 18 |
GPS_NXT_STEP_DT |
Date(10) |
DATE |
This stores the Next Grade Step Date.
|
| 19 |
GPS_PERF_STEP_DT |
Date(10) |
DATE |
This stores the Performance Step Date.
|
| 20 |
GPS_STEP_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores values of Grade Step Action.
D=Demote
H=Hire
M=Manual
P=Promote
|
| 21 |
GPS_STEP_ACTION_DT |
Date(10) |
DATE |
This field stores Step Action Date.
|
| 22 |
GPS_ALLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allowance flag.
Y/N Table Edit
Default Value: N
|
| 23 |
GPS_WFS_MUNICIPLTY |
Character(8) |
VARCHAR2(8) NOT NULL |
Municipality (EF 14) for German Public Sector Workforce Statistics.
Prompt Table:
GPS_RPT_JB_M_DW
|