Learning Environment Organization
Last updated
Last updated
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.
mart_course_offering
mart_course_section
The following visualization shows the construction of this data mart defined in the repository. More information on the repository and diagram can be found on .
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
enrollment_status
STRING
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.
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.
udp_course_section_id
INTEGER
The UDP ID of the Course section.
lms_course_section_id
STRING
The LMS ID of the Course section.
The latest of the person in the course offering
The latest of the person in the course offering
