...
| 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. |
| 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. |
...
| 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 | 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 | 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 | 2099.12.31 | Appian.CR_REC_courseByAcademicYear.endDate |
| 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 |
| Course by Academic Year | COURSE_START_DATE | course start date | 1900.01.01 | Appian.CR_REC_courseByAcademicYear.startdate |
| CM_COURSE_BY_ACADEMIC_YEARCourse by Academic Year | COURSE_SUBJECT_CODE | course subject code | Unknown | Appian.CR_REC_courseByAcademicYear.subjectCode |
| CM_COURSE_BY_ACADEMIC_YEARCourse by Academic Year | COURSE_TITLE | course title. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.title |
| CM_COURSE_BY_ACADEMIC_YEARCourse by Academic Year | COURSE_MED_YEAR | course year number taught in | 0 | Appian.CR_REC_courseByAcademicYear.year |
| CM_COURSE_OBJECTIVECourse Objective | COURSE_BY_ACADEMIC_YEAR_ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_objectivePair.courseId |
| CM_COURSE_OBJECTIVECourse Objective | COURSE_OBJECTIVE | course objective description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_objectivePair.courseobjective |
| CM_COURSE_OBJECTIVECourse Objective | COURSE_OBJECTIVE_ID | appian course objective primary key | (not null) | Appian.MCOM_CM_objectivePair.id |
| CM_COURSEBYACADYEAR_PROGRAM 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 |
| CM_COURSEBYACADYEAR_PROGRAMCourse 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 |
| CM_PROGRAM_OBJECTIVEProgram Objective | PROGRAM_OBJECTIVE_ID | appian program objective primary key | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
| CM_PROGRAM_OBJECTIVEProgram Objective | PROGRAM_OBJECTIVE_TITLE | program objective title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_programObjective.title |
| CM_SESSIONSession | COURSE_BY_ACADEMIC_YEAR_ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_session.courseid |
| CM_SESSION Session | SESSION_DESCRIPTION | session description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.description |
| CM_SESSIONSession | SESSION_DURATION | session duration | 0 | Appian.MCOM_CM_session.duration |
| CM_SESSIONSession | SESSION_ID | appian session primary key | (not null) | Appian.MCOM_CM_session.id |
| CM_SESSIONSession | SESSION_PREPERATION_HOURS | session preparationHours | 0 | Appian.MCOM_CM_session.preparationHours |
| CM_SESSIONSession | 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_OBJECTIVESession Objective | SESSION_OBJECTIVE_ID | appian session objective primary key | (not null) | Appian.MCOM_CM_sessionObjectivePair.id |
| CM_SESSION_OBJECTIVESession Objective | SESSION_ID | appian session foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePair.sessionid |
| CM_SESSION_OBJECTIVESession Objective | SESSION_OBJECTIVE | session objective name. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_sessionObjectivePair.sessionobjective |
...