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_ATTR_TRANS

Description Source composite view contains course attribute information that indicates which courses may be used to satisfy outcome requirements. This may be for institutional or for transfer subjects completed by the student.

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)

SHRTRCR

SHRTRCR_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Description of the academic period. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
ACADEMIC_YEAR Academic year associated with the academic period. VARCHAR2(30)

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Description for this academic year. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COURSE_ATTRIBUTE Identifies the type of degree course attribute will be satisfied by successful completion of this course. VARCHAR2(4)

SHRTATT

SHRTATT_ATTR_CODE

NO

NO
COURSE_ATTRIBUTE_DESC Description for the degree course attribute. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(9)       NO
COURSE_NUMBER Course number associated with the subject for the course. VARCHAR2(5)

SHRTRCE

SHRTRCE_CRSE_NUMB

NO

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

CALCULATION

SHRTATT_TRIT_SEQ_NO||TO_CHAR(SHRTATT_TRAM_SEQ_NO,'FM09')||TO_CHAR(NVL(SHRTATT_TRCR_SEQ_NO,0),'FM009')||TO_CHAR(SHRTATT_TRCE_SEQ_NO,'FM009')

NO

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

SHRTATT

SHRTATT

SHRTATT_TRCE_SEQ_NO

SHRTATT_TRIT_SEQ_NO||SHRTATT_TRAM_SEQ_NO||SHRTATT_TRCR_SEQ_NO||SHRTATT_TRCE_SEQ_NO

NO

NO

NO
CURRENT_DATE CURRENT_DATE: The current date. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

NO

NO
INSTITUTION_COURSE_IND This field stores a Y or N to indicate if the course was taken at the institution or not. VARCHAR2(1)

CALCULATION

DECODE(SHRTATT_PIDM, NULL, 'Y', 'N')

NO

NO
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

NO

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

SHRTATT

SHRTATT_PIDM

NO

NO
SUBJECT Identifies the main instructional subject area for this course. VARCHAR2(4)

SHRTRCE

SHRTRCE_SUBJ_CODE

NO

NO
SUBJECT_DESC Description for the subject code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_DESC Description of the sub academic period. VARCHAR2(30)

NA

NA

NO

NO
TRANSFER_COURSE_IND This field stores a Y or N to indicate if the course is a transfer course or not. VARCHAR2(1)

CALCULATION

DECODE(SHRTATT_PIDM, NULL, 'N', 'Y')

NO

NO
ZONE_VALUE The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

NO

NO


Ver: