|
InfoAccess |
|
|
DATA VIEW NAME |
COURSE_ SECTION_STOUT |
|
OVERVIEW |
Contains information about course sections. Current and historical data. |
|
LOAD FREQUENCY |
Data is updated every night. |
|
DATA CUSTODIAN |
Registrar, Records
& Registration |
|
AUTHORIZATION |
You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess web site |
|
SPECIAL CONSIDERATIONS |
Key fields are identified with an asterisk (*) |
|
QUESTIONS |
Contact: Division
of Information Technology Help Desk |
|
LAST UPDATED |
2/03 Created |
|
DATA FORMATS |
The codes following the field names in this document define the field. The different types are: |
|
CHAR2(N)OR CHAR(N)- |
Alphanumeric. (N)is the length of the field. Field contains letters and/or numbers. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ (N) is the length of the field. Field contains letters and/or numbers. |
|
NUM (N) |
Numeric Field. (N) is the length of the field. Field contains only numbers. Numbers with decimal points are represented as NUM (X.Y) X=total number of digits Y=the number of decimals after the decimal Examples: NUM (6,2) could contain 2500.12 NUM(6)could contain 000005 or 550000 |
|
DATE (XXXX) |
Date field. (XXXX)is the format of the field. Date can be in various formats and date functions available based on your query tool can be used against the field. Examples: DATE(YYMMDD);DATE(YYDDD);DATE(DD-MM-YY) |
|
Column Name |
Format |
Description |
|---|---|---|
|
TERM |
CHAR 8 |
Term Course Offered |
|
SECTION_ID |
CHAR 8 |
Section ID |
|
SYNONYM |
CHAR 11 |
Synonym Of Section |
|
DEPARTMENT_DESC |
CHAR 30 |
Description Of Department Offering The Section |
|
DEPARTMENT_NO |
CHAR 4 |
Department Number Of Department Offering The Section |
|
SUBJECT |
CHAR 8 |
Subject Section |
|
COURSE_TITLE |
CHAR 30 |
Title Of Course |
|
COURSE_ID |
CHAR 8 |
Course ID |
|
COURSE_CLASS |
CHAR 4 |
Course Number |
|
COURSE_NAME |
CHAR 15 |
Name Of Course (ie. Engl-090-001) |
|
SCHEDULE_TYPE |
CHAR 4 |
Type Of Course Schedule (ie REM, SAP) |
|
SECTION_NO |
CHAR 5 |
Section Number |
|
SECTION_NAME |
CHAR 25 |
Name Of Section |
|
SECTION_PURPOSE |
CHAR 3 |
Purpose Of Course (ie. CNT, SAP) |
|
SECTION_START_DATE |
DATE 19 |
Section Start Date |
|
SECTION_END_DATE |
DATE 19 |
Section End Date |
|
COURSE_LEVEL |
CHAR 2 |
Level Of Course |
|
COURSE_CLASS_LEVEL |
CHAR 1 |
|
|
CREDIT_TYPE |
CHAR 1 |
Type Of Credit (ie. I-Institutional) |
|
SECTION_STATUS |
CHAR 1 |
Current Status Of Course |
|
SECTION_STATUS_DATE |
DATE 19 |
Date Of Current Status |
|
MINIMUM_CRED |
NUM (6,2) |
Minimum Number Of Credits Class Can Be Taken For |
|
MAXIMUM_CRED |
NUM (6,2) |
Maximum Number Of Credits Class Can Be Taken For |
|
MINIMUM_ENROLL |
NUM 3 |
Minimum Head Count Class Can Have For |
|
MAXIMUM_ENROLL |
NUM 3 |
Maximum Head Count Class Can Have |
|
ACTUAL_ENROLL |
NUM 3 |
Number Students Enrolled In Section |
|
AVAILABLE_ENROLL |
NUM 3 |
Number Open Seats In Section |
|
SECTION_COMMENTS |
CHAR 1000 |
Comments For Course |
|
SECTION_PRINTED_COMMENTS |
CHAR1000 |
Comments Used For Printing |
|
LAST_UPDATE_DATE_TIME |
DATE 19 |
Date Time Transaction Loaded |