FPMRATECODE_VW2

(SQL View)
 Index Back

Rate Code View 2

Select only FA and HR rate codes with frequency H, M or A - used in Point Type Definition

SELECT A.COMP_RATECD , A.EFFDT , A.EFF_STATUS , A.DESCR , A.COMP_FREQUENCY , A.CURRENCY_CD FROM PS_COMP_RATECD_TBL A , PS_COMP_FREQ_VW B WHERE B.FREQUENCY_ID = A.COMP_FREQUENCY AND A.COMP_RATE_TYPE IN ('FA','HR') AND A.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_COMP_FREQ_VW B_ED WHERE B.FREQUENCY_ID = B_ED.FREQUENCY_ID AND B_ED.EFFDT <= A.EFFDT AND B.FREQUENCY_TYPE IN ('A','M','H')) AND B.EFF_STATUS = 'A' AND B.FREQUENCY_TYPE IN ('A','M','H')

  • Related Language Record: FPMRATECD2_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 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: FREQUENCY_TBL

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

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL