Darton State College
Home » Administration » Data Warehouse » Data Dictionaries » Table: WSCmain/WSCyytt
Data Warehouse
Home | Search | Training | Data Dictionaries | Reports | Register | News | Email
WSCMAIN Student Course Table
(MUST BE ACCESSED THROUGH HOUSE)
User Dictionary
Revision Date: October 2, 2000
- WSC_TERM_CODE (6- YYYYMM)
- Registration term code in the format of YYYYMM, where YYYY is the year and MM is the month.
- See BANNER form STVTERM for valid codes.
- See BANNER form STVTERM for valid codes.
- Registration term code in the format of YYYYMM, where YYYY is the year and MM is the month.
- WSC_LINK Numeric(8)
- A data item used to link appropriate data warehouse tables.
- A data item used to link appropriate data warehouse tables.
- WSC_SYSDATE (Date)
- Date this course table was created.
- Date this course table was created.
- WSC_CRN (5)
- Course reference number.
- Course reference number.
- WSC_RSTS_CODE (2)
- Course registration status.
- See BANNER form STVRSTS for valid codes.
- See BANNER form STVRSTS for valid codes.
- Course registration status.
- WSC_RSTS_DATE (Date)
- Date the course registration status was established.
- Date the course registration status was established.
- WSC_ERROR_FLAG (1)
- Identifies the error checking associated with the course
registration, if an error occurred.
- D - Deleted
- F - Fatal error
- O - Override
- blank - No error
- Identifies the error checking associated with the course
registration, if an error occurred.
- WSC_MESSAGE (25)
- A warning or error message associated with the course
registration.
- A warning or error message associated with the course
registration.
- WSC_BILL_HR Numeric(4)
- Course billing hours.
- Course billing hours.
- WSC_CREDIT_HR Numeric(4)
- Course credit hours.
- Course credit hours.
- WSC_GMOD_CODE (1)
- Grade mode of course registration.
- See BANNER form STVGMOD for valid codes.
- See BANNER form STVGMOD for valid codes.
- Grade mode of course registration.
- WSC_GRDE_CODE (3)
- Initial grade code of course (A, B, C, W, etc.). This
will be blank unless grades for the term have been processed. Then
it will contain the initial grade given by the instructor when
grades are processed at the end of the quarter.
- See BANNER form SHAGRDE for valid codes.
- See BANNER form SHAGRDE for valid codes.
- Initial grade code of course (A, B, C, W, etc.). This
will be blank unless grades for the term have been processed. Then
it will contain the initial grade given by the instructor when
grades are processed at the end of the quarter.
- WSC_GRDE_DATE (Date)
- Date that grade was entered.
- Date that grade was entered.
- WSC_ADD_DATE (Date)
- Date that course was added for the student.
- Date that course was added for the student.
- WSC_ACTIVITY_DATE (Date)
- Date of creation or last update of the student's course
registration information.
- Date of creation or last update of the student's course
registration information.
- WSC_LEVL_CODE (2)
- Level code of the student.
- US - Undergraduate Semester
- See BANNER form STVLEVL for valid codes.
- Level code of the student.
- WSC_USER (30)
- Not available at this time.
- Not available at this time.
- WSC_NAME_LFM (35)
- Student's last name, first name, and middle initial.
- Student's last name, first name, and middle initial.
- WSC_NAME_FML (35)
- Student's first name, middle initial, and last name.
- Student's first name, middle initial, and last name.
- WSC_STREET_LINE1 (30)
- Street address line 1 (permanent mailing address).
- Contains "****** CONFIDENTIAL ON *******" if
student has requested confidentiality.
- Contains "****** CONFIDENTIAL ON *******" if
student has requested confidentiality.
- Street address line 1 (permanent mailing address).
- WSC_STREET_LINE2 (30)
- Street address line 2 (permanent mailing address).
- Contains "****** CONFIDENTIAL ON *******" if
student has requested confidentiality.
- Contains "****** CONFIDENTIAL ON *******" if
student has requested confidentiality.
- Street address line 2 (permanent mailing address).
- WSC_STREET_LINE3 (30)
- Street address line 3 (permanent mailing address).
- Contains "****** CONFIDENTIAL ON *******" if
student has requested confidentiality.
- Contains "****** CONFIDENTIAL ON *******" if
student has requested confidentiality.
- Street address line 3 (permanent mailing address).
- WSC_CITY (20)
- City name (permanent mailing address).
- Contains "XXXXXXXXXXXXXXXXXXXX" if student has
requested confidentiality.
- Contains "XXXXXXXXXXXXXXXXXXXX" if student has
requested confidentiality.
- City name (permanent mailing address).
- WSC_STATE_CODE (3)
- State code (permanent mailing address).
- See BANNER form STVSTAT for valid codes.
- Contains "XXX" if student has requested
confidentiality.
- State code (permanent mailing address).
- WSC_ZIP_CODE (10)
- Zipcode (permanent mailing address).
- See BANNER form GTVZIPC for valid codes.
- Contains "00000" if student has requested
confidentiality.
- Zipcode (permanent mailing address).
- WSC_CSZ (45)
- The concatenated city, state and zip of the student's address.
- Ex. Albany, GA 31707
- Ex. Albany, GA 31707
- The concatenated city, state and zip of the student's address.
- WSC_PHONE_MA (12)
- Phone number [format is: 999-999-9999] (for mailing address).
- Contains blanks if student has requested
confidentiality.
- Contains blanks if student has requested
confidentiality.
- Phone number [format is: 999-999-9999] (for mailing address).
- WSC_E_MAIL (90)
- Darton assigned e-mail address of student.
- Darton assigned e-mail address of student.
- WSC_SS_NUMBER (9)
- Social security number.
- Social security number.
- WSC_DEGREE (6)
- Code of the degree that student is seeking.
- See BANNER form STVDEGC for valid codes.
- See BANNER form STVDEGC for valid codes.
- Code of the degree that student is seeking.
- WSC_DEGREE_DESC (24)
- Degree description.
- Degree description.
- WSC_COLLEGE (2)
- College code of the student.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code of the student.
- WSC_COLLEGE_DESC (24)
- Student's college description.
- Student's college description.
- WSC_DEPARTMENT (4)
- Department code of the student.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code of the student.
- WSC_DEPARTMENT_DESC (24)
- Student's department description.
- Student's department description.
- WSC_MAJOR (4)
- Student's major code.
- See BANNER form STVMAJR for valid codes.
- See BANNER form STVMAJR for valid codes.
- Student's major code.
- WSC_MAJOR_DESC (24)
- Description of major.
- Description of major.
- WSC_SGBSTDN_SESS_CODE (1)
- Student session indicator.
- X - Combined
- Y - Day
- Z - Evening
- Student session indicator.
- WSC_SGBSTDN_SESS_DESC (30)
- Description of session code.
- Description of session code.
- WSC_FIRST_TERM (6-yyyymm)
- The first term in which the student registered or, if never
registered, the term in which the student was admitted.
- See BANNER form STVTERM for valid codes.
- See BANNER form STVTERM for valid codes.
- The first term in which the student registered or, if never
registered, the term in which the student was admitted.
- WSC_LAST_TERM (6-yyyymm)
- The last term in which grades were processed for a student,
including withdrawals.
- See BANNER form STVTERM for valid codes.
- See BANNER form STVTERM for valid codes.
- The last term in which grades were processed for a student,
including withdrawals.
- WSC_ADVISOR_PIDM (8)
- Banner's internal identification number for a student's advisor.
- Banner's internal identification number for a student's advisor.
- WSC_ADVISOR_NAME (35)
- Advisor's name (first name, middle initial, last name)
- Advisor's name (first name, middle initial, last name)
- WSC_CLASSIFICATION (3)
- Classification of student based on hours earned at the time
table was created.
- See BANNER form STVCLAS for valid codes.
- See BANNER form STVCLAS for valid codes.
- Classification of student based on hours earned at the time
table was created.
- WSC_CLASSIFICATION_DESC (30)
- Description of classification code.
- Description of classification code.
- WSC_LEARN_SUP (1)
- Identifies if the student currently has learning support
requirements.
- Y - Yes
- N - No.
- Identifies if the student currently has learning support
requirements.
- WSC_LEARN_SUP_EXITED (1)
- Identifies whether student has existed Learning Support.
- Y - Yes
- N - No
- blank - No Learning Support required.
- Identifies whether student has existed Learning Support.
- WSC_LEARN_SUP_EXITED_TERM (6)
- The term the student exited Learning Support.
- See BANNER form STVTERM for valid codes.
- See BANNER form STVTERM for valid codes.
- The term the student exited Learning Support.
- WSC_CRSE_TITLE (30)
- Course title.
- Course title.
- WSC_SUBJ_CODE (4)
- Course subject code. (Example: BIOL, ENGL, HIST, ART)
- See BANNER form STVSUBJ for valid codes.
- See BANNER form STVSUBJ for valid codes.
- Course subject code. (Example: BIOL, ENGL, HIST, ART)
- WSC_SUBJ_DESC (30)
- The subject description of the course taken by the student.
- The subject description of the course taken by the student.
- WSC_CRSE_NUMB (5)
- Course number associated with the course subject. (Example:
BIOL 1110)
- Course number associated with the course subject. (Example:
BIOL 1110)
- WSC_SECTION (4)
- Course section number.
- Course section number.
- WSC_PART_TERM_CODE (1)
- Code indicating which part of term course meets.
- See BANNER form STVPTRM for valid codes.
- See BANNER form STVPTRM for valid codes.
- Code indicating which part of term course meets.
- WSC_PART_TERM_DESC (30)
- The description of the part of the term during which the course
meets.
- The description of the part of the term during which the course
meets.
- WSC_CAMPUS_CODE (1)
- Campus code where course meets.
- See BANNER form STVCAMP for valid codes.
- See BANNER form STVCAMP for valid codes.
- Campus code where course meets.
- WSC_CAMPUS_DESC (30)
- The description of the campus code where course meets.
- The description of the campus code where course meets.
- WSC_COURSE_COLLEGE (2)
- College code in which the course is taught.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code in which the course is taught.
- WSC_COURSE_COLLEGE_DESC (30)
- College description of the course.
- College description of the course.
- WSC_COURSE_DEPARTMENT (4)
- Department code in which the course is taught.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code in which the course is taught.
- WSC_COURSE_DEPARTMENT_DESC (30)
- Department description of the course.
- Department description of the course.
- WSC_SESS_CODE (1)
- Session code for the course.
- See BANNER form STVSESS for valid codes.
- See BANNER form STVSESS for valid codes.
- Session code for the course.
- WSC_COURSE_MAX_ENROLL Numeric(4)
- The maximum number of students permitted in a given class.
- The maximum number of students permitted in a given class.
- WSC_SEATS_USED Numericr(4)
- Number of seats taken in a given class.
- Number of seats taken in a given class.
- WSC_SEATS_AVAIL Numeric(4)
- Number of seats that remain available in a given class.
- Number of seats that remain available in a given class.
- WSC_COURSE_PERCENT_FULL (99999.99)
- Indicates the percent full of the given class. This field is
displayed as an integer, but should be read as a percent. (EX. If
the field contains 34.5 that means the class is 34.5% full.)
- Indicates the percent full of the given class. This field is
displayed as an integer, but should be read as a percent. (EX. If
the field contains 34.5 that means the class is 34.5% full.)
- WSC_INSTRUCTOR_PIDM (8)
- Banner's internal identification number for the course
instructor.
- Banner's internal identification number for the course
instructor.
- WSC_INSTRUCTOR_NAME_LFM (35)
- Instructor's name (in last name, first name, and middle initial
order).
- Name will be 'xxxxxxxxxxxxxxxxxxx if no
instructor is assigned.
- Name will be 'xxxxxxxxxxxxxxxxxxx if no
instructor is assigned.
- Instructor's name (in last name, first name, and middle initial
order).
- WSC_INSTRUCTOR_NAME_FML (35)
- Instructor's name (in first name, middle initial, and last name
order).
- Name will be 'xxxxxxxxxxxxxxxxxxx if no
instructor is assigned.
- Name will be 'xxxxxxxxxxxxxxxxxxx if no
instructor is assigned.
- Instructor's name (in first name, middle initial, and last name
order).
- WSC_INSTRUCTOR_COLLEGE (2)
- College code of the instructor.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code of the instructor.
- WSC_INSTRUCTOR_COLLEGE_DESC (24)
- Instructor's college description.
- Instructor's college description.
- WSC_INSTRUCTOR_DEPARTMENT (4)
- Department code of the instructor.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code of the instructor.
- WSC_INSTRUCTOR_DEPARTMENT_DESC (24)
- Instructor's department description.
- Instructor's department description.
- WSC_INSTRUCTOR_E_MAIL (90)
- Instructor's e-mail address (will be populated only if e-mail
address is listed in the GSU Faculty/Staff Directory).
- Instructor's e-mail address (will be populated only if e-mail
address is listed in the GSU Faculty/Staff Directory).
- WSC_INSTRUCTOR_COUNT Numeric(2)
- Instructor's department description.
- Instructor's department description.
- WSC_BLDG_CODE (6)
- Code of building in which the course section meets.
- See BANNER form STVBLDG for valid codes.
- See BANNER form STVBLDG for valid codes.
- Code of building in which the course section meets.
- WSC_BLDG_NAME (30)
- Description of building in which the course section meets.
- Description of building in which the course section meets.
- WSC_ROOM_CODE (10)
- Room code in which the course section meets.
- See BANNER form SLQROOM for valid room/building codes.
- See BANNER form SLQROOM for valid room/building codes.
- Room code in which the course section meets.
- WSC_BEGIN_TIME (4)
- Beginning time the course section starts.
- Beginning time the course section starts.
- WSC_END_TIME (4)
- Ending time the course section ends.
- Ending time the course section ends.
- WSC_SUN_DAY (1)
- Sunday class meeting indicator.
- U - meets on Sunday.
- blank - does not meet on Sunday.
- Sunday class meeting indicator.
- WSC_MON_DAY (1)
- Monday class meeting indicator.
- M - meets on Monday.
- blank - does not meet on Monday.
- Monday class meeting indicator.
- WSC_TUE_DAY (1)
- Tuesday class meeting indicator.
- T - meets on Tuesday.
- blank - does not meet on Tuesday.
- Tuesday class meeting indicator.
- WSC_WED_DAY (1)
- Wednesday class meeting indicator.
- W - meets on Wednesday.
- blank - does not meet on Wednesday.
- Wednesday class meeting indicator.
- WSC_THU_DAY (1)
- Thursday class meeting indicator.
- R - meets on Thursday.
- blank - does not meet on Thursday.
- Thursday class meeting indicator.
- WSC_FRI_DAY (1)
- Friday class meeting indicator.
- F - meets on Friday.
- blank - does not meet on Friday.
- Friday class meeting indicator.
- WSC_SAT_DAY (1)
- Saturday class meeting indicator.
- S - meets on Saturday.
- blank - does not meet on Saturday.
- Saturday class meeting indicator.
- WSC_BLDG_CODE_2 (6)
- Code of building in which the course section meets during second
time slot.
- See BANNER form STVBLDG for valid codes.
- See BANNER form STVBLDG for valid codes.
- Code of building in which the course section meets during second
time slot.
- WSC_BLDG_NAME_2 (30)
- Description of building in which the course section meets during
second time slot.
- Description of building in which the course section meets during
second time slot.
- WSC_ROOM_CODE_2 (10)
- Room code in which the course section meets during second time
slot.
- See BANNER form SLQROOM for valid room/building codes.
- See BANNER form SLQROOM for valid room/building codes.
- Room code in which the course section meets during second time
slot.
- WSC_BEGIN_TIME_2 (4)
- Beginning time the course section starts during second time
slot.
- Beginning time the course section starts during second time
slot.
- WSC_END_TIME_2 (4)
- Ending time the course section ends during second time slot.
- Ending time the course section ends during second time slot.
- WSC_SUN_DAY_2 (1)
- Sunday class meeting indicator for second time slot.
- U - meets on Sunday.
- blank - does not meet on Sunday.
- Sunday class meeting indicator for second time slot.
- WSC_MON_DAY_2 (1)
- Monday class meeting indicator for second time slot.
- M - meets on Monday.
- blank - does not meet on Monday.
- Monday class meeting indicator for second time slot.
- WSC_TUE_DAY_2 (1)
- Tuesday class meeting indicator for second time slot.
- T - meets on Tuesday.
- blank - does not meet on Tuesday.
- Tuesday class meeting indicator for second time slot.
- WSC_WED_DAY_2 (1)
- Wednesday class meeting indicator for second time slot.
- W - meets on Wednesday.
- blank - does not meet on Wednesday.
- Wednesday class meeting indicator for second time slot.
- WSC_THU_DAY_2 (1)
- Thursday class meeting indicator for second time slot.
- R - meets on Thursday.
- blank - does not meet on Thursday.
- Thursday class meeting indicator for second time slot.
- WSC_FRI_DAY_2 (1)
- Friday class meeting indicator for second time slot.
- F - meets on Friday.
- blank - does not meet on Friday.
- Friday class meeting indicator for second time slot.
- WSC_SAT_DAY_2 (1)
- Saturday class meeting indicator for second time slot.
- S - meets on Saturday.
- blank - does not meet on Saturday.
- Saturday class meeting indicator for second time slot.
- WSC_BLDG_CODE_3 (6)
- Code of building in which the course section meets during third
time slot.
- See BANNER form STVBLDG for valid codes.
- See BANNER form STVBLDG for valid codes.
- Code of building in which the course section meets during third
time slot.
- WSC_BLDG_NAME_3 (30)
- Description of building in which the course section meets during
third time slot.
- Description of building in which the course section meets during
third time slot.
- WSC_ROOM_CODE_3 (10)
- Room code in which the course section meets during third time
slot.
- See BANNER form SLQROOM for valid room/building codes.
- See BANNER form SLQROOM for valid room/building codes.
- Room code in which the course section meets during third time
slot.
- WSC_BEGIN_TIME_3 (4)
- Beginning time the course section starts during third time slot.
- Beginning time the course section starts during third time slot.
- WSC_END_TIME_3 (4)
- Ending time the course section ends during third time slot.
- Ending time the course section ends during third time slot.
- WSC_SUN_DAY_3 (1)
- Sunday class meeting indicator for third time slot.
- U - meets on Sunday.
- blank - does not meet on Sunday.
- Sunday class meeting indicator for third time slot.
- WSC_MON_DAY_3 (1)
- Monday class meeting indicator for third time slot.
- M - meets on Monday.
- blank - does not meet on Monday.
- Monday class meeting indicator for third time slot.
- WSC_TUE_DAY_3 (1)
- Tuesday class meeting indicator for third time slot.
- T - meets on Tuesday.
- blank - does not meet on Tuesday.
- Tuesday class meeting indicator for third time slot.
- WSC_WED_DAY_3 (1)
- Wednesday class meeting indicator for third time slot.
- W - meets on Wednesday.
- blank - does not meet on Wednesday.
- Wednesday class meeting indicator for third time slot.
- WSC_THU_DAY_3 (1)
- Thursday class meeting indicator for third time slot.
- R - meets on Thursday.
- blank - does not meet on Thursday.
- Thursday class meeting indicator for third time slot.
- WSC_FRI_DAY_3 (1)
- Friday class meeting indicator for third time slot.
- F - meets on Friday.
- blank - does not meet on Friday.
- Friday class meeting indicator for third time slot.
- WSC_SAT_DAY_3 (1)
- Saturday class meeting indicator for third time slot.
- S - meets on Saturday.
- blank - does not meet on Saturday.
- Saturday class meeting indicator for third time slot.
- WSC_MULT_HR_COUNT Numeric(2)
- Count of the number of different meeting times scheduled during a week.
