...
| TABLE_NAME | COLUMN_NAME | COLUMN_DESCRIPTION | COLUMN_DEFAULT | COLUMN_SOURCE |
|---|---|---|---|---|
| Course by Academic Year | COURSE_LOCATIONCourse 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_CORECourse 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_SELECTCourse 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_YEARCourse Academic Year | course academic year | UNKN | Appian.CR_REC_courseByAcademicYear.academicYear |
| Course by Academic Year | COURSE_CONTACT_HOURS Course Contact Hours | course contact hours | 0 | Appian.CR_REC_courseByAcademicYear.contactHours |
| Course by Academic Year | 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_NUMBERCourse Number | course number | Unknown | Appian.CR_REC_courseByAcademicYear.courseNumber |
| Course by Academic Year | COURSE_DESCRIPTIONCourse Description | course description. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.description |
| Course by Academic Year | COURSE_END_DATECourse End Date | course end date | 2099.12.31Date 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 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_DATECourse Start Date | course start date | 1900.01.01Date 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_CODECourse Subject Code | course subject code | Unknown | Appian.CR_REC_courseByAcademicYear.subjectCode |
| Course by Academic Year | COURSE_TITLECourse Title | course title. blanks ltrimed and rtrimed | Unknown | Appian.CR_REC_courseByAcademicYear.title |
| Course by Academic Year | COURSE_MED_YEARCourse Med Year | course year number taught in | 0 | Appian.CR_REC_courseByAcademicYear.year |
| Course Objective | COURSE_BY_ACADEMIC_YEAR_Course by Academic Year ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_objectivePair.courseId |
| Course Objective | COURSE_OBJECTIVECourse Objective | course objective description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_objectivePair.courseobjective |
| Course Objective | COURSE_OBJECTIVE_Course Objective ID | appian course objective primary key | (not null) | Appian.MCOM_CM_objectivePair.id |
Course By Academic Program | CURRICULUM_PROGRAMCurriculum 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_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_Course Objective ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.objectivePairId |
| CM_PROGRAM_OBJ_COURSE_OBJ | PROGRAM_OBJECTIVE_Program Objective ID | appian program objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.programObjectiveId |
| Program Objective | PROGRAM_OBJECTIVE_Program Objective ID | appian program objective primary key | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
| Program Objective | PROGRAM_OBJECTIVE_TITLEProgram Objective Title | program objective title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_programObjective.title |
| Session | COURSE_BY_ACADEMIC_YEAR_Course by Academic ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_session.courseid |
Session | SESSION_DESCRIPTIONSession Description | session description. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.description |
| Session | SESSION_DURATIONSession Duration Hours | session duration hours | 0 | Appian.MCOM_CM_session.duration |
| Session | SESSION_Session ID | appian session primary key | (not null) | Appian.MCOM_CM_session.id |
| Session | SESSION_PREPERATION_HOURSSession Preparation Hours | session preparationHourspreparation hours | 0 | Appian.MCOM_CM_session.preparationHours |
| Session | SESSION_TITLESession Title | session title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.title |
| CM_SESSION_OBJ_COURSE_OBJ | COURSE_OBJECTIVE_Course Objective ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.courseObjectiveId |
| CM_SESSION_OBJ_COURSE_OBJ | SESSION_OBJECTIVE_Session Objective ID | appian session objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.sessionObjectiveId |
| Session Objective | SESSION_OBJECTIVE_Session Objective ID | appian session objective primary key | (not null) | Appian.MCOM_CM_sessionObjectivePair.id |
| Session Objective | SESSION_Session ID | appian session foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePair.sessionid |
| Session Objective | SESSION_OBJECTIVESession Objective | session objective name. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_sessionObjectivePair.sessionobjective |
...