Enrollments
The following describes the enrollments table that is in the database.
Name | Description | Example |
---|---|---|
enrollmentid | This is |
|
programdetails | This contains program specific details for this enrollment. Currently it just has communication preferences. |
|
lastname | This is the lastname of the user and is used for searching purposes on the record. |
|
transportation1 | This is the data that is on the first transportation screen on the enrollment process. |
|
transportation2 | This is the data that is on the second transportation screen on the enrollment process. |
|
address | The address of the user that is being enrolled. |
|
kaizenid | This is the kaizen id for this person. Please note for this record it can be either a string or a long. |
|
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 |
|
birthdate | The birthdate of the user | Â |
enrolleduser | This is the social navigator that enrolled the user |
|
persondetails | This contains |
|
firstname | The first name of the person. This is used for searching purposes. |
|
personid | The unique id for this person. |
|
demographics | This contains the demographics of the person. This is from the demographics screen |
|
source | This is the source of the enrollment. This can be either social navigation or referral form. |
|
enrollmentstatus | The status of the emrollment. |
|
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 |
|