Skip Navigation

Darton State College

Darton State College Administration

Home  » Administration  » Data Warehouse  » Data Dictionaries  » Table: WSCmain/WSCyytt

Data Warehouse

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

WSCMAIN User Dictionary

Course Data

Please be aware that these dictionaries consist of the complete WSC 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: WSCmain

Description: The course table consists of student and course information extracted from the Banner system. There exists one entry for each course in which a student is registered. For example, if a student were registered for three classes, there would exist three entries in the table for the student. For the current term or for next 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: WSCyytt (yy=Year, tt=Term where 02 = Spring, 05 = Summer and 08 = Fall)

Description: The course table consists of student and course information extracted from the Banner system. There exists one entry for each course in which a student is registered. For example, if a student were registered for three classes, there would exist three entries in the table for the student. For the current term or for next 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 Data: The length of each data item is included in parenthesis after the item name. 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.