CMP_COMBO_RL_VW

(SQL View)
 Index Back

Combo Defaulting Rules View

Combo Defaulting Rules View, used as a Prompt Table.

SELECT CMP_RULE_ID , EFFDT , EFF_STATUS , CMP_RULE_DESCR50 , CMP_RULE_DESCR20 , CMP_SRC_IND FROM PS_CMP_RULE_DEFN WHERE CMP_SRC_IND = 'C'

  • Related Language Record: CMP_COMBO_RL_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CMP_RULE_ID Character(15) VARCHAR2(15) NOT NULL Compensation Defaulting Rule Identifier
    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 CMP_RULE_DESCR50 Character(50) VARCHAR2(50) NOT NULL Compensation Defaulting Rule Description
    5 CMP_RULE_DESCR20 Character(20) VARCHAR2(20) NOT NULL Compensation Defaulting Rule Short Description
    6 CMP_SRC_IND Character(1) VARCHAR2(1) NOT NULL Rate Code Source Indicator
    A=Absorbing Premium
    B=Non-Absorbing Premium
    C=Combination Rule
    E=Seniority Pay
    J=Job Code
    M=Manual
    N=None
    P=Payroll
    R=Employee Review
    S=Salary Step

    Default Value: C