EDORA Learn β Pipelines
Opportunity & Workforce
Pipeline 09D
Pathways that pull youth back into school and work: mentoring and credible-messenger models, re-engagement centers, CTE programs, work-based learning, and apprenticeships that lead to real paychecks and staying power.
What We Track
Re-engagement (Education)
- Days to re-enrollment after release or disposition (target β€10)
- Route used: school, GED/HiSET, credit recovery, alternative-ed bridge, virtual
Career & Technical Education (CTE)
- Program enrollment by pathway (e.g., construction, health, IT)
- Industry-recognized credentials attempted/earned per youth
Work-Based Learning (WBL)
- Internships, paid placements, summer youth employment participation
- Supports provided: transportation, tools/PPE, stipends
Apprenticeships
- Pre-apprenticeship completions and transitions to Registered Apprenticeship
- Placement rate from pre-apprentice β apprentice within 90 days
Mentoring / Coaching
- Credible-messenger or coach assigned (name/contact; start date)
- Engagement: meeting cadence met; persistence through 30/90/180 days
Typical Flow
- Assessment & plan β education status, career interests, barriers (transport, childcare)
- Set target route (school, GED/HiSET, CTE); assign mentor/coach
- Re-engage β enroll in school or GED/HiSET; activate supports
- Confirm schedule; arrange transport/tools; begin tutoring as needed
- Skill-build β CTE coursework + WBL placement
- Track hours, competencies, and onsite evaluations
- Credential & place β earn industry certs; place into first job or apprenticeship
- Document offer date, start date, wage/hours (where available)
- Stabilize β follow-ups at 30/90/180 days
- Attendance, credits/credentials, employment retention; adjust supports
Fields
Field | Type | Required | Codeset | Description |
---|---|---|---|---|
pipeline_place_id | uuid | β | β | Unique identifier for this opportunity/workforce episode. |
pipeline_stage_id | enum | β | stages.yml#stage_key(8)
| One of the canonical stages; here = reentry_aftercare. |
pipeline_place_key | enum | β | pipeline_places.yml#place_key(45)
| Canonical key for this place (maps to route/slug). |
youth_id | string | β | β | Salted/hashed or state UID. No plaintext PII. |
staff_id | string | β | Reentry/aftercare staff coordinating education/work supports. | |
occurred_datetime | datetime | β | β | Anchor timestamp (e.g., route selection or first program enrollment). |
jurisdiction_code | string | β | β | County/parish/circuit or standardized local code. |
source_system | string | β | β | Origin system name. |
source_file | string | β | Source batch/file id if flatfile. | |
extract_run_id | string | β | ETL run id for lineage. | |
series_break_flag | boolean | β | Comparability break applies to this row. | |
series_break_reason | enum | series_breaks.yml#reason(4)
| Reason for break (policy/process/tool change). | |
release_or_disposition_date | date | β | Anchor to measure re-enrollment timeliness. | |
reengagement_route_code | enum | reengagement_routes.yml#route(5)
| school, ged_hiset, credit_recovery, alt_ed_bridge, virtual. | |
re_enrollment_start_date | date | β | First active enrollment date per selected route. | |
elapsed_days_to_reenrollment | integer | β | Structural store of days from release/disposition to re_enrollment_start_date. | |
school_provider_id | string | β | Receiving school/LEA (if route = school or alt_ed_bridge). | |
cte_provider_id | string | β | Training/CTE provider id. | |
cte_pathway_code | enum | cte_pathways.yml#pathway(11)
| CTE pathway (e.g., construction, health_sciences, it, culinary). | |
cte_enrollment_date | date | β | Date of CTE program enrollment. | |
credential_type_code | enum | credential_types.yml#type(6)
| Industry-recognized credential type attempted/earned. | |
credential_attempted_date | date | β | Date of first attempt at credential. | |
credential_earned_flag | boolean | β | True if credential earned during this episode. | |
credential_earned_date | date | β | Date credential earned (if earned_flag true). | |
wbl_type_code | enum | wbl_types.yml#type(8)
| internship, paid_placement, summer_youth_employment, job_shadow, pre_apprenticeship_project. | |
wbl_host_provider_id | string | β | Host site/employer for WBL. | |
wbl_start_date | date | β | WBL start date. | |
wbl_end_date | date | β | WBL end date (if concluded). | |
wbl_hours_completed | integer | β | Total hours completed in WBL. | |
wbl_evaluation_outcome_code | enum | evaluation_outcomes.yml#outcome(4)
| satisfactory, needs_improvement, unsatisfactory, not_evaluated. | |
supports_provided_codes | array<string> | support_services.yml#type(7)
| Supports used (transportation, tools_ppe, stipend, tutoring, mentoring); semicolon-delimited. | |
pre_apprenticeship_completion_flag | boolean | β | True if pre-apprenticeship requirements completed. | |
pre_apprenticeship_completion_date | date | β | Date of pre-apprenticeship completion. | |
apprenticeship_transition_status_code | enum | apprenticeship_transition_statuses.yml#status(4)
| transitioned_within_90d, transitioned_after_90d, not_transitioned, in_progress. | |
apprenticeship_start_date | date | β | Registered Apprenticeship start date (if transitioned). | |
employer_provider_id | string | β | Employer/provider for apprenticeship or job placement. | |
job_offer_date | date | β | Date of first job offer in this episode. | |
job_start_date | date | β | First day worked in placed job. | |
scheduled_hours_per_week | integer | β | Scheduled weekly hours at start. | |
hourly_wage_amount | number | β | Hourly wage at start (currency not stored; handle upstream). | |
employment_status_code | enum | employment_statuses.yml#status(5)
| placed, pending, searching, not_placed, declined_offer. | |
mentoring_provider_id | string | β | Mentoring provider assigned. | |
coach_staff_id | string | β | Coach/credible messenger staff id. | |
mentoring_start_date | date | β | Date mentoring/coaching began. | |
meeting_cadence_interval_code | enum | review_intervals.yml#interval(3)
| Planned cadence for meetings (e.g., weekly, biweekly, monthly). | |
engagement_status_30d_code | enum | engagement_statuses.yml#status(4)
| Engagement snapshot at 30 days (active, sporadic, disengaged). | |
engagement_status_90d_code | enum | engagement_statuses.yml#status(4)
| Engagement snapshot at 90 days. | |
engagement_status_180d_code | enum | engagement_statuses.yml#status(4)
| Engagement snapshot at 180 days. | |
Download CSVwhat_we_track.csv |
Data & Methods
Education re-engagement uses an enrolled-student denominator; employment outcomes use placed-youth cohorts with follow-up at 30/90/180 days. Track credential counts and acceptance via district crosswalks. Apply small-n pooling over 2β3 years with suppression flags. Equity lenses (race/ethnicity, disability, rural/urban) are applied to access and outcomes. When program definitions change (e.g., WBL category updates), mark series breaks.
Featured
Related
- Education & Reentry
- Case Studies β community diversion, reentry coaching, therapeutic group homes.
- Provider Landscape & Processes
- YARI+ β At-Risk Counties (AR)
Transparency note: Employment and credential data often lag; we mark data vintage on charts and pool small-n cohorts to protect privacy while keeping trends interpretable.