# 2.0.137

## Batch ingest release, database resource improvements, and UCDM SIS 2.0 loading schema option

| Version      | 2.0.137        |
| ------------ | -------------- |
| Release Date | March 20, 2023 |

## Key Features

This release introduces internal improvements to batch-ingest that will allow Unizin to better manage database resources and improve reliability and speed of the pipeline. It also includes new option set values added for Person, Course Section, and Academic Degree entities.

## Details

All non-infrastructure user queries that are running at an institution's ingest run-time will be cancelled to prevent deadlocking of resources in the context\_store database. Queries run by users belonging to the institution role will be cancelled if they take longer than ten minutes. This is to prevent deadlocking of tables in the context\_store database and it ensures that Airflow can process institutional data without interruption.

**The new option set values added to the UCDM are linked below:**

#### **Person Entity**

citizenship\_one (ref\_country)

* [International](https://docs.udp.unizin.org/tables/ref_country.html)

sex (ref\_sex)

* [Nonbinary](https://docs.udp.unizin.org/tables/ref_sex.html)

#### **Course Section**

type (ref\_course\_section\_type)

* [Activity](https://docs.udp.unizin.org/tables/ref_course_section_type.html)
* [Field Work](https://docs.udp.unizin.org/tables/ref_course_section_type.html)
* [Tutorial](https://docs.udp.unizin.org/tables/ref_course_section_type.html)

#### **Academic Degree**

educational\_level (ref\_degree\_educational\_level)

* [ProfessionalMasters](https://docs.udp.unizin.org/tables/ref_degree_educational_level.html)
* [AcademicMasters](https://docs.udp.unizin.org/tables/ref_degree_educational_level.html)
* [ProfessionalDoctorate](https://docs.udp.unizin.org/tables/ref_degree_educational_level.html)
* [AcademicDoctorate](https://docs.udp.unizin.org/tables/ref_degree_educational_level.html)

## Known Issues

None.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/release-notes/2.0.137_batch_ingest_release.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.