Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: STUDENT_COURSE_ATTRIBUTE

Description Contains data about the student course attributes associated with a subject and course number completed by the person. Reporting requirements for these student course attributes include grouping the courses to complete specific academic completion requirements and reporting on those.
Key & Frequency One row per person per academic period per course reference number per course attribute.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID, COURSE_REFERENCE_NUMBER
PERSON_UID, SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD

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 and was recorded to the student history record. VARCHAR2(63)

SHRATTR

SHRTRCR

SHRATTR_TERM_CODE

SHRTRCR_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

COURSE_ATTRIBUTE Type of degree course attribute satisfied by successful completion of this course. VARCHAR2(63)

SHRATTR

SHRTATT

SHRATTR_ATTR_CODE

SHRTATT_ATTR_CODE

COURSE_ATTRIBUTE_DESC Degree course attribute description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB

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

SHRTCKN

SHRTRCE

SHRTCKN_CRSE_NUMB

SHRTRCE_CRSE_NUMB

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

CALCULATION

SHRATTC

SHRTCKN

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

SHRATTC_CRN

SHRTCKN_CRN

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

SHRATTR

SHRTATT

SHRATTR_TCKN_SEQ_NO

SHRTATT_TRIT_SEQ_NO||SHRTATT_TRAM_SEQ_NO||SHRTATT_TRCR_SEQ_NO||SHRTATT_TRCE_SEQ_NO

ID Person's identification number used to access the records associated with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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(SHRATTR_PIDM, NULL, 'N', 'Y')

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

SHRATTR

SHRTATT

SHRATTR_PIDM

SHRTATT_PIDM

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

NA

NA

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

SHRTCKN

SHRTRCE

SHRTCKN_SUBJ_CODE

SHRTRCE_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

SHRTCKN

SHRTCKN_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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



Ver: 8.0