Standard Views | Bluebook

View name: rpt.std_bluebook

Description: Basic information for Blue Book entries including information about the Blue Book provider

Field	Data Type	Notes
bluebook_id	integer	References bluebook_id in rpt.bluebook
bluebook_entity_id	integer	References entity_id in rpt.entity
bluebook_name	text
bluebook_type_id	integer
bluebook_type	character varying
bluebook_type_is_organization	boolean
bluebook_role	text
bluebook_is_private	boolean
bluebook_drop_down_1_id	integer
bluebook_drop_down_1	character varying
bluebook_notes	text
parent_bluebook_id	integer	References bluebook_id in rpt.bluebook
parent_bluebook_entity_id	integer	References entity_id in rpt.entity
parent_bluebook_name	text
parent_bluebook_type_id	integer
parent_bluebook_type	character varying
parent_bluebook_type_is_organization	boolean
provider_bluebook_id	integer	References bluebook_id in rpt.bluebook
provider_bluebook_entity_id	integer	References entity_id in rpt.entity
provider_bluebook_name	text
provider_bluebook_type_id	integer
provider_bluebook_type	character varying
provider_bluebook_type_is_organization	boolean
provider_bluebook_referral_drop_down_1_id	integer
provider_bluebook_referral_drop_down_1	text
provider_bluebook_referral_drop_down_2_id	integer
provider_bluebook_referral_drop_down_2	text
provider_bluebook_referral_memo_1	text
provider_bluebook_referral_memo_2	text

Views and Standard Views