Outcomes Course Schema
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.
| 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.
| 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.
| 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. |
