el_decisions_raw
Decisions relate to "People" users and their Applications. Contains decision metadata, like checklists, criteria and notes.
el_decisions_raw Columns#
JSON Keys for Decision Object#
Sample JSON Object for Decision#
Note: this sample is abbreviated — the full source record includes additional entries within checklist, board_log, and criteria_ai_last_reasoning.
Decision
{
"_id": "698dfe3b3bffdb432d09ef5c",
"_subdom": "instance",
"active": true,
"addresses": [
{
"city": "Amherst",
"country": "USA",
"county": "Lorain County",
"index_weight": 1,
"item_id": "OMYACZGM",
"mailing": true,
"state": "OH",
"street_1": "123 Main St",
"type": "home",
"valid": true,
"zipcode": "44001"
}
],
"app_synced_at": "2026-02-25T03:01:26.623000",
"application_guid": "instance.applications.349259",
"assigned_to": {
"_id": "698dfe3b3db432d09ef5f",
"_version": 0,
"tags": {
"_id": "69ca944b72ad3b2046eb8",
"_version": 2,
"items": [
"instance.taxonomy.4150331",
"instance.taxonomy.4175542"
]
},
"updated_at": "2026-03-30T15:21:23.787000",
"user_id": "698dfe3b3db432d09ef5f"
},
"board": {
"_id": "698dfe3b3bf432d09ef60",
"_version": 5,
"stage_id": "ZBGGTY8S",
"status_guid": "instance.taxonomy.4122929",
"updated_at": "2026-03-30T15:19:54.426000"
},
"campus": null,
"checklist": [
{
"_id": "O7YJTSST",
"item_key": "PLZIKARI",
"status": "uncompleted",
"status_changed_at": "2026-02-12T16:22:36.817000",
"type": "condition",
"updated_at": "2026-05-27T02:50:34.733000",
"updated_by": "checklist_condition_evaluator",
"visible": false
}
],
"citizenship": {
"us_status": "US"
},
"cohorts": [
"1G9A0NA2",
"HECSIFHR"
],
"computed_scores": [],
"conversation_guid": null,
"created_at": "2026-02-12T16:22:19.113000",
"criteria": [
{
"_id": "B5J5AMQQ",
"aggregate_score_type": "average",
"description": "Student has 3.0 High School Official GPA",
"index_weight": 1000,
"maximum_score": 0,
"name": "3.0 HS",
"question_type": "numerical",
"scores": [],
"short_name": "HSGPA",
"type": "per_reviewer",
"weight": 5,
"works_for": [
"instance.applications.349259"
]
}
],
"decision_released_at": "2026-02-24T18:45:59.697000",
"degree": null,
"email": "example@gmail.com",
"final_decision_at": "2026-02-24T18:45:54.911000",
"financial_award": [],
"first_name": "First",
"former_last_name": null,
"fraud": {
"evaluated_at": "2026-02-12T16:25:20",
"fraud_category": "low-risk",
"fraud_evaluation": "698dfef1c9a1597084855",
"fraud_search": "low-risk",
"ignored": false,
"ignored_at": null,
"ignored_by": null,
"resolved_as": null,
"score": 25.645055555555558
},
"gender": "Female",
"identities": [
{
"index_weight": 1,
"item_id": "AOZMKLJV",
"type": "SPARK_ID",
"value": "8MGPNXDM"
},
{
"index_weight": 2,
"type": "EMAIL",
"value": "example@gmail.com"
}
],
"last_name": "Last",
"last_reviewer": {
"date": "2026-02-24T20:54:33.086000",
"payload": {
"status_guid": "instance.taxonomy.4122929"
},
"user_id": "682b4962015985042463"
},
"letter": [],
"major": "insatnce.major.184657",
"media": [],
"middle_name": "M",
"notes": [],
"phone": [
{
"carrier_name": "T-Mobile USA",
"carrier_type": "mobile",
"country_alpha_2": "US",
"country_code": "1",
"formatted": true,
"index_weight": 1,
"international": "+123456789",
"item_id": "DAGD9U8T",
"number": "123456789",
"type": "cell",
"valid": true
}
],
"preferred_name": null,
"registration_id": "QYP7T1UV",
"reviewers": [
{
"date": "2026-02-24T20:54:33.086000",
"payload": {
"status_guid": "instance.taxonomy.4122929"
},
"user_id": "682b49620195985042463"
}
],
"score": 0,
"social_security_number": "123-45-6789",
"student_type": "N",
"tags": {
"_id": "698dfe3b3bff32d09ef5d",
"_version": 0,
"items": [],
"updated_at": "2026-03-30T15:21:55.885000"
},
"term": "instance.terms.42282",
"tokens": [],
"updated_at": "2026-05-27T02:50:34.771000",
"user_id": "698dfb1d79cbef00696e1",
"visibility_groups": [
"all",
"6807d773985427901eb51"
]
}el_decisions_raw Columns
6 rows
| Column | SQL Data Type | Description |
|---|---|---|
| updated_at | TIMESTAMP_NTZ | Document update timestamp |
| src | VARIANT | JSON object of decision document properties. |
| subdom | VARCHAR | Partner school instance identifier |
| etl_loaded_at | TIMESTAMP_NTZ | Document loaded to Snowflake timestamp |
| _id | VARCHAR | Unique identifier for each document. |
| created_at | TIMESTAMP_NTZ | Document created timestamp |
JSON Keys for Decision Object
135 rows
| Description | Data Type | Key |
|---|---|---|
| Timestamp when application data was last synced to this decision. | STRING (TIMESTAMP) | app_synced_at |
| Academic term associated with the application decision. | STRING | term |
| Category assigned by the fraud evaluation. | STRING | fraud.fraud_category |
| Timestamp when tags were last updated. | STRING (TIMESTAMP) | tags.updated_at |
| Decision letter content or generated letter artifacts. | ARRAY | letter |
| International-format phone number string. | STRING | phone.international |
| Contact SSN copied onto the decision snapshot. | STRING | social_security_number |
| MongoDB identifier for the assignment subdocument. | STRING | assigned_to._id |
| Numeric fraud risk score. Also stored as Integer in a minority of rows. | INTEGER | fraud.score |
| Client-configured computed score fields keyed by score field GUID. Also stored as Object in a minority of rows. | ARRAY | computed_scores |
| Element451 user identifier for the most recent reviewer. | STRING | last_reviewer.user_id |
| Tag metadata applied to the decision record. | OBJECT | tags |
| Internal event tracking for integrations and product instrumentation. | ARRAY | ia_tracking |
| Timestamp of the most recent reviewer action. | STRING (TIMESTAMP) | last_reviewer.date |
| Financial aid or scholarship awards tied to the decision. | ARRAY | financial_award |
| Whether the contact currently holds a visa. | STRING | citizenship.hold_visa |
| Sort weight for the phone number among multiple numbers. | INTEGER | phone.index_weight |
| Tags applied within the assignment subdocument. | OBJECT | assigned_to.tags |
| Whether the fraud flag was ignored by staff. | BOOLEAN | fraud.ignored |
| User who resolved the fraud evaluation. | STRING | fraud.resolved_by |
| Timestamp when the fraud flag was ignored. | STRING (TIMESTAMP) | fraud.ignored_at |
| Timestamp when the decision record was last updated in Element451. | STRING (TIMESTAMP) | updated_at |
| Primary country of citizenship. | STRING | citizenship.citizen_of |
| Country where the contact was born. | STRING | citizenship.birthcountry |
| Foreign key for the application. Join to el_users_raw at src:applications[].registration_id. | STRING | registration_id |
| GUID of the application type associated with the decision. | STRING | application_guid |
| Whether English is the contact's native language. | STRING | citizenship.english_native_language |
| Campus associated with the application decision. | STRING | campus |
| Identifier for the phone number item. | STRING | phone.item_id |
| Citizenship and visa information copied from the contact or application. Also stored as Array in a minority of rows. | OBJECT | citizenship |
| MongoDB identifier for the board subdocument. | STRING | board._id |
| Preview image object for decision communications. | OBJECT | preview.image |
| Number of years the contact has been in the United States. | STRING | citizenship.us_years |
| Timestamp when the decision outcome was released to the applicant. | STRING (TIMESTAMP) | decision_released_at |
| Status of AI-assisted criteria evaluation. | STRING | criteria_ai_status |
| GUID of an Element451 conversation linked to the decision. | STRING | conversation_guid |
| Fields or data noted as missing during decision processing. | STRING | missing |
| Whether the contact holds or requires an F-1 visa. | STRING | citizenship.visa_f1 |
| AI-generated narrative summary or comment for criteria evaluation. | STRING | criteria_ai_summary.comment |
| Array of checklist items required to complete the decision process. | ARRAY | checklist |
| Decision board workflow state, including stage and status. | OBJECT | board |
| Nested board configuration or state object. | OBJECT | board.board |
| User assignment object for the decision reviewer or owner. | OBJECT | assigned_to |
| Alternate identity records associated with the contact. | ARRAY | identities |
| Permanent resident identification number. | STRING | citizenship.permanent_resident_number |
| Timestamp when the decision record was created in Element451. | STRING (TIMESTAMP) | created_at |
| Access or integration tokens related to the decision. | ARRAY | tokens |
| Local phone number digits. | STRING | phone.number |
| Outcome label from the fraud evaluation. | STRING | fraud.fraud_evaluation |
| Timestamp of the last system-level update to the decision. | STRING (TIMESTAMP) | system_updated_at |
| Media attachments related to the decision or application. | ARRAY | media |
| GUID of the current decision board status. | STRING | board.status_guid |
| Visa type associated with the contact. | STRING | citizenship.visa_type |
| Users assigned or recorded as reviewers on the decision. | ARRAY | reviewers |
| Fraud evaluation details on the assigned reviewer context. | OBJECT | assigned_to.fraud |
| User who ignored the fraud flag. | STRING | fraud.ignored_by |
| AI-generated scores for admission criteria. | ARRAY | criteria_ai_scores |
| Dialing country code for the phone number. | STRING | phone.country_code |
| Users watching board changes on the decision. | ARRAY | board.watchers |
| Identifier for the AI criteria API request. | STRING | criteria_ai_request_id |
| History of board stage and status transitions. | ARRAY | board_log |
| Phone number type, such as mobile or home. | STRING | phone.type |
| Primary major or program associated with the application decision. | STRING | major |
| Contact mailing or physical addresses copied onto the decision snapshot. | ARRAY | addresses |
| Preview metadata for decision communications or documents. | OBJECT | preview |
| Contact gender copied onto the decision snapshot. | STRING | gender |
| Timestamp when the AI criteria summary was created. | STRING (TIMESTAMP) | criteria_ai_summary.created_at |
| MongoDB schema version for the board subdocument. | INTEGER | board._version |
| MongoDB schema version for the assignment subdocument. | INTEGER | assigned_to._version |
| Internal flag indicating the record was corrected or repaired. | BOOLEAN | fix |
| Timestamp when the fraud evaluation was resolved. | STRING (TIMESTAMP) | fraud.resolved_at |
| Unique identifier for the Decision document. | STRING | _id |
| Whether the decision record is currently active. | BOOLEAN | active |
| Whether the phone number passed validation. | BOOLEAN | phone.valid |
| AI-recommended score from the criteria summary. | STRING | criteria_ai_summary.score |
| Reviewer or system feedback on AI criteria suggestions. | ARRAY | criteria_ai_feedback |
| Users watching the decision for updates. | ARRAY | watchers |
| Visibility group identifier controlling decision access. | STRING | visibility_groups.\{group_id\} |
| Timestamp when fraud evaluation was performed. | STRING (TIMESTAMP) | fraud.evaluated_at |
| Array of individual tag entries. | ARRAY | tags.items |
| Type of visa currently held by the contact. | STRING | citizenship.hold_visa_type |
| Whether the phone number is stored in formatted form. | BOOLEAN | phone.formatted |
| MongoDB identifier for the tags subdocument. | STRING | tags._id |
| Nested tag key-value object. | OBJECT | tags.tags |
| Timestamp when the decision reached the final decision stage. | STRING (TIMESTAMP) | final_decision_at |
| Degree program associated with the application decision. | STRING | degree |
| Secondary country of citizenship. | STRING | citizenship.citizen_of_second |
| Timestamp when the assignment subdocument was last updated. | STRING (TIMESTAMP) | assigned_to.updated_at |
| Student type classification for the application decision. | STRING | student_type |
| Whether the contact requires a visa. | STRING | citizenship.require_visa |
| Contact first name copied onto the decision snapshot. | STRING | first_name |
| Contact former last name, if provided. | STRING | former_last_name |
| Version number of the assignment subdocument. | INTEGER | assigned_to.version |
| Contact last name copied onto the decision snapshot. | STRING | last_name |
| Contact email copied onto the decision snapshot. | STRING | |
| Contact place of birth. | STRING | citizenship.birth_place |
| Visibility group identifiers controlling access to the decision. Also stored as Object in a minority of rows. | ARRAY | visibility_groups |
| Identifier of the current decision board stage. | STRING | board.stage_id |
| Historical AI admission criteria evaluations. | ARRAY | criteria_ai_admission_history |
| Element451 user identifier for the assigned reviewer. | STRING | assigned_to.user_id |
| Overall numeric decision score. | INTEGER | score |
| Fraud search or screening result reference. | STRING | fraud.fraud_search |
| Migration metadata from a legacy data import. | STRING | migration |
| Globally applied admission criteria results. | ARRAY | criteria_global |
| Contact native language. | STRING | citizenship.native_language |
| U.S. state of residency, if applicable. | STRING | citizenship.state_residency |
| Application fraud detection evaluation and resolution details. Also stored as String in a minority of rows. | OBJECT | fraud |
| Cohort identifiers used when evaluating or routing the decision. | ARRAY | cohorts |
| Most recent reviewer action on the decision. | OBJECT | last_reviewer |
| Client instance subdomain embedded in the source document. | STRING | _subdom |
| Contact preferred name copied onto the decision snapshot. | STRING | preferred_name |
| Most recent AI reasoning output for admission criteria. | ARRAY | criteria_ai_last_reasoning |
| Timestamp when the board subdocument was last updated. | STRING (TIMESTAMP) | board.updated_at |
| Contact middle name copied onto the decision snapshot. | STRING | middle_name |
| Staff notes attached to the decision. | ARRAY | notes |
| Migration marker from a legacy data import. | STRING | migrate |
| Identifier for the AI criteria processing job. | STRING | criteria_ai_process_id |
| Confirmation status or message related to the decision outcome. | STRING | confirmation |
| Users watching the assignment subdocument. | ARRAY | assigned_to.watchers |
| Foreign key for the user document. Join to el_users_raw at _id. | STRING | user_id |
| Tags applied within the board subdocument. | OBJECT | board.tags |
| Summary object for the latest AI criteria recommendation. | OBJECT | criteria_ai_summary |
| Reviewer assignment nested within the board state. | OBJECT | board.assigned_to |
| Payload object for the most recent reviewer action. | OBJECT | last_reviewer.payload |
| Two-letter country code for the phone number. | STRING | phone.country_alpha_2 |
| MongoDB schema version for the tags subdocument. | INTEGER | tags._version |
| Resolution label applied to the fraud evaluation. | STRING | fraud.resolved_as |
| Numeric value for a client-configured computed score field identified by score field GUID. | STRING | computed_scores.\{score_id\} |
| Phone number object copied onto the decision snapshot. Also stored as Object in a minority of rows. | ARRAY | phone |
| Admission criteria evaluations applied to the decision. | ARRAY | criteria |
| Explanation or reasoning from the fraud evaluation. | STRING | fraud.reasoning |
| U.S. immigration or residency status. | STRING | citizenship.us_status |
| Admission criteria results broken out by reviewer. | ARRAY | criteria_per_reviewer |
| Whether the contact is currently in the United States. | STRING | citizenship.currentlyus |
| Internal event tracking on the board subdocument. | ARRAY | board.ia_tracking |
Was this page helpful?