Oracle · Workflow

Oracle / Workflow

Operational Workflow Diagram

End-to-end flow: intake → triage → routing → handoff → stabilization → placement → retention → escalation

Success path

─ ─Failure path label

Offline (hub-outage)

/api/endpointData touchpoint

Row 1: Entry & Assessment

STAGE 01

Intake

Multi-channel entry: walk-in, phone triage, street engagement

Providers

Open Door (walk-in)

Center of Hope (walk-in)

211 Kansas (phone)

H.O.T. (street outreach)

Data touchpoint

/api/community-snapshot

→ intakeVolume, entryDoor, intakeMethod

intake overflow → 211 escalation

STAGE 02

Triage

VI-SPDAT vulnerability scoring and priority assignment

Providers

Second Light / HMIS (assessment)

211 Kansas (coordination)

Data touchpoint

/api/community-snapshot

→ viSpdatScore, assessmentStatus, priorityTier

triage queue > 72h → emergency bypass

STAGE 03

Routing

Algorithmic bed and program matching by vulnerability score

Providers

Second Light / HMIS (routing engine)

211 Kansas (referral link)

Data touchpoint

/api/matcher

→ pathwayFit, bedAvailability, programMatch

no bed match → waitlist overflow

STAGE 04

Handoff

Document verification, program enrollment, warm handoff

Providers

City ID (document verification)

All receiving providers

Data touchpoint

/api/handoffs

→ handoffStatus, failureReason, docReadiness

handoff refusal → re-triage

Row 2: Housing & Long-Term Stability

STAGE 05

Stabilization

Benefits enrollment, document completion, service linkage

Providers

CrossRoads (youth shelter)

BRIDGES (youth services)

DCF IL (foster youth)

City ID (docs)

Data touchpoint

/api/stabilization-docs

→ pendingCount, docStatus, benefitEnrollment

doc gap → City ID loop

STAGE 06

Placement

Landlord match, lease signing, move-in coordination

Providers

NEXTenant (landlord match)

Housing First (permanent)

Rapid Rehousing (subsidy)

Data touchpoint

/api/placement

→ placementStatus, landlordMatch, unitAvailability

landlord decline → trust fund activation

STAGE 07

Retention

30- and 90-day check-ins, crisis support, tenancy stabilization

Providers

NEXTenant (check-ins)

Housing First (ongoing)

211 Kansas (crisis line)

Data touchpoint

/api/retention

→ retention30d, retention90d, caseManagerContact

lease violation → emergency stabilization

STAGE 08

Escalation

Re-entry detection, intensive case management, HMIS flag

Providers

211 Kansas (re-intake line)

H.O.T. (re-engagement)

Second Light / HMIS (chronic flag)

Data touchpoint

/api/system-status

→ escalationFlag, reEntryRisk, chronicity

↺

Escalation → Re-Intake Loop

When Stage 08 (Escalation) flags chronic re-entry risk, a new intake record is created in Second Light / HMIS and the individual re-enters Stage 01 with elevated VI-SPDAT priority. H.O.T. re-engagement team delivers warm hand-off back to Center of Hope or 211 Kansas.

/api/system-status → escalationFlag/api/community-snapshot → reEntryCountfailure: chronic re-entry → intensive case management

All Labeled Failure Paths

⚡

Intake → Triage

intake overflow → 211 escalation

/api/community-snapshot → intakeVolume

⚡

Triage → Routing

triage queue > 72h → emergency bypass

/api/community-snapshot → assessmentStatus

⚡

Routing → Handoff

no bed match → waitlist overflow

/api/matcher → bedAvailability

⚡

Handoff → Stabilization

handoff refusal → re-triage

/api/handoffs → failureReason

⚡

Stabilization → Placement

doc gap → City ID loop

/api/stabilization-docs → pendingCount

⚡

Placement → Retention

landlord decline → trust fund activation

/api/placement → landlordMatch

⚡

Retention → Escalation

lease violation → emergency stabilization

/api/retention → retention30d

⚡

Escalation → Re-Intake

chronic re-entry → intensive case management

/api/system-status → escalationFlag

Wichita Provider Index

Second Light / HMIS

Assessment, Routing, HMIS data

Open Door

Primary walk-in intake hub

Center of Hope

Secondary walk-in, overflow

H.O.T.

Street outreach, re-engagement

211 Kansas

Phone triage, referral coordination

CrossRoads

Youth shelter & stabilization

BRIDGES

Youth services & case management

DCF IL

Foster youth / independent living

City ID

Document verification & ID

NEXTenant

Landlord matching, check-ins

Housing First

Permanent supportive housing

Rapid Rehousing

Subsidized housing placement

Oracle Tools

← Oracle Dashboard $500K Use-of-Funds Model →Pilot KPI Framework →Counterfactual Analysis →Year-Two Renewal Case →Investor Pitch Deck →

Workflow data traces to community-snapshot, telemetry, and handoff API endpoints · Hub-outage toggle simulates Open Door offline (48–72h)