- DATA VIEW NAME
- COURSE_CURRENT
- OVERVIEW
- This view contains basic Catalog information for all course records with an effective date less than or equal to the current date.
- LOAD FREQUENCY
- Data is refreshed daily Monday through Friday.
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - 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 Home Page
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/2008– New view created.
1/2010 – Data Custodian Change C4j
09/2012 – Data Custodian Contact changed from Karen Hanson to Kim Alling - DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *Course_Key | Number(8) | A unique identifier that is system generated. Useful for joining to other course data views. |
| Course_ID | Varchar2 (6) | A unique ID number assigned by ISIS to a specific course, regardless of academic department. Therefore, all course members of a crosslisted course will have the same Course_ID. |
| Course_Effective_Date | Date | The date when the course was first implemented with its current attributes. Users who want to know when a course was first offered (regardless of attributes) should search for the minimum course_effective_date for a given course_id. Effective dates are entered for course records first implemented in the early 1970s. Course records with effective dates of 1/1/00 existed prior to 1971 but the actual implementation date is not known. |
| Course_Status | Varchar2 (1) | Course Status A = course is currently active (i.e. able to be offered) I = course used to be offered but is not currently active |
| Course_Title_Long | Varchar2 (100) | Long course description |
| Course_Title_Short | Varchar2 (30) | Short course description |
| Repeatable_Ind | Varchar2 (1) | Identifies courses for which a student may receive credit multiple times. For example, a course which offers different topics each semester is often repeatable. Values: Y=Yes N=No |
| Grading_Basis | Varchar2 (3) | Grading basis ADM = Administrative CNC = Credit/No Credit GRD = Graded GRN = Graded, no GPA Calculated GRV = Graded, Vet Med OPT = Student Option PRG = First Course in 2 Course Sequence SUS = Satisfactory/Unsatisfactory TRN = Transfer |
| Credit_Minimum | Number(5,2) | Minimum credits for the course. If minimum and maximum credits are equal then the course has been approved for a fixed number of credits. If the minimum and maximum differ, then the course can have variable credit within the limits of the minimum and maximum. |
| Credit_Maximum | Number(5,2) | Maximum credits for the course. If minimum and maximum credits are equal then the course has been approved for a fixed number of credits. If the minimum and maximum differ, then the course can have variable credit, within the limits of the minimum and maximum. |
| Cross_List_Ind | Varchar2 (1) | Indicates whether this course is cross-listed Y = Course is crosslisted N = Course is not crosslisted |
| Honors_Symbol | Varchar2 (4) | Honors status of a courseHON = A course for honors students only. HOP = A course open to all qualified students and recommended for students planning an Honors program. Honors students should register for Honors credit. HIA = Honors credits is available for this course. Students should discuss credit options with the instructor. |
| Course_Description | Varchar2(1000) | Course description |
| Course_Prerequisites | Varchar2(500) | Course prerequisites |
| Extract_Date_Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |