| Table of Contents | ||
|---|---|---|
|
...
The template is designed for the self-service creation of Power BI Report development Reports for future Curriculum Mapping reports. Currently the Template can be located in Box and at \\usffs.forest.usf.edu\odrive$\IT-BIA\Projects\PowerBI\Templates by 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 template contains the first tab includes core filters used in all Curriculum Mapping reporting along with a , while the Relationship documentation tab that provides information for the data fields that can be used in a report (which should be deleted . Please delete this tab before a created report is published)shared with others.
Filters
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
| TABLE_NAME | COLUMN_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 | 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 | Content Objective Heading | Content objective heading description. Each heading will have subheadings upto level five | Unknown | Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION |
| Content Objective | Content Heading Objective ID | Appian content objective heading foreign key | -1 | Appian.MCOM_CM_contentObjective.HEADERID |
| Content Objective | Content Objective ID | Appian content objective primary key | (not null) | Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION |
| Course by Academic Year | Course Academic Year | course academic year | UNKN | Appian.CR_REC_courseByAcademicYear.academicYear |
| 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 |
| Course by Academic Year | Course Contact Hours | course contact hours | 0 | Appian.CR_REC_courseByAcademicYear.contactHours |
| Course by Academic Year | Course Description | course description. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.description |
| Course by Academic Year | Course End Date | course end date | 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 by Academic Year | Course is Core Flag | Yes' if the course belongs to either 'Core' or 'Core and SELECT', else 'No' | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
| Course by Academic Year | Course Is Outside Banner Flag | course is outside banner flag. Yes if outsideBanner=1, Else No | No | Appian.CR_REC_courseByAcademicYear.outsideBanner |
| Course by Academic Year | Course is SELECT Flag | Yes' if the course belongs to either 'SELECT' or 'Core and SELECT', else 'No' | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
| Course by Academic Year | Course Location | when location = 1, 'Lehigh Valley' when location = 2, 'Tampa' Else 'Unknown' | Unknown | (derived) Appian.CR_REC_courseByAcademicYear.location |
| Course by Academic Year | Course Med Year | course year number taught in | 0 | Appian.CR_REC_courseByAcademicYear.year |
| Course by Academic Year | Course Number | course number | Unknown | Appian.CR_REC_courseByAcademicYear.courseNumber |
| Course by Academic Year | Course Start Date | course start date | 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 by Academic Year | Course Subject Code | course subject code | Unknown | Appian.CR_REC_courseByAcademicYear.subjectCode |
| Course by Academic Year | Course Title | course title. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.title |
| Course By Academic Program | Course by Academic Year ID | appian course by academic year foreign key | -1 | Appian.CR_REC_courseByAcademicYear.courseAcademicYearId |
Course By Academic 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 |
| Course Objective | Course by Academic Year ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_objectivePair.courseId |
| Course Objective | Course Objective | course objective description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_objectivePair.courseobjective |
| Course Objective | Course Objective ID | appian course objective primary key | (not null) | Appian.MCOM_CM_objectivePair.id |
Keyword Hierarchy | Keyword | ilios term/keyword | Unknown | ILIOS.term.title |
| Keyword Hierarchy | Keyword Description | ilios term/keyword level (not consistently populated). Does not contain a keyword description | Unknown | ILIOS.term.description |
| Keyword Hierarchy | Keyword ID | ilios term/keyword primary key | (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 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 | ilios term/keyword parent key. Keywords have a hierarchy. | -1 | ILIOS.term.parent_term_id |
| Keyword Hierarchy | School ID | school id value looked up from the ilios vocabulary table. | -1 | ILIOS.vocabulary.school_id |
| Keyword Hierarchy | School Title | school description looked up value from the ilios vocabulary table | Unknown | ILIOS.school.title |
| Keyword Hierarchy | Vocabulary ID | ilios vocabulary foreign key. Joins to the ilios vocabulary table. | -1 | ILIOS.term.vocabulary_id |
| Keyword Hierarchy | Vocabulary Title | vocabulary description value looked up from the ilios vocabulary table. | Unknown | ILIOS.vocabulary.title |
| Methods | Method | Description of type of method | Unknown | Appian_MCOM_CM_METHODS.METHOD |
| Methods | Method Code | alphanumeric (e.g IM001) | Unknown | Appian_MCOM_CM_methods.METHOD |
| Methods | Method ID | appian method primary key | (not null) | Appian_MCOM_CM_methods.METHODID |
| Methods | Method Type | Primary Instructional Method; Assessment Method | Unknown | (derived) Appian_MCOM_CM_methods.PRIMARY and Appian_MCOM_CM_methods.METHODTYPE |
| Methods | Method Type Code | IM = Primary Instructional Method; AM = Assessment Method | U | Appian_MCOM_CM_methods.METHODTYPE |
| Methods | Primary Method Flag | Yes for Primary Instructional Method; No for Assessment Method | Unknown | Appian_MCOM_CM_methods.PRIMARY |
| Program Objective Course Objective | Course Objective ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.objectivePairId |
| Program Objective Course Objective | Program Objective ID | appian program objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.programObjectiveId |
| Program Objective | Program Objective Title | program objective title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_programObjective.title |
| Program Objective | Program Objective ID | appian program objective primary key | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
| Session | Course by Academic ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_session.courseid |
| Session | Session | Session title; blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.title |
Session | Session Description | session description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.description |
| Session | Session Duration Hours | session duration hours | 0 | Appian.MCOM_CM_session.duration |
| Session | Session ID | appian session primary key | (not null) | Appian.MCOM_CM_session.id |
| Session | Session Preparation Hours | session preparation hours | 0 | Appian.MCOM_CM_session.preparationHours |
| Session | Session Total Hours | Total hours, combining session duration hours and session preparation hours | 0 | Appian.MCOM_CM_session.totalduration |
| Session Objective Course Objective | Course Objective ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.courseObjectiveId |
| Session Objective Course Objective | Session Objective ID | appian session objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.sessionObjectiveId |
| Session Objective | Session ID | appian session foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePair.sessionid |
| Session Objective | Session Objective | session objective name. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_sessionObjectivePair.sessionobjective |
| Session Objective | Session Objective ID | appian 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.