...
| TABLE_NAME | COLUMN_NAME | COLUMN_DESCRIPTION | COLUMN_DEFAULT | COLUMN_SOURCE |
|---|---|---|---|---|
| Content Objective | Content Objective | Content objective with number followed by description (e.g. 1.17.8 Predict the changes...) | Unknown | Appian.MCOM_CM_contentObjectives.DESCRIPTION |
| Content Objective | Content Objective Discipline | Content objective discipline Discipline or content area of a given content objective (e.g. Pharmacology, Neuroscience, Biochemistry) | Unknown | Appian.MCOM_CM_REF_disciplineDirector.DESCRIPTION |
| Content Objective | Content Objective Heading | Content objective heading description. Each heading will have subheadings upto level five | Unknown | Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION |
| Content Objective | Content Heading Objective ID | Appian content objective heading foreign key | -1 | Appian.MCOM_CM_contentObjective.HEADERID |
| Content Objective | Content Objective ID | Appian content objective primary key | (not null) | Appian.MCOM_CM_contentObjectiveHeading.DESCRIPTION |
| Course by Academic Year | Course Academic Year | course academic year | UNKN | Appian.CR_REC_courseByAcademicYear.academicYear |
| 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 Contact Hours | course contact hours | 0 | Appian.CR_REC_courseByAcademicYear.contactHours |
| 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 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 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 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 Location | when location = 1, 'Lehigh Valley' when location = 2, 'Tampa' Else 'Unknown' | Unknown | (derived) Appian.CR_REC_courseByAcademicYear.location |
| Course by Academic Year | Course Med Year | course year number taught in | 0 | Appian.CR_REC_courseByAcademicYear.year |
| Course by Academic Year | Course Number | course number | Unknown | Appian.CR_REC_courseByAcademicYear.courseNumber |
| 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 Program | Course by Academic Year ID | appian course by academic year foreign key | -1 | Appian.CR_REC_courseByAcademicYear.courseAcademicYearId |
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 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 |
Keyword Hierarchy | Keyword | |||
| Keyword Hierarchy | Keyword Description | |||
| Keyword Hierarchy | Keyword ID | |||
| Keyword Hierarchy | Keyword ID Level 1 (Level 2, Level 3, Level 4, Leve5) | |||
| Keyword Hierarchy | Keyword Level | |||
| Keyword Hierarchy | Keyword Level 1 (Level 2, Level 3, Level 4, Level 5) | |||
| Keyword Hierarchy | Keyword Level Hierarchy | |||
| Keyword Hierarchy | Parent Keyword ID | |||
| Keyword Hierarchy | School ID | |||
| Keyword Hierarchy | School Title | |||
| Keyword Hierarchy | Vocabulary ID | |||
| Keyword Hierarchy | Vocabulary Title | |||
| Methods | Method | Description of type of method | ||
| Methods | Method Code | alphanumeric (e.g IM001 | ||
| Methods | Method ID | appian method primary key | ||
| Methods | Method Type | Primary Instructional Method; Assessment Method | ||
| Methods | Method Type Code | IM = Primary Instructional Method; AM = Assessment Method | ||
| Methods | Primary Method Flag | Yes for Primary Instructional Method; No for Assessment Method | ||
| Program Objective Course Objective | Course Objective ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.objectivePairId |
| Program Objective Course Objective | Program Objective ID | appian program objective foreign key | (not null) | Appian.MCOM_CM_objectivePairProgramObjectiveJoin.programObjectiveId |
| Program Objective | Program Objective Title | program objective title. blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_programObjective.title |
| Program Objective | Program Objective ID | appian program objective primary key | (not null) | Appian.MCOM_CM_programObjective.programObjectiveId |
| Session | Course by Academic ID | appian foreign key for Course By Academic Year | (not null) | Appian.MCOM_CM_session.courseid |
| Session | Session | Session title; blanks ltrimed and rtrimed | Unknown | Appian.MCOM_CM_session.title |
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 Total Hours | Total hours, combining session duration hours and session preparation hours | 0 | Appian.MCOM_CM_session.totalduration |
| Session Objective Course Objective | Course Objective ID | appian course objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.courseObjectiveId |
| Session Objective Course Objective | Session Objective ID | appian session objective foreign key | (not null) | Appian.MCOM_CM_sessionObjectivePairCourseObjectiveJoin.sessionObjectiveId |
| 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 |
| Session Objective | Session Objective ID | appian session objective primary key | (not null) | Appian.MCOM_CM_sessionObjectivePair.id |
...