COMP_RC_NOMX_VW

(SQL View)
 Index Back

Comp Rate Code Tbl - no matrix

4/29/04 : This view reflects the COMP_RATECD_TBL. It EXCLUDES matrix associated rate codes.

SELECT A.COMP_RATECD , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.COMP_BASE_PAY_SW , A.USE_HIGHEST_RT_SW , A.COMP_RATE_TYPE , A.COMPRATE , A.COMP_PCT , A.COMP_FREQUENCY , A.CURRENCY_CD , A.ERNCD , A.FTE_INDICATOR , A.RATE_CODE_CLASS , A.SENIORITY_CALC , %subrec(COMP_RT_AUS_SBR,A) , A.CMP_NON_UPD_IND , A.CMP_CALC_BY , A.LOOKUP_ID , A.CMP_PAYABLE_SW FROM PS_COMP_RATECD_TBL A WHERE A.CMP_CALC_BY = 'ZZ'

  • 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
    17 SAL_PKG_WARN Character(1) VARCHAR2(1) NOT NULL Sal package - Maintained via Package Only

    Y/N Table Edit

    Default Value: N

    18 CMP_NON_UPD_IND Character(1) VARCHAR2(1) NOT NULL Non-Updateable Component Indicator

    Y/N Table Edit

    Default Value: N

    19 CMP_CALC_BY Character(2) VARCHAR2(2) NOT NULL Calculated By
    EX=Extended
    RM=Rate Matrix
    ZZ=None
    20 LOOKUP_ID Character(15) VARCHAR2(15) NOT NULL Main unique identifier for Configurable Matrices.
    21 CMP_PAYABLE_SW Character(1) VARCHAR2(1) NOT NULL Payable Switch