| Table of Contents | ||
|---|---|---|
|
...
| TABLE NAME | TABLE DESCRIPTION |
|---|---|
| Content Objective | Contains Content Objectives with description and discipline, linked to Courses from the Course by Academic Year table. Table is filtered for active records. |
| Course by Academic Year | Contains Course attributes by academic year. Table is filtered by Course Status = 2 ('Completed'), and Source = 'Health' which brings in only Health courses. |
| Course by Academic Year Program | Contains mapping between course_by_academic_year_id and program. Courses linked to both Core and SELECT programs will have two separate records in the table. This table was created to help report writers with the program button functionality on the report. |
| Course Objective | Course objective description and the course objective ID. |
| EPAs | Contains EPA (Entrustable Professional Activities) information. |
| EPA by Progam Objective | Contains mapping between EPA and Porgram Objective table; linked by EPA ID. |
| Keyword Hierarchy | Contains Keyword information for keyword search. |
| Methods | Contains method information (for session objectives) with method type description noting Primary Instructional Method, Additional Instructional Method, or Assessment. |
| Methods to Course Objectives | Contains method information (for course objectives), with method type description noting Primary Instructional Method, Additional Instructional Method, or Assessment. |
| Program Objective Course Objective | Bridge table to handle many to many relationship between program objective and course objective. |
| Program Objective | Contains Program Objectives. |
| Session | Contains Sessions, linked to Courses from the Course By Academic Year table. Table is filtered by Status = 2 (Completed). |
| Session Objective Course Objective | Bridge table to handle many to many relationship between session objective and course objective. |
| Session Objective | Contains session objectives, linked to Sessions from the CM_SESSION table. |
...
- In addition to the pre-made filters mentioned at the top of the page (Academic Year, Med Year, and Curriculum Program), report level filters can be set, e.g. "Course Academic Year" is not blank, or "Program Objective" is not blank.
- It may be needed at times to obtain a single line for an item (when using a table in the report) or when used as a measure to provide a count, to select "Count Distinct," such as for SessionID.
- For Session Duration Hours or Session Preparation Hours, select "Don't Summarize" instead of "Count(Distinct)" to obtain correct hour count for sessions.
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.