Queries whose name begins with jobl. Primary contact is Doug Hearrington hearridb@jmu.edu Section last updated 2/9/2017.
jobl00 (NTS): Grade anal by deliver mode. Contains a prompt for academic term and an optional prompt for course delivery modes listed below. The primary major degree field is from the students primary major as of the census date of the term entered. In the event multiple instructors are returned for the same course, it is because the department responsible for keying the course data entered multiple primary instructors which the query cannot resolve. Delivery modes to use:
ID will return those courses tracked as 100% Internet Delivered. .
HY will return those courses tracked as 51% or more online, aka hybrid courses
IP will return those courses tracked as 100% in person
MP will return those courses tracked as 51% or more in person
jobl01 (NTS): Grade anal for matches. Similar to joe100. In this case a “match” is defined as a course (defined as the crse_id value) being offered for the prompted for term as BOTH a hybrid or internet delivered course AND the same course also being offered with a delivery mode-IP (100% in person).
jobl02 (NTS): Not in online degrees. Prompts for a single term. Returns enrollment information for students enrolled in a 100% Internet Delivered (delivery mode=ID) course for the given term who is NOT active as of the census date in one of the x academic plan/programs considered to be online degree only. After research and confirmation from the office of the registrar, the plans included are below.
OR one of these subplans: ('00002260500','00002260600','00077000227')
jobl02a (NTS): In online degrees. Is the inverse of joe102; these students ARE active as of the given census date in one of the listed academic plans/programs.
Jobl02b (NTS) Baseline online population. contains no prompts built for the sole purpose of knowing a baseline population of those students active in the list of academic program, plans and sub-plans provided by the office of the registrar
jobl03 (NTS): Online student demo. Prompts for a single term, returns basic student demographics for those enrolled in a course who delivery mode=ID (100% Internet Delivered). The address fields returned are for the addr_type=HOME.
jobl04 (NTS): Learning activities data. Returns course enrollment details for the prompted for term whose instruction mode is any of the following hard coded values. *** note, the SA system does NOT track the locations of these various instruction modes.
jobl05 (TS): JMH contract data. Prompts for a single course term. The logic present includes:
The baseline of this query is dependent upon each student being active as of the date the query is run in a student group=JMH.
The student had to have matriculated in the given program stack of data on/after 6/1/2016. Because of this hard coded date, the query may need to be adjusted when run after the Spring 2017 term.
The student is currently active in one of the following academic plan numbers: ('0000005950','0007000050','0007000051','0007000052','0007000210','0007000226','0007000176','0007000201','0007000225','0031500000','0007000215','0007000220','0007000260') OR active in the academic plan number 0039005000 and either sub-plan numbers ('0002260500','0002260600')
Enrollment data is left outer joined to allow students to be returned even if they are not enrolled in any courses for the given term.
This version of the query does not include data related to the employee tuition waivers as that data is on the item_sf record to which some users who need the results do not have access.
jobl05b (TS): JMH contract AA only. The only difference from jobl05 is that this version contains the item_sf record which is used to return a Y/N if the student has a current employee tuition waiver defined by these three item type values: ('720000001600','720000001730','060000000000')
jobl05c (TS): Not in proper plans. Contains no prompts, and should not return any rows. IF a row of data is returned, it is because the student is active in the student group=JMH, but their current program stack of data is not in line with the logic used in the jobl05 query.
Outreach and Engagement
Queries whose name begins with joe. Primary contact is Sarah MacDonald macdonsk@jmu.edu Section last updated 7/2/2018.
Joe001 (TS): selects anyone whose academic program status is <> CM for those in the program CE125. This means it returns active, both also those who have discontinued. NORMALLY, when folks want to return program data, they want active students only, but I know CE careers can be an interesting career. So, there are no time related specs in the selection. Joe001a is similar but prompts for a single term.
Joe006 (TS): selects students who are in the CE125 program.
Joe007 (TS): selects students in the academic plan=0000005950 (Individualized Study – BIS major) prompts for a term range and returns a count of the number of these type students in each of the courses they took.
Joe008 (TS): selects ce125 students who have not completed their program, and have one or more terms with zero enrolled hours.
Joe009 (TS): selects students in a plan=9999999600 (High School Special) who were admitted between the terms 1001 and 1108 (hard coded values). Returns their HOME email address. ** If you want to keep using for other terms, suggest adding a term range.
Joe009a (TS): only difference from joe009 is the hard coded term range in this query is 1001 thru 1111.
Joe0010 (NTS): Returns instructors for a given term who are teaching a course whose section is between OP01 AND OP14.
Joe013 (TS): All students active in a CE academic program (except CE175 and CE250) Return their JMU and secondary email addresses, name, emplid#, academic program and program description.
Joe014 (NTS): Prompts for a range of course enrollment terms and 1-5 academic plan numbers. Returns student enrollment details. Joe014a returns aggregate/summary data for the same population.
JOE015 (NTS): All students whose academic plan is BIS (Bachelor of Individualized Study), with a list of their stdnt_enrl data from the current semester. Return the specific course information and their JMU and secondary email addresses, name, emplid#, academic program and program description. Joe015a returns aggregate/summary data for the same population.
Joe0018 (NTS): returns courses for a prompted term whose instruction mode=WW (aka online or the world wide web) which have not been cancelled.
Joe0019 (NTS): returns a list of enrolled courses for students in the CE150 program for a prompted for term range.
Joe0020 (NTS): BIS not enroll after this term. BIS students who have not enrolled in courses in the two previous semesters.
Joe021 (NTS): CE150 students from Clarke. No prompts. Returns aggregate information of students who had ever been in the CE150 program and if they applied, were accepted and ever attended JMU in the UGEN program.
Joe022 (NTS): Online program zip codes. Prompts for a range of admit terms, returns a count of the number of students who were active in a list of hard coded plan numbers by their zip codes.
Joe023 (NTS): Experiential Learning credits. Returns a list of students who have forever in the history of JMU received experiential learning credits defined by the name of the organization found in the transfer course school record. The values used to determine the criteria are hard coded.
Joe024 (NTS): OP courses by term. Prompts for a single term value. Returns a list of courses who have the letters OP in the section.
Joe025 (NTS): BIS last term data. were ever a BIS major in the history of JMU, and never graduated and not active in their career. Criteria provided by Sarah MacDonald.
Joe026 (TS): Course anal for Ed Leadership. Prompts for a single term, use the current term. Returns a list of students in specific plans designated educational leadership ad their progress in series of courses defined by Sarah MacDonald.
Joe026a (TS): Course anal for Ed Technology. Similar to joe026, but for the educational technology plan.
Joe027 (NTS): no prompts. Returns a list of BIS graduates who also have GR/DR graduate information.
Joe028 (NTS): Active BIS majors for drilling. Prompts for the current term. Includes drilling URL’s for additional data.
Joe029 (NTS): Contains no prompts. Returns aggregate data by term of the number and amount of students who used tuition waiver monies. Includes the item types: ('720000001600','720000001730','060000000000')
