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 |