el_decisions_settings_raw
el_decisions_settings_raw Columns#
JSON Keys for Decisions Settings Object#
Sample JSON Object for Decisions Settings#
Note: this sample is abbreviated to a representative excerpt of each array field — the full source record includes many more entries within cohorts, criteria, financial_award, groups, intelligent_admissions, stages, and tests.
Decisions Settings
{
"_id": "5b0da8b455391353da",
"_subdom": "instance",
"checklist": {
"guid": "instance.checklists.28"
},
"cohorts": [
{
"_id": "VBS0C0TF",
"active": true,
"author": "59aef02d819177b1b7f",
"created_at": "2019-07-17T20:48:58",
"index_weight": 48000,
"title": "PhD"
}
],
"created_at": "2018-05-29T19:23:32",
"criteria": [
{
"_id": "I8FG4VOR",
"aggregate_score_type": "sum",
"description": "Is the candidate able to present self verbally?",
"index_weight": 2000,
"maximum_score": 5,
"name": "English Language Assessment",
"question_type": "numerical",
"scores": [],
"short_name": "EL",
"type": "per_reviewer",
"weight": 0
}
],
"financial_award": [
{
"_id": "VOX6LOCN",
"active": true,
"active_to_send": true,
"letter": [
"instance.letters.4"
],
"title": "Financial Aid",
"works_for": [
"instance.applications.95"
]
}
],
"groups": [
{
"_id": "UM97HGWC",
"_version": 0,
"author": "5af4762d5539341d",
"created_at": "2018-08-09T14:52:40",
"description": "All permissions",
"name": "Admin",
"permissions": {
"_version": 57,
"cohorts": [
{
"cohort_id": "NOCOHORT"
}
],
"stages": [
{
"stage_id": "WBSCYW1"
}
],
"statuses": [
{
"status_guid": "instance.taxonomy.3971"
}
]
},
"users": {
"ids": [
{
"user_id": "57719c709567a6b906f"
}
]
}
}
],
"guid": "instance.decisions_settings.6",
"intelligent_admissions": [
{
"_id": "5c896d032ca3f61cc3078708",
"active": false,
"author_id": "59aef02ec2a9d819177b1b7f",
"created_at": "2019-03-13T20:50:11+00:00",
"description": "Automate Decisions Assignee",
"name": "Automate Decisions Assignee",
"rule": {
"action": {
"type": "assign_to",
"value": "5a5e3d4fc2a9d8241e7a4f74"
},
"filter": {
"conditions": [
{
"content": [
{
"operator": "$eq",
"type": "application_guid",
"value": "instance.applications.109"
}
],
"type": "decision_application"
}
],
"conditions_operator": "and"
}
},
"updated_at": "2019-06-06T17:43:13+00:00"
}
],
"stages": [
{
"_id": "WBSCY1W1",
"_version": 13,
"all_stage_transitions": true,
"created_at": "2018-05-29T19:23:32",
"index_weight": 1,
"locked": true,
"name": "Ready for Review",
"slug": "ready-for-review",
"statuses": [
{
"status_guid": "instance.taxonomy.3971"
}
],
"updated_at": "2019-03-12T17:32:48"
}
],
"system_updated_at": "2020-01-29T16:42:25.334000",
"tests": [
{
"application_guid": "instance.applications.32",
"testset": [
{
"_id": "PQQAEU41",
"index_weight": 1,
"ranges": {
"average": {
"max": 290,
"min": 210
},
"high": {
"max": 340,
"min": 300
},
"low": {
"max": 200,
"min": 0
}
},
"show_in": {
"card": false,
"header": false
},
"test_type": "GRE"
}
]
}
],
"tokens": [
{
"_id": "FIDUQRG",
"index_weight": 1000,
"name": "Admitted",
"slug": "admitted-test"
}
],
"updated_at": "2020-09-08T22:55:24"
}el_decisions_settings_raw Columns
6 rows
| Column | SQL Data Type | Description |
|---|---|---|
| subdom | VARCHAR | Partner school instance identifier. |
| _id | VARCHAR | Unique decisions settings identifier. |
| src | VARIANT | JSON object of decisions settings properties. |
| etl_loaded_at | TIMESTAMP_NTZ | Decisions Settings loaded to Snowflake timestamp |
| created_at | TIMESTAMP_NTZ | Decisions Settings log created timestamp |
| updated_at | TIMESTAMP_NTZ | Decisions Settings update timestamp |
JSON Keys for Decisions Settings Object
16 rows
| Description | Data Type | Key |
|---|---|---|
| Array of objects. Each objects containing parameters for a unique media. | ARRAY | media |
| Array of objects. Each object containing parameters for a unique financial award configuration. | ARRAY | financial_award |
| Array of objects. Each objects containing parameters for a unique group. | ARRAY | groups |
| Object with properties referencing checklist items associated with the settings. | OBJECT | checklist |
| Date of object creation. | STRING (TIMESTAMP) | created_at |
| Array of objects. Each objects containing parameters for a unique intelligent admissions configuration. | ARRAY | intelligent_admissions |
| Date of last update. | STRING (TIMESTAMP) | updated_at |
| Array of objects. Each objects containing parameters for a unique test. | ARRAY | tests |
| Array of objects. Each object containing parameters for a unique critera. | ARRAY | criteria |
| Indicates the subdomain related to a given instance. | STRING | _subdom |
| Unique identifier for the data object. | STRING | _id |
| Array of objects. Each object containing parameters for a unique cohort. | ARRAY | cohorts |
| Date of last system update. | STRING (TIMESTAMP) | system_updated_at |
| Array of objects. Each objects containing parameters for a unique stage. | ARRAY | stages |
| Unique identifier for the settings. | STRING | guid |
| Array of objects. Each objects containing parameters for a unique token. | ARRAY | tokens |
Was this page helpful?