FROZEN ENROLLMENT PLAN

DATA VIEW NAME

FROZEN_ENROLLMENT_PLAN

OVERVIEW

This data view contains all enrolled students that had a course as of the official census date (the 10th day) of the term. Demographic data is as of the date of the extract. This is a companion view to UW.FROZEN_ENROLLMENT_DEMO.

LOAD FREQUENCY

Spring and Fall data will be refreshed on or about the end of the seventh week of classes. Summer Sessions’ data will be refreshed at the end of August.

DATA CUSTODIAN

Office of the Registrar
Contact: Phillip Hull

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

None.

QUESTIONS

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

LAST UPDATED

12/2000 New data view.
3/2008 A few changes were made:

Data refreshed at the end of the 7th week instead of 10 day
Acad_Prog was added
Shows all Acad_Prog_Types (not just MAJ and MIN)

DATA FORMATS

Primary Key Columns are identified with an asterisk (*)

Char – Character data
Number- Numeric fields will be null if no data is available.
Date – This data type allows the date to be represented in various formats and date related functions to be used against the field. The formats (i.e. 19980203, 10-jun-98) and functions available vary based on your query tool.

Column Name	Format	Description
TERM	CHAR 4	Term student registered for. The term code is derived as follows: -First number is the century, 0=1900 and 1=2000 -Second and third numbers are the year -Last number is the term, 2=Fall, 4=Spring and 6=Summer.For Example: 1004 = Spring 1999-00 1006 = Summer 1999-00 1012 = Fall 2000-01Term is a necessary field in order to receive accurate lists.
ACAD_PROG	CHAR 5	Academic Program was formerly known as classification. BA or MED are examples of an academic program.
EMPLID	CHAR 10	The EMPLID is generated by the ISIS system. It is a unique identifier for a student and will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only 10 characters are in use.
ACAD_PLAN_TYPE	CHAR 3	Sample values are: MAJ = Major MIN = Minor CRT=Certificate CAP=Capstone
ACAD_PLAN	CHAR 10	The equivalent of a major or minor. Generally, undergraduate, special, and professional plans will be coded using the program to which they are associated, followed by the major code used in 3270. Examples: AED 085 = Art Education; BA 121 = Botany BS 499 = History. Generally, graduate plans will be coded using the school/college, the 3270 major code, and the intended degree. Examples: ALS 103MS = Masters in Biochemistry; E 643PHD = PH.D. in Mechanical Engineering.
ACAD_PLAN_CODE	CHAR 3	This is a subset of the ACAD_PLAN as is equivalent to the Major code that was used in 3270.
CIP_CODE	CHAR 13	This is the Classification of Instructional Program code that is used to report majors to the Federal Government.
FTE_PERCENT	NUMBER 3,2	If a student has more than one major, each is reported as a fraction of one so that the total majors equals the total of students with majors.
ACAD_PLAN_DESCR	CHAR 30
TRANSCR_DESCR	CHAR 100	ISIS requires every student to have a plan. Student with tentative plans, where they have not been excepted officially into a program, are not posted to the transcript and therefore the transcript description field will be blank. i.e. Major Unknown, No Plan, Intended-Jour, etc.
DESCR_SHORT	CHAR 10	A shorter version of the ACAD_PLAN_DESCR.
EXTRACT_DATE_TIME	DATE	The System generated date when the data was last refreshed. Format: mm/dd/ccyy.