Template Description
The template is designed for the creation of Power BI Report development for future Curriculum Mapping Report. Currently the Template can be located at \\usffs.forest.usf.edu\odrive$\IT-BIA\Projects\PowerBI\Templates by the name of "Self-Service Curriculum Mapping Template". The Template contains all the currently mapped data and details needed for Curriculum Mapping Reports. The Template contains the core filters used in all Curriculum Mapping Reporting along with the Link Icon, Last Refresh on:, and Tab Name if more then 1 tab is created per report.
Filters
Course Academic Year
Academic year the courses were offered, listed in four digit format for the year the term began.Med Year
Year of academic progress for the medical school program, year 1-4.
Curriculum Program
Core or SELECT options available. Choosing a program will display all items a student in that program could experience.
Table Details
TABLE_NAME | TABLE_TYPE | TABLE_DESCRIPTION |
---|---|---|
CM_COURSE_BY_ACADEMIC_YEAR | Reporting Table | Contains Course attributes by academic year. Table is filtered by Course Status = 2 ('Completed'), and Source = 'Health' which brings in only Health courses. |
CM_COURSE_OBJECTIVE | Reporting Table | Contains Course Objectives, linked to Courses from the CM_COURSE_BY_ACADEMIC_YEAR table. Table is filtered by Active = 1. |
CM_COURSEBYACADYEAR_PROGRAM | Derived Reporting Table | Contains mapping between course_by_acedemic_year_id and program. Courses linked to both Core and SELECT programs will have two seperate records in the table. This table was created to help report writers with the program button functionality on the report |
CM_PROGRAM_OBJ_COURSE_OBJ | Reporting Bridge Table | Bridge table to handle many to many relationship between program objective and course objective. |
CM_PROGRAM_OBJECTIVE | Reporting Table | Contains Program Objectives. |
CM_SESSION | Reporting Table | Contains Sessions, linked to Courses from the CM_COURSE_BY_ACADEMIC_YEAR table. Table is filtered by Status = 2 (Completed). |
CM_SESSION_OBJ_COURSE_OBJ | Reporting Bridge Table | Bridge table to handle many to many relationship between session objective and course objective. |
CM_SESSION_OBJECTIVE | Reporting Table | Contains session objectives, linked to Sessions from the CM_SESSION table. |
Column Details
TABLE_NAME | COLUMN_NAME | COLUMN_DESCRIPTION | COLUMN_DEFAULT | COLUMN_SOURCE |
---|---|---|---|---|
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_LOCATION | when location = 1, 'Lehigh Valley' when location = 2, 'Tampa' Else 'Unknown' | Unknown | (derived) Appian.CR_REC_courseByAcademicYear.location |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_IS_CORE | Yes' if the course belongs to either 'Core' or 'Core and SELECT', else 'No' | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_IS_SELECT | Yes' if the course belongs to either 'SELECT' or 'Core and SELECT', else 'No' | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_ACADEMIC_YEAR | course academic year | UNKN | Appian.CR_REC_courseByAcademicYear.academicYear |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_CONTACT_HOURS | course contact hours | 0 | Appian.CR_REC_courseByAcademicYear.contactHours |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_BY_ACADEMIC_YEAR_ID | appian composite primay key for Course By Academic Year | (not null) | Appian.CR_REC_courseByAcademicYear.courseAcademicYearId |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_NUMBER | course number | Unknown | Appian.CR_REC_courseByAcademicYear.courseNumber |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_DESCRIPTION | course description. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.description |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_END_DATE | course end date | 2099.12.31 | Appian.CR_REC_courseByAcademicYear.endDate |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_IS_OUTSIDE_BANNER | course is outside banner flag. Yes if outsideBanner=1, Else No | No | Appian.CR_REC_courseByAcademicYear.outsideBanner |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_START_DATE | course start date | 1900.01.01 | Appian.CR_REC_courseByAcademicYear.startdate |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_SUBJECT_CODE | course subject code | Unknown | Appian.CR_REC_courseByAcademicYear.subjectCode |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_TITLE | course title. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.title |
CM_COURSE_BY_ACADEMIC_YEAR | COURSE_MED_YEAR | course year number taught in | 0 | Appian.CR_REC_courseByAcademicYear.year |
CM_COURSE_OBJECTIVE | COURSE_BY_ACADEMIC_YEAR_ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_objectivePair.courseId |
CM_COURSE_OBJECTIVE | COURSE_OBJECTIVE | course objective description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_objectivePair.courseobjective |
CM_COURSE_OBJECTIVE | COURSE_OBJECTIVE_ID | appian course objective primary key | (not null) | Appian.MCOM_CM_objectivePair.id |
CM_COURSEBYACADYEAR_PROGRAM | CURRICULUM_PROGRAM | Can be 'Core' or 'SELECT'. If program is 1 then both 'Core' and 'SELECT' (separate records). If program is 2 then 'Core'. If program is 3 then 'SELECT' | -1 | (derived) Appian.CR_REC_courseByAcademicYear.program |
CM_COURSEBYACADYEAR_PROGRAM | COURSE_BY_ACADEMIC_YEAR_ID | appian course by academic year foreign key | -1 | Appian.CR_REC_courseByAcademicYear.courseAcademicYearId |
CM_PROGRAM_OBJ_COURSE_OBJ | COURSE_OBJECTIVE_ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.objectivePairId |
CM_PROGRAM_OBJ_COURSE_OBJ | PROGRAM_OBJECTIVE_ID | appian program objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.programObjectiveId |
CM_PROGRAM_OBJECTIVE | PROGRAM_OBJECTIVE_ID | appian program objective primary key | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
CM_PROGRAM_OBJECTIVE | PROGRAM_OBJECTIVE_TITLE | program objective title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_programObjective.title |
CM_SESSION | COURSE_BY_ACADEMIC_YEAR_ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_session.courseid |
CM_SESSION | SESSION_DESCRIPTION | session description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.description |
CM_SESSION | SESSION_DURATION | session duration | 0 | Appian.MCOM_CM_session.duration |
CM_SESSION | SESSION_ID | appian session primary key | (not null) | Appian.MCOM_CM_session.id |
CM_SESSION | SESSION_PREPERATION_HOURS | session preparationHours | 0 | Appian.MCOM_CM_session.preparationHours |
CM_SESSION | SESSION_TITLE | session title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.title |
CM_SESSION_OBJ_COURSE_OBJ | COURSE_OBJECTIVE_ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.courseObjectiveId |
CM_SESSION_OBJ_COURSE_OBJ | SESSION_OBJECTIVE_ID | appian session objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.sessionObjectiveId |
CM_SESSION_OBJECTIVE | SESSION_OBJECTIVE_ID | appian session objective primary key | (not null) | Appian.MCOM_CM_sessionObjectivePair.id |
CM_SESSION_OBJECTIVE | SESSION_ID | appian session foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePair.sessionid |
CM_SESSION_OBJECTIVE | SESSION_OBJECTIVE | session objective name. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_sessionObjectivePair.sessionobjective |
CM_COURSE_BY_ACADEMIC_YEAR Copy
Currently within the data model there are 2 tables that contain the same data, the table is CM_COURSE_BY_ACADEMIC_YEAR.
The two tables provide ways to access data point(s) differently due to how objectives are mapped to each other in the source. The path you take depends on what question is been asked with the data.
Not all course objectives are always mapped to a session objective and hence a session. Keeping that in mind here are the possible scenarios:
To get all connected data points here is the path that needs to be followed:
Content Objective Subheadings <- Content Objective <-Course -> Session -> Session Objective -> Course Objective -> Program Objective
To get all the course objectives connected to a course (not necessarily mapped to a session objective), and program objectives connected to those course objectives, here is the path that needs to followed:
Course-> Course Objective -> Program Objective
Data Refreshed On
Data in this report is not live, but refreshed regularly. The date on the bottom right of the report displays the last day the data was refreshed from Archivum Curriculum Mapping.
Disclaimer
This report only displays values as the were in Archivum Curriculum Mapping at last refresh as indicated at the bottom of the report. Those values are subject to change over time. Unauthorized use of this report is prohibited. If you log on to this computer system, you acknowledge your awareness of and concurrence with the University of South Florida policies. The University will prosecute violators to the full extent of the law.