Pre-Enrollment Views

Pre-Enrollment View: Pre-Enrollment

View name: rpt.preenrollment

Type: Record

Description: Pre-Enrollment Core Information

Field	Data Type	Notes
preenrollment_id	integer
individual_id	integer	References individual_id in rpt.individual
preenrollment_reason_id	integer
preenrollment_reason	character varying(30)
preenrollment_status	text

Pre-Enrollment View: Pre-Enrollment Profile

View name: rpt.preenrollment_profile

Type: Profile

Description: Pre-Enrollment Information

Field	Data Type	Notes
preenrollment_id	integer	References preenrollment_id in rpt.preenrollment
individual_id	integer	References individual_id in rpt.individual
preenrollment_reason_id	integer
preenrollment_reason	character varying(30)
preenrollment_status	text
service_id	integer	References service_id in rpt.service
case_service_group_id	integer	References case_service_group_id in rpt.case_service_group
informal_series_id	integer	References informal_series_id in rpt.informal_series
worker_id	integer	References worker_id in rpt.worker
preenrollment_drop_down_1_id	integer
preenrollment_drop_down_1	character varying(100)
preenrollment_on_list_date	date
preenrollment_off_list_date	date
preenrollment_priority_id	integer
preenrollment_priority	character varying(10)
preenrollment_notes	text
preenrollment_cancelation_reason_id	integer
preenrollment_cancelation_reason	character varying(30)
preenrollment_closing_notes	text
service_file_id	integer	References service_file_id in rpt.service_file

Pre-Enrollment View: Pre-Enrollment Referrals

View name: rpt.preenrollment_referrals

Type: Cross Reference

Description: Pre-Enrollment Referrals

Field	Data Type	Notes
preenrollment_id	integer	References preenrollment_id in rpt.preenrollment
referral_id	integer	References referral_id in rpt.referral

Views and Standard Views