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

Banner Operational Data Store
Reporting View Target: STUDENT_TRANSFERRED_COURSE

Description Contains detail data for a each course a student completed at another institution for which this institution is granted equivalent course credit. This reporting view will contain the details as recorded on the received transfer institution transcript as well as the institution equivalent course for which the student is receiving credit. This reporting will show one row for each Transfer Course Detail Repeating Table (SHRTRCE) and Transfer Course Equivalent Repeating Table (SHRTRCE) combination. Therefore they may be more than one row per entry on either the transfere course or the equivalent course. This reporting view should not be used in combination with the STUDENT_COURSE reporting view which will have one row per each Transfer Course Equivalent Repeating Table row.
Key & Frequency One row per person per academic period per transferred course per equivalent course
Recommended Search Columns TRANSFER_COURSE_INSTITUTION, TRANSFER_COURSE_SUBJECT, TRANSFER_COURSE_NUMBER
PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID, TRANSFER_COURSE_INST_SEQ_NO
PERSON_UID, ACADEMIC_PERIOD, COURSE_SEQ_NO
COURSE_IDENTIFICATION, ACADEMIC_PERIOD, PERSON_UID
ACADEMIC_PERIOD, PERSON_UID, COURSE_LEVEL, COURSE_REFERENCE_NUMBER
SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD

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

SHRTRCE

SHRTRCE_TERM_CODE_EFF

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

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

NA

NA

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_ATTRIBUTES_COUNT Number of course attributes associated with this course for this student. NUMBER

FUNCTION

MSKFUNC.F_COUNT_STUDENT_COURSE_ATTR

COURSE_CREDITS Credits associated with this course. NUMBER

SHRTRCE

SHRTRCE_CREDIT_HOURS

COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(63)

CALCULATION

SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS_COURSE_NUMBERS

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

SHRTRCE

SHRTRCE_LEVL_CODE

COURSE_LEVEL_DESC Course level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

SHRTRCE

SHRTRCE_CRSE_NUMB

COURSE_REFERENCE_NUMBER Unique number used to identify the transfer course. VARCHAR2(63)

CALCULATION

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

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

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_SHORT Short title for the course. VARCHAR2(63)

SHRTRCE

SHRTRCE_CRSE_TITLE

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

SHRTRCE_CREDIT_HOURS*DECODE(SHRGRDE_ATTEMPTED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'E',0,1)

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

SHRTRCE_CREDIT_HOURS*DECODE(SHRGRDE_EARNED_IND,'Y',1,0)*DECODE(SHRTCKN_REPEAT_COURSE_IND,'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

SHRTRCE_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

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

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

SHRTRCE

SHRTRCE_GRDE_CODE

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

SHRTCKG

SHRTRCE_GMOD_CODE

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

STVGMOD

STVGMOD_DESC

GROUP_PRIMARY_IND Identifies this transfer course as the primary course when the course has more than one transfer course listed to the institution equivalent course or courses. VARCHAR2(1)

SHRTRCR

SHRTRCR_GROUP_PRIMARY_IND

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTIPLE_COURSE_EQUIVALENT Indicates there was more than one transfer course for the academic period entered on the Transfer Articulation Rules Form (SHATAEQ). VARCHAR2(63)

SHRTRCR

SHRTRCR_DUPLICATE

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SHRTRCR

SHRTRCR_PIDM

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

NA

NA

PROGRAM_ARTICULATION Program (if any) associated with transfer course articulation rule. VARCHAR2(63)

SHRTRCR

SHRTRCR_PROGRAM

PROGRAM_ARTICULATION_DESC Description for the program articulated in the articulation rule. VARCHAR2(255)

SMRPRLE

SMRPRLE_PROGRAM_DESC

QUALITY_POINTS Quality points associated with the grade. NUMBER

CALCULATION

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

STUDY_PATH_SEQUENCE Sequence number of the study path for which the course reference number is registered. NUMBER

NA

NA

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

SHRTRCE

SHRTRCE_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(255)

STVSUBJ

STVSUBJ_DESC

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

SHRGRDE

SHRGRDE_TRADITIONAL_IND

TRANSFER_ARTICULATION_RULE Identifies whether articulation rules were built for this transfer institution and transfer course. VARCHAR2(1)

SHRTRCR

SHRTRCR_ART_IND

TRANSFER_COURSE_ACTIVITY_DATE Specifies the date record was created or last updated. DATE

SHRTRCR

SHRTRCR_ACTIVITY_DATE

TRANSFER_COURSE_CREDITS Specifies the credit hours of the transfer course from the original transcript. NUMBER

SHRTRCR

SHRTRCR_TRANS_CREDIT_HOURS

TRANSFER_COURSE_GRADE Grade for transfer course from the original transcript. VARCHAR2(63)

SHRTRCR

SHRTRCR_TRANS_GRADE

TRANSFER_COURSE_GROUP Group connector for many to one transfer course relationships. VARCHAR2(63)

SHRTRCR

SHRTRCR_GROUP

TRANSFER_COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(255)

CALCULATION

SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS_COURSE_NUMBERS

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

SHRTRIT

SHRTRIT_SBGI_CODE

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

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

TRANSFER_COURSE_NUMBER Course number associated with the subject for the course. VARCHAR2(63)

SHRTRCR

SHRTRCR_TRANS_COURSE_NUMBERS

TRANSFER_COURSE_SEQ_NUMBER Unique identifier for a course being transferred from this institution. NUMBER

SHRTRCR

SHRTRCR_SEQ_NO

TRANSFER_COURSE_SUBJECT Main instructional subject area for this course. VARCHAR2(255)

SHRTRCR

SHRTRCR_TRANS_COURSE_NAME

TRANSFER_COURSE_TITLE Transfer institution course title. VARCHAR2(255)

SHRTRCR

SHRTRCR_TCRSE_TITLE

TRANS_ARTICULATION_RULE_DESC Description for the articulation built. VARCHAR2(255)

CALCULATION

DECODE(SHRTRCR_ART_IND,NULL,'NO ARTICULATION RULE','N','COURSE HAS NO INSTITUTION EQUIVALENT','Y','COURSE HAS INSTITUTION EQUIVALENT')

TRANS_INST_ATTENDANCE_SEQ Unique identifier for the attendance period at this institution from which course credit was transferred. NUMBER

SHRTRCR

SHRTRCR_TRAM_SEQ_NO



Ver: 9.1