Referral Views

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

Views and Standard Views