- DATA VIEW NAME
- CFI_CREDIT_ALLOCATION
- OVERVIEW
- This data view is the core data view for the Credits Follow the Instructor (CFI) reporting. The purpose of CFI is to associate student credits hours with the department that paid the instructor’s salary, rather than the departments that offered the course.
The data is drawn primarily from October or March payroll data and 8th-week CDR data stored in the InfoAccess data warehouse, along with some supporting data maintained in ISIS tables.
Contains terms 1122 forward.
- LOAD FREQUENCY
- Refreshed upon the request of the Provost’s Office. There generally will be a fall term load in early December and spring term load in early May.
- DATA CUSTODIAN
- Office of Academic Planning and Institutional Research
Contact: Clare Huhn - 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 - There are no special considerations.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 12/2002 New Data View
06/2005 Changed CFI_Credits from Number (4,2) to Number (5,3)
01/2012 Added new field Instructor_HR_Emplid and stopped populating Instructor_SSN
10/2015 Removed column Instructor_SSN. Add new columns Student_level and Course_ID. Changed Column CFI_Instr_Category format from Varchar2(4) to Varchar2(2). Updated CFI_Instr_Category Description. - 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 |
|---|---|---|
| TERM | Varchar2(4) | The code for the academic year and semester. The term code is 4 digits CYYT – and is DERIVED as follows: C = the century. 0=1900, 1=2000 YY = the academic year. 99 = academic year 98-99; 00 =academic year 99-00; etc T = the term. 2=Fall, 4=Spring, 6=Summer.Example: Fall 1998-99 is 0992. Summer 1999-00 is 1006. School term in ISIS (not CDR) format. |
| EMPLID | Varchar2(10) | ISIS Personal Identifier. This ID never changes throughout the individual’s relationship with the University. |
| STUDENT_LEVEL | Varchar2(2) | The level of the student’s primary intended degree program. Valid values: CD = Clinical doctorate (enrolled in a program that grants a clinical doctorate degree) GR = Graduate (enrolled in a masters or PhD granting degree program) SP = Special student (not enrolled in a degree granting program) UG = Undergraduate (enrolled in a bachelors granting degree program) |
| COURSE_ID | Varchar2(8) | 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. |
| SUBJECT_CODE | Varchar2(8) | The (typically 3-digit) code for the academic department of a course. E.g., Math = ‘600’. This is the subject code from ISIS, not the curricular area code (CAC) from CDR. |
| CATALOG_NUMBER | Varchar2(10) | The (typically 3-digit) catalog number of a course. A course is identified by ‘SSS-CCC’ where ‘SSS’ is the subject (see above) and ‘CCC’ is the catalog number. E.g. Algebra, a course in the Math department, is ‘600-112’. This is the ISIS ‘catalog_nbr’, but formatted for the data warehouse. |
| SESSION_CODE | Varchar2(3) | The ISIS session code. |
| SECTION_NUMBER | Varchar2(4) | The (typically 3-digit) ISIS class section number. |
| INSTRUCTOR_HR_EMPLID | Varchar2(8) | The HRS Emplid of the instructor. Please note: this field was added and will only contain values from Term 1122 forward. |
| UDDS: | The components of the 7-character UDDS code identify the organizational unit of the payroll split. The UDDS code consists of the following: Unit (campus) Division Department Sub-Department |
|
| UNIT | Varchar2(1) | The code for the Unit (campus). |
| DIVISION | Varchar2(2) | The code for the Division. |
| DEPARTMENT | Varchar2(2) | The code for the Department. |
| SUBDEPT | Varchar2(2) | The code for the Sub Department. |
| SEQ_NUMBER | Number(1) | A sequence number to maintain a unique key in case the higher order keys are not sufficient.
For instance, if the credits are following payroll splits, an instructor could have multiple qualifying splits with the same UDDS — each split will get its share of the credits. Or, if the credits are following the teaching departments, multiple members of a meetswith group may belong to the same teaching department — each member will get its share of the credits. |
| SECTION_LEVEL | Varchar2(1) | The code for the intended degree of complexity or expected level of comprehension of the course section. Valid values: 0 = unknown 1 = Remedial 2 = Undergraduate, basic 3 = Undergraduate, advanced 4 = Graduate, basic 5 = Graduate, advanced 6 = preponderant enrollment is professional |
| TYPE_OF_INSTRUCTION | Varchar2(1) | The type of instruction: lecture, discussion, laboratory, etc. The CDR legacy ‘type of instruction’ codes are used, rather than the ISIS ‘component’ codes (class_tbl.component) used in other InfoAccess tables, e.g., Timetable_Multiterm. Valid values: C = LEC (Lecture) L = LAB (Laboratory/Studio) D = DIS (Discussion) F = FLD (Field Expression) I = IND (Independent/Individualized Instruction) S = SEM (Seminar/Colloquia) |
| TITLE_CODE | Varchar2(5) | The code for the official University System title for the instructor’s position. |
| CFI_INSTR_CATEGORY | Varchar(4) | The level of the section instructor based on their title code in the October or March payroll. Valid values: FA = Instructor is a tenured or tenur track faculty member SA = Instructor has a student assistant title (TA, lecturer, SA, etc.) OT = Instructor has a payroll title that is not in the faculty or student assistant title series (academic staff, instructional academic staff, post doctoral fellow, etc.) |
| CFI_CREDITS | Number(5,3) | The portion of a student’s course credits allocated to this section-instructor-UDDS-seq#. |
| RULE | Varchar2(2) | The CFI allocation rule that placed these credits.
1) instructor has one and only one instructional appointment in a teaching department — instructor’s credits go to that department. 2) instructor has instructional appointments in multiple teaching departments, and 3) instructor has an instructional appointment(s), but none in a teaching department — credits stay with the department having ownership of the course offering. 4) instructor has no appointment funded from the instructional budget — credits stay with the department having ownership of the course offering |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted from the source system. |