Page Comparison

Table of Contents

maxLevel	3

...

The template is designed for the self-service creation of Power BI Reports for Curriculum Mapping. Currently the "Self-Service Curriculum Mapping Template" is accessible once given access to the Box folder 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 first tab includes core filters used in all Curriculum Mapping reporting, while the Relationship documentation tab provides information for the data fields that can be used in a report. Please delete this tab before a report is shared with others.

...

Tables and description in grey italics are not displayed in 'FIELDS' in PowerBI template, however, table can be made to be visible in 'Relationships' by right-clicking on grey table (tables in lighter grey are currently visible under FIELDS).

...

the Power BI template. There is no additional data in those tables except how items are mapped to one another.

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.
Keyword Hierarchy	Contains Keyword information for keyword search.
Methods	Contains method information, 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.

Column Details

TABLE_

COLUMN NAME

COLUMN_

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

	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

Heading

Content objective heading description. Each heading will have subheadings

upto

up to level five.	Unknown	Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION
Content Heading Objective ID	Content

Heading

Objective

ID

Appian

Archivum content objective heading foreign key.	-1	Appian.MCOM_CM_contentObjective.HEADERID
Content Objective ID	Content Objective

ID

Appian

Archivum content objective

primary key

unique identifier.	(not null)	Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION
Course

by

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

ID

appian

Archivum composite

primay

primary key for Course By Academic Year	(not null)	Appian.CR_REC_courseByAcademicYear.courseAcademicYearId
Course Contact Hours	Course by Academic Year	Course

Contact Hourscourse

contact hours, pulled from Health Banner into Archivum	0	Appian.CR_REC_courseByAcademicYear.contactHours
Course Description	Course by Academic Year	Course

Descriptioncourse description. blanks ltrimed and rtrimed

description as entered by course director/coordinator in Archivum	Unknown	Appian.CR_REC_courseByAcademicYear.description
Course End Date	Course by Academic Year	Course

End Datecourse

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

Course is Core Flag

Yes

'

if the course belongs to either

'

Core

'

or

'

Core and SELECT

'

, else

'No'

No as entered into Archivum.

No

(derived) Appian.CR_REC_courseByAcademicYear.program

Course Is Outside Banner Flag

Course by Academic Year

Course

Is Outside Banner Flagcourse

is outside

banner

Health Banner flag. Yes if

outsideBanner=1

the course is not contained in Health Banner, Else No.	No	Appian.CR_REC_courseByAcademicYear.outsideBanner
Course is SELECT Flag	Course by Academic Year

Course is SELECT Flag

Yes

'

if the course belongs to either

'

SELECT

'

or

'

Core and SELECT

'

, else

'No'

No as entered into Archivum.	No	(derived) Appian.CR_REC_courseByAcademicYear.program
Course Location	Course by Academic Year

Course Locationwhen location = 1, '

Location as entered in Archivum; Lehigh Valley

'
when location = 2, 'Tampa'
Else 'Unknown'

or Tampa.	Unknown	(derived) Appian.CR_REC_courseByAcademicYear.location
Course Med Year	Course by Academic Year	Course

Med Yearcourse

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

Numbercourse number

number as pulled from Health Banner into Archivum	Unknown	Appian.CR_REC_courseByAcademicYear.courseNumber
Course Start Date	Course by Academic Year	Course

Start Datecourse

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 Codecourse

subject code as pulled from Health Banner into Archivum.	Unknown	Appian.CR_REC_courseByAcademicYear.subjectCode
Course Title	Course by Academic Year	Course

Titlecourse title. blanks ltrimed and rtrimed

title as pulled from Health Banner into Archivum.	Unknown	Appian.CR_REC_courseByAcademicYear.title
Course

By

by Academic

Program

Year ID

Course

by

By Academic

Year ID

Program

appian

Archivum course by academic year foreign key	-1	Appian.CR_REC_courseByAcademicYear.courseAcademicYearId
Curriculum Program	Course By Academic

ProgramCurriculum

Program

Can be 'Core' or 'SELECT'. If

program is 1 then both

a course is taught to 'Core' and 'SELECT'

(

, there are separate records

). If program is 2 then 'Core'. If program is 3 then 'SELECT'

for each curriculum program/course combination.

-1

(derived) Appian.CR_REC_courseByAcademicYear.program

Course Objective


Course by Academic Year ID	Course Objective

appian

Archivum foreign key for Course By Academic Year	(not null)	Appian.MCOM_CM_objectivePair.courseId
Course Objective	Course Objective

course

Course objective description

. blanks ltrimed and rtrimed

as entered in Archivum by course director/coordinator.	Unknown	Appian.MCOM_CM_objectivePair.courseobjective
Course Objective ID	Course Objective

ID

appian

Archivum course objective

primary key

unique identifier.	(not null)	Appian.MCOM_CM_objectivePair.id
Keyword

Hierarchy

Keyword Hierarchy

ilios

Ilios term/keyword	Unknown	ILIOS.term.title
Keyword

Hierarchy

Description

Keyword

Description

Hierarchy

ilios

Ilios term/keyword level (not consistently populated). Does not contain a keyword description.	Unknown	ILIOS.term.description
Keyword

Hierarchy

ID

Keyword

ID

Hierarchy

ilios

Ilios term/keyword

primary key

unique identifier

(not null)

ILIOS.term.term_id

Keyword Hierarchy


Keyword ID Level 1 (Level 2, Level 3, Level 4, Leve5)	Keyword Hierarchy
Keyword Level	Keyword Hierarchy

keyword

Keyword hierarchy level

-1

(derived) ILIOS.term.term_id, ILIOS.term.parent_term.id

Keyword Hierarchy


Keyword Level 1 (Level 2, Level 3, Level 4, Level 5)	Keyword Hierarchy
Keyword Level Hierarchy	Keyword Hierarchy
Parent Keyword ID	Keyword Hierarchy

ilios

Ilios term/keyword parent key. Keywords have a hierarchy.	-1	ILIOS.term.parent_term_id
School ID	Keyword Hierarchy	School

IDschool id value looked up from the ilios vocabulary table

unique identifier value from Ilios.	-1	ILIOS.vocabulary.school_id
School Title	Keyword Hierarchy	School

Titleschool

description

looked up value from the ilios vocabulary tableilios vocabulary foreign key

from Ilios.	Unknown	ILIOS.school.title
Vocabulary ID	Keyword Hierarchy

Vocabulary ID

Ilios vocabulary unique identifier. Joins to the

ilios

Ilios vocabulary table.	-1	ILIOS.term.vocabulary_id
Vocabulary Title	Keyword Hierarchy	Vocabulary

Titlevocabulary

description value

looked up from the ilios vocabulary table

from Ilios.	Unknown	ILIOS.vocabulary.title
Method	Methods

Method

Description of type of method

Unknown

Appian_MCOM_CM_METHODS.METHOD

Methods

Method Code

alphanumeric

Methods

Alphanumeric as determined by Ilios (e.g IM001)

Unknown

Appian_MCOM_CM_methods.METHOD

Methods

Method ID

Methods

appian

Archivum method

primary key

unique identifier

(not null)

Appian_MCOM_CM_methods.METHODID

Methods


Method Type	Methods	Primary Instructional Method; Assessment Method	Unknown	(derived) Appian_MCOM_CM_methods.PRIMARY and Appian_MCOM_CM_methods.METHODTYPE

Methods


Method Type Code	Methods	IM = Primary Instructional Method; AM = Assessment Method	U	Appian_MCOM_CM_methods.METHODTYPE

Methods


Primary Method Flag	Methods	Yes for Primary Instructional Method; No for Assessment Method	Unknown	Appian_MCOM_CM_methods.PRIMARY

Program Objective

Course Objective ID

Program Objective Course Objective

ID

appian

Archivum course objective foreign key	(not null)	Appian.MCOM_CM_objectivePairProgramObjectiveJoin.objectivePairId
Program Objective

Course Objective

ID	Program Objective Course Objective

ID

appian

Archivum program objective foreign key	(not null)	Appian.MCOM_CM_objectivePairProgramObjectiveJoin.programObjectiveId
Program Objective Title	Program Objective

Title

program

Program objective title

. blanks ltrimed and rtrimed

	Unknown	Appian.MCOM_CM_programObjective.title
Program Objective ID	Program Objective

ID

appian

Archivum program objective

primary key

unique identifier

(not null)

Appian.MCOM_CM_programObjective.programObjectiveId

Session

Course by Academic ID

appian foreign key for

	Session	Archivum Course By Academic Year unique identifier	(not null)	Appian.MCOM_CM_session.courseid
Session	Session	Session title

; blanks ltrimed and rtrimed

as entered in Archivum by course director/coordinator	Unknown	Appian.MCOM_CM_session.title
Session Description	Session

Description

session description. blanks ltrimed and rtrimed

Session description as entered in Archivum by course director/coordinator	Unknown	Appian.MCOM_CM_session.description
Session Duration Hours	Session

Duration Hours

session

Session duration hours as entered in Archivum by course director/coordinator	0	Appian.MCOM_CM_session.duration
Session ID	Session

ID

appian

Archivum session

primary key

unique identifier	(not null)	Appian.MCOM_CM_session.id
Session Preparation Hours	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

Total hours, combining session duration hours and session preparation hours

0

Appian.MCOM_CM_session.totalduration

Session Objective

Course Objective ID

Session Objective Course Objective

ID

appian

Archivum course objective foreign key	(not null)	Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.courseObjectiveId
Session Objective

Course Objective

ID	Session Objective

ID

Course Objective

appian

Archivum session objective foreign key	(not null)	Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.sessionObjectiveId
Session

Objective

ID

Session

ID

Objective

appian

Archivum session

foreign key

unique identifier	(not null)	Appian.MCOM_CM_sessionObjectivePair.sessionid
Session Objective	Session Objective

session

Session objective name

. blanks ltrimed and rtrimed

as entered in Archivum by course director/coordinator	Unknown	Appian.MCOM_CM_sessionObjectivePair.sessionobjective
Session Objective ID	Session Objective

ID

appian

Archivum session objective primary key

(not null)

Appian.MCOM_CM_sessionObjectivePair.id

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.

Versions Compared

Old Version 28

New Version 29

Key

Column Details

Data Refreshed On

Disclaimer