HRS_GVT_PPLN_VW

(SQL View)
 Index Back

Government Pay Plan

Returns government pay plan details.

SELECT PPLN.GVT_PAY_PLAN , PPLN.DESCR , PPLN.DESCRSHORT , PPLN.GVT_AUTO_WGI , PPLN.GVT_CLASS_AUTH , PPLN.GVT_IGA_PAY , PPLN.GVT_LEO_PAY , PPLN.GVT_LOCALITY_PAY , PPLN.GVT_PREMIUM_PAY , PPLN.GVT_SAL_STEP_TYPE , PPLN.GVT_BW_LIM_OK_PAY , PPLN.ERNCD_SPCL , PPLN.GVT_FEGLI_ACCUM , PPLN.GVT_PAY_LIMIT_REQ FROM PS_GVT_PAY_PLAN PPLN WHERE %EffdtCheck(GVT_PAY_PLAN PPLN2, PPLN, %CurrentDateIn) AND PPLN.EFF_STATUS = 'A'

  • Related Language Record: HRS_GVT_PPLNLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 GVT_AUTO_WGI Character(1) VARCHAR2(1) NOT NULL Auto Within Grade Increase

    Y/N Table Edit

    Default Value: Y

    5 GVT_CLASS_AUTH Character(2) VARCHAR2(2) NOT NULL Classification Authority
    05=Title 5, Other
    38=Title 38, United States Code
    GE=Equivalent to GS Class System
    GS=Title 5, GS Class System
    WE=Equivalent to Title 5 FWS
    WG=Title 5, Prevailing Rate Sys

    Default Value: GS

    6 GVT_IGA_PAY Character(1) VARCHAR2(1) NOT NULL Interim Geographic Adjustment

    Y/N Table Edit

    Default Value: N

    7 GVT_LEO_PAY Character(1) VARCHAR2(1) NOT NULL Law Enforcement Officer Pay

    Y/N Table Edit

    Default Value: N

    8 GVT_LOCALITY_PAY Character(1) VARCHAR2(1) NOT NULL Locality Adjusted Pay

    Y/N Table Edit

    Default Value: N

    9 GVT_PREMIUM_PAY Character(1) VARCHAR2(1) NOT NULL Premium Pay

    Y/N Table Edit

    Default Value: N

    10 GVT_SAL_STEP_TYPE Character(1) VARCHAR2(1) NOT NULL Non-Numeric Steps

    Y/N Table Edit

    Default Value: N

    11 GVT_BW_LIM_OK_PAY Character(1) VARCHAR2(1) NOT NULL OK to Pay

    Y/N Table Edit

    Default Value: N

    12 ERNCD_SPCL Character(3) VARCHAR2(3) NOT NULL Special Accumulator Code

    Prompt Table: SPCL_EARNS_TBL

    13 GVT_FEGLI_ACCUM Character(3) VARCHAR2(3) NOT NULL Field used to store Special FEGLI Accum

    Prompt Table: GVT_ERN_SPCL_VW

    14 GVT_PAY_LIMIT_REQ Character(1) VARCHAR2(1) NOT NULL Pay Limit Check Required

    Y/N Table Edit

    Default Value: N