Skip to main content
pdf?stylesheet=default
Blackboard Help

Outcomes Dimension and Miscellaneous View

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_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_VW

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.

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_DEPLOYMENT_DIM_VW 

This view contains one row for each deployment of any instrument. Used in the Rubric, Submission and Survey star schemas. This view contains the instrument_pk1 of the instrument that was deployed. This actually concatenates instrument type (A=Artifact Template, P=Portfolio Template, C=Course Evaluation, S=Survey, O=Offline Instrument) and pk1 so is unique across instruments.

This view contains a curr_instr_version_pk1 column which identifies the current version of the deployed instrument. This can come into play when an instrument is modified after a given deployment.

This view contains a place_pk1 column which identifies the work context that this deployment belongs to. This column is used to select deployments that belong to the work context where a report is running.

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 Identified the instrument deployed.
curr_instr_version_pk1 The instrument_pk1 of the current version of the deployed instrument. Whenever an instrument is edited, or in some cases when it is deployed, a new current version is created so that the old versions can be preserved.
place_pk1 Identifies the owner of the deployment (Unit, Program, Course, Educational Experience, or Work Space).
survey_pk1 If the deployed instrument was a Survey or Course Evaluation this key identifies the Survey or Course Evaluation.
artifact_tmpltpk1 If the deployed instrument was an Artifact Template this key identifies the Artifact Template.
portfolio_tmplt_pk1 If the deployed instrument was a Portfolio Template this key identifies the Portfolio Template.

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_II_VW

This view contains one record for each Improvement Initiative. It is used in the Goals schema.

Goals Schema Information
Column Description
pk1 Unique Identifier.
title The title of the Improvement Initiative.
description The description of the Improvement Initiative.
owner_title The name of the Unit that owns the Improvement Initiative.
start_date The date the Improvement Initiative begins.
end_date The date the Improvement Initiative ends.
status The Improvement Initiative's status: A=Draft, B=Complete, C=Approved, D=Inactive, E=Incomplete
status_lable Can be used to retrieve internationalized text for the status.

ODS_IP_VW 

This view contains one record for each Improvement Project. It is used in the Goals schema.

Goals Schema Information
Column Description
pk1 Unique Identifier.
title The title of the Improvement Project.
description The description of the Improvement Project.
ii_pk1 Identifies the ods_ii_vw record that this Improvement Project has been mapped to (if any).
owner_title The name of the Unit that owns the Improvement Project.
start_date The date the Improvement Project begins.
end_date The date the Improvement Project ends.
status The improvement initiative's status: A=Draft, B=Complete, C=Approved, D=Inactive, E=Incomplete
status_lable Can be used to retrieve internationalized text for the status.

ODS_INSTRUCTOR_VW

This view contains a record for each lead instructor identified for an Outcomes Course or Educational Experience Section. Used in the Survey schema. This view is not directly referred to by any of the ODS Views. It has been included to provide a list of lead instructors.

Survey Schema Information
Column Description
pk1 Unique Identifier.
name The name of the lead instructor.

ODS_INSTRUMENT_DIM_VW 

This view contains a record for each instrument. Instruments include Surveys, Course Evaluations, Artifact Templates, Portfolio Templates, and Offline Instruments. It is used in the Rubric, Submission, Survey and Goals schemas.

Schema Information
Column Description
pk1 Unique Identifier.
name The name of the instrument.
description The description the instrument.
end_date The date the deployment stopped.
curr_instr_version_pk1 The instrument_pk1 of the current version of the deployed instrument. Whenever an instrument is edited, or in some cases when it is deployed, a new current version is created so that the old versions can be preserved.
place_pk1 Identifies the owner of the deployment (Unit, Program, Course, Educational Experience, or Work Space).
type The type of this instrument. A=Artifact Template, P=Portfolio Template, C=Course Evaluation, S=Survey, O=Offline Instrument
offline_instrument_pk1 If this instrument is an offline_instrument this key identifies that offline instrument. Not needed in most cases.
survey_pk1 If the deployed instrument was a Survey or Course Evaluation this key identifies the Survey or Course Evaluation.
artifact_tmpltpk1 If the deployed instrument was an Artifact Template this key identifies the Artifact Template. Not needed in most cases.
portfolio_tmplt_pk1 If the deployed instrument was a Portfolio Template this key identifies the Portfolio Template. Not needed in most cases.

ODS_INSTR_MEASURE_IPO_VW

This view identifies all of the instruments that are used to measure a given Improvement Project Objective. It is based off of the clp_instr_association table. Modifying the Improvement Project Objective screen and selecting an instrument in the measurement section will cause it to show up here.

Improvement Project Objective Information
Column Description
sog_pk1 Identifies the ods_sog_vw record that is measured by an instrument.
instrument_pk1 Identifies the ods_instrument_dim_vw record that is used to measure a Goal.
instrument_name The name of the instrument.
instrument_description The description the instrument.
offline_instrument_pk1 If this instrument is an offline_instrument this key identifies that offline instrument.
survey_pk1 If the deployed instrument was a Survey or Course Evaluation this key identifies the Survey or Course Evaluation.
artifact_tmpltpk1 If the deployed instrument was an Artifact Template this key identifies the Artifact Template.
portfolio_tmplt_pk1 If the deployed instrument was a Portfolio Template this key identifies the Portfolio Template.

ODS_INSTRUMENT_RUBRIC_VW

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_PERSON_DIM_VW

This view contains one row for each Outcomes 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.
gender_label Can be used to lookup 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
ethnicity_label Can be used to lookup the internationalized string for this person's ethnicity.
socio_economic_status The person's socio-economic status.
standard_test_score The person's standard test score.
birth_date The person's birth date.
prim_state The two (2) letter abbreviation for the state of this person's primary address.
prim_state_lable Can be used to look up the internationalized string for the two (2) 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.

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_VW

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_SOG_VW

This view maps ods_question_dim_vw records to ods_sog_vw records.

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_QUESTION_TAG_VW

This view maps tags to ods_question_dim_vw 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_VW

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_VW 

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

ODS_SOG_INSTRUMENT_VW

This view contains one record for each Instrument – Goals alignment. This record contains information about the Instrument and the pk1 of the Goal. If you go to an Instrument page and align it to a Goal, the relationship shows up here.

Record Information
Column Description
sog_pk1 Identifies the ods_sog_vw record that is mapped to an instrument.
instrument_pk1 Identifies the ods_instrument_dim_vw record that is mapped to a Goal.
survey_pk1 If this instrument is a Survey or Course evaluation this key identifies the Survey or Course evaluation.
artifact_tmplt_pk1 If this instrument is an artifact template this key identifies the artifact template.
portfolio_tmplt_pk1 If this instrument is a portfolio template this key identifies the portfolio template.

ODS_SOG_VW 

This view contains one record for each Goal. Most of the columns contain the same information that is documented for the ods_aligned_sog_vw.

Record Information
Column Description Can be used to filter ods_survey_answer_fact_vw records by
pk1 Unique Identifier.  
title The Goal's title. Personal attributes such as gender or zip code.
description The Goal's description.  
owner_title The title of the Goal's place.  Can be a Goal, Operating Unit, Program, Course, Educational Experience, or Improvement Project. The Survey or Course evaluation question that the response is answering.
type A=Improvement Project Objective, C=Course Goal, E=Educational Experience Objective, O=Operating Unit Goal, P=Program Goal, S=Goal In cases where a single student responds twice to the same deployment the two sets of answers can be grouped by their response_pk1 values.
ip_pk1 Identifies the ods_ip_vw record of the Improvement Project that owns this Goal. This field is only non-null if the type = A. Improvement Project (IP) or Initiative (II) attributes.
ancestor_ou_pk1 Identifies the ods_deployment_dim_vw record for the deployment which caused the survey or course evaluation being answered to be sent to the submitter. Deployment, or by the instrument being deployed (only one instrument can be deployed at a time).
ancestor_ou_title The title of the Operating Unit that ancestor_ou_pk1 refers to  
program_pk1 If this Goal is a program goal (type=P) this will identify the ods_program_dim_vw record of the owning program. Program attributes or the attributes of the Operating Unit that owns the program.
ou_pk1 If this Goal is an operating unit goal (type=O) this will identify the ods_ou_vw record of the owning program. Operating Unit attributes.
course_pk1 If this Goal is a course goal (type=C) this will identify the owning outcomes course. clp_course_ext table columns.
ee_pk1 If the Course evaluation or Survey was deployed to this submitter because of a program affiliation this column identifies the ods_program_vw record for that program. If this Goal is an Educational Experience Goal this will identify the Educational Experience.
std_category_pk1 If this Goal is a Goal this will identify the owning Goal Category Operating Unit attributes.
status D=Draft, A=Complete, P=Approved, I=Inactive, ACT=Active, INC=Incomplete clp_course_ext table columns.
status_label A tag that can be used to retrieve an internationalized string for the status. clp_ee_ext table columns.