# 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.