Reporting View Target: STUDENT_COURSE

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Beardata Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: STUDENT_COURSE_MV

Recommended Search Columns FINAL_GRADE, ACADEMIC_PERIOD
PERSON_UID, COURSE_REFERENCE_NUMBER
ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD
PERSON_UID
COURSE_IDENTIFICATION
REPEAT_COURSE_IND
PERSON_UID, COURSE_IDENTIFICATION
REGISTRATION_STATUS, ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD Academic period or time frame associated with this course record. VARCHAR2(65)

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(28)

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(65)

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(26)

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(123)

CAMPUS Campus the student attended this schedule offering or section. VARCHAR2(62)

CAMPUS_DESC Institution campus name. VARCHAR2(24)

CAMPUS_RESTRICT_OVERRIDE_IND VARCHAR2()

CAPACITY_OVERRIDE_IND VARCHAR2()

CHARGES_WAIVED_IND VARCHAR2()

CLASS_RESTRICT_OVERRIDE_IND VARCHAR2()

COLLEGE College, faculty or school to which the course instructional responsibility is associated. VARCHAR2(90)

COLLEGE_DESC College, faculty or school name. VARCHAR2(32)

COLLEGE_RESTRICT_OVERRIDE_IND VARCHAR2()

COREQUISITE_OVERRIDE_IND VARCHAR2()

COUNT_IN_GPA_IND Indicates whether this course should be used in the calculation of the GPA. VARCHAR2(75)

COURSE_ATTEMPTED_IND VARCHAR2()

COURSE_ATTRIBUTES_COUNT VARCHAR2()

COURSE_BILLING_CREDITS Billing units associated with this section or schedule offering. VARCHAR2(64)

COURSE_BILLING_HOLD Identifies the number of billing units that are being held for potential reinstatement. VARCHAR2(87)

COURSE_CREDITS Credits associated with this course. VARCHAR2(36)

COURSE_CREDITS_HOLD Identifies the number of credits that are being held for potential reinstatement. VARCHAR2(81)

COURSE_EARNED_IND VARCHAR2()

COURSE_FAILED_IND VARCHAR2()

COURSE_IDENTIFICATION Combined subject code and course number that identifies the instructional content of this course. VARCHAR2(97)

COURSE_LEVEL Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc. VARCHAR2(100)

COURSE_LEVEL_DESC Course level description. VARCHAR2(25)

COURSE_NUMBER Course number associated with the subject for the course. VARCHAR2(57)

COURSE_PASSED_IND VARCHAR2()

COURSE_REFERENCE_NUMBER Computer assigned internal unique number for the schedule offering. VARCHAR2(67)

COURSE_REGISTER_IND VARCHAR2()

COURSE_SECTION_NUMBER Sequence number used to associated the information about the unique course for the student. VARCHAR2(91)

COURSE_TITLE_LONG Long title for the course. VARCHAR2(26)

COURSE_TITLE_SHORT Short title for the course. VARCHAR2(27)

COURSE_VERSION Course version number. VARCHAR2(22)

CREDITS_ATTEMPTED Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted. VARCHAR2(153)

CREDITS_EARNED Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. VARCHAR2(162)

CREDITS_FOR_GPA Credits used in the calculation of the average or GPA based on the rules of the institution. VARCHAR2(92)

CREDITS_PASSED Credits passed as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. VARCHAR2(162)

CREDIT_FOR_GPA_IND VARCHAR2()

DEGREE_RESTRICT_OVERRIDE_IND VARCHAR2()

DEPARTMENT Department responsible for the instructional delivery of this offering. VARCHAR2(71)

DEPARTMENT_DESC Department name. VARCHAR2(16)

DEPARTMENT_RESTRICT_OVER_IND VARCHAR2()

DIVISION Division responsible for the instructional delivery of this course or section. VARCHAR2(78)

DIVISION_DESC Name of the division. VARCHAR2(21)

DUPLICATE_COURSE_OVERRIDE_IND VARCHAR2()

EFF_ACADEMIC_PERIOD_OF_GRADE Earliest academic period for which grade is used. VARCHAR2(49)

END_DATE Date the student completes the coursework in the section. This is either recorded for the individual student in the course or taken from the overall section end date. VARCHAR2(166)

EXTENSIONS Number of extensions granted for the student to complete the required work for this section. VARCHAR2(92)

FINALIZED_COMPLETION_DATE Date a student completed their study for this subject or course. This might be the final completion date for an open learning course or it might be the end date from the sub academic period end date associated with a section. VARCHAR2(225)

FINAL_GRADE Final grade earned by the student for this course. VARCHAR2(50)

FINAL_GRADE_DATE Date associated with this grade. VARCHAR2(32)

FINAL_GRADE_ROLL_IND Indicates whether the final grade has been rolled to the history tables where applicable. VARCHAR2(89)

GRADABLE_IND Indicates whether the course can be graded. VARCHAR2(43)

GRADE_CHANGE_COUNT VARCHAR2()

GRADE_CHANGE_REASON Institution defined grade change reason associated with this grade for this course. VARCHAR2(83)

GRADE_CHANGE_REASON_DESC Grade change reason description. VARCHAR2(32)

GRADE_COMMENT VARCHAR2()

GRADE_COMMENT_DESC VARCHAR2()

GRADE_TYPE Grade mode associated with this CRN. VARCHAR2(36)

GRADE_TYPE_DESC Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code. VARCHAR2(97)

GRADE_VALUE Numeric value assigned to a grade symbol to be used to measure course performance statistics. This willl only be present if a final grade has been recorded for either in progress or grades rolled to history for the student course. VARCHAR2(230)

HOURS_ATTENDED Number of hours the student attended this class. VARCHAR2(48)

ID Person's identification number used to access the records associated with the person. VARCHAR2(85)

INCOMPLETE_EXT_DATE Specifies the latest date the student has to complete any missing course work before they are assigned an incomplete grade for the course. VARCHAR2(138)

INCOMPLETE_GRADE_IND VARCHAR2()

INSTITUTION_COURSE_IND Indicates whether the subject or course was taken at this institution. VARCHAR2(70)

INSTRUCTION_METHOD Instructional method used for the section. VARCHAR2(42)

INSTRUCTION_METHOD_DESC Instructional method description associated with the course. VARCHAR2(60)

IN_PROGRESS_COURSE_IND Indicates whether the course is in progress and not yet graded. VARCHAR2(63)

LAST_ATTEND_DATE Identifies the date on which the instruction ended. VARCHAR2(51)

LAST_DATE_ATTEND_REQUIRED_IND VARCHAR2()

LEVEL_RESTRICT_OVERRIDE_IND VARCHAR2()

LINK_OVERRIDE_IND VARCHAR2()

MAJOR_RESTRICT_OVERRIDE_IND VARCHAR2()

MID_TERM_GRADE Mid-term grade code associated with this CRN. VARCHAR2(45)

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(103)

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(94)

MUTUTAL_EXCLUSION_OVERRIDE_IND VARCHAR2()

NAME Combination of the person's last, first, and middle initial into one value. VARCHAR2(75)

PERSON_UID System generated, unique, internal identification number assigned to this person. VARCHAR2(81)

PREREQUISITE_OVERRIDE_IND VARCHAR2()

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(118)

PROGRAM_RESTRICT_OVERRIDE_IND VARCHAR2()

QUALITY_POINTS Quality points associated with the grade. VARCHAR2(41)

REGISTER_CENSUS_DATE1_IND VARCHAR2()

REGISTER_CENSUS_DATE2_IND VARCHAR2()

REGISTRATION_ERROR_FLAG Indicates an error is associated with this section registration. VARCHAR2(64)

REGISTRATION_OVERRIDE_IND VARCHAR2()

REGISTRATION_SEQUENCE_NUMBER Sequence number system assigned to the student registration in the section. VARCHAR2(75)

REGISTRATION_STATUS Course registration status associated with this section. VARCHAR2(56)

REGISTRATION_STATUS_DATE Date associated with the course registration status of this section. VARCHAR2(68)

REGISTRATION_STATUS_DESC Course registration status description. VARCHAR2(39)

REGISTRATION_USER_ID Person user identification number who processed the registration request for this section. VARCHAR2(90)

REPEAT_COURSE_CREDIT_OVER_IND VARCHAR2()

REPEAT_COURSE_IND Identifies this course appears in more than one academic period for the student. Valid values in this data include 'E' exclude in any calculations, 'I' include in all calculations, or 'A' average in all calculations. VARCHAR2(217)

REPEAT_COURSE_OVERRIDE_IND VARCHAR2()

REPEAT_EVALUATE_IND VARCHAR2()

SCHEDULE_TYPE Instructional method or delivery type associated with the course. VARCHAR2(65)

SCHEDULE_TYPE_DESC Schedule type description. VARCHAR2(26)

SECTION_ADD_DATE Date the student registered in this section. VARCHAR2(44)

SPECIAL_APPROVAL_IND Indicates whether special approval was received to register in this section. VARCHAR2(76)

SPECIAL_APPROVAL_OVERRIDE_IND VARCHAR2()

START_DATE Date the instruction for this course began for this student. This is either recorded for the individual student in the course or taken from the overall section begin date. VARCHAR2(171)

STUDENT_ATTRIBUTE_OVERRIDE_IND VARCHAR2()

STUDENT_COHORT_OVERRIDE_IND VARCHAR2()

STUDY_PATH_SEQUENCE VARCHAR2()

SUBJECT Main instructional subject area for this course. VARCHAR2(48)

SUBJECT_DESC Subject code description. VARCHAR2(25)

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(50)

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(32)

TEST_SCORE_OVERRIDE_IND VARCHAR2()

TIME_CONFLICT_OVERRIDE_IND VARCHAR2()

TRADITIONAL_IND Indicates whether this grade symbol is considered a traditional type of grade. VARCHAR2(78)

TRANSFER_COURSE_IND Indicates whether this course was taken at and transferred from another post secondary institution. VARCHAR2(99)

TRANSFER_COURSE_INSTITUTION Identifies the post secondary institution where the transfer course was taken. VARCHAR2(78)

TRANSFER_COURSE_INST_DESC Name of the post secondary transfer institution. VARCHAR2(48)

WAITLIST_IND VARCHAR2()

WITHDRAWN_IND VARCHAR2()

Ver: 8.5

Target Column	Business Definition	Database Data Type
ACADEMIC_PERIOD	Academic period or time frame associated with this course record.	VARCHAR2(65)
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(28)
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(65)
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(26)
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(123)
CAMPUS	Campus the student attended this schedule offering or section.	VARCHAR2(62)
CAMPUS_DESC	Institution campus name.	VARCHAR2(24)
CAMPUS_RESTRICT_OVERRIDE_IND		VARCHAR2()
CAPACITY_OVERRIDE_IND		VARCHAR2()
CHARGES_WAIVED_IND		VARCHAR2()
CLASS_RESTRICT_OVERRIDE_IND		VARCHAR2()
COLLEGE	College, faculty or school to which the course instructional responsibility is associated.	VARCHAR2(90)
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(32)
COLLEGE_RESTRICT_OVERRIDE_IND		VARCHAR2()
COREQUISITE_OVERRIDE_IND		VARCHAR2()
COUNT_IN_GPA_IND	Indicates whether this course should be used in the calculation of the GPA.	VARCHAR2(75)
COURSE_ATTEMPTED_IND		VARCHAR2()
COURSE_ATTRIBUTES_COUNT		VARCHAR2()
COURSE_BILLING_CREDITS	Billing units associated with this section or schedule offering.	VARCHAR2(64)
COURSE_BILLING_HOLD	Identifies the number of billing units that are being held for potential reinstatement.	VARCHAR2(87)
COURSE_CREDITS	Credits associated with this course.	VARCHAR2(36)
COURSE_CREDITS_HOLD	Identifies the number of credits that are being held for potential reinstatement.	VARCHAR2(81)
COURSE_EARNED_IND		VARCHAR2()
COURSE_FAILED_IND		VARCHAR2()
COURSE_IDENTIFICATION	Combined subject code and course number that identifies the instructional content of this course.	VARCHAR2(97)
COURSE_LEVEL	Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(100)
COURSE_LEVEL_DESC	Course level description.	VARCHAR2(25)
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(57)
COURSE_PASSED_IND		VARCHAR2()
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(67)
COURSE_REGISTER_IND		VARCHAR2()
COURSE_SECTION_NUMBER	Sequence number used to associated the information about the unique course for the student.	VARCHAR2(91)
COURSE_TITLE_LONG	Long title for the course.	VARCHAR2(26)
COURSE_TITLE_SHORT	Short title for the course.	VARCHAR2(27)
COURSE_VERSION	Course version number.	VARCHAR2(22)
CREDITS_ATTEMPTED	Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted.	VARCHAR2(153)
CREDITS_EARNED	Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.	VARCHAR2(162)
CREDITS_FOR_GPA	Credits used in the calculation of the average or GPA based on the rules of the institution.	VARCHAR2(92)
CREDITS_PASSED	Credits passed as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.	VARCHAR2(162)
CREDIT_FOR_GPA_IND		VARCHAR2()
DEGREE_RESTRICT_OVERRIDE_IND		VARCHAR2()
DEPARTMENT	Department responsible for the instructional delivery of this offering.	VARCHAR2(71)
DEPARTMENT_DESC	Department name.	VARCHAR2(16)
DEPARTMENT_RESTRICT_OVER_IND		VARCHAR2()
DIVISION	Division responsible for the instructional delivery of this course or section.	VARCHAR2(78)
DIVISION_DESC	Name of the division.	VARCHAR2(21)
DUPLICATE_COURSE_OVERRIDE_IND		VARCHAR2()
EFF_ACADEMIC_PERIOD_OF_GRADE	Earliest academic period for which grade is used.	VARCHAR2(49)
END_DATE	Date the student completes the coursework in the section. This is either recorded for the individual student in the course or taken from the overall section end date.	VARCHAR2(166)
EXTENSIONS	Number of extensions granted for the student to complete the required work for this section.	VARCHAR2(92)
FINALIZED_COMPLETION_DATE	Date a student completed their study for this subject or course. This might be the final completion date for an open learning course or it might be the end date from the sub academic period end date associated with a section.	VARCHAR2(225)
FINAL_GRADE	Final grade earned by the student for this course.	VARCHAR2(50)
FINAL_GRADE_DATE	Date associated with this grade.	VARCHAR2(32)
FINAL_GRADE_ROLL_IND	Indicates whether the final grade has been rolled to the history tables where applicable.	VARCHAR2(89)
GRADABLE_IND	Indicates whether the course can be graded.	VARCHAR2(43)
GRADE_CHANGE_COUNT		VARCHAR2()
GRADE_CHANGE_REASON	Institution defined grade change reason associated with this grade for this course.	VARCHAR2(83)
GRADE_CHANGE_REASON_DESC	Grade change reason description.	VARCHAR2(32)
GRADE_COMMENT		VARCHAR2()
GRADE_COMMENT_DESC		VARCHAR2()
GRADE_TYPE	Grade mode associated with this CRN.	VARCHAR2(36)
GRADE_TYPE_DESC	Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code.	VARCHAR2(97)
GRADE_VALUE	Numeric value assigned to a grade symbol to be used to measure course performance statistics. This willl only be present if a final grade has been recorded for either in progress or grades rolled to history for the student course.	VARCHAR2(230)
HOURS_ATTENDED	Number of hours the student attended this class.	VARCHAR2(48)
ID	Person's identification number used to access the records associated with the person.	VARCHAR2(85)
INCOMPLETE_EXT_DATE	Specifies the latest date the student has to complete any missing course work before they are assigned an incomplete grade for the course.	VARCHAR2(138)
INCOMPLETE_GRADE_IND		VARCHAR2()
INSTITUTION_COURSE_IND	Indicates whether the subject or course was taken at this institution.	VARCHAR2(70)
INSTRUCTION_METHOD	Instructional method used for the section.	VARCHAR2(42)
INSTRUCTION_METHOD_DESC	Instructional method description associated with the course.	VARCHAR2(60)
IN_PROGRESS_COURSE_IND	Indicates whether the course is in progress and not yet graded.	VARCHAR2(63)
LAST_ATTEND_DATE	Identifies the date on which the instruction ended.	VARCHAR2(51)
LAST_DATE_ATTEND_REQUIRED_IND		VARCHAR2()
LEVEL_RESTRICT_OVERRIDE_IND		VARCHAR2()
LINK_OVERRIDE_IND		VARCHAR2()
MAJOR_RESTRICT_OVERRIDE_IND		VARCHAR2()
MID_TERM_GRADE	Mid-term grade code associated with this CRN.	VARCHAR2(45)
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(103)
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(94)
MUTUTAL_EXCLUSION_OVERRIDE_IND		VARCHAR2()
NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(75)
PERSON_UID	System generated, unique, internal identification number assigned to this person.	VARCHAR2(81)
PREREQUISITE_OVERRIDE_IND		VARCHAR2()
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(118)
PROGRAM_RESTRICT_OVERRIDE_IND		VARCHAR2()
QUALITY_POINTS	Quality points associated with the grade.	VARCHAR2(41)
REGISTER_CENSUS_DATE1_IND		VARCHAR2()
REGISTER_CENSUS_DATE2_IND		VARCHAR2()
REGISTRATION_ERROR_FLAG	Indicates an error is associated with this section registration.	VARCHAR2(64)
REGISTRATION_OVERRIDE_IND		VARCHAR2()
REGISTRATION_SEQUENCE_NUMBER	Sequence number system assigned to the student registration in the section.	VARCHAR2(75)
REGISTRATION_STATUS	Course registration status associated with this section.	VARCHAR2(56)
REGISTRATION_STATUS_DATE	Date associated with the course registration status of this section.	VARCHAR2(68)
REGISTRATION_STATUS_DESC	Course registration status description.	VARCHAR2(39)
REGISTRATION_USER_ID	Person user identification number who processed the registration request for this section.	VARCHAR2(90)
REPEAT_COURSE_CREDIT_OVER_IND		VARCHAR2()
REPEAT_COURSE_IND	Identifies this course appears in more than one academic period for the student. Valid values in this data include 'E' exclude in any calculations, 'I' include in all calculations, or 'A' average in all calculations.	VARCHAR2(217)
REPEAT_COURSE_OVERRIDE_IND		VARCHAR2()
REPEAT_EVALUATE_IND		VARCHAR2()
SCHEDULE_TYPE	Instructional method or delivery type associated with the course.	VARCHAR2(65)
SCHEDULE_TYPE_DESC	Schedule type description.	VARCHAR2(26)
SECTION_ADD_DATE	Date the student registered in this section.	VARCHAR2(44)
SPECIAL_APPROVAL_IND	Indicates whether special approval was received to register in this section.	VARCHAR2(76)
SPECIAL_APPROVAL_OVERRIDE_IND		VARCHAR2()
START_DATE	Date the instruction for this course began for this student. This is either recorded for the individual student in the course or taken from the overall section begin date.	VARCHAR2(171)
STUDENT_ATTRIBUTE_OVERRIDE_IND		VARCHAR2()
STUDENT_COHORT_OVERRIDE_IND		VARCHAR2()
STUDY_PATH_SEQUENCE		VARCHAR2()
SUBJECT	Main instructional subject area for this course.	VARCHAR2(48)
SUBJECT_DESC	Subject code description.	VARCHAR2(25)
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(50)
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(32)
TEST_SCORE_OVERRIDE_IND		VARCHAR2()
TIME_CONFLICT_OVERRIDE_IND		VARCHAR2()
TRADITIONAL_IND	Indicates whether this grade symbol is considered a traditional type of grade.	VARCHAR2(78)
TRANSFER_COURSE_IND	Indicates whether this course was taken at and transferred from another post secondary institution.	VARCHAR2(99)
TRANSFER_COURSE_INSTITUTION	Identifies the post secondary institution where the transfer course was taken.	VARCHAR2(78)
TRANSFER_COURSE_INST_DESC	Name of the post secondary transfer institution.	VARCHAR2(48)
WAITLIST_IND		VARCHAR2()
WITHDRAWN_IND		VARCHAR2()