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
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
Class                     TMILDON 22-MAR-07
Credit hours                     TMILDON 09-APR-07
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
New/Continuing/Returning                     TMILDON 22-MAR-07
Part-time student                     TMILDON 09-APR-07
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
Seminar room                     TMILDON 04-MAY-07
Undergraduate                     TMILDON 22-MAR-07
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