Basic Needs Banner Tracking
- Jordan Lamb
- Joshua Metry
Overview
Owner | Miriam Sallam |
|---|---|
Contributors | Jordan Lamb, Carolyn Franco |
Goals | Launch and Utilize Banner Baseline Screens for Local Tracking and Reporting |
Jira tickets | |
On this page |
Changes to the program in Spring 2024 (MIS Term 243) removed the need to track each Service Code distinctly. Instead, the program has decided to just report a Service Code of “1” where applicable and a “REFER” code when they refer out but still need it reported. Created Service Codes will still stay in the system. (As ofJul 2, 2024)
Meetings
Launch Meeting Mar 17, 2023
Introductions
Expectations
Technology Services to provide Setup, Training, Maintenance, Local Report building, MIS Reporting
Basic Needs to do Desk Manual Documentation, Data Entry, Data Validation, Approval of MIS Reporting
Quick Demo of Banner Screens (TEST Database)
Basic Needs granularity requirements?
Scenarios Banner Entry
SVANEED is the form where functional users input data. The underlying view is SVVNEED and the underlying table is SVRPSID.
| 1 | Scenarios | Banner Entry | |||||||
| 2 | Service Type | Service Provided | Information or Material Good | Referred Elsewhere | Report on MIS | Need to Track Separately? | Service Code Required FIeld | Provider Origin Internal Department to Provide Material Good | Referral Agency Optional Field |
| 3 | 🍲 Food | Groceries | Information | CalFresh | Yes | Yes | GROC | BN - Basic Needs | CalFresh |
| 4 | 🍲 Food | Food Pantry | Material Good |
| Yes | Yes | GROC | FP - Food Pantry |
|
| 5 | 🍲 Food | Food Card | Material Good |
| Yes | Yes | CARD | BN - Basic Needs |
|
| 6 | 🍲 Food | Holiday Giveaway | Material Good |
| Yes | Yes | GROC_YYYY_EVENT | FP - Food Pantry |
|
| 7 | 🏡 Housing | Direct Housing Support | Information | Emergency Shelter | Yes | Yes | HOUS |
| Emergency Shelter |
| 8 | 🏡 Housing | Housing Navigation/Placement | Information | Kings/Tulare Homeless Alliance | No | No | INFO_NR |
| Kings/Tulare Homeless Alliance |
| 9 | 🏡 Housing | Referral | Information | Emergency Shelter, CSET, Kings/Tulare Homeless Alliance, CalWORKS, Tulare Works | Yes | Yes | REFER | CW - CalWORKS | Emergency Shelter, CSET, Kings/Tulare Homeless Alliance, Tulare Works |
| 10 | 🚄 Transportation | Transportation Support | Material Good |
| Yes | Yes | INFO | BN - Basic Needs |
|
| 11 | 🚄 Transportation | Parking Permit | Material Good |
| Yes | Yes | PARK | BN - Basic Needs |
|
| 12 | 🚄 Transportation | Gas Assistance | Material Good |
| Yes | Yes | GAS | BN - Basic Needs |
|
| 13 | 🚄 Transportation | Public Transit Financial Support | Material Good |
| Yes | Yes | TRANSIT | BN - Basic Needs |
|
| 14 | 🚄 Transportation | Public Transit Sticker Referral | Information | SAA- Student Activities & Affairs; other | Yes | Yes | STICKER | SAA - Student Activities and Affairs | TBD |
| 15 | 🧠 Mental Health | Intervention (Direct Referral) | Information | Health Center, Off Campus Referral | Yes | Yes | REFER | HC - Health Center | TBD |
| 16 | 🧠 Mental Health | Prevention Services/Support | Information | Health Center; Silver Cloud | Yes | Yes | SERVICE | HC - Health Center | Silver Cloud |
| 17 | 👶 Child Care | Referral | Information | CalWORKS | Yes | Yes | INFO | CW - CalWORKS |
|
| 18 | 👶 Child Care | External Referral | Information | Resource & Referral | Yes | Yes | INFO |
| TBD |
| 19 | 🧑⚕️ Health & Hygiene | Referral | Information | Health Center | Yes | Yes | INFO | HC - Health Center |
|
| 20 | 🧑⚕️ Health & Hygiene | External Referral | Information |
| Yes | Yes | INFO |
| TBD |
| 21 | 🧑⚕️ Health & Hygiene | Hygiene Items | Material Good |
| No | No | SUPPLIES | BN - Basic Needs |
|
| 22 | 💻 Technology | Access | Material Good |
| Yes | Yes | ACCESS | BN - Basic Needs |
|
| 23 | 💻 Technology | Referral for Equipment | Information | LRC, Other Department | Yes | Yes | REFER | LRC - Learning Resource Center, TBD |
|
| 24 | 💻 Technology | Referral for Lab Use | Information | Computer Lab | Yes | Yes | LAB | LAB - Computer Lab |
|
Additional Logic
Service Code GOASEID: Required FIeld
Tab | Code | Informal Description | Description |
|---|---|---|---|
FOOD_SRV_TYPE | GROC | Groceries | FOOD |
FOOD_SRV_TYPE | CARD | Food Card | FOOD |
HSNG_SRV_TYPE | HOUS | Direct Housing Support | HOUSING |
HSNG_SRV_TYPE | INFO_NR | Housing Navigation/Placement | Not MIS Reportable |
HSNG_SRV_TYPE | REFER | Referral | HOUSING |
TRANS_SRV_TYPE | INFO_NR | Transportation Support | Not MIS Reportable |
TRANS_SRV_TYPE | PARK_NR | Parking Permit | Not MIS Reportable |
TRANS_SRV_TYPE | GAS_NR | Gas Assistance | Not MIS Reportable |
TRANS_SRV_TYPE | TRANSIT_NR | Public Transit Financial Support | Not MIS Reportable |
TRANS_SRV_TYPE | TRANSIT | Public Transit Sticker Referral | TRANSPORTATION |
MNTL_HLTH_SRV_TYPE | REFER | Intervention (Direct Referral) | MENTAL_HEALTH |
MNTL_HLTH_SRV_TYPE | SERVICE | Prevention Services/Support | MENTAL_HEALTH |
CHLD_CARE_SRV_TYPE | INFO | Referral | CHILD_CARE |
PHYS_HLTH_SRV_TYPE | INFO | Referral | PHYSICAL_HEALTH |
PHYS_HLTH_SRV_TYPE | SUPPLIES | Hygiene Items | PHYSICAL_HEALTH |
TECH_SRV_TYPE | ACCESS | Access | TECHNOLOGY |
TECH_SRV_TYPE | REFER | Referral for Equipment | TECHNOLOGY |
TECH_SRV_TYPE | LAB | Referral for Lab Use | TECHNOLOGY |
Service Date: Required FIeld
Date that service was provided, not date entered by staff where different.
Provider User ID: Optional Field
What person provided the service?
Status STVSSST: Optional Field
Provider Origin STVORIG: Required FIeld
What department/area provided the service to the student. For the purposes of this, it may be as simple as what internal department/area was the student sent to for the service?
Code | Description |
|---|---|
FAID | Financial Aid 737-6227 |
ADM | Admissions 730-3727 |
ASMT | Assessment 730-3737 |
COUN | Counseling 730-3715 |
OREN | Orientation 737-5410 |
RCDS | Records 730-3775 |
DEAN | Dean's Office 737-5441 |
DRC | DRC 730-3805 |
BKST | Bookstore 730-3751 |
CASH | Cashier 730-3956 |
LIBR | Library 730-3824 |
VOC | Vocational Education |
CNAD | Counseling 730-3715 |
ATH | Athletics 730-3911 |
TRUB | TRIO Upward Bound Math/Science |
TRSS | TRIO Student Support Services |
AAC | AAC 730-3805 |
ESEP | Electronic Student Ed Plan |
EOPS | EOPS |
BN | Basic Needs |
FP | Food Pantry |
CALW | CalWORKS |
SAA | Student Activities and Affairs |
HC | Health Center |
LAB | Computer Lab |
Service Group STVSSGP: Optional Field
Has a combination of goals, needs, and/or services that may be assigned together.
Referral Agency STVEMPL: Optional Field
External agency where a student is connected for services.
Code | Description |
|---|---|
CALF | CalFresh |
EMSH | Emergency Shelter |
KTHA | Kings/Tulare Homeless Alliance |
CSET | Community Services Employment Training |
TWRK | Tulare Works |
SCLD | Silver Cloud |
Comments SVVNEED_%_SERVICE_COMMENTS: Optional Field
Free form text box.
Deployment plan
Date | Plan type | Action items | Notes | |
|---|---|---|---|---|
| 1 | Mar 13, 2023 | Setup | Applications: Permissions Applications: Confluence Page |
|
| 2 | Apr 3, 2023 | BN OFFICE NOTES | Basic Needs: Fill Out Scenarios |
|
| 3 | Apr 11, 2023 | BN NOTES SETUP | Applications: Fill Out Banner Entry Applications: Update Validation Tables |
|
| 4 | Apr 17, 2023 | Soft Launch | Basic Needs: Input a Student Per Scenario Where Possible Applications: Run SG |
|
| 5 | May 2, 2023 | GO LIVE & Handoff | Basic Needs: Takes over documentation of scenarios and how-to. IE Desk Manual Applications: Manages and document validation tables here. |
|