View: core.county_scrud_view

 CREATE OR REPLACE VIEW core.county_scrud_view
 AS
 SELECT counties.county_id,
    counties.county_code,
    counties.county_name,
    ((states.state_code::text || '('::text) || states.state_name::text) || ')'::text AS state
   FROM core.counties
   JOIN core.states ON counties.state_id = states.state_id;