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 |
|