- DATA VIEW NAME
- LUMEN_CRSE_LEARNING_OUTCOMES
- OVERVIEW
- The governance approved learning outcomes for a course as entered in the Lumen Course Proposal System.
- This data view may be connected to LUMEN_COURSE_PROPOSALS via the CIM_KEY and PROPOSAL_NUMBER to retrieve additional data about a course.
- The max PROPOSAL_NUMBER represents the most recent proposal for the course.
- LOAD FREQUENCY
- Data updated nightly.
- DATA STEWARD
- Academic Planning and Institutional Research Contact: Michelle Young
- AUTHORIZATION
- You must receive approval to access data from the data steward.
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
- Phone: 264-HELP (4357)
- LAST UPDATED
- 05/2020 – New view created.
- 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 |
|---|---|---|
| CIM_KEY | NUMBER | A unique ID assigned by Lumen Courses that identifies a course. Each courseID in SIS will have a CIM key |
| COURSE_ID | VARCHAR2 (6) | A unique ID number assigned by SIS that identifies a course. |
| PROPOSAL_NUMBER | NUMBER | For each CIM_KEY a proposal number starting with one (1) will be assigned to each successive proposal submitted for a course. The highest proposal number represents the most recent proposal. |
| PROPOSAL_STATUS | VARCHAR2 | Where the proposal is in the approval process. Values: Completed Not in Workflow Workflow Role Name |
| SUBJECT | VARCHAR2 (8) | The officially approved short description of the subject. The subject short descr is the one most frequently used in publications and for DARS |
| COURSE_NUMBER | VARCHAR2 (3) | The course number associated with the title of the course. |
| FIRST_TERM_AVAILABLE_EFF_
DATE |
VARCHAR2 (10) | The term in which the proposed course or course changes will go into effect, the first day of the term is displayed. Format: MM/DD/YYYY |
| COURSE_TITLE_LONG | VARCHAR2 (100) | A 100 character title for the course |
| COURSE_TITLE_SHORT | VARCHAR2 (30) | A 30 character title for the course |
| COURSE_DESCRIPTION | VARCHAR2 (1000) | A brief summary of the course content. |
| SEQUENCE_NUMBER | NUMBER | Beginning with one (1), organizes the learning outcomes in the order that they were entered in Lumen Courses. |
| LEARNING_OUTCOME | VARCHAR2 (400) | Course learning outcomes state what students are expected to know or be able to do upon completion of a course. |
| CLO_AUDIENCE | VARCHAR2 (4) | The intended audience for the learning outcome. Values: BOTH = Both Grad & Undergrads GRAD = Graduate UGRD = Undergraduate |
| ETL_UPDATE_DATE | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |