Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner Operational Data Store
Composite View Target: AS_ENROLLMENT_WITHDRAWAL

Description Source composite view contains the academic period based fields needed to support the creation of the enrollment withdrawal reporting view.
Key & Frequency One row per person per academic period per withdrawal record 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(6)

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(30)

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(4)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

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

SFRWDRL

SFRWDRL_ACTIVITY_DATE

CURRENT_DATE   DATE    
DOMAIN_VALUE Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

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

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(30)

STVESTS

STVESTS_DESC

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

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

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

NA

NA

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

NA

NA

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

SFRWDRL

SFRWDRL_PIDM

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(240)

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(2)

SFRWDRL

SFRWDRL_WDRL_CODE

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

STVWDRL

STVWDRL_DESC

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

NA

NA



Ver: