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

Banner Operational Data Store
Reporting View Target: ENROLLMENT_WITHDRAWAL

Description Contains student withdrawal data for persons who enrolled for the academic period but has withdrawn or been administratively withdrawn from the institution. This reporting view may be used to report how much of an academic period the person attended. Persons who have an enrollment withdrawal record will have a record in the ENROLLMENT and the ACADEMIC STUDY reporting views.
Key & Frequency One row per person per academic period per withdrawal record number.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD

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)

SFRWDRL

SFRWDRL_TERM_CODE

ACADEMIC_PERIOD_BREAK_DAYS Number of break days defined the academic period. NUMBER

SFRWDRL

SFRWDRL_ENRL_BREAK_DAYS

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_PERIOD_END_DATE Academic Period End Date. DATE

SFRWDRL

SFRWDRL_ENRL_END_DATE

ACADEMIC_PERIOD_START_DATE Academic Period Start Date. DATE

SFRWDRL

SFRWDRL_ENRL_START_DATE

ACADEMIC_PERIOD_TOTAL_DAYS Net number of days attended before the withdrawal or the number of days between the academic period start date and the student's enrollment withdrawal date. NUMBER

SFRWDRL

SFRWDRL_ENRL_DAYS

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)

STVACYR

STVACYR_DESC

ACTIVITY_DATE Date the last change were made to this record. DATE

SFRWDRL

SFRWDRL_ACTIVITY_DATE

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

NA

NA

ENROLLMENT_STATUS Student's current enrollment status for this section or schedule offering. VARCHAR2(63)

SFRWDRL

SFRWDRL_ESTS_CODE

ENROLLMENT_STATUS_DATE Date for the last update to enrollment status. DATE

SFRWDRL

SFRWDRL_ESTS_DATE

ENROLLMENT_STATUS_DESC Student's enrollment status description. VARCHAR2(255)

STVESTS

STVESTS_DESC

ENROLLMENT_UPDATE_USER User who made the last updated to this record. VARCHAR2(63)

SFRWDRL

SFRWDRL_USER

ENROLLMENT_WITHDRAWAL_DATE Date the student's enrollment status was changed to show the student as withdrawn for this academic period. DATE

SFRWDRL

SFRWDRL_EFF_WDRL_DATE

FINANCIAL_AID_PROCESSED_IND Indicates that the student withdrawal was processed by the Financial Aid Office. VARCHAR2(1)

SFRWDRL

SFRWDRL_PROCESSED_IND

FINANCIAL_AID_REGULATORY_IND Identified withdrawal processed because of government guidelines. In the US, this withdrawal data is required to be compliant for Title IV regulations. VARCHAR2(1)

SFRWDRL

SFRWDRL_TIV_IND

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)

NA

NA

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

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

SFRWDRL

SFRWDRL_PIDM

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

NA

NA

STUDENT_ATTEND_BREAK_DAYS Number of days during the student's enrollment on which classes were on break or not in session during this academic period. Number of days the student was not expected to attend class. NUMBER

SFRWDRL

SFRWDRL_ATTEND_BREAK_DAYS

STUDENT_ATTEND_DAYS Number of days during the student's enrollment days on which classes were held or in session during this academic period. Number of days the student was expected to attend class. NUMBER

SFRWDRL

SFRWDRL_ATTEND_DAYS

STUDENT_ATTEND_LEAVE_DAYS Number of approved leave days for the student this academic period. NUMBER

SFRWDRL

SFRWDRL_LEAVE_DAYS

STUDENT_ATTEND_PERCENT Percent of enrollment period that student attended. NUMBER

SFRWDRL

SFRWDRL_PERCENT_ATTEND

STUDENT_ORIGINAL_CHARGES Student total original institutional charges for this academic period. NUMBER

SFRWDRL

SFRWDRL_ORIGINAL_CHARGES

STUDENT_OTHER_CHARGES Other institutional costs not in accounts receivable. NUMBER

SFRWDRL

SFRWDRL_OTHER_COSTS

WITHDRAWAL_COMMENT Comment associated with this withdrawal record. VARCHAR2(4000)

SFRWDRL

SFRWDRL_COMMENT

WITHDRAWAL_RECORD_NUMBER Sequence number that is used with the PERSON_UID and ACADEMIC_PERIOD to identify a unique withdrawal record. NUMBER

SFRWDRL

SFRWDRL_SEQ_NO

WITHDRAWAL_RECORD_TYPE Institution defined withdrawal type assigned when the person is identified as withdrawn for the academic period. VARCHAR2(63)

SFRWDRL

SFRWDRL_WDRL_CODE

WITHDRAWAL_RECORD_TYPE_DESC Description for the type of withdrawal noted for the person. VARCHAR2(255)

STVWDRL

STVWDRL_DESC



Ver: 9.1