This schema contains views needed to navigate the relationships between courses, terms, and nodes. It doesn't really contain any facts so all of its views are documented in the list below.


ODS_TERM

ODS_TERM contains one record for each term.

Fact table
Column Description
pk1 Unique Identifier.
title Title of the term.
description Description of the term.
start_date The date on which this term begins.
end_date The date on which this term ends.
available_ind An indicator of if the term is available.
batch_uid Batch_uid of the term.

ODS_NODE

ODS_NODE contains one record for each term.

Fact table
Column Description
pk1 Unique Identifier.
Name Name of the node.
Batch_uid Batch_uid of the node.
parent_pk1 Unique Identifier.

ODS_LS_COURSE_NODE

ODS_LS_COURSE_NODE contains a record for each node to course mapping.

Fact table
Column Description
course_pk1 Identifies an ods_ls_course record.
node_pk1 Identifies an ods_term record.
primary_ind Indicates if this is the primary node for this course.