...
| 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 Title | 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 |
...