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_TRANSFER

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

SHRTRCE

SHRTRCE_TERM_CODE_EFF

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

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   VARCHAR2(1)    
CAPACITY_OVERRIDE_IND   VARCHAR2(1)    
CHARGES_WAIVED_IND   VARCHAR2(1)    
CLASS_RESTRICT_OVERRIDE_IND   VARCHAR2(1)    
COLLEGE_RESTRICT_OVERRIDE_IND   VARCHAR2(1)    
COREQUISITE_OVERRIDE_IND   VARCHAR2(1)    
COUNT_IN_GPA_IND Indicates whether this course should be used in the calculation of the GPA. VARCHAR2(1)

SHRTRCE

SHRTRCE_COUNT_IN_GPA_IND

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

NA

NA

COURSE_BILLING_HOLD Identifies the number of billing units that are being held for potential reinstatement. Not valid for transfer courses. NUMBER

NA

NA

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

NA

NA

COURSE_CAMPUS_DESC Institution campus description. VARCHAR2(255)

NA

NA

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

SCBCRSE

SCBCRSE_COLL_CODE

COURSE_COLLEGE_DESC College description. VARCHAR2(30)

STVCOLL

STVCOLL_DESC

COURSE_CREDITS Credits associated with this course. NUMBER

SHRTRCE

SHRTRCE_CREDIT_HOURS

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

NA

NA

COURSE_DEPARTMENT Department providing this instruction. VARCHAR2(4)

SCBCRSE

SCBCRSE_DEPT_CODE

COURSE_DEPARTMENT_DESC Department providing this instruction. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

COURSE_DIVISION Division providing this instruction. VARCHAR2(4)

SCBCRSE

SCBCRSE_DIVS_CODE

COURSE_DIVISION_DESC Division description. VARCHAR2(30)

STVDIVS

STVDIVS_DESC

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

SHRTRCE

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

SHRTRCE

SHRTRCE_CRSE_NUMB

COURSE_PASSED_IND   VARCHAR2(1)    
COURSE_REFERENCE_NUMBER Unique number used to identify the transfer course. VARCHAR2(51)

CALCULATION

NA

SHRTRCE_TRIT_SEQ_NO||TO_CHAR(SHRTRCE_TRAM_SEQ_NO,'FM09')||TO_CHAR(NVL(SHRTRCE_TRCR_SEQ_NO,0),'FM009')||TO_CHAR(SHRTRCE_SEQ_NO,'FM009')

NA

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

SHRTRCE

SHRTRCE_SEQ_NO

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

SHRTRCE

SHRTRCE_SEQ_NO

COURSE_TITLE_LONG Long title for the course. VARCHAR2(255)

NA

NA

COURSE_TITLE_SHORT Short title for the course. VARCHAR2(30)

SHRTRCE

SHRTRCE_CRSE_TITLE

COURSE_VERSION_NO Course version number. VARCHAR2(255)

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

SYSDATE

DEGREE_RESTRICT_OVERRIDE_IND   VARCHAR2(1)    
DEPARTMENT_RESTRICT_OVER_IND   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   VARCHAR2(1)    
EFF_ACADEMIC_PERIOD_OF_GRADE Earliest academic period for which grade is used. VARCHAR2(6)

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

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

SHRTRCE

SHRTRCE_GRDE_CODE

FINAL_GRADE_DATE Date associated with this grade. DATE

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

GRADE_CHANGE_REASON_DESC Grade change reason description. VARCHAR2(255)

NA

NA

GRADE_COMMENT   VARCHAR2(63)    
GRADE_COMMENT_DESC   VARCHAR2(255)    
GRADE_TYPE Grade mode associated with this COURSE REFERENCE NUMBER. VARCHAR2(1)

NA

NA

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

NA

NA

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

NA

NA

HOURS_ATTENDED Number of hours the student attended this class. NUMBER

NA

NA

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

NA

NA

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

CONSTANT

'N'

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

NA

NA

INSTRUCTION_METHOD_DESC Instructional method description for the section. VARCHAR2(255)

NA

NA

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

SSBSECT

SSBSECT_INTG_CDE

INTEGRATION_PARTNER_DESC Instruction integration partner description. VARCHAR2(255)

GORINTG

GORINTG_DESC

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

GORINTG

GORINTG_INTP_CODE

INTEGRATION_PARTNER_SYS_DESC Instruction integration partner system description. VARCHAR2(255)

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

NA

NA

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

NA

NA

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   VARCHAR2(1)    
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SHRTRCE

SHRTRCE_PIDM

PREREQUISITE_OVERRIDE_IND   VARCHAR2(1)    
PROGRAM_RESTRICT_OVERRIDE_IND   VARCHAR2(1)    
QUALITY_POINTS Quality points associated with the grade. NUMBER

NA

NA

REGISTER_CENSUS_DATE1_IND   VARCHAR2(1)    
REGISTER_CENSUS_DATE2_IND   VARCHAR2(1)    
REGISTRATION_ERROR_FLAG Indicates an error is associated with the registration of this COURSE REFERENCE NUMBER. VARCHAR2(1)

NA

NA

REGISTRATION_OVERRIDE_IND   VARCHAR2(1)    
REGISTRATION_SEQUENCE_NUMBER Registration sequence number. NUMBER

NA

NA

REGISTRATION_STATUS Course registration status associated with this COURSE REFERENCE NUMBER. VARCHAR2(63)

NA

NA

REGISTRATION_STATUS_DATE Date associated with the course registration status of this COURSE REFERENCE NUMBER. DATE

NA

NA

REGISTRATION_STATUS_DESC Course registration status description associated with the code. VARCHAR2(255)

NA

NA

REGISTRATION_USER_ID User identification number of the person who entered the registration request. VARCHAR2(63)

NA

NA

REPEAT_COURSE_CREDIT_OVER_IND   VARCHAR2(1)    
REPEAT_COURSE_IND Repeat Course Indicator. Indicates whether the course was taken as a repeat course by the student. VARCHAR2(1)

NA

NA

REPEAT_COURSE_OVERRIDE_IND   VARCHAR2(1)    
REPEAT_EVALUATE_IND   VARCHAR2(1)    
SCHEDULE_TYPE Instructional type associated with the course. VARCHAR2(63)

NA

NA

SCHEDULE_TYPE_DESC Instructional type description associated with the course. VARCHAR2(255)

NA

NA

SECTION_ADD_DATE Add date when the student registered in this COURSE REFERENCE NUMBER. DATE

NA

NA

SPECIAL_APPROVAL_IND Indicates whether special approval has been received for this COURSE REFERENCE NUMBER. VARCHAR2(1)

NA

NA

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

NA

NA

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

SHRTRCE

SHRTRCE_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(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

TEST_SCORE_OVERRIDE_IND   VARCHAR2(1)    
TIME_CONFLICT_OVERRIDE_IND   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 yes when this is a transfer course. VARCHAR2(1)

CONSTANT

'Y'

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

SHRTRIT

SHRTRIT_SBGI_CODE

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

STVSBGI

STVSBGI_DESC

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

SHRTRIT

SHRTRIT_SEQ_NO

WAITLIST_IND   VARCHAR2(1)    
WITHDRAWN_IND   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: