CRC_FA_JPN_VW

(SQL View)
 Index Back

Step Comp Rate View

This is the view to define CompRateCodes which will be used to update salary increase by amount

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 ,FTE_INDICATOR ,RATE_CODE_CLASS ,SENIORITY_CALC FROM PS_COMP_RATECD_TBL WHERE RATE_CODE_CLASS<>'GRPPAY' AND RATE_CODE_CLASS<>'SENPAY' AND COMP_RATE_TYPE='FA'

  • Related Language Record: COMP_RATCD_LANG

    • # 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

    Prompt Table: COMP_RT_ERNS_VW

    14 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization

    Y/N Table Edit

    Default Value: N

    15 RATE_CODE_CLASS Character(6) VARCHAR2(6) NOT NULL Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table.

    Prompt Table: RATECD_CLS_TBL

    16 SENIORITY_CALC Character(1) VARCHAR2(1) NOT NULL This field defines by what date seniority should be calculated for the Seniority Pay compensation component.
    B=Birth Date
    E=EdclvlaBDt (for Japan only)
    H=Hire Date
    P=Professional Experience Date
    S=Company Seniority Date