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_REG_AUDIT

Description Contains audit information for all student registration activity.

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)       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_BILLING_CREDITS Billing units associated with this section or schedule offering. NUMBER       NO
COURSE_CAMPUS Campus the student attended this schedule offering or section. VARCHAR2(3)       NO
COURSE_CAMPUS_DESC Institution campus description. VARCHAR2(30)

STVCAMP

STVCAMP_DESC

NO

NO
COURSE_CREDITS Credits associated with this course. NUMBER       NO
COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(9)

NA

NA

NO

NO
COURSE_LEVEL Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc. VARCHAR2(2)       NO
COURSE_LEVEL_DESC Course level description. VARCHAR2(30)

STVLEVL

STVLEVL_DESC

NO

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

NA

NA

NO

NO
COURSE_REFERENCE_NUMBER Computer assigned internal unique number for the schedule offering. VARCHAR2(5)       NO
COURSE_SECTION_NUMBER Sequence number used to associated the information about the unique course for the student. VARCHAR2(3)

NA

NA

NO

NO
COURSE_VERSION_NUMBER This field identifies the course version number. VARCHAR2(30)

NA

NA

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. 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
GRADE_COMMENT Value for the grade comment or result code added for this course. VARCHAR2(7)       NO
GRADE_COMMENT_DESC Grade comment descriptive text. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GRADE_TYPE Grade mode associated with this section or offering of the course. VARCHAR2(1)       NO
GRADE_TYPE_DESC Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
LAST_DATE_CHANGE Date this record was last added or changed. DATE       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       NO
REGISTRATION_ERROR_FLAG Indicates an error is associated with this section registration. VARCHAR2(1)       NO
REGISTRATION_ERROR_MESSAGE Text of the message associated with an error for this section registration. VARCHAR2(200)       NO
REGISTRATION_SOURCE This field shows the source of the audit record. VARCHAR2(4)       NO
REGISTRATION_STATUS Course registration status associated with this section. VARCHAR2(2)       NO
REGISTRATION_STATUS_DATE Date associated with the course registration status of this section. DATE       NO
REGISTRATION_STATUS_DESC Course registration status description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
REGISTRATION_USER_ID Person user identification number who processed the registration request for this section. VARCHAR2(30)       NO
SECTION_ADD_DATE Date the student registered in this section. DATE       NO
SEQUENCE_NUMBER Sequence number for the records for the course reference number for this student in this academic period. NUMBER       NO
SUBJECT Main instructional subject area for this course. VARCHAR2(4)

NA

NA

NO

NO
SUBJECT_DESC Subject code description. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(30)

NA

NA

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: