HCR_JOB_GPS_STG

(SQL Table)
Index Back

GPS Job Table

Staging for job modernization Stores Job Data attributes that are specific to the German Public Sector.

  • Parent record: JOB
  • # 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