Element451Integrations Guide

el_decisions_settings_raw

Updated Article

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

json
{
  "_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
el_decisions_settings_raw Columns
ColumnSQL Data TypeDescription
subdomVARCHARPartner school instance identifier.
_idVARCHARUnique decisions settings identifier.
srcVARIANTJSON object of decisions settings properties.
etl_loaded_atTIMESTAMP_NTZDecisions Settings loaded to Snowflake timestamp
created_atTIMESTAMP_NTZDecisions Settings log created timestamp
updated_atTIMESTAMP_NTZDecisions Settings update timestamp
JSON Keys for Decisions Settings Object
16 rows
JSON Keys for Decisions Settings Object
DescriptionData TypeKey
Array of objects. Each objects containing parameters for a unique media.ARRAYmedia
Array of objects. Each object containing parameters for a unique financial award configuration.ARRAYfinancial_award
Array of objects. Each objects containing parameters for a unique group.ARRAYgroups
Object with properties referencing checklist items associated with the settings.OBJECTchecklist
Date of object creation.STRING (TIMESTAMP)created_at
Array of objects. Each objects containing parameters for a unique intelligent admissions configuration.ARRAYintelligent_admissions
Date of last update.STRING (TIMESTAMP)updated_at
Array of objects. Each objects containing parameters for a unique test.ARRAYtests
Array of objects. Each object containing parameters for a unique critera.ARRAYcriteria
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.ARRAYcohorts
Date of last system update.STRING (TIMESTAMP)system_updated_at
Array of objects. Each objects containing parameters for a unique stage.ARRAYstages
Unique identifier for the settings.STRINGguid
Array of objects. Each objects containing parameters for a unique token.ARRAYtokens