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

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 Definition Database Data Type Source Name Source Column Local Source Local Target
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(6)

SHRTCKN

SHRTCKN_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

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

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
CAMPUS_RESTRICT_OVERRIDE_IND   VARCHAR2(1)       NO
CAPACITY_OVERRIDE_IND   VARCHAR2(1)       NO
CHARGES_WAIVED_IND   CHAR(1)       NO
CLASS_RESTRICT_OVERRIDE_IND   VARCHAR2(1)       NO
COLLEGE_RESTRICT_OVERRIDE_IND   VARCHAR2(1)       NO
COREQUISITE_OVERRIDE_IND   VARCHAR2(1)       NO
COUNT_IN_GPA_IND Indicates whether this course should be used in the calculation of the GPA. VARCHAR2(1)

SHRGRDE

SHRGRDE_GPA_IND

NO

NO
COURSE_ATTEMPTED_IND   VARCHAR2(1)       NO
COURSE_BILLING_CREDITS Billing units associated with this section or schedule offering. NUMBER

SFRSTCR

SFRSTCR_BILL_HR

NO

NO
COURSE_BILLING_HOLD Identifies the number of billing units that are being held for potential reinstatement. NUMBER

SFRSTCR

SFRSTCR_BILL_HR_HOLD

NO

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

SHRTCKN

SHRTCKN_CAMP_CODE

NO

NO
COURSE_CAMPUS_DESC Institution campus description. VARCHAR2(30)

STVCAMP

STVCAMP_DESC

NO

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

SHRTCKN

SHRTCKN_COLL_CODE

NO

NO
COURSE_COLLEGE_DESC College description. VARCHAR2(30)

STVCOLL

STVCOLL_DESC

NO

NO
COURSE_COMMENT This field identifies the course comment. VARCHAR2(255)

SHRTCKN

SHRTCKN_COURSE_COMMENT

NO

NO
COURSE_CREDITS Credits associated with this course. NUMBER

SHRTCKG

SHRTCKG_CREDIT_HOURS

NO

NO
COURSE_CREDITS_HOLD Identifies the number of credits that are being held for potential reinstatement. NUMBER

SFRSTCR

SFRSTCR_BILL_HR_HOLD

NO

NO
COURSE_DEPARTMENT Department providing this instruction. VARCHAR2(4)

SHRTCKN

SHRTCKN_DEPT_CODE

NO

NO
COURSE_DEPARTMENT_DESC Department providing this instruction. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

NO

NO
COURSE_DIVISION Division providing this instruction. VARCHAR2(4)

SHRTCKN

SHRTCKN_DIVS_CODE

NO

NO
COURSE_DIVISION_DESC Division description. VARCHAR2(30)

STVDIVS

STVDIVS_DESC

NO

NO
COURSE_EARNED_IND   VARCHAR2(1)       NO
COURSE_FAILED_IND   CHAR(1)       NO
COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(9)       NO
COURSE_LEVEL Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc. VARCHAR2(2)

SHRTCKL

SHRTCKL_LEVL_CODE

NO

NO
COURSE_LEVEL_DESC Course level description. VARCHAR2(30)

STVLEVL

STVLEVL_DESC

NO

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

SHRTCKN

SHRTCKN_CRSE_NUMB

NO

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

SHRTCKN

SHRTCKN_CRN

NO

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

SHRTCKN

SHRTCKN_SEQ_NUMB

NO

NO
COURSE_SEQ_NO Sequence number used to associated the information about the unique course for the student. NUMBER

SHRTCKN

SHRTCKN_SEQ_NO

NO

NO
COURSE_TITLE_LONG Long title for the course. VARCHAR2(100)

SHRTCKN

SHRTCKN_LONG_COURSE_TITLE

NO

NO
COURSE_TITLE_SHORT Short title for the course. VARCHAR2(30)

SHRTCKN

SHRTCKN_CRSE_TITLE

NO

NO
COURSE_VERSION_NO Course version number. VARCHAR2(0)

NA

NA

NO

NO
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)

NO

NO
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)

NO

NO
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)

NO

NO
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)

NO

NO
CREDIT_FOR_GPA_IND   VARCHAR2(1)       NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

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

NA

NA

NO

NO
DUPLICATE_COURSE_OVERRIDE_IND   VARCHAR2(1)       NO
EFF_ACADEMIC_PERIOD_OF_GRADE Earliest academic period for which grade is used. VARCHAR2(6)

SHRGRDE

SHRGRDE_TERM_CODE_EFFECTIVE

NO

NO
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'))

NO

NO
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))

NO

NO
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

NO

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

SHRTCKG

SHRTCKG_GRDE_CODE_FINAL

NO

NO
FINAL_GRADE_DATE Date associated with this grade. DATE

SHRTCKG

SHRTCKG_FINAL_GRDE_CHG_DATE

NO

NO
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')

NO

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

SSBSECT

SSBSECT_GRADABLE_IND

NO

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

SHRTCKG

SHRTCKG_GCHG_CODE

NO

NO
GRADE_CHANGE_REASON_DESC Grade change reason description. VARCHAR2(30)

STVGCHG

STVGCHG_DESC

NO

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

SHRTCKG

SHRTCKG_GMOD_CODE

NO

NO
GRADE_TYPE_DESC Grade type description. VARCHAR2(30)

STVGMOD

STVGMOD_DESC

NO

NO
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

NO

NO
HOURS_ATTENDED Number of hours the student attended this class. NUMBER

SFRSTCR

SFRSTCR_ATTEND_HR

NO

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

SHRTCKG

SHRTCKG_INCOMPLETE_EXT_DATE

NO

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

CONSTANT

'Y'

NO

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

STVSCHD

STVSCHD_INSM_CODE

NO

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

GTVINSM

GTVINSM_DESC

NO

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

SSBSECT

SSBSECT_INTG_CDE

NO

NO
INTEGRATION_PARTNER_DESC Instruction integration partner description. VARCHAR2(30)

GORINTG

GORINTG_DESC

NO

NO
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

NO

NO
INTEGRATION_PARTNER_SYS_DESC Instruction integration partner system description. VARCHAR2(30)

GORINTG

GTVINTP_DESC

NO

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

CONSTANT

'N'

NO

NO
LAST_ATTEND_DATE Identifies the date on which the instruction ended. DATE

SFRSTCR

SFRSTCR_LAST_ATTEND

NO

NO
LAST_DATE_ATTEND_REQUIRED_IND   VARCHAR2(1)       NO
LEVEL_RESTRICT_OVERRIDE_IND   VARCHAR2(1)       NO
LINK_OVERRIDE_IND   VARCHAR2(1)       NO
MAJOR_RESTRICT_OVERRIDE_IND   VARCHAR2(1)       NO
MID_TERM_GRADE Mid-term grade code associated with this COURSE REFERENCE NUMBER. VARCHAR2(6)

SFRSTCR

SFRSTCR_GRDE_CODE_MID

NO

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

NA

NA

NO

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

NA

NA

NO

NO
MUTUTAL_EXCLUSION_OVERRIDE_IND   VARCHAR2(1)       NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SHRTCKN

SHRTCKN_PIDM

NO

NO
PREREQUISITE_OVERRIDE_IND   VARCHAR2(1)       NO
PROGRAM_RESTRICT_OVERRIDE_IND   VARCHAR2(1)       NO
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)

NO

NO
REGISTER_CENSUS_DATE1_IND   CHAR(1)       NO
REGISTER_CENSUS_DATE2_IND   CHAR(1)       NO
REGISTRATION_ACT_DATE This identifies the activity date of the registration request. DATE

SFRSTCR

SFRSTCR_ACTIVITY_DATE

NO

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

SFRSTCR

SFRSTCR_ERROR_FLAG

NO

NO
REGISTRATION_OVERRIDE_IND   CHAR(1)       NO
REGISTRATION_SEQUENCE_NUMBER Sequence number system assigned to the student registration in the section. NUMBER

SHRTCKN

SHRTCKN_REG_SEQ

NO

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

SFRSTCR

SFRSTCR_RSTS_CODE

NO

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

SFRSTCR

SFRSTCR_RSTS_DATE

NO

NO
REGISTRATION_STATUS_DESC Course registration status description. VARCHAR2(30)

STVRSTS

STVRSTS_DESC

NO

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

SFRSTCR

SFRSTCR_USER

NO

NO
REPEAT_COURSE_CREDIT_OVER_IND   VARCHAR2(1)       NO
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

NO

NO
REPEAT_COURSE_OVERRIDE_IND   VARCHAR2(1)       NO
REPEAT_EVALUATE_IND   VARCHAR2(1)       NO
SCHEDULE_TYPE Instructional method or delivery type associated with the course. VARCHAR2(3)

SHRTCKN

SHRTCKN_SCHD_CODE

NO

NO
SCHEDULE_TYPE_DESC Schedule type description. VARCHAR2(30)

STVSCHD

STVSCHD_DESC

NO

NO
SECTION_ADD_DATE Date the student registered in this section. DATE

SFRSTCR

SFRSTCR_ADD_DATE

NO

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

SFRSTCR

SFRSTCR_APPR_RECEIVED_IND

NO

NO
SPECIAL_APPROVAL_OVERRIDE_IND   VARCHAR2(1)       NO
START_DATE Date the instruction for this course began for this student. DATE

FUNCTION

SOKODSF.F_GET_COURSE_DATES

NO

NO
STUDENT_ATTRIBUTE_OVERRIDE_IND   VARCHAR2(1)       NO
STUDENT_COHORT_OVERRIDE_IND   VARCHAR2(1)       NO
STUDY_PATH_SEQUENCE   NUMBER       NO
SUBJECT Main instructional subject area for this course. VARCHAR2(4)

SHRTCKN

SHRTCKN_SUBJ_CODE

NO

NO
SUBJECT_DESC Subject code description. VARCHAR2(30)

STVSUBJ

STVSUBJ_DESC

NO

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

SHRTCKN

SHRTCKN_PTRM_CODE

NO

NO
SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(30)

STVPTRM

STVPTRM_DESC

NO

NO
TEST_SCORE_OVERRIDE_IND   VARCHAR2(1)       NO
TIME_CONFLICT_OVERRIDE_IND   VARCHAR2(1)       NO
TRADITIONAL_IND Indicates whether this grade symbol is considered a traditional type of grade. VARCHAR2(1)

NA

NA

NO

NO
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'

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

NO
WAITLIST_AVAILABLE It displays a running total of remaining available waitlist seats by subtracting the waitlist actual enrollment from the maximum waitlist enrollment for the section. NUMBER

SSBSECT

SSBSECT_WAIT_AVAIL

NO

NO
WAITLIST_CAPACITY This field stores the maximum waitlist enrollment for a section. NUMBER

SSBSECT

SSBSECT_WAIT_CAPACITY

NO

NO
WAITLIST_COUNT It displays a running total of enrollments in the section which have course status with a waitlist flag set to Y on the Registration Status Code Validation Form - STVRSTS. NUMBER

SSBSECT

SSBSECT_WAIT_COUNT

NO

NO
WAITLIST_IND   VARCHAR2(1)       NO
WAITLIST_PRIORITY This field indicates the Waitlist priority. NUMBER

SFRSTCR

SFRSTCR_WL_PRIORITY

NO

NO
WAITLIST_PRIORITY_ORIG This field indicates the waitlist priority origin. Valid values are S-system originated, M-manually originated. VARCHAR2(1)

SFRSTCR

SFRSTCR_WL_PRIORITY_ORIG

NO

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

NA

NA

NO

NO


Ver: