...
The template is designed for the creation of Power BI Report development 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 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 a Relationship documentation tab that provides information for the data fields that can be used in a report (which should be deleted before a created report is published).
...
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Table Details
Tables and description in grey italics 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).
| 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_NAME | COLUMN_NAME | COLUMN_DESCRIPTION | COLUMN_DEFAULT | COLUMN_SOURCE |
|---|---|---|---|---|
| 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 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 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 Academic Year | course academic year | UNKN | Appian.CR_REC_courseByAcademicYear.academicYear |
| Course by Academic Year | Course Contact Hours | course contact hours | 0 | Appian.CR_REC_courseByAcademicYear.contactHours |
| 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 Number | course number | Unknown | Appian.CR_REC_courseByAcademicYear.courseNumber |
| 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 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 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 Year | Course Med Year | course year number taught in | 0 | Appian.CR_REC_courseByAcademicYear.year |
| 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 |
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 By Academic 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 |
| Program Objective | Program Objective ID | appian program objective primary key | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
| Program Objective | Program Objective Title | program objective title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_programObjective.title |
| Session | Course by Academic ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_session.courseid |
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 | 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 |
| Session Objective | Session Objective ID | appian session objective primary key | (not null) | Appian.MCOM_CM_sessionObjectivePair.id |
| 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 |
...