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

Banner Operational Data Store
Composite View Target: AS_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

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)

SHRTRCE

SHRTRCE_TERM_CODE_EFF

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
COURSE_REFERENCE_NUMBER Unique number used to identify the transfer course. VARCHAR2(51)

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

NO

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

NA

SYSDATE

NO

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

NA

NA

NO

NO
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

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
MULTIPLE_COURSE_EQUIVALENT Indicates there was more than one transfer course for the academic period entered on the Transfer Articulation Rules Form (SHATAEQ). VARCHAR2(2)

SHRTRCR

SHRTRCR_DUPLICATE

NO

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

SHRTRCR

SHRTRCR_PIDM

NO

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

SHRTRCR

SHRTRCR_PROGRAM

NO

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

SMRPRLE

SMRPRLE_PROGRAM_DESC

NO

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

SHRTRCR

SHRTRCR_ART_IND

NO

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

SHRTRCR

SHRTRCR_ACTIVITY_DATE

NO

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

SHRTRCR

SHRTRCR_TRANS_CREDIT_HOURS

NO

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

SHRTRCR

SHRTRCR_TRANS_GRADE

NO

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

SHRTRCR

SHRTRCR_GROUP

NO

NO
TRANSFER_COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(120)

CALCULATION

SHRTRCR_TRANS_COURSE_NAME||SHRTRCR_TRANS_COURSE_NUMBERS

NO

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

SHRTRIT

SHRTRIT_SBGI_CODE

NO

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

STVSBGI

STVSBGI_DESC

NO

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

SHRTRIT

SHRTRIT_SEQ_NO

NO

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

SHRTRCR

SHRTRCR_TRANS_COURSE_NUMBERS

NO

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

SHRTRCR

SHRTRCR_SEQ_NO

NO

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

SHRTRCR

SHRTRCR_TRANS_COURSE_NAME

NO

NO
TRANSFER_COURSE_TITLE Transfer institution course title. VARCHAR2(30)

SHRTRCR

SHRTRCR_TCRSE_TITLE

NO

NO
TRANS_ARTICULATION_RULE_DESC Description for the articulation built. VARCHAR2(36)       NO
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

NO

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: