View: core.bonus_slab_scrud_view

 CREATE OR REPLACE VIEW core.bonus_slab_scrud_view
 AS
 SELECT bonus_slabs.bonus_slab_id,
    bonus_slabs.bonus_slab_code,
    bonus_slabs.bonus_slab_name,
    bonus_slabs.effective_from,
    bonus_slabs.ends_on,
    ((frequencies.frequency_code::text || '('::text) || frequencies.frequency_name::text) || ')'::text AS checking_frequency
   FROM core.bonus_slabs
   JOIN core.frequencies ON bonus_slabs.checking_frequency_id = frequencies.frequency_id;