Table of Contents | ||
---|---|---|
|
...
COLUMN NAME | TABLE NAME | COLUMN DESCRIPTION | COLUMN DEFAULT | COLUMN SOURCE |
---|---|---|---|---|
Content Objective | Content Objective | Content objective with number followed by description (e.g. 1.17.8 Predict the changes...) | Unknown | Appian.MCOM_CM_contentObjectives.DESCRIPTION |
Content Objective Discipline | Content Objective | Discipline or content area of a given content objective (e.g. Pharmacology, Neuroscience, Biochemistry) | Unknown | Appian.MCOM_CM_REF_disciplineDirector.DESCRIPTION |
Content Objective Heading | Content Objective | Content objective heading description. Each heading will have subheadings up to level five. | Unknown | Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION |
Content Heading Objective ID | Content Objective | Archivum content objective heading foreign key. | -1 | Appian.MCOM_CM_contentObjective.HEADERID |
Content Objective ID | Content Objective | Archivum content objective unique identifier. | (not null) | Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION |
Course Academic Year | Course by Academic Year | Academic year for the course, where the year is the year the academic year began. | UNKN | Appian.CR_REC_courseByAcademicYear.academicYear |
Course by Academic Year ID | Course by Academic Year | Archivum composite primary key for Course By Academic Year | (not null) | Appian.CR_REC_courseByAcademicYear.courseAcademicYearId |
Course Contact Hours | Course by Academic Year | Course contact hours, pulled from Health Banner into Archivum | 0 | Appian.CR_REC_courseByAcademicYear.contactHours |
Course Description | Course by Academic Year | Course description as entered by course director/coordinator in Archivum | Unknown | Appian.CR_REC_courseByAcademicYear.description |
Course End Date | Course by Academic Year | Course end date as pulled from Health Banner into Archivum. | Date in Power BI will display with Day, Month, Year, and Quarter which can be removed in a table | Appian.CR_REC_courseByAcademicYear.endDate |
Course is Core Flag | Course by Academic Year | Yes if the course belongs to either Core or Core and SELECT, else No as entered into Archivum. | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
Course Is Outside Banner Flag | Course by Academic Year | Course is outside Health Banner flag. Yes if the course is not contained in Health Banner, Else No. | No | Appian.CR_REC_courseByAcademicYear.outsideBanner |
Course is SELECT Flag | Course by Academic Year | Yes if the course belongs to either SELECT or Core and SELECT, else No as entered into Archivum. | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
Course Location | Course by Academic Year | Location as entered in Archivum; Lehigh Valley or Tampa. | Unknown | (derived) Appian.CR_REC_courseByAcademicYear.location |
Course Med Year | Course by Academic Year | Course med year number taught in as entered in Archivum by course director/coordinator. | 0 | Appian.CR_REC_courseByAcademicYear.year |
Course Number | Course by Academic Year | Course number as pulled from Health Banner into Archivum | Unknown | Appian.CR_REC_courseByAcademicYear.courseNumber |
Course Start Date | Course by Academic Year | Course start date as pulled from Health Banner into Archivum. | Date in Power BI will display with Day, Month, Year, and Quarter which can be removed in a table | Appian.CR_REC_courseByAcademicYear.startdate |
Course Subject Code | Course by Academic Year | Course subject code as pulled from Health Banner into Archivum. | Unknown | Appian.CR_REC_courseByAcademicYear.subjectCode |
Course Title | Course by Academic Year | Course title as pulled from Health Banner into Archivum. | Unknown | Appian.CR_REC_courseByAcademicYear.title |
Course by Academic Year ID | Course By Academic Program | Archivum course by academic year foreign key | -1 | Appian.CR_REC_courseByAcademicYear.courseAcademicYearId |
Curriculum Program | Course By Academic Program | Can be 'Core' or 'SELECT'. If a course is taught to 'Core' and 'SELECT', there are separate records for each curriculum program/course combination. | -1 | (derived) Appian.CR_REC_courseByAcademicYear.program |
Course by Academic Year ID | Course Objective | Archivum foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_objectivePair.courseId |
Course Objective | Course Objective | Course objective description as entered in Archivum by course director/coordinator. | Unknown | Appian.MCOM_CM_objectivePair.courseobjective |
Course Objective ID | Course Objective | Archivum course objective unique identifier. | (not null) | Appian.MCOM_CM_objectivePair.id |
EPA Description | EPA | Description of EPA (exteral professional activity) (e.g. Gather a history and perform a physical examination). | text | Appian.MCOM_CM_objectivePair.epadescription |
EPA ID | EPA | Archivum course objective unique identifier. | (not null) | Appian.MCOM_CM_objectivePair.epaid |
EPA Title | EPA | Identifier for EPAs, (e.g. EPA 1, EPA 2, SEL EPA 1, SEL EPA 2)/ | text | Appian.MCOM_CM_EPA.epa_title |
Keyword | Keyword Hierarchy | Ilios term/keyword | Unknown | ILIOS.term.title |
Keyword Description | Keyword Hierarchy | Ilios term/keyword level (not consistently populated). Does not contain a keyword description. | Unknown | ILIOS.term.description |
Keyword ID | Keyword Hierarchy | Ilios term/keyword unique identifier | (not null) | ILIOS.term.term_id |
Keyword ID Level 1 (Level 2, Level 3, Level 4, Leve5) | Keyword Hierarchy | |||
Keyword Level | Keyword Hierarchy | Keyword hierarchy level | -1 | (derived) ILIOS.term.term_id, ILIOS.term.parent_term.id |
Keyword Level 1 (Level 2, Level 3, Level 4, Level 5) | Keyword Hierarchy | |||
Keyword Level Hierarchy | Keyword Hierarchy | |||
Parent Keyword ID | Keyword Hierarchy | Ilios term/keyword parent key. Keywords have a hierarchy. | -1 | ILIOS.term.parent_term_id |
School ID | Keyword Hierarchy | School unique identifier value from Ilios. | -1 | ILIOS.vocabulary.school_id |
School Title | Keyword Hierarchy | School description from Ilios. | Unknown | ILIOS.school.title |
Vocabulary ID | Keyword Hierarchy | Ilios vocabulary unique identifier. Joins to the Ilios vocabulary table. | -1 | ILIOS.term.vocabulary_id |
Vocabulary Title | Keyword Hierarchy | Vocabulary description value from Ilios. | Unknown | ILIOS.vocabulary.title |
Method | Methods | Description of type of method | Unknown | Appian_MCOM_CM_METHODS.METHOD |
Method Code | Methods | Alphanumeric as determined by Ilios (e.g IM001) | Unknown | Appian_MCOM_CM_methods.METHOD |
Method ID | Methods | Archivum method unique identifier | (not null) | Appian_MCOM_CM_methods.METHODID |
Method Type | Methods | Primary Instructional Method; Assessment Method | Unknown | (derived) Appian_MCOM_CM_methods.PRIMARY and Appian_MCOM_CM_methods.METHODTYPE |
Method Type Code | Methods | IM = Primary Instructional Method; AM = Assessment Method | U | Appian_MCOM_CM_methods.METHODTYPE |
Primary Method Flag | Methods | Yes for Primary Instructional Method; No for Assessment Method | Unknown | Appian_MCOM_CM_methods.PRIMARY |
Course Objective ID | Program Objective Course Objective | Archivum course objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.objectivePairId |
Program Objective ID | Program Objective Course Objective | Archivum program objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.programObjectiveId |
Program Objective Title | Program Objective | Program objective title | Unknown | Appian.MCOM_CM_programObjective.title |
Program Objective ID | Program Objective | Archivum program objective unique identifier | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
Course by Academic ID | Session | Archivum Course By Academic Year unique identifier | (not null) | Appian.MCOM_CM_session.courseid |
Session | Session | Session title as entered in Archivum by course director/coordinator | Unknown | Appian.MCOM_CM_session.title |
Session Description | Session | Session description as entered in Archivum by course director/coordinator | Unknown | Appian.MCOM_CM_session.description |
Session Duration Hours | Session | Session duration hours as entered in Archivum by course director/coordinator | 0 | Appian.MCOM_CM_session.duration |
Session ID | Session | Archivum session unique identifier | (not null) | Appian.MCOM_CM_session.id |
Session Preparation Hours | Session | Session student preparation hours as entered in Archivum by course director/coordinator | 0 | Appian.MCOM_CM_session.preparationHours |
Session Total Hours | Session | Total hours, combining session duration hours and session preparation hours | 0 | Appian.MCOM_CM_session.totalduration |
Course Objective ID | Session Objective Course Objective | Archivum course objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.courseObjectiveId |
Session Objective ID | Session Objective Course Objective | Archivum session objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.sessionObjectiveId |
Session ID | Session Objective | Archivum session unique identifier | (not null) | Appian.MCOM_CM_sessionObjectivePair.sessionid |
Session Objective | Session Objective | Session objective name as entered in Archivum by course director/coordinator | Unknown | Appian.MCOM_CM_sessionObjectivePair.sessionobjective |
Session Objective ID | Session Objective | Archivum session objective primary key | (not null) | Appian.MCOM_CM_sessionObjectivePair.id |
...
- 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.