...
Table Details
| TABLE_NAME | TABLE_TYPE | TABLE_DESCRIPTION | CM_COURSE_BY_ACADEMIC_YEAR | Reporting Table
|---|---|---|---|
| DESCRIPTION | |||
| 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. | ||
| CM_COURSE_OBJECTIVE | Reporting TableCourse Objective | Contains Course Objectives, linked to Courses from the | CMCM_COURSE_BY_ACADEMIC_YEAR table. Table is filtered by Active = 1. |
| CM_COURSEBYACADYEAR_PROGRAM | Derived Reporting TableCourse by Academic Year Program | Contains mapping between course_by_acedemic_year_id and program. Courses linked to both Core and SELECT programs will have two seperate records in the table. This table was created to help report writers with the program button functionality on the report | |
| CM_PROGRAM_OBJ_COURSE_OBJ | Reporting Bridge Table | BridgeProgram Objective Course Objective | Bridge table to handle many to many relationship between program objective and course objective. |
| CM_PROGRAM_OBJECTIVE | Reporting Table | Program Objective | Contains Program Objectives. |
| CM_SESSION | Reporting TableSession | Contains Sessions, linked to Courses from the CM_COURSE_BY_ACADEMIC_YEAR table. Table is filtered by Status = 2 (Completed). | |
| CM_SESSION_OBJ_COURSE_OBJ | Reporting Bridge TableSession Objective Course Objective | Bridge table to handle many to many relationship between session objective and course objective. | |
| CM_SESSION_OBJECTIVE | Reporting Table | 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 |
|---|---|---|---|---|
| CM_COURSE_BY_ACADEMIC_YEARCourse by Academic Year | COURSE_LOCATION | when location = 1, 'Lehigh Valley' when location = 2, 'Tampa' Else 'Unknown' | Unknown | (derived) Appian.CR_REC_courseByAcademicYear.location |
| CM_COURSE_BY_ACADEMIC_YEARCourse by Academic Year | COURSE_IS_CORE | Yes' if the course belongs to either 'Core' or 'Core and SELECT', else 'No' | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
| CM_COURSE_BY_ACADEMIC_YEARCourse by Academic Year | COURSE_IS_SELECT | Yes' if the course belongs to either 'SELECT' or 'Core and SELECT', else 'No' | No | (derived) Appian.CR_REC_courseByAcademicYear.program |
| CM_COURSE_BY_ACADEMIC_YEARCourse by Academic Year | COURSE_ACADEMIC_YEAR | course academic year | UNKN | Appian.CR_REC_courseByAcademicYear.academicYear |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_CONTACT_HOURS | course contact hours | 0 | Appian.CR_REC_courseByAcademicYear.contactHours |
| CM_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 |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_NUMBER | course number | Unknown | Appian.CR_REC_courseByAcademicYear.courseNumber |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_DESCRIPTION | course description. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.description |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_END_DATE | course end date | 2099.12.31 | Appian.CR_REC_courseByAcademicYear.endDate |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_IS_OUTSIDE_BANNER | course is outside banner flag. Yes if outsideBanner=1, Else No | No | Appian.CR_REC_courseByAcademicYear.outsideBanner |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_START_DATE | course start date | 1900.01.01 | Appian.CR_REC_courseByAcademicYear.startdate |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_SUBJECT_CODE | course subject code | Unknown | Appian.CR_REC_courseByAcademicYear.subjectCode |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_TITLE | course title. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.title |
| CM_COURSE_BY_ACADEMIC_YEAR | COURSE_MED_YEAR | course year number taught in | 0 | Appian.CR_REC_courseByAcademicYear.year |
| CM_COURSE_OBJECTIVE | COURSE_BY_ACADEMIC_YEAR_ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_objectivePair.courseId |
| CM_COURSE_OBJECTIVE | COURSE_OBJECTIVE | course objective description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_objectivePair.courseobjective |
| CM_COURSE_OBJECTIVE | COURSE_OBJECTIVE_ID | appian course objective primary key | (not null) | Appian.MCOM_CM_objectivePair.id |
| CM_COURSEBYACADYEAR_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 |
| CM_COURSEBYACADYEAR_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 |
| CM_PROGRAM_OBJECTIVE | PROGRAM_OBJECTIVE_ID | appian program objective primary key | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
| CM_PROGRAM_OBJECTIVE | PROGRAM_OBJECTIVE_TITLE | program objective title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_programObjective.title |
| CM_SESSION | COURSE_BY_ACADEMIC_YEAR_ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_session.courseid |
| CM_SESSION | SESSION_DESCRIPTION | session description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.description |
| CM_SESSION | SESSION_DURATION | session duration | 0 | Appian.MCOM_CM_session.duration |
| CM_SESSION | SESSION_ID | appian session primary key | (not null) | Appian.MCOM_CM_session.id |
| CM_SESSION | SESSION_PREPERATION_HOURS | session preparationHours | 0 | Appian.MCOM_CM_session.preparationHours |
| CM_SESSION | SESSION_TITLE | 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 |
| CM_SESSION_OBJECTIVE | SESSION_OBJECTIVE_ID | appian session objective primary key | (not null) | Appian.MCOM_CM_sessionObjectivePair.id |
| CM_SESSION_OBJECTIVE | SESSION_ID | appian session foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePair.sessionid |
| CM_SESSION_OBJECTIVE | SESSION_OBJECTIVE | session objective name. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_sessionObjectivePair.sessionobjective |
...