- DATA VIEW NAME
- CFI_CREDIT_ALLOCATION_HIST
- OVERVIEW
- This data view is the historical 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 1022 through 1114.
- LOAD FREQUENCY
- Contains only historical terms and is no longer refreshed.
- 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 - This data view is the original CFI and contains Social Security Number. Anyone who applies for this data view will need to provide justification.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/2015 New Data View
- 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. |
| 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_SSN | Varchar2(9) | The social security number of the instructor or the first nine digits of his/her Campus Id. Please note: this field will no longer contain SSN values after Term 1114. |
| 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 include: 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 are: 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 code for the instructor category for Credits-Follow-the-Instructor: FAC = Faculty GRA = Graduate Assistant IAS = Instructional Academic Staff OTH = Other |
| 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 a) only ONE of those departments has ownership of the course offering — credits go to that department 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. |