Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_STUDENT_COURSE_HISTORY

Description Source composite view contains information about the courses taken by a student. It tracks registered, graded and transfer courses.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD   Academic period or time frame associated with this course record. VARCHAR2(6)  

SHRTCKN

SHRTCKN_TERM_CODE

ACADEMIC_PERIOD_DESC   Academic period description. VARCHAR2(30)  

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC   Academic year description. VARCHAR2(30)  

STVACYR

STVACYR_DESC

CAMPUS_RESTRICT_OVERRIDE_IND Campus Restrict Override Indicator   VARCHAR2(1)      
CAPACITY_OVERRIDE_IND Capacity Override Indicator   VARCHAR2(1)      
CHARGES_WAIVED_IND Charges Waived Indicator   CHAR(1)      
CLASS_RESTRICT_OVERRIDE_IND Class Restrict Override Indicator   VARCHAR2(1)      
COLLEGE_RESTRICT_OVERRIDE_IND College Restrict Override Indicator   VARCHAR2(1)      
COREQUISITE_OVERRIDE_IND Corequisite Override Indicator   VARCHAR2(1)      
COUNT_IN_GPA_IND   Indicates whether this course should be used in the calculation of the GPA. VARCHAR2(1)  

SHRGRDE

SHRGRDE_GPA_IND

COURSE_ATTEMPTED_IND Course Attempted Indicator   VARCHAR2(1)      
COURSE_BILLING_CREDITS   Billing units associated with this section or schedule offering. NUMBER(7, 3)  

SFRSTCR

SFRSTCR_BILL_HR

COURSE_BILLING_HOLD   Identifies the number of billing units that are being held for potential reinstatement. NUMBER(7, 3)  

SFRSTCR

SFRSTCR_BILL_HR_HOLD

COURSE_CAMPUS   Campus the student attended this schedule offering or section. VARCHAR2(3)  

SHRTCKN

SHRTCKN_CAMP_CODE

COURSE_CAMPUS_DESC   Institution campus description. VARCHAR2(30)  

STVCAMP

STVCAMP_DESC

COURSE_COLLEGE   College, faculty or school provide this section instruction. VARCHAR2(2)  

SHRTCKN

SHRTCKN_COLL_CODE

COURSE_COLLEGE_DESC   College description. VARCHAR2(30)  

STVCOLL

STVCOLL_DESC

COURSE_CREDITS   Credits associated with this course. NUMBER(7, 3)  

SHRTCKG

SHRTCKG_CREDIT_HOURS

COURSE_CREDITS_HOLD   Identifies the number of credits that are being held for potential reinstatement. NUMBER(7, 3)  

SFRSTCR

SFRSTCR_BILL_HR_HOLD

COURSE_DEPARTMENT   Department providing this instruction. VARCHAR2(4)  

SHRTCKN

SHRTCKN_DEPT_CODE

COURSE_DEPARTMENT_DESC   Department providing this instruction. VARCHAR2(30)  

STVDEPT

STVDEPT_DESC

COURSE_DIVISION   Division providing this instruction. VARCHAR2(4)  

SHRTCKN

SHRTCKN_DIVS_CODE

COURSE_DIVISION_DESC   Division description. VARCHAR2(30)  

STVDIVS

STVDIVS_DESC

COURSE_EARNED_IND Course Earned Indicator   VARCHAR2(1)      
COURSE_FAILED_IND Course Failed Indicator   CHAR(1)      
COURSE_IDENTIFICATION   Combined subject code and course number that identifies the instructional content of this course. VARCHAR2(9)      
COURSE_LEVEL   Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc. VARCHAR2(2)  

SHRTCKL

SHRTCKL_LEVL_CODE

COURSE_LEVEL_DESC   Course level description. VARCHAR2(30)  

STVLEVL

STVLEVL_DESC

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

SHRTCKN

SHRTCKN_CRSE_NUMB

COURSE_PASSED_IND Course Passed Indicator   VARCHAR2(1)      
COURSE_REFERENCE_NUMBER   Computer assigned internal unique number for the schedule offering. VARCHAR2(5)  

SHRTCKN

SHRTCKN_CRN

COURSE_REGISTER_IND Course Register Indicator   VARCHAR2(1)      
COURSE_SECTION_NUMBER   Sequence number used to associated the information about the unique course for the student. VARCHAR2(3)  

SHRTCKN

SHRTCKN_SEQ_NUMB

COURSE_SEQ_NO   Sequence number used to associated the information about the unique course for the student. NUMBER(2)  

SHRTCKN

SHRTCKN_SEQ_NO

COURSE_TITLE_LONG   Long title for the course. VARCHAR2(100)  

SHRTCKN

SHRTCKN_LONG_COURSE_TITLE

COURSE_TITLE_SHORT   Short title for the course. VARCHAR2(30)  

SHRTCKN

SHRTCKN_CRSE_TITLE

COURSE_VERSION_NO   Course version number. VARCHAR2(0)  

NA

NA

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

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_ATTEMPTED_IND,'Y',1,0)

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

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_COMPLETED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)

CREDITS_FOR_GPA   Credits used in the calculation of the average or GPA based on the rules of the institution. NUMBER  

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)

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

CALCULATION

SHRTCKG_CREDIT_HOURS*DECODE(SHRGRDE_PASSED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'A',0,'E',0,1)

CREDIT_FOR_GPA_IND Credit For GPA - Grade Point Average or Average Indicator   VARCHAR2(1)      
CURRENT_DATE   System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DEGREE_RESTRICT_OVERRIDE_IND Degree Restrict Override Indicator   VARCHAR2(1)      
DEPARTMENT_RESTRICT_OVER_IND Department Restrict Over Indicator   VARCHAR2(1)      
DOMAIN_VALUE   Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

DUPLICATE_COURSE_OVERRIDE_IND Duplicate Course Override Indicator   VARCHAR2(1)      
EFF_ACADEMIC_PERIOD_OF_GRADE   Earliest academic period for which grade is used. VARCHAR2(6)  

SHRGRDE

SHRGRDE_TERM_CODE_EFFECTIVE

END_DATE   Date on which the instruction ended. It is either stored specifically for the open learning student or taken from the end date on the offering. DATE  

CALCULATION

NVL(SHRTCKN_REG_COMPLETION_DATE,SOKODSF.F_GET_COURSE_DATES(SHRTCKN_PIDM,SHRTCKN_TERM_CODE,SHRTCKN_CRN,SHRTCKN_PTRM_CODE,'E'))

EXTENSIONS   Number of extensions granted to an open learning student to complete the instruction. NUMBER  

CALCULATION

NVL(SHRTCKN_NUMBER_OF_EXTENSIONS, SOKODSF.F_GET_COURSE_EXTENSIONS(SHRTCKN_PIDM,SHRTCKN_TERM_CODE,SHRTCKN_CRN))

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

FUNCTION

SOKODSF.F_GET_COURSE_DATES

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

SHRTCKG

SHRTCKG_GRDE_CODE_FINAL

FINAL_GRADE_DATE   Date associated with this grade. DATE  

SHRTCKG

SHRTCKG_FINAL_GRDE_CHG_DATE

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

CALCULATION

DECODE(SFRSTCR_GRDE_DATE,NULL,'N','Y')

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

SSBSECT

SSBSECT_GRADABLE_IND

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

SHRTCKG

SHRTCKG_GCHG_CODE

GRADE_CHANGE_REASON_DESC   Grade change reason description. VARCHAR2(30)  

STVGCHG

STVGCHG_DESC

GRADE_COMMENT Grade Comment   VARCHAR2(7)      
GRADE_COMMENT_DESC Grade Comment Description   VARCHAR2(200)      
GRADE_TYPE   Grade mode associated with this COURSE REFERENCE NUMBER. VARCHAR2(1)  

SHRTCKG

SHRTCKG_GMOD_CODE

GRADE_TYPE_DESC   Grade type description. VARCHAR2(30)  

STVGMOD

STVGMOD_DESC

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

SHRGRDE

SHRGRDE_NUMERIC_VALUE

HOURS_ATTENDED   Number of hours the student attended this class. NUMBER(9, 3)  

SFRSTCR

SFRSTCR_ATTEND_HR

INCOMPLETE_EXT_DATE   Specifies the date at which the extension for the course becomes an incomplete grade. DATE  

SHRTCKG

SHRTCKG_INCOMPLETE_EXT_DATE

INCOMPLETE_GRADE_IND Incomplete Grade Indicator   VARCHAR2(1)      
INSTITUTION_COURSE_IND   Indicates whether the subject or course was taken at this institution and is in academic history. VARCHAR2(1)  

CONSTANT

'Y'

INSTRUCTION_METHOD Instruction Method Instructional method associated with the course. VARCHAR2(5)  

STVSCHD

STVSCHD_INSM_CODE

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

GTVINSM

GTVINSM_DESC

INTEGRATION_PARTNER Integration Partner Institution defined integration code that identifies an external partner used for instruction of this schedule offering. VARCHAR2(5)  

SSBSECT

SSBSECT_INTG_CDE

INTEGRATION_PARTNER_DESC Integration Partner Description Instruction integration partner description. VARCHAR2(30)  

GORINTG

GORINTG_DESC

INTEGRATION_PARTNER_SYSTEM Integration Partner System Institution defined integration system code that identifies an external partner systen used for instruction of this schedule offering. VARCHAR2(5)  

GORINTG

GORINTG_INTP_CODE

INTEGRATION_PARTNER_SYS_DESC Integration Partner System Description Instruction integration partner system description. VARCHAR2(30)  

GORINTG

GTVINTP_DESC

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

CONSTANT

'N'

LAST_ATTEND_DATE   Identifies the date on which the instruction ended. DATE  

SFRSTCR

SFRSTCR_LAST_ATTEND

LAST_DATE_ATTEND_REQUIRED_IND Last Date Attend Required Indicator   VARCHAR2(1)      
LEVEL_RESTRICT_OVERRIDE_IND Level Restrict Override Indicator   VARCHAR2(1)      
LINK_OVERRIDE_IND Link Override Indicator   VARCHAR2(1)      
MAJOR_RESTRICT_OVERRIDE_IND Major Restrict Override Indicator   VARCHAR2(1)      
MID_TERM_GRADE   Mid-term grade code associated with this COURSE REFERENCE NUMBER. VARCHAR2(6)  

SFRSTCR

SFRSTCR_GRDE_CODE_MID

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

NA

NA

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

NA

NA

MUTUTAL_EXCLUSION_OVERRIDE_IND Mututal Exclusion Override Indicator   VARCHAR2(1)      
PERSON_UID   System generated, unique, internal identification number assigned to this person. NUMBER(8)  

SHRTCKN

SHRTCKN_PIDM

PREREQUISITE_OVERRIDE_IND Prerequisite Override Indicator   VARCHAR2(1)      
PROGRAM_RESTRICT_OVERRIDE_IND Program Restrict Override Indicator   VARCHAR2(1)      
QUALITY_POINTS   Quality points associated with the grade. NUMBER  

CALCULATION

SHRTCKG_CREDIT_HOURS*SHRGRDE_QUALITY_POINTS*DECODE(SHRGRDE_GPA_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)

REGISTER_CENSUS_DATE1_IND Register Census Date 1 Indicator   CHAR(1)      
REGISTER_CENSUS_DATE2_IND Register Census Date 2 Indicator   CHAR(1)      
REGISTRATION_ERROR_FLAG   Indicates an error is associated with this section registration. VARCHAR2(1)  

SFRSTCR

SFRSTCR_ERROR_FLAG

REGISTRATION_OVERRIDE_IND Registration Override Indicator   CHAR(1)      
REGISTRATION_SEQUENCE_NUMBER   Sequence number system assigned to the student registration in the section. NUMBER(4)  

SHRTCKN

SHRTCKN_REG_SEQ

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

SFRSTCR

SFRSTCR_RSTS_CODE

REGISTRATION_STATUS_DATE   Date associated with the course registration status of this section. DATE  

SFRSTCR

SFRSTCR_RSTS_DATE

REGISTRATION_STATUS_DESC   Course registration status description. VARCHAR2(30)  

STVRSTS

STVRSTS_DESC

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

SFRSTCR

SFRSTCR_USER

REPEAT_COURSE_CREDIT_OVER_IND Repeat Course Credit Over Indicator   VARCHAR2(1)      
REPEAT_COURSE_IND   Indicates whether this course was registered in more than one academic period by the student. VARCHAR2(1)  

SHRTCKN

SHRTCKN_REPEAT_COURSE_IND

REPEAT_COURSE_OVERRIDE_IND Repeat Course Override Indicator   VARCHAR2(1)      
REPEAT_EVALUATE_IND Repeat Evaluate Indicator   VARCHAR2(1)      
SCHEDULE_TYPE   Instructional method or delivery type associated with the course. VARCHAR2(3)  

SHRTCKN

SHRTCKN_SCHD_CODE

SCHEDULE_TYPE_DESC   Schedule type description. VARCHAR2(30)  

STVSCHD

STVSCHD_DESC

SECTION_ADD_DATE   Date the student registered in this section. DATE  

SFRSTCR

SFRSTCR_ADD_DATE

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

SFRSTCR

SFRSTCR_APPR_RECEIVED_IND

SPECIAL_APPROVAL_OVERRIDE_IND Special Approval Override Indicator   VARCHAR2(1)      
START_DATE   Date the instruction for this course began for this student. DATE  

FUNCTION

SOKODSF.F_GET_COURSE_DATES

STUDENT_ATTRIBUTE_OVERRIDE_IND Student Attribute Override Indicator   VARCHAR2(1)      
STUDENT_COHORT_OVERRIDE_IND Student Cohort Override Indicator   VARCHAR2(1)      
STUDY_PATH_SEQUENCE Study Path Sequence   NUMBER      
SUBJECT   Main instructional subject area for this course. VARCHAR2(4)  

SHRTCKN

SHRTCKN_SUBJ_CODE

SUBJECT_DESC   Subject code description. VARCHAR2(30)  

STVSUBJ

STVSUBJ_DESC

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

SHRTCKN

SHRTCKN_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC   Sub academic period description. VARCHAR2(30)  

STVPTRM

STVPTRM_DESC

TEST_SCORE_OVERRIDE_IND Test Score Override Indicator   VARCHAR2(1)      
TIME_CONFLICT_OVERRIDE_IND Time Conflict Override Indicator   VARCHAR2(1)      
TRADITIONAL_IND   Indicates whether this grade symbol is considered a traditional type of grade. VARCHAR2(1)  

NA

NA

TRANSFER_COURSE_IND   Indicates whether this course was taken at and transferred from another post secondary institution. This is no when this is an institutional history course. VARCHAR2(1)  

CONSTANT

'N'

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

NA

NA

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

NA

NA

TRANSFER_COURSE_INST_SEQ_NO   Specifies the sequence number for the institution where the course was transferred. NUMBER  

NA

NA

WAITLIST_IND Waitlist Indicator   VARCHAR2(1)      
WITHDRAWN_IND Withdrawn Indicator   VARCHAR2(1)      
ZONE_VALUE   Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: