el_people_milestones
Milestones (opens in a new tab) are activity objects that denote significant events in the Person's funnel. Element451 automatically creates many Milestones based on a student's activity. Element451 users can also create Milestones manually, or import them.
Milestones are stored as an array on the Person record. This model unwinds the Milestones array into rows.
el_people_milestones Columns#
JSON Keys for People Milestones#
| Name | Data Type | Description |
|---|---|---|
| application_guid | String | For milestones related to applications, GUID of the application type that the person is filling out. |
| application_type | String | For milestones related to applications, code for the application origin, like "internal". |
| code | String | For HARDBOUNCE_SMS type Milestone, code for the error that caused the bounce. Description also listed. |
| date | String (Timestamp) | Timestamp when the milestone occured. |
| deposit_status | String | For DEPOSITED milestone type, Code indicating the status of the deposit, like "active". |
| description | String | For HARDBOUNCE_SMS type Milestone, describes the error that causes that bounce which corresponds to the code. |
| String | For UNSUBSCRIBE_EMAIL type Milestone, lists the email from which the person unsubscribed. | |
| enrollment_status | String | For ENROLLED_DATE milestone type, code indicating the status of the enrollment, like "active". |
| index_weight | Integer | Integer representing the milestone's position in it's parent array. |
| interviewer | String | For INTERVIEW type milestones, name of the staff member who conducted the interview. |
| item_id | String | For PROSPECT type milestones, identifier for the event registration that generated the milestone. |
| major | String | GUID of the milestone most relevant to the milestone, inherited from the form or application that created the milestone. |
| name | String | Human friendly name of the Milestone, often indicating what created the Milestone or what the milestone indicates. |
| number | String | For HARDBOUNCE_SMS type milestones, the destination number that the message attempted to reach. |
| reason | String | For WITHDRAW type milestones, corresponds to the status assigned to the Decision when it was withdrawn. |
| registration_id | String | Identifier for the application that the milestones correspond to. |
| source | String | For "PROSPECT" type milestone, Reference to the source that created the milestone, such as the URL at which the form was submitted. |
| student_type | String | Code for the student type most relevant to the milestone, inherited from the form or application that created the milestone. |
| term | String | GUID for the term most relevant to the milestone, inherited from the form or application that created the milestone. |
| type | String | Category of milestone, like "PROSPECT", "APPLICATION_SUBMIT", or "ENROLL". |
Example People Milestone JSON#
People Milestone
{
"application_guid": "instance.applications.137836",
"application_type": "internal",
"date": "2025-01-04T00:23:47",
"index_weight": 14,
"major": "asun.major.146182",
"name": "Undergraduate App",
"registration_id": "MEJDVU",
"student_type": "R",
"term": "instance.terms.25917",
"type": "APPLICATION_SUBMIT"
}el_people_milestones
29 rows
| Column | Description | Data Type |
|---|---|---|
| term | Milestone term | VARCHAR |
| blocked_email | Email address that has been blocked related to Milestone, if applicable | VARCHAR |
| intended_term | Current student intended term value | VARCHAR |
| intended_major | Current student intended major value | VARCHAR |
| subdom | Partner institution instance identifier | VARCHAR |
| registration_id | Application registration identifier related to Milestone, if applicable | VARCHAR |
| student_type | Milestone student type | VARCHAR |
| element_id | Unique student record identifier associated with the Milestone | VARCHAR |
| deposit_status | Deposit status related to Milestone, if applicable | VARCHAR |
| application | Application name, transformed from application guid. | VARCHAR |
| position | Index weight of the milestone in the array. | NUMBER |
| application_guid | Application identifier related to Milestone, if applicable | VARCHAR |
| withdraw_reason | Withdraw reason related to Milestone, if applicable | VARCHAR |
| student_type | Student type name, transformed from student type code. | VARCHAR |
| name | Milestone name | VARCHAR |
| interviewer | Interviewer name related to Milestone, if applicable | VARCHAR |
| application_internal | Application internal/external flag related to Milestone, if applicable | BOOLEAN |
| enrollment_status | Enrollment status related to Milestone, if applicable | VARCHAR |
| major | Milestone major | VARCHAR |
| type | Milestone type | VARCHAR |
| major | Major name, transformed from major guid. | VARCHAR |
| source | Milestone creation source | VARCHAR |
| updated_at | Milestone last updated at timestamp | TIMESTAMP_NTZ |
| active_term | Current student active term value | VARCHAR |
| active_major | Current student active major value | VARCHAR |
| timestamp | Milestone occurrence timestamp | TIMESTAMP_NTZ |
| src | JSON object of all Milestone properties | VARIANT |
| blocked_number | Phone number that has been blocked related to Milestone, if applicable | VARCHAR |
| milestone_id | Unique Milestone identifier | VARCHAR |
Was this page helpful?