Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE 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
ACADEMIC_PERIOD Academic period or time frame this degree course attribute applied to this course. VARCHAR2(6)

SHRTRCR

SHRTRCR_TERM_CODE

ACADEMIC_PERIOD_DESC Description of the academic period. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Description for this academic year. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SHRTATT

SHRTATT_ATTR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

COURSE_IDENTIFICATION Combined subject code and course number that identifies the instructional content of this course. VARCHAR2(9)

CALCULATION

SHRTRCE_SUBJ_CODE||SHRTRCE_CRSE_NUMB

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

SHRTRCE

SHRTRCE_CRSE_NUMB

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

COURSE_SEQUENCE_NUMBER Sequence number used to associated the information about the unique course for the student. NUMBER(3)

SHRTATT

SHRTATT_TRCE_SEQ_NO

SHRTATT_TRIT_SEQ_NO||SHRTATT_TRAM_SEQ_NO||SHRTATT_TRCR_SEQ_NO||SHRTATT_TRCE_SEQ_NO

CURRENT_DATE CURRENT_DATE: The current date. DATE

NA

SYSDATE

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

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

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

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

PERSON_UID System generated unique internal identification number assigned to this person. NUMBER(8)

SHRTATT

SHRTATT_PIDM

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

SHRTRCE

SHRTRCE_SUBJ_CODE

SUBJECT_DESC Description for the subject code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

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

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



Ver: 8.0