- DATA VIEW NAME
- CFI_INSTRUCTOR_UDDS_FTE_HIST
- OVERVIEW
- This data view supports the creation historical of Credits Follow the Instructor (CFI) results shown in CFI_Credit_Allocation. It is available for purposes of auditing the CFI methodology. This data view identifies qualified payroll position splits used to associate student credits with academic departments.
The funding of a payroll split is categorized as follows:
Teaching Department – yes/no (INSTR_DEPT_IND)
Instructional Fund -yes/no (INSTR_FUND_IND),
Instructional Title – yes/no (INSTR_TITLE_IND).For CFI purposes, a ‘qualified’ split is a split where INSTR_DEPT_IND = “Y” and INSTR_FUND_IND = “Y”.
A row exists in this data view for each split where one, two or all three of the payroll split categories is Y (YES). The data can be summarized in various ways—such as instructional fund FTE and instructional title FTE subtotals by unit, division, or department.
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. |
| *RECORD_ID | Number(7) | A key on the October and March payroll tables included to ensure a unique key. TERM + RECORD_ID provides a unique key. (Also included for auditing purposes) |
| SOC_SEC_NUMBER | Varchar2(9) | The social security number of the instructor (Included for auditing purposes.) 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 more recently 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 full 7-character UDDS code consists of the following: |
|
| UNIT | Varchar2(1) | The code for the Unit. |
| 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. |
| FUND | Varchar2(3) | The code for the general source of funds from which the budgeted amount is paid. (Included for auditing purposes.) |
| ACTIVITY | Varchar2(1) | The code for the function for which a particular split is budgeted. 0 – Student Services 1 – Institutional Support 2 – Instruction 3 – Hospitals 4 – Research 5 – Public Service 6 – Academic Support 7 – Physical Plant 8 – Auxiliary Enterprises 9 – Financial Aid & – Farm Operations |
| TITLE_CODE | Varchar2(5) | The code for the official University System title for the position. (Included for auditing purposes.) |
| INSTR_DEPT_IND | Varchar2 (1) | Indicates if the split is paid by a teaching department. Values are: Y=Yes N=No |
| INSTR_FUND_IND | Varchar2 (1) | Indicates if the split is paid by an instructional fund. Values are: Y=Yes N=No |
| INSTR_TITLE_IND | Varchar2(1) | Indicates if the split has an instructional title. Values are: Y=Yes N=No |
| FUND_FRACT | Number(3,2) | The percent of the entire salary for the position paid on the particular split in the fiscal year. It is an FTE count for the split. |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted from the source system. |