Skip Navigation

Darton State College

Darton State College Administration |

Home  » Administration  » Data Warehouse  » Data Dictionaries  » Table WSSmain/WSSyytt

Data Warehouse

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

WSSMAIN User Dictionary

Student Statistics

*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 (*).

Please be aware that these dictionaries consist of the complete WSS 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 WSSmain

Description: The student statistics table contains aggregate information by term. Please refer to the User Dictionary description of the table for the table contents, as it is rather extensive. 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 WSSyytt (yy=Year, tt=Term where 02 = Spring, 05 = Summer and 08 = Fall)

Description: The student statistics table contains aggregate information by term. Please refer to the User Dictionary description of the table for the table contents, as it is rather extensive. 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.

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