GLOSSARY LIST Home Help

Term: Start Yr Start Qtr End Yr End Qtr Source Definition SQL Relevant Fields Related Code Manual Entry Related Dictionary Entry Updated By Update Date
10th Day     2002 3   Old name for Census Day. (See Census Day.)         TMILDON 05-APR-06
80/20 rule                     TMILDON 04-MAY-07
Academic Year           The annual period of formal instruction at the University of Washington. Runs from Summer Quarter through Spring Quarter of the next calendar year.         AHUMMEL 22-MAR-07
Academic Year           The grouping of time into academic quarters for purposes of conducting university activities. For most purposes e.g., faculty contracts, course scheduling, etc., it is considered Fall, Winter, and Spring quarters. When Summer quarter is included, in the academic year as the following Fall Quarter. Example: Academic Year 2002-03 is Summer 2002, Fall 2002, Winter 2003 and Spring 2003. http://www.washington.edu/admin/factbook/glossary.htm         TMILDON 12-APR-07
Academic Year           Washington Administrative Code: Autumn quarter through summer quarter. http://apps.leg.wa.gov/WAC/default.aspx?cite=478-132-030         TMILDON 12-APR-07
Asynchronous           A course offering in which students do not begin and/or complete the course at the same time. An example would be correspondence coursework.         AHUMMEL 26-AUG-10
Census Day 2002 4 9999     The last business day of the second week of the academic quarter.

Formerly known as Tenth Day.
        AHUMMEL 29-MAR-07
Charge Code         Student Fiscal Services A 10-digit code used in SDB to identify debits and credits against a student's account       SDB Charge Codes CASACHS 27-MAY-11
Class                     TMILDON 22-MAR-07
Credit hours                     TMILDON 09-APR-07
Declarable Major           A Declarable Major is a major that can enter for the current or future quarters. This is distinguished from a Non-Declarable Major which might be "grandfathering" students, but does not allow new declarations of major. Sometimes referred to as Enterable Major.         AHUMMEL 15-JUN-10
Ethnic Origin                     TMILDON 22-MAR-07
FTE                     TMILDON 09-APR-07
Full-time student                     TMILDON 09-APR-07
Gender           Self-reported sex of student, represented as a single character. M=Male, F=Female, blank=Unknown/Not-Reported. Unlike the numeric Sex field, which defaults to 0 (Male) in the absence of any input from the student, Gender was added to database in {year/qtr} to allow students who do not to report to be accurately reported as Unknown.         AHUMMEL 29-MAR-07
Graduate - First Meaning           Any student admitted by the Graduate School into a masters or doctoral studies program. Also known as Graduate Student. class=8       AHUMMEL 29-MAR-07
Graduate - Second Meaning           A degree-recipient, an alumnus or alumna.         AHUMMEL 29-MAR-07
Head count                     TMILDON 09-APR-07
Home Location                     TMILDON 22-MAR-07
Melt                     AHUMMEL 22-JUL-10
New/Continuing/Returning                     TMILDON 22-MAR-07
Off-Calendar           Any course offering which either does not begin in the first week of the quarter or does not end in the last week of the quarter. These can be determined using time_schedule.start_date and time_schedule.end_date         AHUMMEL 26-AUG-10
Part-time student                     TMILDON 09-APR-07
Post-baccalaureate           A matriculated student who is working toward a baccalaureate degree and who already holds a baccalaureate degree from the UW or any other accredited institution.         AHUMMEL 15-JUN-10
Prime time                     TMILDON 04-MAY-07
Professional           A matriculated student working toward one of four professional degrees offered by the UW: Juris Doctor (JD), Doctor of Medicine (MD), Doctor of Dental Surgery (DDS) or Doctor of Pharmacy (PHARMD). Professional students are distinguished by class codes of 11-14, the second digit of the class code being interpretable as the class year within the program.         AHUMMEL 29-MAR-07
Residency                     TMILDON 22-MAR-07
Selectivity                     AHUMMEL 22-JUL-10
Seminar room                     TMILDON 04-MAY-07
Undergraduate           A matriculated student who is working toward a baccalaureate degree. This includes Freshmen, Sophomores, Juniors and Seniors (class codes 1 through 4) and post-baccalaureate students (class code 5).         AHUMMEL 15-JUN-10
Yield                     AHUMMEL 22-JUL-10
state-reported 1984 3 1997 3 Office of Data Management Used in the context of reporting enrollment counts to the state.
(mm_proc_ind = 2 and (census day records)
mm_enroll_status = 12 and (registered)
index1 = 1 and (first major only)
mm_curr_credits > 0 (current credits > 0)
SELECT
dbo_sr_mini_master!mm_year & dbo_sr_mini_master!mm_qtr AS YQ,
dbo_sr_mini_master.*,
dbo_sr_mini_master_deg_program.mm_branch
FROM
dbo_sr_mini_master
INNER JOIN dbo_sr_mini_master_deg_program ON
(dbo_sr_mini_master.mm_student_no = dbo_sr_mini_master_deg_program.mm_student_no) AND
(dbo_sr_mini_master.mm_proc_ind = dbo_sr_mini_master_deg_program.mm_proc_ind) AND
(dbo_sr_mini_master.mm_qtr = dbo_sr_mini_master_deg_program.mm_qtr) AND
(dbo_sr_mini_master.mm_year = dbo_sr_mini_master_deg_program.mm_year)
WHERE
(((dbo_sr_mini_master.mm_year)=[Year?]) AND
((dbo_sr_mini_master.mm_qtr)=[Quarter?]) AND
((dbo_sr_mini_master.mm_proc_ind)=2) AND
((dbo_sr_mini_master_deg_program.index1)=1) AND
((dbo_sr_mini_master.mm_enroll_status)=12) AND
((dbo_sr_mini_master.mm_curr_credits)>0) AND
(([dbo_sr_mini_master]![mm_year] & [dbo_sr_mini_master]![mm_qtr])<=19973));
mm_proc_ind, mm_enroll_status, index1, mm_curr_credits   mini-master table DFRAY 17-MAY-06
state-reported 1997 4 2002 3 Office of Data Management Used in the context of reporting enrollment counts to the state.
(mm_proc_ind = 2 and (census day records)
mm_enroll_status = 12 and (registered)
(mm_sea_st_funded + (Seattle state funded or
mm_bot_st_funded + Bothell state funded or
mm_tac_st_funded) > 0 ) Tacoma state funded )
OR (the above set of conditions OR the below set)
(mm_proc_ind = 2 and (census day records)
mm_enroll_status = 12 and (registered)
(mm_sea_self_sus + (Seattle self sustaining or
mm_bot_self_sus + Bothell self sustaining or
mm_tac_self_sus) > 0 and Tacoma self sustaining )
mm_class <> 6) (excluding non-matriculated students)
SELECT
dbo_sr_mini_master!mm_year & dbo_sr_mini_master!mm_qtr AS YQ,
dbo_sr_mini_master.*
FROM
dbo_sr_mini_master
WHERE
((([dbo_sr_mini_master]![mm_sea_st_funded]+
[dbo_sr_mini_master]![mm_bot_st_funded]+
[dbo_sr_mini_master]![mm_tac_st_funded])>0) AND
(([dbo_sr_mini_master]![mm_year] & [dbo_sr_mini_master]![mm_qtr])>=19974 And
([dbo_sr_mini_master]![mm_year] & [dbo_sr_mini_master]![mm_qtr])<=20023) AND
((dbo_sr_mini_master.mm_year)=[Year?]) AND
((dbo_sr_mini_master.mm_qtr)=[Quarter?]) AND
((dbo_sr_mini_master.mm_proc_ind)=2) AND
((dbo_sr_mini_master.mm_enroll_status)=12)) OR
((([dbo_sr_mini_master]![mm_year] & [dbo_sr_mini_master]![mm_qtr])>=19974 And
([dbo_sr_mini_master]![mm_year] & [dbo_sr_mini_master]![mm_qtr])<=20023) AND
((dbo_sr_mini_master.mm_year)=[Year?]) AND
((dbo_sr_mini_master.mm_qtr)=[Quarter?]) AND
((dbo_sr_mini_master.mm_proc_ind)=2) AND
((dbo_sr_mini_master.mm_enroll_status)=12) AND
(([dbo_sr_mini_master]![mm_sea_self_sus]+[dbo_sr_mini_master]![mm_bot_self_sus]+
[dbo_sr_mini_master]![mm_tac_self_sus])>0) AND
((dbo_sr_mini_master.mm_class)<>6));
mm_proc_ind, mm_enroll_status, mm_sea_self_sus, mm_bot_self_sus, mm_tac_self_sus, mm_class   mini-master table DFRAY 17-MAY-06
state-reported 2002 4 9999   Office of Data Management Used in the context of reporting enrollment counts to the state.
mm_proc_ind = 2 and (census day records)
mm_enroll_status = 12 and (registered)
(mm_sea_st_funded + mm_sea_self_sus + (Seattle state funded or self sustaining)
mm_bot_st_funded + mm_bot_self_sus + (Bothell state funded or self sustaining)
mm_tac_st_funded + mm_tac_self_sus) > 0 (Tacoma state funded or self sustaining)
SELECT
dbo_sr_mini_master!mm_year & dbo_sr_mini_master!mm_qtr AS YQ,
dbo_sr_mini_master.*
FROM
dbo_sr_mini_master
WHERE
((([dbo_sr_mini_master]![mm_year] & [dbo_sr_mini_master]![mm_qtr])>=20024) AND
((dbo_sr_mini_master.mm_year)=[Year?]) AND ((dbo_sr_mini_master.mm_qtr)=[Quarter?]) AND
((dbo_sr_mini_master.mm_proc_ind)=2) AND
(([dbo_sr_mini_master]![mm_sea_st_funded]+
[dbo_sr_mini_master]![mm_sea_self_sus]+
[dbo_sr_mini_master]![mm_bot_st_funded]+
[dbo_sr_mini_master]![mm_bot_self_sus]+
[dbo_sr_mini_master]![mm_tac_st_funded]+
[dbo_sr_mini_master]![mm_tac_self_sus])>0) AND
((dbo_sr_mini_master.mm_enroll_status)=12));
mm_proc_ind, mm_enroll_status, mm_sea_st_funded, mm_sea_self_sus, mm_bot_st_funded, mm_bot_self_sus, mm_tac_st_funded, mm_tac_self_sus   mini-master table DFRAY 17-MAY-06

UW College of Engineering