HCR_JOB_GPS_STG(SQL Table) |
Index Back |
---|---|
GPS Job TableStaging for job modernization Stores Job Data attributes that are specific to the German Public Sector. |
# | 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 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: JOB.EFFDT |
4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: JOB.EFFSEQ |
5 | HCR_ACTN_SEQN | Number(3,0) | SMALLINT NOT NULL | Sequence number |
6 | GPS_REMUN_REG | Character(4) | VARCHAR2(4) NOT NULL |
This field is used for Remuneration Regulation values.
Prompt Table: GPS_REMREGMAPVW |
7 | GPS_JG_SC | Character(4) | VARCHAR2(4) NOT NULL |
This field is used for Job Group/Service Class values.
Prompt Table: GPS_JGSCMAP_VW |
8 | GPS_JG_JOB | Character(4) | VARCHAR2(4) NOT NULL |
This field is used to define GPS Job values.
Prompt Table: GPS_JGJOBMAP_VW |
9 | 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 |
10 | GPS_BDA_DATE | Date(10) | DATE | This field is used define BDA Date for GPS. |
11 | 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 |
12 | GPS_CSR_CD | Character(15) | VARCHAR2(15) NOT NULL |
This field is used to define Civil Service Ranks.
Prompt Table: GPS_JGSCGRSR_VW |
13 | 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 |
14 | GPS_FA_FTE_PCT | Number(3,0) | SMALLINT NOT NULL | Family Allowance FTE Percentage. |
15 | GPS_CASE_GROUP | Character(4) | VARCHAR2(4) NOT NULL | This field is used to define Case Groups for GPS. |
16 | GPS_PRB_PERIOD | Number(3,0) | SMALLINT NOT NULL | This field is used to define the Standard Probation Period. |
17 | GPS_PRB_END_DT | Date(10) | DATE | This field stores the Probation End Date. |
18 | GPS_PRE_PERIOD | Number(3,0) | SMALLINT NOT NULL | This field is used to define Pre-Service Period in Months. |
19 | GPS_PRE_END_DT | Date(10) | DATE | This field stores the Pre-Service End Date |
20 | GPS_NXT_GR_STEP | Number(2,0) | SMALLINT NOT NULL | This field stores the Next Grade Step. |
21 | GPS_NXT_STEP_DT | Date(10) | DATE | This stores the Next Grade Step Date. |
22 | GPS_PERF_STEP_DT | Date(10) | DATE | This stores the Performance Step Date. |
23 | 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 |
24 | GPS_STEP_ACTION_DT | Date(10) | DATE | This field stores Step Action Date. |
25 | GPS_ALLOW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allowance flag.
Y/N Table Edit Default Value: N |
26 | 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 |