COMPRT_GRP_VW

(SQL View)
 Index Back

Comp Rate Code View

This view is used to select rate codes that do not have a rate type of percent.

SELECT COMP_RATECD ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,COMP_BASE_PAY_SW ,USE_HIGHEST_RT_SW ,COMP_RATE_TYPE ,COMPRATE ,COMP_PCT ,COMP_FREQUENCY ,CURRENCY_CD ,ERNCD FROM PS_COMP_RATECD_TBL WHERE COMP_RATE_TYPE <> 'PC' AND COMP_BASE_PAY_SW = 'Y'

  • Related Language Record: CMPRT_GRPVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 COMP_BASE_PAY_SW Character(1) VARCHAR2(1) NOT NULL Comp Base Pay Switch

    Y/N Table Edit

    Default Value: N

    7 USE_HIGHEST_RT_SW Character(1) VARCHAR2(1) NOT NULL Use Highest Rate

    Y/N Table Edit

    Default Value: N

    8 COMP_RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Rate Code Type
    FA=Flat Amount
    HF=Hourly Rate + Flat Amount
    HR=Hourly Rate
    PC=Percent
    PT=Points
    9 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    10 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    11 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Prompt Table: COMP_FREQ_VW

    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    13 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code