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 |