CREDITS FOLLOW INSTRUCTOR

*** NEW VIEW is UNDER CONSTRUCTION ***

DATA VIEW NAME

CREDITS FOLLOW INSTRUCTOR

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.

LOAD FREQUENCY

Contains …

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 ….

QUESTIONS

Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)

LAST UPDATED

xx/2025 – 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)

THE FOLLOWING TABLE IS OUTDATE and comes from a previous version of the view.