Enrollments

The following describes the enrollments table that is in the database.

Name

Description

Example

Name

Description

Example

enrollmentid

This is

9ffb1c26-1ccf-472a-ba2b-4427e40b7ba8

programdetails

This contains program specific details for this enrollment. Currently it just has communication preferences.

{communicationpreference=Text Message}

lastname

This is the lastname of the user and is used for searching purposes on the record.

CLARK

transportation1

This is the data that is on the first transportation screen on the enrollment process.

{motorcycle=Never, paratransit=A few times a month, bus=Never, rideshare=Never, walking=Never, biking=Never, personal=Not available to me, borrowing=A few times a year, carpool=A few times a year, rental=Never, train=Never, wheelchair=No}

transportation2

This is the data that is on the second transportation screen on the enrollment process.

{relationships=Often, othervehicle=, leavehouse=Often, feelbad=Often, householdcar=null, vehiclesforwork=, publictransport=No, carpoolmethod=Yes}

address

The address of the user that is being enrolled.

{country=USA, city=Detroit, line=, postalcode={"string": "48235"}, county=Wayne County, text=16250 Snowden Street, state=MI}

kaizenid

This is the kaizen id for this person. Please note for this record it can be either a string or a long.

{"string": "857859"}

{"long": 857859}

createddatetime

The date and time that this enrollment was created. This is in epoch format.

 

employment

This contains the information that is captured on the employment screen

{eligibiltycriteria=, details=, referralpatner=, referindivemail=null, referindivname=null, residenceeligibility=null, triptaken={"string": "0"}, pbpid=, emplystatus=, totalcoseallowed={"string": ""}, othersourceofincome=, contractid=, totalcost={"string": ""}}

birthdate

The birthdate of the user

 

enrolleduser

This is the social navigator that enrolled the user

cleovra.harper-perkins@liveunitedsem.org

persondetails

This contains

{gender={name=UW Gender, value=Female}, raceethnicity={name=UW Race/Ethnicity, value=Black / African American}}

firstname

The first name of the person. This is used for searching purposes.

TEST

personid

The unique id for this person.

9ffb1c26-1ccf-472a-ba2b-4427e40b7ba8

demographics

This contains the demographics of the person. This is from the demographics screen

{vetstatus=No, benefits=['Food stamps / SNAP'], childrenunderagefive={"string": "0"}, householdmem={"string": "1"}, empstatusother=Disabled, unable or not looking for work, combinedhouseholdincome=<$25,000, childerfromsixtoseventeen={"string": "0"}, employstatus=, primaryincomesource=Social security, employed=No}

source

This is the source of the enrollment. This can be either social navigation or referral form.

RideUnitedRefer

SocialNavigator

enrollmentstatus

The status of the emrollment.

Completed

programid

The id of the program that this user was enrolled in. This is a unique id that can be linked to the program table

9ffb1c26-1ccf-472a-ba2b-4427e40b7ba8