Learning Environment Organization

Purpose and potential use-cases

The purpose of this mart is to associate courses and enrollments in courses (both course_offerings and course_sections) with the hierarchy of LMS accounts, which we call learning environment organizations in the UDP.

Use cases can include provisioning and permissions in other reporting tools. For example, if users have operational needs to see all UDP data associated with a particular LMS account, joining this mart into analyses will surface the appropriate account hierarchies and enable pivoting.

There are two marts: mart_course_offering.learning_environment_organization and mart_course_section.learning_environment_organization. The former mart captures the LMS account hierarchy of a course offering, while the latter part captures the LMS account hierarchy of a course section.

BQ Prod Dataset Location

mart_course_offering

mart_course_section

Interactive Mart Dependency Diagram

The following visualization shows the construction of this data mart defined in the UDP marts repository. More information on the repository and diagram can be found on this marts page.

Click here to open the interactive chart.

Schema

Mart/course_offering/learning_environment_organization

Field	Type	Description
udp_course_offering_id	INTEGER	The UDP ID of the course offering.
lms_course_offering_id	STRING	The LMS ID of the course offering.
udp_person_id	INTEGER	The UDP ID of the person.
lms_person_id	STRING	The LMS ID of the person.
udp_learning_environment_organization_id	INTEGER	The UDP ID of the learning environment organization associated with the course offering.
lms_learning_environment_organization_id	STRING	The LMS ID of the learning environment organization associated with the course offering.
academic_term_name	STRING	The name of the academic term, i.e. Fall 2020.
academic_term_start_date	DATE	The start date for the academic term.
course_offering_title	STRING	The title of the Course offering, i.e. Linear Algebra.
course_offering_start_date	DATE	The start date of the Course offering.
course_offering_subject	STRING	The subject of the Course offering, i.e. MATH.
course_offering_number	STRING	The number of the Course offering, i.e. 310.
course_offering_code	STRING	The code of the Course offering, i.e. MATH 310.
instructor_display	STRING	An array of all the instructor’s names for the Course offering written as a string.
instructor_name_array	ARRAY<STRING>	An array of all the instructor’s names for the Course offering.
instructor_email_address_display	STRING	An array of all the instructor email addresses for the Course offering written as a comma-separated string.
instructor_email_address_array	ARRAY<STRING>	An array of all the instructor email addresses for the Course offering.
person_name	STRING	The name of the person.
role	STRING	The role of the person in the Course offering, i.e. Student, Teacher.
role_status	STRING	The latest role status of the person in the course offering
enrollment_status	STRING	The latest enrollment status of the person in the course offering
name	STRING	The name of the learning environment organization
depth	INTEGER	The number of levels from the root learning environment organization
status	STRING	The status of the learning environment organization from the LMS.
parent_learning_environment_organization_id	INTEGER	The UDP ID of the learning environment organization directly above the learning environment organization in scope, if it exists.
grandparent_learning_environment_organization_id	INTEGER	The UDP ID of the learning environment organization two levels above the learning environment organization in scope, if it exists.
root_learning_environment_organization_id	INTEGER	The UDP ID of the learning environment organization that has no parent. Depth = 0
root_learning_environment_organization	STRING	The name of the learning environment organization that has no parent. Depth = 0
sub_learning_environment_organization_id_1	INTEGER	The UDP ID of the learning environment organization that has depth = 1 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_1	STRING	The name of the learning environment organization that has depth = 1 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_2	INTEGER	The UDP ID of the learning environment organization that has depth = 2 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_2	STRING	The name of the learning environment organization that has depth = 2 in the hierarchy of the learning environment organization in scope, if it exists
sub_learning_environment_organization_id_3	INTEGER	The UDP ID of the learning environment organization that has depth = 3 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_3	STRING	The name of the learning environment organization that has depth = 3 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_4	INTEGER	The UDP ID of the learning environment organization that has depth = 4 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_4	STRING	The name of the learning environment organization that has depth = 4 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_5	INTEGER	The UDP ID of the learning environment organization that has depth = 5 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_5	STRING	The name of the learning environment organization that has depth = 5 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_6	INTEGER	The UDP ID of the learning environment organization that has depth = 6 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_6	STRING	The name of the learning environment organization that has depth = 6 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_7	INTEGER	The UDP ID of the learning environment organization that has depth = 7 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_7	STRING	The name of the learning environment organization that has depth = 7 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_8	INTEGER	The UDP ID of the learning environment organization that has depth = 8 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_8	STRING	The name of the learning environment organization that has depth = 8 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_9	INTEGER	The UDP ID of the learning environment organization that has depth = 9 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_9	STRING	The name of the learning environment organization that has depth = 9 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_id_10	INTEGER	The UDP ID of the learning environment organization that has depth = 10 in the hierarchy of the learning environment organization in scope, if it exists.
sub_learning_environment_organization_10	STRING	The name of the learning environment organization that has depth = 10 in the hierarchy of the learning environment organization in scope, if it exists.

Field

Type

Description

udp_course_offering_id

INTEGER

The UDP ID of the course offering.

lms_course_offering_id

STRING

The LMS ID of the course offering.

udp_person_id

INTEGER

The UDP ID of the person.

lms_person_id

STRING

The LMS ID of the person.

udp_learning_environment_organization_id

INTEGER

The UDP ID of the learning environment organization associated with the course offering.

lms_learning_environment_organization_id

STRING

The LMS ID of the learning environment organization associated with the course offering.

academic_term_name

STRING

The name of the academic term, i.e. Fall 2020.

academic_term_start_date

DATE

The start date for the academic term.

course_offering_title

STRING

The title of the Course offering, i.e. Linear Algebra.

course_offering_start_date

DATE

The start date of the Course offering.

course_offering_subject

STRING

The subject of the Course offering, i.e. MATH.

course_offering_number

STRING

The number of the Course offering, i.e. 310.

course_offering_code

STRING

The code of the Course offering, i.e. MATH 310.

instructor_display

STRING

An array of all the instructor’s names for the Course offering written as a string.

instructor_name_array

ARRAY<STRING>

An array of all the instructor’s names for the Course offering.

instructor_email_address_display

STRING

An array of all the instructor email addresses for the Course offering written as a comma-separated string.

instructor_email_address_array

ARRAY<STRING>

An array of all the instructor email addresses for the Course offering.

person_name

STRING

The name of the person.

role

STRING

The role of the person in the Course offering, i.e. Student, Teacher.

role_status

STRING

The latest role status of the person in the course offering

enrollment_status

STRING

The latest enrollment status of the person in the course offering

name

STRING

The name of the learning environment organization

depth

INTEGER

The number of levels from the root learning environment organization

status

STRING

The status of the learning environment organization from the LMS.

parent_learning_environment_organization_id

INTEGER

The UDP ID of the learning environment organization directly above the learning environment organization in scope, if it exists.

grandparent_learning_environment_organization_id

INTEGER

The UDP ID of the learning environment organization two levels above the learning environment organization in scope, if it exists.

root_learning_environment_organization_id

INTEGER

The UDP ID of the learning environment organization that has no parent. Depth = 0

root_learning_environment_organization

STRING

The name of the learning environment organization that has no parent. Depth = 0

sub_learning_environment_organization_id_1

INTEGER

The UDP ID of the learning environment organization that has depth = 1 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_1

STRING

The name of the learning environment organization that has depth = 1 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_2

INTEGER

The UDP ID of the learning environment organization that has depth = 2 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_2

STRING

The name of the learning environment organization that has depth = 2 in the hierarchy of the learning environment organization in scope, if it exists

sub_learning_environment_organization_id_3

INTEGER

The UDP ID of the learning environment organization that has depth = 3 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_3

STRING

The name of the learning environment organization that has depth = 3 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_4

INTEGER

The UDP ID of the learning environment organization that has depth = 4 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_4

STRING

The name of the learning environment organization that has depth = 4 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_5

INTEGER

The UDP ID of the learning environment organization that has depth = 5 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_5

STRING

The name of the learning environment organization that has depth = 5 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_6

INTEGER

The UDP ID of the learning environment organization that has depth = 6 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_6

STRING

The name of the learning environment organization that has depth = 6 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_7

INTEGER

The UDP ID of the learning environment organization that has depth = 7 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_7

STRING

The name of the learning environment organization that has depth = 7 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_8

INTEGER

The UDP ID of the learning environment organization that has depth = 8 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_8

STRING

The name of the learning environment organization that has depth = 8 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_9

INTEGER

The UDP ID of the learning environment organization that has depth = 9 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_9

STRING

The name of the learning environment organization that has depth = 9 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_id_10

INTEGER

The UDP ID of the learning environment organization that has depth = 10 in the hierarchy of the learning environment organization in scope, if it exists.

sub_learning_environment_organization_10

STRING

The name of the learning environment organization that has depth = 10 in the hierarchy of the learning environment organization in scope, if it exists.

Mart/Course_section/learning_environment_organization

The course section mart includes all the fields found in the course offering mart, as well as 2 more fields, which are presented in the table below.

Field	Type	Description
udp_course_section_id	INTEGER	The UDP ID of the Course section.
lms_course_section_id	STRING	The LMS ID of the Course section.

Field

Type

Description

udp_course_section_id

INTEGER

The UDP ID of the Course section.

lms_course_section_id

STRING

The LMS ID of the Course section.

PreviousInteraction sessions NextFile Interaction

Last updated 5 months ago