Blue Book Views

Blue Book View: Blue Book

View name: rpt.bluebook

Type: Record

Description: Blue Book Core Information

Field	Data Type	Notes
bluebook_id	integer
entity_id	integer	References entity_id in rpt.entity
bluebook_name	text
bluebook_type_id	integer
bluebook_type	character varying (50)
bluebook_type_is_organization	boolean

Blue Book View: Blue Book Profile

View name: rpt.bluebook_profile

Type: Profile

Description: Blue Book Information

Field	Data Type	Notes
bluebook_id	integer	References bluebook_id in rpt.bluebook
entity_id	integer	References entity_id in rpt.entity
bluebook_name	text
bluebook_type_id	integer
bluebook_type	character varying (50)
bluebook_type_is_organization	boolean
bluebook_role	text
bluebook_is_private	boolean
bluebook_drop_down_1_id	integer
bluebook_drop_down_1	character varying (50)
parent_bluebook_id	integer	References bluebook_id in rpt.bluebook
provider_bluebook_id	integer	References bluebook_id in rpt.bluebook
bluebook_notes	text

Blue Book View: Blue Book Provider Profile

View name: rpt.bluebook_provider_profile

Type: Profile

Description: Blue Book Provider Information

Field	Data Type	Notes
bluebook_id	integer	References bluebook_id in rpt.bluebook
bluebook_referral_drop_down_1_id	integer
bluebook_referral_drop_down_1	text
bluebook_referral_drop_down_2_id	integer
bluebook_referral_drop_down_2	text
bluebook_referral_memo_1	text
bluebook_referral_memo_2	text

Blue Book View: Blue Book Documents

View name: rpt.bluebook_documents

Type: Cross Reference

Description: Blue Book Documents

Field	Data Type	Notes
bluebook_id	integer	References bluebook_id in rpt.bluebook
document_id	integer	References document_id in rpt.document

Blue Book View: Blue Book Serviced Area

View name: rpt.bluebook_serviced_area

Type: Cross Reference

Description: Blue Book Serviced Areas

Field	Data Type	Notes
bluebook_serviced_area_id	integer
bluebook_serviced_area_name	text
bluebook_id	integer	References bluebook_id in rpt.bluebook

Blue Book View: Blue Book Referral 5

View name: rpt.bluebook_referral_5_multi_select

Type: Cross Reference

Description: Blue Book Referral 5

Field	Data Type	Notes
bluebook_referral_5_multi_select_id	integer
bluebook_referral_5_multi_select_5_name	text
bluebook_id	integer	References bluebook_id in rpt.bluebook

Blue Book View: Blue Book Available Service

View name: rpt.bluebook_available_service

Type: Cross Reference

Description: Blue Book Available Services

Field	Data Type	Notes
bluebook_available_service_id	integer
bluebook_available_service_name	text
bluebook_id	integer	References bluebook_id in rpt.bluebook
bluebook_available_service_comment	text
bluebook_available_service_restrictions	text

Blue Book View: Blue Book Available Services Offered By

View name: rpt.bluebook_available_services_offered_by

Type: Cross Reference

Description: Blue Book Available Services Offered By

Field	Data Type	Notes
bluebook_id	integer	References bluebook_id in rpt.bluebook
bluebook_available_service_id	integer	References bluebook_available_service_id in rpt.bluebook_available_service
bluebook_available_service_intake_bluebook_id	integer	References bluebook_id in rpt.bluebook

Views and Standard Views