RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE 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 Definition Database Data Type 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)

FUNCTION

GOKODSF.F_GET_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRGRDE

SHRGRDE_GPA_IND

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)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRTCKN

SHRTCKN_COLL_CODE

COURSE_COLLEGE_DESC College description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

COURSE_DIVISION Division providing this instruction. VARCHAR2(4)

SHRTCKN

SHRTCKN_DIVS_CODE

COURSE_DIVISION_DESC Division description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB

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)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRTCKN

SHRTCKN_CRSE_NUMB

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

SHRTCKN

SHRTCKN_CRN

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)

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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)

FUNCTION

GOKODSF.F_GET_DESC

GRADE_TYPE Grade mode associated with this COURSE REFERENCE NUMBER. VARCHAR2(1)

SHRTCKG

SHRTCKG_GMOD_CODE

GRADE_TYPE_DESC Grade type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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. NUMBER(3)

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

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

CONSTANT

'Y'

INSTRUCTION_METHOD Instructional method associated with the course. VARCHAR2(30)

STVSCHD

STVSCHD_INSM_CODE

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

FUNCTION

GOKODSF.F_GET_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

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

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

SHRTCKN

SHRTCKN_PIDM

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)

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

SFRSTCR

SFRSTCR_ERROR_FLAG

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)

FUNCTION

GOKODSF.F_GET_DESC

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

SFRSTCR

SFRSTCR_USER

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

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)

FUNCTION

GOKODSF.F_GET_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

START_DATE Date the instruction for this course began for this student. DATE

FUNCTION

SOKODSF.F_GET_COURSE_DATES

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

SHRTCKN

SHRTCKN_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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)

SHRTRIT

SHRTRIT_SBGI_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

SHRTRIT

SHRTRIT_SEQ_NO

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

NA

NA



Ver: 3.1