FPMRATECODE_VW1

(SQL View)
 Index Back

Rate Code View 1

Select only PT rate codes - 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 WHERE A.COMP_RATE_TYPE = 'PT' AND A.EFF_STATUS='A'

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