Skip Navigation

Darton State College

Darton State College Administration

Home  » Administration  » Data Warehouse  » Data Dictionaries  » Table: WSEmain/WSEyytt

Data Warehouse

Home | Search | Training | Data Dictionaries | Reports | Register | News | Email

WSEMAIN User Dictionary

Student Enrollment

Please be aware that these dictionaries consist of the complete WSE table. If you do not have access to a particular data element and need access to it, please contact us. In addition, these tables are subject to change. It would be in your best interest to check back regularly.

Table: WSEmain

Description: The enrollment table contains general information about each student registered for the term. There is only one entry in the table for each student. Information currently available includes name, address, demographics, degree and major, academic status, GPA, credit hours, test scores, and other general student information. For a current term, this information is extracted from the Banner student information system at the end of each day. For a past term, the table contains a snapshot of student information as of the last day of drop/add for the next term.

Table: WSEyytt (yy=Year, tt=Term where 02 = Spring, 05 = Summer and 08 = Fall)

Description: The enrollment table contains general information about each student registered for the term. There is only one entry in the table for each student. Information currently available includes name, address, demographics, degree and major, academic status, GPA, credit hours, test scores, and other general student information. For a current term, this information is extracted from the Banner student information system at the end of each day.

Table Data: The length of the each item is included in parenthesis after the item name. Numeric decimal field lengths are represented by the number of decimal positions before and after the decimal point (example: 999.99 indicates that there are up to three positions before the decimal point and two after). Fields with date information include the word 'Date' following them.

*Note: A data warehouse table for the current term would reflect grade, hour, GPA, and some student academic status information as of the beginning of the current term. For tables from past terms, the grade, hour, GPA, and academic status information would reflect information frozen the last day of drop/add for the next term. Affected fields are marked with asterisks (*).

Codes: The current Banner codes for the table items listed below can be referenced using the Banner form specified under the item description.