FREQUENTLY ASKED QUESTIONS ABOUT REPGEN

• QUESTION: EXPLAIN THE FIELD "EXACT" ON THE SUBJECT MENU AND THE RESULTS THAT OCCUR WHEN YOU SELECT OR DON'T SELECT THIS OPTION.
  
  ANSWER: We do not have a student record for each term for a student. The student record contains data like college, status, major. A student record is only created when a piece of data changes. So, if a student comes to UVM and never changes major or anything else, s/he would have only 3 student records:
  
  

  TERM	STATUS	TYPE	LEVEL	COLLEGE	MAJOR
  199709	AS	1	UG	20	BSAD
  199801	AS	9	UG	20	BSAD*
  200001	PC	9	UG	20	BSAD**

  
  
  * Each term we run a process to change 'new' types (1,2,3,7) to 9 (continuing). So, this person got the 199801 record because they went from 1 to 9.
  
  ** When someone graduates, they have a student record created for the term they graduated w/ a PC status.
  
  Because we do not have a student record for each term, the normal REPGEN logic used is 'select the student if the maximum student record term is less than or equal to the term specified and it meets the other criteria'. When you use 'Exact', the REPGEN logic changes to student term = term you entered. The term has to be an exact match.
  
  So, using the example above, if you wanted to get a list of everyone w/ status PC for 200201, and you do not use 'exact', the person above would be selected. That person's term, 200001, is less than 200201, and the status is PC. So the person matches what you asked for (but that is probably not what you wanted). If you say exact = Y, that person would not be selected, because the term 200001 does not = 200201.



• QUESTION: HOW WOULD YOU ENTER A QUERY THAT ASKS FOR THE NAMES OF CURRENT BUSINESS JUNIORS WITH CUM GPA 2.5 OR ABOVE, ARE FULL TIME AND WHOSE LAST SEMESTER GPA IS 2.5 OR ABOVE?
  
  ANSWER:
  Current = use registration term
  Business = student college = 20
  Junior = use student term and class 03
  Full time = 12+ registered credits
  Cum GPA 2.5 or above = cum GPA range 2.5 and 4.0
  Last semester GPA = you need to specify a term
  
  Semester GPA term is not performing optimally right now. If you leave the semester GPA term blank AND the student term is blank, it will perform a select max TGPA term. However, if you leave the semster GPA term blank and student term is NOT blank, REPGEN will make semester GPA term = student term. Since usually the student term is current (eg 199909), and there aren't any semester GPA's for 199909 yet, this means you get a count of 0.
  
  REPGEN should be modified so if semester GPA term is blank, it will always select max regardless of other values in REPGEN. This is on the list of 'things we would like fixed in REPGEN'. However, w/ Y2K upon us, it is not something that will be fixed soon. So, for the interim, you need to specify a TGPA semester. To give a specific context to the query above, then, you would use these selects:
  
  registration menu term = 199909
  registration menu credits = 12 - 999.99 (you decide whether or not to include WD courses)
  student menu term = 199909
  student menu college = 20
  student menu class = 03
  academic history menu cum gpa values: 2.5 - 4.0
  academic history menu sem gpa values: 2.5 - 4.0
  academic history menu sem term = 199901
  
  If you want juniors whose max sem GPA term is 199906 or 199809, you have to run separate queries for each of those terms. This is an example where you would NOT use the exact feature on the student menu. The maximum student term for these students could well be 199809 or 199901. If you choose exact = Y, it would only select students who have a student record term = 199909.
  
  
  
• QUESTION: HOW DOES REPGEN RECOGNIZE CLASS LEVEL?
  WHEN I INPUT A LEVEL (01,02,ETC) FOR "CLASS LEVEL" ON THE STUDENT MENU USING A TERM THAT HAS ROLLED TO HISTORY, IS IT RECOGNIZED AS THE SAME INFORMATION IF I INPUT THE CUM HOURS ON THE ACADEMIC HISTORY LEVEL?
  
  ANSWER: REPGEN defines class as "current class for the term WITHOUT the credits you are currently enrolled in".
  
  Here is an example:
  

  TERM	CURRENT REGISTERED CREDITS	CLASS	CREDITS AFTER GRADES ROLLED
  199509	15	01	15
  199601	15	01	30

  
  In the above example, if you ask for class 01 for 199601, this person would be selected. If you ask for class 02, this person would NOT be selected.
  
  If you do the select based on academic history cum hours, this person would be considered to have 30 hrs.
  
  
  LAST UPDATE: 11/18/99 Sue Osborne