This list is weekly updated on every Wednesday around 3PM CST.Last updated date: June 11, 2019
|Entry||Variation of Data Entry's Name||Definition||Logic/Query [Recommended]|
|Academic Groups||School/College||Academic groups are the highest level breakdowns of the academic institution for academic structural purposes. Often each school or college within an academic institution is defined as an academic group. Sometimes units such as extended education are defined as an academic group if classes are offered separately from the standard colleges or schools. For example, PeopleSoft University comprises the College of Liberal Arts, the College of Engineering, the School of Law, the School of Education, and the Evening Extension Division. Each entity is defined as an academic group in the system. Academic groups can offer academic programs in more than one academic career, and academic careers can cross academic groups. In the previous example, the College of Liberal Arts and the College of Engineering contain both undergraduate and graduate academic careers, but the School of Law contains only one academic career, which is not shared with any other academic group. (https://docs.oracle.com/cd/E56917_01/cs9pbr4/eng/cs/lsfn/task_DefiningAcademicGroups-ab5820.html#topofpage)|
Academic groups are linked to students and courses.
|Academic Plan||Plans are used to identify what major and or minor a student is pursuing. For example,|
ENGLBA1 is the plan code assigned to a student who is intending to pursue an English
major. Where as BUSMSC is the plan code assigned to a student who is pursuing a
Business Management MS masters. (From PAWS Resource > Faculty/Staff Resources > Plan Changes Form: https://uwm.edu/paws-resources/wp-content/uploads/sites/436/2017/04/Plan_Changes.pdf)
|Academic Program||Programs are used to identify what school/college a student is in, along with the type of|
degree they are pursuing. For example, a BUSUG is the program assigned to a student
who is pursuing an undergraduate degree in the Lubar School of Business. Where as a
BUSGD is the program assigned to a student who is pursuing a graduate degree in the
Lubar School of Business. (From the Program Changes Form: https://uwm.edu/paws-resources/home/faculty-staff-resources/)
|Admitted Students||Net Admits, Gross Admits||Students who meet the admissions requirements and are accepted to the university.||VU_ADM_APPL_PROG_DIM:
For the undergraduate population, I use the APPP_PROG_ACTION field to get the most up to date information on a student's application status (including admit) by term, career (UGRD), application number, and admit type. For admit, these values include: ADMT (admitted based on all previous work), COND (admitted conditionally on the most recent previous work - student will need to submit final documents for final review), MATR (for freshmen, a MATR code means that students have been admitted AND completed the next steps; for all other admit types, a MATR code is used immediately after the COND or ADMT code). If I want to get at the Gross Admit number, I would also use the WAPP code. This includes students who have been admitted but have since cancelled their admissions. These are no longer active students, but depending on the purpose, can be counted in overall admit numbers. I use the APPP_PROG_REASON field to determine the "type" of admit - standard, probationary, etc). More research needs to be done on the DEFR, PRGC, PLNC codes to determine if they are admits or not as the way the data is currently stored, it is not easy to determine if those actions take place before or after an admit row is added to the record.
For the undergraduate population, I most often use the D_APPLICATION_STATUS field. For me, this tells me what status the student is currently in. In this case, "Admitted" are those admitted students who we see as those who still have an intent to attend. "Cancelled" are those who were admitted, but have since cancelled. I can include both to get Gross Admit or just "Admitted" (Net Admit) to get the students who are still elgible to move through the pipeline. In this D_APPLICATION_STATUS field you cannot determine if a student is a matriculated admit or not.
I use the PROGRAM_ACTION field in APPSTAT to do the same as I do with the APPP_PROG_ACTION field from APPL_PROG_DIM table above.
|Attempted Credit Hours||The number of credit hours that the student attempted to complete. Official attempted credit hours is following the rule of the official enrollment, which means any enrollment occurring between the first day of classes and the census date. Attempted credit hours are only considered for credit-bearing courses, not non-credit courses.|
|Census Date||Official Reporting Date, ORD||The date that enrollment information is captured for reporting purposes each term. On the census date, the snapshot of enrollment and student credit hours is taken. UWM's census date is the 10th class day for Fall and Spring semester.|
|Completed Credit Hours||The number of credit hours that the student enrolled in credit-bearing courses and obtained any final grades. However, a withdrawal grade is not considered as completed.|
|Completed Credits||Earned Credits||"Completed credits" mean credits from a course that students earned an official grade between A+ and D-, or a grade of CR.|
|Course Enrollment||Student enrollment broken down at course level.|
|Credit Hours||Student Credit Hours, SCH||Credit hours are a subset of Units. The number of units of the class that apply toward academic progress for students enrolled in the class. Credit hours are applied toward the total number of credit hours needed for completing the requirements of a degree program. All courses have units but not all courses like remedial courses have credit hours.|
|Credits vs. Units||Credit hours||Units refers to the number of credit hours a student has enrolled in and will be charged for a given course. Credits refers to how many of these credit hours will (or can possibly) count for progress toward a degree program. These terms are closely related and in the vast majority of cases will be the same -- they will differ in cases like remedial coursework such as MATH 95, where a student will have UNITS associated with the course, but will not actually earn CREDITS toward degree completion.||UNITS_TAKEN = Credits
UNITS_BILLING = Units
|Dual Enrollment||High school students who enroll in a class offered by UWM, wishing to receive credit through the University.||I don't know how we can pull data for the Dual Enrollment from the DW.|
|Earned Credit Hours||The number of credit hours that student enrolled in credit-bearing courses and obtained the final grade D- or better.|
|Enrollment||Registration, Enrolled Students, Registered Students||The action of registering as a student on a course in a given term. Official enrollment for UWM is based on the enrollment activities occurring between the first day of classes and the census date. Official enrollment activity includes not only registering but also dropping a course(s). |
FERPA, CDR, and IPEDS have a different methodology to count enrolled students.
|Enrollment||Registration||Enrollment specifically refers to the process of a student enrolling in (or registering for) a specific class section and "adding" that course, whether auditing or for credit -- this is course enrollment. A student who is enrolled in one or more courses for a specific semester is said to be "term enrolled" for that semester.||CASE WHEN (CTERM_ACAD_LOAD_CODE 'N' OR SCTERM_UNITS_AUDIT '0')
THEN 'Registered' else 'Not Registered' END as CTERM_REGISTRATION_STATUS
|Enrollment, Registration||Enrollment / Registered definition found on the UWM One-Stop site: https://uwm.edu/onestop/enrolling/eligibility-to-enroll/|
In order to be reported as fully-enrolled for a term, a student must be enrolled as of the day after the add deadline in that term. Prior to the add deadline, students are considered registered but not fully enrolled.
|Headcount||A count of persons irrespective of full- or part-time status.|
|Milestone||Student tracking records that allow school/college to denote student's academic progress. For example, it contains students' test completion, advanced to major status, or other academic requirements.|
|Online Students||students who are enrolled in one or more online courses. The currently-used categories (described more fully below) are online, blended, and traditional face-to-face studentsthe first two categories would be defined as "online students." It's important to note that these categories are currently only determined on a course-by-course and semester-by-semester basisthere is no common institutional method of reporting on students whose enrollment has been fully online for all semesters.||There are four LOCATION_DESCR fields in Office of Assessment and Institutional Research data models that can be used to identify online students at two levels 1) at the course enrollment level, and 2) at the term enrollment level.
The Enrollstats weekly course enrollment model uses two fields:
ENRL_LOCATION_DESCR (VU_STC_STUDENT_CLASS) can be used to identify and report on online students in specific courses using values of "Online" (fully-online) or "Hybrid" (some online component, some face-to-face).
LOCATION_DESCR (VU_STE_STUDENT_TERM) can be used to identify "online students" by semester based on all course enrollments using values of "Online" or "Blended" (see calculations below).
And, in the Statmaster official semester enrollment model:
CLA_LOCATION_DESCR (VU_STA_CLASS) can be used to identify and report on online students by enrollment in specific courses using values of "Online" (fully-online) or "Hybrid" (some online component, some face-to-face).
STU_LOCATION_DESCR (VU_STA_STUDENT) can be used to identify "online students" by semester based on all course enrollments using values of "Online" or "Blended" (see calculations below).
These four fields are calculated in PAWS based on an analysis of each class section in which a student is currently enrolled. The course-level location fields (ENRL_LOCATION_DESCR and CLA_LOCATION_DESCR) are calculated with the following rules:
Online courses have a CLASS_INSTRUCTION_MODE value of WW
or a CLASS_LOCATION_CD value of ONLINE
Hybrid courses have a CLASS_INSTRUCTION_MODE value that begins with H
Study Abroad courses have a CATTR_ABRD_VALUE of ABRD
Independent Study courses have a CLASS_COMPONENT_CD value of IND
Field courses have a CLASS_COMPONENT_CD value of FLD
On Campus courses have a CLASS_LOCATION_CD value of KENWOOD
Off Campus courses have a CLASS_LOCATION_CD value of OFFCAMPUS
The semester-level location fields (LOCATION_DESCR and STU_LOCATION_DESCR) are calculated for each student based on an analysis of the course-level location fields above:
Independent Study: All Independent Study courses
Online: All Online courses or all Online courses with Independent Study courses
Blended: Student is taking at least one Online or Hybrid course
Study Abroad: All Study Abroad courses or all Study Abroad courses with Independent Study courses
|Registered student||Enrolled student||A student who is enrolled in a credit-bearing class for a given semester, which includes audit credits.||CASE WHEN (CTERM_ACAD_LOAD_CODE 'N' OR SCTERM_UNITS_AUDIT '0')
THEN 'Registered' else 'Not Registered' END as CTERM_REGISTRATION_STATUS
|Remedial Credits||Credit hours attached to the remedial courses. Remedial credits are not counted for degree completion.|
|Student Enrollment||A student who is enrolled between the first day of classes and census date. Students who drop entire classes between these periods are also considered as enrolled students.|
|Students of Color||As I have understood this and reported in the past, students of color include African American, American Indian, Latino/a, Southeast Asian American, Asian American, and any students who identify as Multi-Ethnic based on inclusion of at least one of the before mentioned categories.||I use the APP_D_ETHNIC_UWM_Heritage field to pull information about students of color when asked, and limit it to the categories mentioned earlier. This field can also be found in CC PERSONAL DIM. Since both of these are derived, I believe it is sourced from CC UWM ETHNICITY SUMMARY table.|
|UDDS Code||Department Code, Department ID||(I'm stealing part of this from https://kb.wisc.edu/ls/page.php?id=23072 :))|
A Department ID is the sequence of numbers that identifies a specific campus department, program, or entity within the UW System. Historically, the Department ID was known as a "UDDS," which stands for "Unit, Division, Department, Subdepartment." This term is still in use in some resources, so we are including it in this glossary listing.
In more practical terms, a Department ID/UDDS is the unique combination of letters and numbers that identify the campus, division, department, and possibly subdepartment, associated with a particular personnel, research, financial, or other activity or transaction.
All UWM UDDS codes start with a 'B', but the following 2-6 digits belong to individual units at different levels of the organizational hierarchy. The resulting 3-, 5-, and 7-digit codes represent UWM divisions, departments, and subdepartments.
One example organizational hierarchy:
B48 is the UW-Milwaukee College of Letters and Science; any UDDS codes beginning with these 3 digits is considered to be within L&S.
B4833 is the UW-Milwaukee Department of English; any UDDS codes beginning with these 5 digits is considered to be within the English Department.
B483310 is the Cream City Review, a literary publication produced by the English Department's creative writing program.
|VU_PREG_UWM_UDDS is probably the best place to reference; we also created an OBIEE-related view for some HR dashboard prompts that's at VW_BI_PREG_UDDS|
|Unduplicated Headcount||The sum of students enrolled on a course counted only once in a given term. For instance, students are counted once regardless of multiple academic plans or multi-race/ethnicity.|
|Units||A unit of measure representing the equivalent of an hour of instruction per week over the entire term. Units attached to the graded section of a course that are used for tuition calculation or billing. Non-grade sections such as lab or discussion do not have units. While remedial courses do not contribute credit hours toward the degree completion, they are billable and will have units.|