BH Drupal Entities

The following Drupal Entities are created to warehouse/cache data which originates in Salesforce.

The following nodes have records which are populated (add, update and delete) by mappings between Salesforce and Drupal which are run each cron cycle.

The following taxonomies have been created and their list items are maintained manually by Drupal developers. Taxonomy items can be added and deleted as needed, but usually will need adjustments to code to work as required.

Custom Entities

Entity	Name	Description
node	bh_project	The primary content_type for a Building Housing Property. Contains meta data about the Project and links to updates, attachments, parcels etc.
node	bh_update	Contains information about updates to a project. This includes certain status changes, attached documents, links to community meeting records and comments from CoB Project Managers to insert into the timeline.
node	bh_meeting	Contains information about Community Meetings held by CoB with residents regarding Building Housing Properties.
node	bh_parcel	The official parcel number and top-level info - with GIS coordinates for the parcel.
node	bh_parcel_project_assoc	Possibly deprecated ? I believe the parcel# is now saved in the field_bh_parcel_id field of bh_project.
node	bh_contact	Deprecated (no data)
node	bh_account	Deprecated (no data)
taxonomy	bh_project_stage	The overall project stage. (usually when project status = active). Linked directly from bh_project.
taxonomy	bh_project_status	The status of the Project. Linked directly from bh_project.
taxonomy	bh_funding_stage	The funding stage for the Project. Linked directly from bh_project.
taxonomy	bh_project_type	The broad project type for the Project. Linked directly from bh_project.
taxonomy	bh_project_update_type	Update type for a bh_update. Linked directly from bh_update.
taxonomy	bh_property_type	The property type. Linked directly from bh_parcel.
taxonomy	bh_public_stage	The Project stage as used in the timeline. Linked directly from bh_project.
taxonomy	bh_neighborhood
taxonomy	bh_record_type
taxonomy	bh_disposition_type	List of disposition types - for use in map.
view	building_housing
view	bh_maps
view	building_housing_updates
page	buildinghousing/[propertyname]	This is the landing page for information about a property. This is a customized page for the node bh_project and contains a timeline and information about parcels.

Data Schema

As at March 2023