cos_geo_org_unit_flat_vw

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

region_code

varchar

10

√

null

region_name

varchar

50

√

null

zone_code

varchar

10

√

null

zone_name

varchar

50

√

null

offloc_code

varchar

10

√

null

offloc_name

varchar

50

√

null

area_code

varchar

10

√

null

area_name

varchar

50

√

null

administrative_office_ind

bool

1

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT DISTINCT gou.geo_organization_unit_code AS region_code,
    gou.short_description AS region_name,
    gou2.geo_organization_unit_code AS zone_code,
    gou2.short_description AS zone_name,
    gou3.geo_organization_unit_code AS offloc_code,
    gou3.short_description AS offloc_name,
    (COALESCE(gou4.geo_organization_unit_code, NULL::character varying))::character varying(10) AS area_code,
    (COALESCE(gou4.short_description, NULL::character varying))::character varying(50) AS area_name,
    gou3.administrative_office_ind
   FROM (((((((geo_org_unit_structure gos
     JOIN geo_organization_unit_code gou ON (((gos.parent_geo_org_unit_code)::text = (gou.geo_organization_unit_code)::text)))
     JOIN geo_org_unit_structure gos2 ON (((gos2.parent_geo_org_unit_code)::text = (gou.geo_organization_unit_code)::text)))
     JOIN geo_organization_unit_code gou2 ON (((gos2.child_geo_org_unit_code)::text = (gou2.geo_organization_unit_code)::text)))
     JOIN geo_org_unit_structure gos3 ON (((gos3.parent_geo_org_unit_code)::text = (gou2.geo_organization_unit_code)::text)))
     JOIN geo_organization_unit_code gou3 ON (((gos3.child_geo_org_unit_code)::text = (gou3.geo_organization_unit_code)::text)))
     LEFT JOIN geo_org_unit_structure gos4 ON (((gos4.parent_geo_org_unit_code)::text = (gou3.geo_organization_unit_code)::text)))
     LEFT JOIN geo_organization_unit_code gou4 ON (((gos4.child_geo_org_unit_code)::text = (gou4.geo_organization_unit_code)::text)))
  WHERE (((gou.geo_org_unit_type_code)::text = 'REGION'::text) AND ((gou2.geo_org_unit_type_code)::text = 'ZONE'::text) AND ((gou3.geo_org_unit_type_code)::text = 'OFFLOC'::text) AND (((gou4.geo_org_unit_type_code)::text = 'AREA'::text) OR (gou4.geo_org_unit_type_code IS NULL)) AND ((gos.agency_code)::text = 'COS'::text));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views