Skip to main content
pdf?stylesheet=default
Blackboard Help

Outcomes Dimension and Miscellaneous Views

Dimension views are views that can be directly used to filter fact views.  Miscellaneous views are views that do not fit into a star schema but are useful. 

ODS_DEPLOYMENT_DIM

Contains one row for each deployment of a survey. Contains the instrument_pk1 of the survey ('S' concatenated with the survey's pk1 value) that was deployed.

Used in the Rubric, Submission, and Survey star schemas.

Deployment Information
Column Description
pk1 Unique Identifier.
name The name of the deployment.
start_date The date the deployment started.
end_date The date the deployment stopped.
instrument_pk1 The instrument_pk1 of the current version of the instrument.
curr_instr_version_pk1 No longer used.
place_pk1 No longer used.
survey_pk1 If the deployed instrument was a survey this key identifies the Survey.
artifact_tmplt_pk1 No longer used.
portfolio_tmplt_pk1 No longer used.

ODS_INSTRUMENT_DIM

This view contains a record for each instrument and is used in the Rubric, Submission, and Survey schemas.

Schema Information
Column Description
pk1 Unique Identifier.
name The name of the instrument.
description The description the instrument.
curr_instr_version_pk1 No longer used.
type The type of this instrument. S=Survey,G=Course Content Item,Q=Course Test Question,E=Evidence Set.
offline_instrument_pk1 No longer used.
survey_pk1 If this instrument is a survey or course evaluation this key identifies the survey or course evaluation.
artifact_tmplt_pk1 No longer used.
portfolio_tmplt_pk1 No longer used.
dtcreated When the instrument was created.  Will be null for non-outcomes instruments.

ODS_PERSON_DIM

This view contains one row for each person. It is used in the Submission, Survey and Rubric star schemas.

Schema Information
Column Description
pk1 Unique Identifier.
given_name The person's first name.
family_name The person's last name.
middle_name The person's middle name.
gender The person's gender: F=Female, M=Male, N=Not Disclosed, Null=Not Disclosed.
gender_label Can be used to look up the internationalized string for this person's gender.
ethnicity The person's ethnicity. A=Asian, B=Black, L=Latino, N=Native American ,X=Not Disclosed, O=Other, P=Pacific Islander, W=White, Null=Not Disclosed.
ethnicity_label Can be used to look up the internationalized string for this person's ethnicity.
socio_economic_status No longer used.
standard_test_score No longer used.
birth_date The person's birth date.
prim_state The two-letter abbreviation for the state of this person's primary address.
prim_state_label Can be used to look up the internationalized string for the two-letter abbreviation for the state of this person's primary address.
prim_country The country of this person's primary address.
zip_code The person's zip code.
email The person's e-mail address.
batch_uid The person's batch_uid.

ODS_QUESTION_SOG

This view maps ods_question_dim records to ods_sog records. It is used in the Survey star schema.

Records Information
Column Description
question_pk1 Identifies the question that has been mapped to a goal.
sog_pk1 Identifies the goal that has a question mapped to it.

ODS_SOG

This view contains one record for each goal. Most of the columns contain the same information that is documented for the ods_aligned_sog. It is used in the Learning Standards schemas

Record Information
Column Description
pk1 Unique Identifier.
title The goal's title.
description The goal's description.
owner_title No longer used.
type No longer used.
ip_pk1 No longer used.
ancestor_ou_pk1 No longer used.
ancestor_ou_title No longer used.
program_pk1 No longer used.
ou_pk1 No longer used.
course_ee_pk1 No longer used.
course_pk1 No longer used.
ee_pk1 No longer used.
std_category_pk1 No longer used.
status D=Draft, A=Complete, P=Approved, I=Inactive, ACT=Active, INC=Incomplete
status_label A tag that can be used to retrieve an internationalized string for the status.
form_pk1 No longer used.
authorized_ind No longer used.
start_date The date time when goal record is applicable.
end_date The date time when goal record is not applicable anymore.
modifying_user The user ID of the last user to modify this goal.
place_pk1 No longer used.
std_category_pk1 No longer used.
public_ind Indicates whether this goal is viewable by all users.
batch_uid This goal's batch_uid.
dtcreated Date on which this goal was created.
measurement_desc No longer used.
dtmodified Date on which this goal was last modified.
priority This is the priority of the goal.
priority_label The readable string for the goal priority.

ODS_AFFILIATION_DIM_VW

The following view contains one record for each entity that an Outcomes Person can be affiliated with. This includes Course and Educational Experience Sections, Programs, and Units. This is used in the Rubric, Submission and Survey star schemas.

Star Schema Information
Column Description
pk1 Unique Identifier.
title The name of the entity a person can be affiliated with.
ee_section_pk1 If this is an Educational Experience Section this key identifies the Section.
course_section_pk1 If this is a Course Section this key identifies the Section.
ou_pk1 If this is a Unit this key identifies the Unit.
program_pk1 If this is a Program, this key identifies the Program.

ODS_ANSWER_DIM

This view contains a row for each possible answer to any survey question. For matrix questions, this view contains a row for each possible answer to any of the rows of the matrix. This is used in the Survey star schema.

Survey Star Schema Information
Column Description
pk1 Unique Identifier.
name The text of the answer.
display_order The zero-based index of the position in which the answer is displayed.
points The point value assigned to the answer.
question_pk1 Identifies the question that the answer applied to.
score_as_percent_of_range The score for this answer as a percentage of the range between the min and max values for this question.

ODS_COURSE_EE_VW

This view contains one record for each Course and Educational Experience. This is used in the Course schema.

Course Schema Information
Column Description
pk1 Unique Identifier.
title The title of the course or Educational Experience.
type The course's type. C=Course, E=Education Experience
ou_pk1 Identifies the Unit the course belongs to.
course_pk1 If this is a course, not an Educational Experience, this key identifies the Course.
ee_pk1 If this is an Educational Experience, not a course, this key identifies the Educational Experience.

ODS_DISTR_LIST_DIM_VW

This view contains one record for each Distribution List. It is used in the Rubric, Submission and Survey star schemas.

Star Schema Information
Column Description
pk1 Unique Identifier.
name The name of the distribution list.

 

ODS_INSTRUMENT_RUBRIC

This view contains a mapping of rubrics to the instruments whose responses the rubric can be used to evaluate. It is used in the rubric star schema.

Rubric Star Schema Information
Column Description
rubric_pk1 Identifies the Rubric that has an instrument mapped to it.
instrument_pk1 Identifies the instrument that is mapped to a Rubric.
rubric_title The title of the Rubric that has an instrument mapped to it.

ODS_OU_VW

This view contains one record for each Outcomes Unit. It is used in the Submission, Survey, Course and Goals schemas.

Schema Information
Column Description
pk1 Unique Identifier.
name The name of the Unit.
title The title of the Unit.
description The description of the Unit.

ODS_PROGRAM_COURSE_EE_VW

This view contains a mapping of Programs to Courses and Educational Experiences. It is used in the Course schema.

Mapping
Column Description
program_pk1 Identifies the program that has a course mapped to it.
course_ee_pk1 Identifies the course or Educational Experience that has a Program mapped to it.

ODS_PROGRAM_DIM_VW

This view contains one record for each Outcomes Program.

Record View
Column Description
pk1 Unique Identifier.
program_name The Program’s name.
program_title The Program’s title.
ou_pk1 Identifies the Operating Unit that owns this Program.

ODS_QUESTION_DIM

This view contains one record for each question in any survey or course evaluation. For matrix questions, this view contains one record for each row in the matrix and each of those view rows will contain the matrix question's text in its super_question_desc column. The super_question_description column is only populated for view rows related to matrix questions.

Question Information
Column Description
pk1 Unique Identifier.
question_desc The text that is displayed for this question. If this is a matrix question this is the text that is displayed to the left of a matrix row.
super_question_desc If this is a matrix question this is the text that is displayed for the matrix as a whole. If this is not a matrix question this column is null.
question_display_order The zero-based display order of this question.
question_type This question's type. M=Multiple Choice, L=Likert, X=Matrix, B=Boolean, O=Open Ended
question_type_label Can be used to retrieve the internationalized string for this question's type.
numbering_type Indicates how the answers for this question are numbered. N="1,2,3,4" L="a,b,c,d" A="A,B,C,D" I="I,II,III" R="i,ii,iii" X=none
survey_name The name of the survey or Course Evaluation that this question belongs to.
survey_desc The description of the survey or Course Evaluation that this question belongs to.
survey_type The type of the Survey or Course Evaluation that this question belongs to. "S"=Survey, "C"=Course Evaluation.
super_question_pk1 Identifies the super question that this answer applies to.
survey_pk1 Identifies the survey or course evaluation that this question belongs to.

ODS_QUESTION_TAG

This view maps tags to ods_question_dim records.

Tags Information
Column Description
tag_value The string displayed for the tag.
question_pk1 Identifies the question that has been tagged with tag_value.

ODS_RUBRIC_CELL_DIM

This view contains one record for each cell defined for any rubric. It also contains information about the row, column, and rubric the cell belongs to.

Record Information
Column Description
pk1 Unique Identifier.
rubric_pk1 Identifies the rubric that this cell belongs to.
rubric_row_pk1 Identifies the rubric row that this cell belongs to.
rubric_column_pk1 Identifies the rubric column that this cell belongs to.
rubric_title The title of the rubric that this cell belongs to.
rubric_desc The description of the rubric that this cell belongs to.
rubric_row_header The displayed header of the rubric row that this cell belongs to.
rubric_row_order The zero-based display order of the row that this cell belongs to.
rubric_column_header The displayed header of the rubric column that this cell belongs to.
rubric_column_order The zero-based display order of the column that this cell belongs to.
Points The points assigned to this cell.

ODS_RUBRIC_EVAL_DIM

This view contains one row for each time any rubric is used to evaluate any instrument.

Rubric Information
Column Description
rubric_pk1 Identifies the rubric that has an instrument mapped to it.
instrument_pk1 Identifies the instrument that is mapped to a rubric.
rubric_title The title of the rubric that has an instrument mapped to it.

ODS_SECTION_DIM_VW

This view contains a record for each Outcomes Course and Educational Experience Section. It also contains information about the entities that own the section, for example, the course or Educational Experience, and up to three levels of Units that own the course or the Educational Experience. The level_1_ou_pk1 refers to the Unit that owns the Course or Educational Experience that this section belongs to. The level_2_ou_pk1 refers to the Unit that owns the level 1 Unit.

Record Information
Column Description
pk1 Unique Identifier.
section_title The title of the section.
instructor_name The name of the section's lead instructor.
course_section_pk1 If this is a course section this key identifies the Course section.
ee_section_pk1 If this is an Educational Experience section this key identifies the section.
course_ee_pk1 Identifies the owning Course or Educational Experience.
course_ee_title The title of the owning Course or Educational Experience.
level_1_ou_pk1 Identifies the Operating Unit that owns the parent Course or Educational Experience section.
level_1_ou_title The title of the Operating Unit that owns the parent course or Educational Experience section.
level_2_ou_pk1 Identifies the Operating Unit that owns the level 1 Operating Unit.
level_3_ou_pk1 Identifies the Operating Unit that owns the level 2 Operating Unit.
Type The type of this section. E=Educational Experience Section, C=Course Section