JBCD_CMP_RT3_VW

(SQL View)
 Index Back

View of JOBCD_COMP_RATE table

This view is used as a grid on the JOBCD_NON_BASE panel. It is used instead of the JOBCD_COMP_RATE record because otherwise, the JOBCD_COMP_RATE record would need to appear on two different panels within the same panel group. Changes made to the JOBCD_COMP_RATE record must be applied to this view as well.

SELECT SETID , JOBCODE , EFFDT , COMP_RATECD , COMP_FREQUENCY , COMPRATE , COMP_PCT , CURRENCY_CD , COMP_RATE_POINTS , RATE_CODE_GROUP , FTE_INDICATOR FROM PS_JOBCD_COMP_RATE

  • Parent record: JOBCODE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RATE_NB_VW

    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: COMP_FREQ_VW

    6 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    7 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
    10 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

    Prompt Table: COMPRT_GRP_TBL

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

    Y/N Table Edit

    Default Value: N