- DATA VIEW NAME
- FROZEN_ENROLLMENT_SUBPLAN
- 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_PLAN.
- 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
- 07/2015 – New view created.
- 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) | Term student registered for. The term code is derived as follows:
-First number is the century, 0=1900 and 1=2000 For Example: Term is a necessary field in order to receive accurate lists. |
| *EMPLID | VARCHAR2(10) | ISIS personal identifier. The ID will be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only ten characters are in use. |
| *ACAD_PROG | VARCHAR2(5) | The code for the student’s academic program. for undergraduates it was formerly known as the student’s classification, e.g., BA, BS, BUS,HEC,EGR. The graduate student’s program includes their departments, e.g., G153 is a graduate student in Chemistry. Some Graduate majors can be offered in more than one school/college. For them, you’ll see a single character college code at the end of the Academic_Program_Code. |
| *ACAD_PLAN | VARCHAR2(10) | The code for Academic Plan associated to the student’s academic program. For Plans of type MAJ this represents the student’s Major. |
| SUBPLAN_TYPE | VARCHAR2(3) | Subplans are grouped by their relation to the Plan. Some Plans may offer multiple types of Subplans.
Values are: |
| * SUBPLAN_CODE | VARCHAR2(10) | The code for the student’s subplan. Students may have zero or more Subplans associated with each Plan. This field will be null if no Subplan is associated with a Plan. |
| SUBPLAN_DESCR | VARCHAR2(30) | A description of the student’s subplan. |
| TRANSCRIPT_DESCR | VARCHAR2(100) | The date on which the student entered the Academic Subplan associated with the student’s plan. For plans of type MAJ this represents the date the student declared their Option (official sub-plan) or Track (unofficial sub-plan) for that Major. |
| SUBPLAN_DECLARATION_DATE | DATE | The date on which the student entered the Academic Subplan associated with the student’s plan. For plans of type MAJ this represents the date the student declared their Option (official sub-plan) or Track (unofficial sub-plan) for that Major. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS |