Blue Book Views

Blue_Book_Views Standard Views

Updated over a week ago

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

Did this answer your question?