Site Search:

Darton State College

Home  » Administration  » Data Warehouse  » Data Dictionaries  » Table: WCCmain/WCCyytt

Data Warehouse

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

WCCMAIN Course Catalog Table
(MUST BE ACCESSED THROUGH HOUSE)

User Dictionary

Revision Date: October 2, 2000

• WCC_CRN (5)
  Course reference number.
  
  

• WCC_SYSDATE (Date)
  Date this course table was created.
  
  

• WCC_TERM_CODE (6)
  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.
    
    

• WCC_SUBJ_CODE (4)
  Course subject code. (Example: BIOL, ENGL, HIST, ART)

  • See BANNER form STVSUBJ for valid codes.
    
    

• WCC_SUBJ_DESC (30)
  The subject description of the course taken by the student.
  
  

• WCC_CRSE_NUMB (5)
  Course number associated with the course subject. (Example: BIOL 1110)
  
  

• WCC_SECTION (4)
  Course section number.
  
  

• WCC_CRSE_TITLE (30)
  Course title.
  
  

• WCC_COURSE_MAX_ENROLL (Numeric 9999)
  The maximum number of students permitted in a given class.
  
  

• WCC_SEATS_USED (Numeric 9999)
  Number of seats taken in a given class.
  
  

• WCC_SEATS_AVAIL (Numeric 9999)
  Number of seats that remain available in a given class.
  
  

• WCC_COURSE_PERCENT_FULL (Numeric 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.)
  
  

• WCC_PRIOR_ENRL (Numeric 9999)
  When the section roll process is used to create section entries based on a previous term's sections, this field is set to the enrollment from the prior term.
  
  

• WCC_PROJECTED_ENRL (Numeric 9999)
  Anticipated enrollment in the section for the term.
  
  

• WCC_CENSUS_ENRL (Numeric 9999)
  The running total of students registered for the section prior to the census enrollment date.
  
  

• WCC_CENSUS_ENRL_DATE (Date)
  This is date used to calculate census enrollment.
  
  

• WCC_PART_TERM_CODE (1)
  Code indicating which part of term course meets.

  • See BANNER form STVPTRM for valid codes.
    
    

• WCC_PART_TERM_DESC (30)
  The description of the part of the term during which the course meets.
  
  

• WCC_PART_TERM_START_DATE (Date)
  Start date for the part term code.
  
  

• WCC_PART_TERM_END_DATE (Date)
  End date for the part term code.
  
  

• WCC_PART_TERM_WEEKS (Numeric 999)
  The number of weeks in this part of the term.
  
  

• WCC_CAMPUS_CODE (1)
  Campus code where course meets.

  • See BANNER form STVCAMP for valid codes.
    
    

• WCC_CAMPUS_DESC (30)
  The description of the campus code where course meets.
  
  

• WCC_BILL_HRS (Numeric 99.99)
  Course billing hours.
  
  

• WCC_CREDIT_HRS (Numeric 99.99)
  Course credit hours.
  
  

• WCC_TOTAL_CREDIT_HRS (Numeric 999999)
  Total credit hours for the course.
  

• WCC_LECTURE_HRS (Numeric 9999.99)
  Course lecture hours.
  
  

• WCC_LAB_HRS (Numeric 9999.99)
  Course lab hours.
  
  

• WCC_CONTACT_HRS (Numeric 9999.99)
  Course contact hours.
  

• WCC_GMOD_CODE (1)
  Grade mode of course registration.

  • See BANNER form STVGMOD for valid codes.
    
    

• WCC_GMOD_DESC (30)
  Description of the grade mode for the course.
  
  

• WCC_LEVEL_CODE_UNDERGRAD (2)
  Will contain 'US'.
  
  

• WCC_COURSE_COLLEGE (2)
  College code of the course.

  • See BANNER form STVCOLL for valid codes.
    
    

• WCC_COURSE_COLLEGE_DESC (30)
  Student's college description.
  
  

• WCC_COURSE_DEPARTMENT (4)
  Department code of the course.

  • See BANNER form STVDEPT for valid codes.
    
    

• WCC_COURSE_DEPARTMENT_DESC (30)
  Course's department description.
  
  

• WCC_STATUS_CODE (1)
  The status of the section.

  • See BANNER form STVSSTS for valid codes.
    
    

• WCC_STATUS_DESC (30)
  Description of the status code.
  
  

• WCC_INSTRUCTIONAL_TYPE (1)
  The instructional type of the section being scheduled.

  • See BANNER form STVSCHD for valid codes.
    
    

• WCC_INSTRUCTIONAL_TYPE_DESC (30)
  Description of the instructional type.
  
  

• WCC_SPECIAL_APPROVAL_CODE (2)
  The type code for the type of special approval needed by a student to register for this course.

  • See BANNER form STVSAPR for valid codes.
    
    

• WCC_SPECIAL_APPROVAL_CODE_DESC (30)
  Description of the special approval.
  
  

• WCC_LINK_IDENT (2)
  Used to link other sections of the same course which must be taken concurrently.

 

• WCC_PRINT_IND (1)
  Indicator used to specify if the section is to be printed in the Schedule Report.

  • Y - Yes

  • Blank - No

 

• WCC_GRADEABLE_IND (1)
  Indicator used to specify if the section is gradeable.

  • Y - Yes

  • Blank - No

 

• WCC_TUITION_IND (1)
  Specifies whether or not the section is exempt from the assessment of tuition fees.

  • Y - Yes

  • Blank - No

 

• WCC_RESERVED_IND (1)
  Indicates whether or not reserved seats are defined for this section.

  • Y - Yes

  • Blank - No

 

• WCC_INSTR1_PIDM (8)
  Banner's internal identification number for the course's first instructor.

 

• WCC_INSTR1_ID (9)
  ID number for first instructor.

 

• WCC_INSTR1_NAME_LFM (35)
  Primary instructor's name (in last name, first name, and middle initial order).

  • Name will be 'xxxxxxxxxxxxxxxxxxx' if no instructor is assigned.

 

• WCC_INSTR1_NAME_FML (35)
  First instructor's name (in first name, middle initial, and last name order).

  • Name will be 'xxxxxxxxxxxxxxxxxxx' if no instructor is assigned.

  

• WCC_INSTR1_COLLEGE (2)
  College code of the first instructor.

  • See BANNER form STVCOLL for valid codes.

 

• WCC_INSTR1_COLLEGE_DESC (24)
  First instructor's college description.

 

• WCC_INSTR1_DEPARTMENT (4)
  Department code of the first instructor.

  • See BANNER form STVDEPT for valid codes.

 

• WCC_INSTR1_DEPARTMENT_DESC (24)
  First instructor's department description.

 

• WCC_INSTR1_PCT_RESPONS (Numeric 999)
  Percent of the course that the first instructor is responsible for.

 

• WCC_INSTR1_PCT_SESSION (Numeric 999)
  Percent of the session that the first instructor is responsible for.

 

• WCC_INSTR1_PRIMARY_IND (1)
  Indicates whether or not the first instructor is the primary instructor.

  • Y - Yes

  • Blank - No

 

• WCC_INSTR1_OVER_RIDE_IND (1)
  Used to indicate whether or not the first instructor has any conflicting classes.

  • O - Override instructor conflicts

  • Blank - Do not override instructor conflicts

 

• WCC_INSTR1_E_MAIL (90)
  First instructor's e-mail address.

 

• WCC_INSTR2_PIDM (8)
  Banner's internal identification number for the course's second instructor.

 

• WCC_INSTR2_ID (9)
  ID number for second instructor.

 

• WCC_INSTR2_NAME_LFM (35)
  Second instructor's name (in last name, first name, and middle initial order).

  • Name will be 'xxxxxxxxxxxxxxxxxxx' if no instructor is assigned.

 

• WCC_INSTR2_NAME_FML (35)
  Second instructor's name (in first name, middle initial, and last name order).

  • Name will be 'xxxxxxxxxxxxxxxxxxx' if no instructor is assigned.

 

• WCC_INSTR2_COLLEGE (2)
  College code of the second instructor.

  • See BANNER form STVCOLL for valid codes.

 

• WCC_INSTR2_COLLEGE_DESC (24)
  Second instructor's college description.

 

• WCC_INSTR2_DEPARTMENT (4)
  Department code of the second instructor.

  • See BANNER form STVDEPT for valid codes.

 

• WCC_INSTR2_DEPARTMENT_DESC (24)
  Second instructor's department description.

 

• WCC_INSTR2_PCT_RESPONS (Numeric 999)
  Percent of the course that the second instructor is responsible for.

 

• WCC_INSTR2_PCT_SESSION (Numeric 999)
  Percent of the session that the second instructor is responsible for.

 

• WCC_INSTR2_PRIMARY_IND (1)
  Indicates whether or not the second instructor is the primary instructor.

  • Y - Yes

  • Blank - No

 

• WCC_INSTR2_OVER_RIDE_IND (1)
  Used to indicate whether or not the second instructor has any conflicting classes.

  • O - Override instructor conflicts

  • Blank - Do not override instructor conflicts 

 

• WCC_INSTR2_E_MAIL (90)
  Second instructor's e-mail address.

 

• WCC_INSTR3_PIDM (8)
  Banner's internal identification number for the course's third instructor.

 

• WCC_INSTR3_ID (9)
  ID number for third instructor.

 

• WCC_INSTR3_NAME_LFM (35)
  Third instructor's name (in last name, first name, and middle initial order).

  • Name will be 'xxxxxxxxxxxxxxxxxxx' if no instructor is assigned.

 

• WCC_INSTR3_NAME_FML (35)
  Third instructor's name (in first name, middle initial, and last name order).

  • Name will be 'xxxxxxxxxxxxxxxxxxx' if no instructor is assigned.

  

• WCC_INSTR3_COLLEGE (2)
  College code of the third instructor.

  • See BANNER form STVCOLL for valid codes.

 

• WCC_INSTR3_COLLEGE_DESC (24)
  Third instructor's college description.

 

• WCC_INSTR3_DEPARTMENT (4)
  Department code of the third instructor.

  • See BANNER form STVDEPT for valid codes.

 

• WCC_INSTR3_DEPARTMENT_DESC (24)
  Third instructor's department description.

 

• WCC_INSTR3_PCT_RESPONS (Numeric 999)
  Percent of the course that the third instructor is responsible for.

 

• WCC_INSTR3_PCT_SESSION (Numeric 999)
  Percent of the session that the third instructor is responsible for.

 

• WCC_INSTR3_PRIMARY_IND (1)
  Indicates whether or not the third instructor is the primary instructor.

  • Y - Yes

  • Blank - No

 

• WCC_INSTR3_OVER_RIDE_IND (1)
  Used to indicate whether or not the third instructor has any conflicting classes.

  • O - Override instructor conflicts

  • Blank - Do not override instructor conflicts 

 

• WCC_INSTR3_E_MAIL (90)
  Third instructor's e-mail address.

 

• WCC_INSTR_COUNT (Numeric 99)
  Total number of instructors for this section.

 

• WCC_BLDG_CODE (6)
  Code of building in which the course section meets.

  • See BANNER form STVBLDG for valid codes.

 

• WCC_BLDG_NAME (30)
  Description of building in which the course section meets.

 

• WCC_ROOM_CODE (10)
  Room code in which the course section meets.

  • See BANNER form SLQROOM for valid room/building codes.

 

• WCC_BEGIN_TIME (4)
  Beginning time the course section starts.

 

• WCC_END_TIME (4)
  Ending time the course section ends.

 

• WCC_SUN_DAY (1)
  Sunday class meeting indicator.

  • U - meets on Sunday.

  • blank - does not meet on Sunday.

 

• WCC_MON_DAY (1)
  Monday class meeting indicator.

  • M - meets on Monday.

  • blank - does not meet on Monday.

 

• WCC_TUE_DAY (1)
  Tuesday class meeting indicator.

  • T - meets on Tuesday.

  • blank - does not meet on Tuesday.

 

• WCC_WED_DAY (1)
  Wednesday class meeting indicator.

  • W - meets on Wednesday.

  • blank - does not meet on Wednesday.

 

• WCC_THU_DAY (1)
  Thursday class meeting indicator.

  • R - meets on Thursday.

  • blank - does not meet on Thursday.

 

• WCC_FRI_DAY (1)
  Friday class meeting indicator.

  • F - meets on Friday.

  • blank - does not meet on Friday.

 

• WCC_SAT_DAY (1)
  Saturday class meeting indicator.

  • S - meets on Saturday.

  • blank - does not meet on Saturday.

 

• WCC_BLDG_CODE_2 (6)
  Code of building in which the course section meets during second time slot.

  • See BANNER form STVBLDG for valid codes.

 

• WCC_BLDG_NAME_2 (30)
  Description of building in which the course section meets during second time slot.

 

• WCC_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.

 

• WCC_BEGIN_TIME_2 (4)
  Beginning time the course section starts during second time slot.

 

• WCC_END_TIME_2 (4)
  Ending time the course section ends during second time slot.

 

• WCC_SUN_DAY_2 (1)
  Sunday class meeting indicator for second time slot.

  • U - meets on Sunday.

  • blank - does not meet on Sunday.

 

• WCC_MON_DAY_2 (1)
  Monday class meeting indicator for second time slot.

  • M - meets on Monday.

  • blank - does not meet on Monday.

 

• WCC_TUE_DAY_2 (1)
  Tuesday class meeting indicator for second time slot.

  • T - meets on Tuesday.

  • blank - does not meet on Tuesday.

 

• WCC_WED_DAY_2 (1)
  Wednesday class meeting indicator for second time slot.

  • W - meets on Wednesday.

  • blank - does not meet on Wednesday.

 

• WCC_THU_DAY_2 (1)
  Thursday class meeting indicator for second time slot.

  • R - meets on Thursday.

  • blank - does not meet on Thursday.

 

• WCC_FRI_DAY_2 (1)
  Friday class meeting indicator for second time slot.

  • F - meets on Friday.

  • blank - does not meet on Friday.

 

• WCC_SAT_DAY_2 (1)
  Saturday class meeting indicator for second time slot.

  • S - meets on Saturday.

  • blank - does not meet on Saturday.

 

• WCC_BLDG_CODE_3 (6)
  Code of building in which the course section meets during third time slot.

  • See BANNER form STVBLDG for valid codes.

 

• WCC_BLDG_NAME_3 (30)
  Description of building in which the course section meets during third time slot.

 

• WCC_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.

 

• WCC_BEGIN_TIME_3 (4)
  Beginning time the course section starts during third time slot.

 

• WCC_END_TIME_3 (4)
  Ending time the course section ends during third time slot.

 

• WCC_SUN_DAY_3 (1)
  Sunday class meeting indicator for third time slot.

  • U - meets on Sunday.

  • blank - does not meet on Sunday.

 

• WCC_MON_DAY_3 (1)
  Monday class meeting indicator for third time slot.

  • M - meets on Monday.

  • blank - does not meet on Monday.

 

• WCC_TUE_DAY_3 (1)
  Tuesday class meeting indicator for third time slot.

  • T - meets on Tuesday.

  • blank - does not meet on Tuesday.

 

• WCC_WED_DAY_3 (1)
  Wednesday class meeting indicator for third time slot.

  • W - meets on Wednesday.

  • blank - does not meet on Wednesday.

 

• WCC_THU_DAY_3 (1)
  Thursday class meeting indicator for third time slot.

  • R - meets on Thursday.

  • blank - does not meet on Thursday.

 

• WCC_FRI_DAY_3 (1)
  Friday class meeting indicator for third time slot.

  • F - meets on Friday.

  • blank - does not meet on Friday.

 

• WCC_SAT_DAY_3 (1)
  Saturday class meeting indicator for third time slot.

  • S - meets on Saturday.

  • blank - does not meet on Saturday.

 

• WCC_MULTI_HOUR_COUNT (Numeric 99)
  Count of the number of different meeting times scheduled during a week.

 

• WCC_ACTIVITY_DATE (Date)
  The date of the last modification of the section information.

Back to top

Administration

Darton State College - 2400 Gillionville Rd, Albany, GA 31707 • (229) 317-6000 • 1-866-775-1214

• Home
• Future Students
• Current Students
• Academics
• Administration
• Faculty & Staff
• Cavalier Life
• Contact
• Site Map

• Campus Hours
• Employment Opportunities
• Office Directory
• Password Help
• University System of Georgia

Copyright © 2013 Darton State College. All Rights Reserved.