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

SGHE Banner Operational Data Store
Reporting View Target: STUDENT_COURSE_REG_AUDIT

Description Contains audit information for all student registration activity.
Key & Frequency One row per sequence number per course request number per student per academic period.
Recommended Search Columns ACADEMIC_PERIOD
SUBJECT, COURSE_NUMBER
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
PERSON_UID
PERSON_UID, ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, SEQUENCE_NUMBER

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)

SFRSTCA

SFRSTCA_TERM_CODE

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)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

BLOCK_REGISTRATION Identifies the block registration code that was assigned to the student that had the student register for this student course. VARCHAR2(63)

SFRSTCA

SFRSTCA_BLCK_CODE

BLOCK_REGISTRATION_DESC Description for the block registration code. VARCHAR2(255)

STVBLCK

STVBLCK_DESC

BLOCK_REG_SEQUENCE_NUMBER Sequence number that uniquely identifies the rule for block assignment. NUMBER

SFRSTCA

SFRSTCA_BRDH_SEQ_NUM

COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_COLL_CODE

SSBOVRR_COLL_CODE

COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

COURSE_BILLING_CREDITS Billing units associated with this section or schedule offering. NUMBER

SFRSTCA

SFRSTCA_BILL_HR

COURSE_CAMPUS Campus the student attended this schedule offering or section. VARCHAR2(63)

SFRSTCA

SFRSTCA_CAMP_CODE

COURSE_CAMPUS_DESC Institution campus description. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

COURSE_CREDITS Credits associated with this course. NUMBER

SFRSTCA

SFRSTCA_CREDIT_HR

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

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

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

SFRSTCA

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

SSBSECT

SSBSECT_CRSE_NUMB

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

SFRSTCA

SFRSTCA_CRN

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

SSBSECT

SSBSECT_SEQ_NUMB

COURSE_VERSION_NUMBER Course version number. VARCHAR2(255)

NA

NA

DEPARTMENT Department responsible for the major subject area of a student course or associated with the major within the student academic study. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_DEPT_CODE

SSBOVRR_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

DIVISION Division responsible for the instructional delivery of this course or section. VARCHAR2(63)

SCBCRSE

SSBOVRR

SCBCRSE_DIVS_CODE

SSBOVRR_DIVS_CODE

DIVISION_DESC Name of the division. VARCHAR2(255)

STVDIVS

STVDIVS_DESC

GRADE_COMMENT Value for the grade comment or result code added for this course. VARCHAR2(63)

SFRSTCA

SFRSTCA_GCMT_CODE

GRADE_COMMENT_DESC Grade comment descriptive text. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

GRADE_TYPE Grade mode associated with this section or offering of the course. VARCHAR2(63)

SFRSTCA

SFRSTCA_GMOD_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

LAST_DATE_CHANGE Date this record was last added or changed. DATE

SFRSTCA

SFRSTCA_ACTIVITY_DATE

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

SFRSTCA

SFRSTCA_PIDM

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

NA

NA

REGISTRATION_ERROR_FLAG Indicates an error is associated with this section registration. VARCHAR2(1)

SFRSTCA

SFRSTCA_ERROR_FLAG

REGISTRATION_ERROR_MESSAGE Text of the message associated with an error for this section registration. VARCHAR2(255)

SFRSTCA

SFRSTCA_MESSAGE

REGISTRATION_SOURCE Identifies the source of the audit record as either temporary or base from the registration input form. VARCHAR2(63)

SFRSTCA

SFRSTCA_SOURCE_CDE

REGISTRATION_STATUS Course registration status associated with this section. VARCHAR2(63)

SFRSTCA

SFRSTCA_RSTS_CODE

REGISTRATION_STATUS_DATE Date associated with the course registration status of this section. DATE

SFRSTCA

SFRSTCA_RSTS_DATE

REGISTRATION_STATUS_DESC Course registration status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

REGISTRATION_USER_ID Person user identification number who processed the registration request for this section. VARCHAR2(63)

SFRSTCA

SFRSTCA_USER

SECTION_ADD_DATE Date the student registered in this section. DATE

SFRSTCA

SFRSTCA_ADD_DATE

SEQUENCE_NUMBER Sequence number for the records for the course reference number for this student in this academic period. NUMBER

SFRSTCA

SFRSTCA_SEQ_NUMBER

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

SSBSECT

SSBSECT_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(255)

STVSUBJ

STVSUBJ_DESC

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

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA



Ver: 8.5