- DATA VIEW NAME
- LUMEN_PROG_LEARNING_OUTCOMES
- OVERVIEW
- The governance approved learning outcomes for a program as entered in the Lumen Program Proposal System.
- This data view may be connected to LUMEN_PROGRAM_PROPOSALS via the CIM_PROG_KEY and PROPOSAL_NUMBER to retrieve additional data about a program.
- 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_PROG_KEY | NUMBER | A unique ID assigned by Lumen Programs that identifies a program. Each plan or subplan code in Lumen Programs will have a CIM_PROG_KEY |
| PROPOSAL_NUMBER | NUMBER | 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 |
| SIS_CODE | VARCHAR2 (10) | The SIS plan or subplan code. |
| SIS_DESCRIPTION | VARCHAR2 (30) | The officially approved description of the academic plan. |
| SIS_TRANSCRIPT_DESCR | VARCHAR2 (100) | The officially approved name of the academic plan as it appears on a student transcript. |
| SIS_EFF_DATE | VARCHAR2 | The term in which the new program or changes to the program will go into effect, the first day of the term is displayed. Format: MM/DD/YYYY |
| SEQUENCE_NUMBER | NUMBER | Beginning with one (1), organizes the learning outcomes in the order that they were entered in Lumen Programs. |
| PROGRAM_LEARNING_OUTCOME | VARCHAR2 (400) | Program learning outcomes state what students are expected to know or be able to do upon completion of a program. |
| ETL_UPDATE_DATE | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |