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

Banner Operational Data Store
Reporting View Target: BLOCK_REGISTRATION_COURSE - Block Registration Course

Description Contains detail information about the block registration course reference number assigned and registration rules assigned to the student in this academic period.
Key & Frequency One row per academic period per person per block registration per course reference number
Recommended Search Columns ACADEMIC_PERIOD,COURSE_REFERENCE_NUMBER
SUBJECT,COURSE_NUMBER,ACADEMIC_PERIOD
PERSON_UID,ACADEMIC_PERIOD,BLOCK_REGISTRATION,COURSE_REFERENCE_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Identifies the academic period in which the student plans to register for the course or course section in the plan. VARCHAR2(63)

SFRBSEL

SFRBSEL_TERM_CODE

ACADEMIC_PERIOD_DESC Description for the academic period. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Identifies the academic period for which the course or course section is planned for registration. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Description for the academic period. VARCHAR2(255)

STVACYR

STVACYR_DESC

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

NA

NA

BLOCK_COURSE_RESTRICTION Identifies what type of course registration restrictions apply to this course in this block registration group. Valid values include : NR - Add/Drop Courses with No Restriction; NB - Add/Drop only Non-Block Courses; NA - Add/Drop Courses Not Available. VARCHAR2(63)

SFRBRDB

SFRBRDB_COURSE_RESTRICTION

BLOCK_COURSE_RESTRICTION_DESC Description for the type of registration restriction defined for this course. VARCHAR2(255)

CALCULATION

CASE WHEN SFRBRDB_COURSE_RESTRICTION

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

SFRBSEL

SFRBSEL_BLCK_CODE

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

STVBLCK

STVBLCK_DESC

BLOCK_REGISTRATION_OVERRIDE Identifies the override rule code to use to change the block registration code. VARCHAR2(63)

SFRBLPA

SFRBLPA_ROVR_CODE

BLOCK_REGISTRATION_USER_ID User ID of the person who inserted or last updated this record. VARCHAR2(63)

SFRBSEL

SFRBSEL_USER_ID

BLOCK_REGISTRATION_USER_NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_FORMAT_NAME

BLOCK_REGISTRATION_USER_UID System generated internal ID for the person who created the plan. This may be the student or one of the student's advisors. NUMBER

SPRIDEN

SPRIDEN_PIDM

BLOCK_REG_ACTIVITY_DATE Date this record was inserted or last updated. DATE

SFRBSEL

SFRBSEL_ACTIVITY_DATE

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

SFRBKOP

SFRBKOP_SURROGATE_ID

BLOCK_REG_DATA_ORIGIN Source system or process that created or last updated this record. VARCHAR2(63)

SFRBSEL

SFRBSEL_DATA_ORIGIN

BLOCK_REG_OVERRIDE_DESC Description for the block registration restriction override. VARCHAR2(255)

STVROVR

STVROVR_DESC

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

SFRBSEL

SFRBSEL_BRDH_SEQ_NUM

BLOCK_REG_VERSION_NUMBER Incremented number used for optimistic locking. NUMBER

SFRBSEL

SFRBSEL_VERSION

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

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

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

SSBSECT

SSBSECT_CRSE_NUMB

COURSE_REFERENCE_NUMBER Sequence number that uniquely identifies the course section in this block registration assignment. VARCHAR2(63)

SSRBLCK

SSRBLCK_CRN

CRSE_REFERENCE_NUMBER_OPT_IND Indicates whether this course reference number is optional during registration. VARCHAR2(1)

SFRBKOP

SFRBKOP_OPTIONAL_CDE

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

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

SFRBSEL

SFRBSEL_BPDI_CODE

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERMIT_BLOCK_REG_OVERRIDE_IND Indicates if the student may change the selected block registration code. VARCHAR2(1)

SFRPABC

SFRPABC_BLOCK_RESTRICTION_IND

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

SFRBSEL

SFRBSEL_PIDM

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

NA

NA

STUDY_PATH_SEQUENCE Key sequence of the study path in the Block Web Registration. NUMBER

SFRBSEL

SFRBSEL_KEY_SEQNO

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)

SSBSECT

SSBSECT_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

STVPTRM

STVPTRM_DESC



Ver: 9.1