Referral View: Referral
View name: rpt.referral
Type: Record
Description: Referral Core Information
Field | Data Type | Notes |
referral_id | integer |
|
bluebook_id | integer | References bluebook_id in rpt.bluebook |
referral_direction_id | integer |
|
referral_direction | text |
Referral View: Referral Profile
View name: rpt.referral_profile
Type: Profile
Description: Referral Information
Field | Data Type | Notes |
referral_id | integer | References referral_id in rpt.referral |
bluebook_id | integer | References bluebook_id in rpt.bluebook |
referral_direction_id | integer |
|
referral_direction | text |
|
referral_date | date |
|
referral_reason_id | integer |
|
referral_reason | text |
|
referral_drop_down_1_id | integer |
|
referral_drop_down_1 | character varying (100) |
|
referral_has_client_consent | boolean |
|
referral_is_exit | boolean |
|
bluebook_available_service_id | integer | References bluebook_available_service_id in rpt.bluebook_available_service |
referral_close_date | date |
|
referral_outcome_id | integer |
|
referral_outcome | character varying (100) |
|
referral_client_needs | text |
|
referral_client_instructions | text |
Referral View: Referral Documents
View name: rpt.referral_documents
Type: Cross Reference
Description: Referral Documents
Field | Data Type | Notes |
referral_id | integer | References referral_id in rpt.referral |
document_id | integer | References document_id in rpt.document |
Referral View: Referral Individuals
View name: rpt.referral_individuals
Type: Cross Reference
Description: Referral Individuals
Field | Data Type | Notes |
referral_id | integer | References referral_id in rpt.referral |
individual_id | integer | References individual_id in rpt.individual |
Referral View: Referral Note
View name: rpt.referral_note
Type: List
Description: Referral Note
Field | Data Type | Notes |
referral_note_id | integer |
|
referral_id | integer | References referral_id in rpt.referral |
referral_note_title | text |
|
referral_note_date | date |
|
referral_note | text |