CMP_PREM_ABS_VW

(SQL View)
Index Back

Absorbing Premium RC View

A prompt view of the Comp Rate Code Table for Absorbing Premium Rate Codes.

SELECT COMP_RATECD ,EFFDT ,EFF_STATUS ,DESCR ,COMP_BASE_PAY_SW ,COMP_RATE_TYPE ,RATE_CODE_CLASS FROM PS_COMP_RATECD_TBL WHERE COMP_BASE_PAY_SW = 'Y' AND (COMP_RATE_TYPE = 'FA' OR COMP_RATE_TYPE = 'HR') AND CMP_NON_UPD_IND = 'Y' AND RATE_CODE_CLASS <> 'SENPAY'

  • Related Language Record: CMP_PREM_ABS_LN
  • # 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
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 COMP_BASE_PAY_SW Character(1) VARCHAR2(1) NOT NULL Comp Base Pay Switch
    6 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
    7 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