Queries whose name begins with jmusic. Primary contact is Donna Wampler wampledk@jmu.edu Some also used by Mary Jean Speare for completing the annual HEADS survey and Jeanette Zyko. Section last updated 10/26/2016.
Jmusic001 (NTS): List of all music students. Returns all students who are active in a music academic plan which spans undergraduate and graduate plan numbers. Designed to be run for any given term.
Jmusic002 (NTS): Music majors and MUS195. Returns a list of UG music students and the number of terms of MUS195 they have completed. A student is required to take 6 terms of MUS197 to graduate.
Jmusic003 (NTS): Music students sub-plans. Similar to jmusic001 with sub-plan data included.
Jmusic004 (NTS): Prompts for a term range. Returns all courses for music graduate and doctoral students in the two academic programs GR420 or DR250.
Jmusic005 (NTS): Music grads by plan. Prompts for a degree conferred date range. Has the five music majors hard coded. Returns aggregate data for the annual HEADS survey. Detail data can be returned from the query this was cloned from; jusdh009.
Jmusic005a (NTS): Similar to jmusic005, but includes detail student data vs jmusic005 which returns aggregate data.
Jmusic006 (NTS): Music grads by plan, other major. Prompts for a degree conferred date range. Has the five music majors hard coded. Returns detail data for the annual HEADS survey. Used to report those music majors who graduated with a major OTHER than music. Need the original music major data as well as the survey asks which area (concentration). Was cloned from jusds007g.
Jmusic007 (NTS): Music UG by gender and ethnicity. Prompts for a single term. Aggregate results returned per annual HEADS survey format. Was cloned from jusdh001. Important note: this query returns data based upon students active in a music major whereas the two previous queries are based upon music graduates.
Jmusic008 (NTS): Credit hour production by term. Prompts for a single term. Returns credit hour production for two populations as defined in the annual HEADS survey. Specifications provided by Mary Jean Speare.
Jmusic008a (NTS). Similar to jmusic008, but this version aggregates data by academic year and returns distinct counts.
Jmusic009 (NTS): Music majors by plan summary. Returns aggregate counts for all 7 music related plans for a given term range.
Jmusic010 (NTS): Music students on pro/sus. Has the same 7 hard coded academic plan numbers as others in the jmusic series. Prompts for a current academic term and the term to use for determining academic probation and suspension.
Jmusic011 (NTS): Music students by subject. Prompts for an academic term, returns aggregate data for all of the course subjects being taken by music students.
Jmusic012 (NTS): MUAP course analysis. Prompts for an academic term range, returns aggregate data on 42 different MUAP subject courses on the number who have passed and failed the returned course.
Jmusic012a (NTS): Similar to jmusic012, but this version selects all MUAP subject courses vs. just the 42 hard coded in jmusic012.
Jmusic013 (NTS): Jazz course enrollment. Contains a hard coded term range for any course with the word “jazz” in the description of the course.
Jmusic017 (NTS): Music application data. Written specifically for music instructor Jeanette Zyko as part of the new CVPA application additional information project. Prompts for an admit term. Has a hard coded list of 23 music specialties the applicant can select from which are part of the school of music.
Jmusic017a (NTS):Drill down all tests. Used by jmusic017 as a drill down into a students tests.
Jmusic018 (NTS): Music app test scores. Prompts for an academic term, contains the same 23 hard coded values present in jmusic017. Returns all test scores for the given population.
Nursing
Queries whose name begins with jnurse. Primary contacts are Christy Comer comerca@jmu.edu Kelly Schuhmann schuhmkf@jmu.eduand Tori Martineau martinvl@jmu.edu Section last updated 12/1/2015.
jnurse001 (TS): Acad data for non UGEN nursing. Cloned from jusds002 query to jnurse001 for Christy Comer (nursing graduate programs). Needed a version of the query for the 5 Nursing academic plans. Other jusds002 queries include acad_prog which varies for their program, so needed a separate version of the query.
jnurse002 (TS): Whitehead stat report. Created for Becky Meadows in nursing who says this is an annual report they need to submit the data to this foundation. She get's the FA data from Vivian Ferris. Email to user: Becky, The data below came from a query named jnurse002 in the SA production system. These notes are more for me than you ¿ I used the singe query, but due to the nature of the request, had to modify it a few times to obtain the desired results, which are as follows: Total Full time Enrollment (Declared BSN Nursing Majors ¿ Soph, Jr. Sr.) : 912 Full time Female Enrollment (of above #) : 847 Total full time FEMALE enrollment from Alabama, Florida, Georgia, Louisiana, Mississippi, North Carolina, South Carolina, Tennessee, and Virginia (of above #) : 643 Alabama: 2 Florida: 4 Georgia: 0 Louisiana: 0 Mississippi: 0 North Carolina: 5 South Carolina:0 Tennessee: 0 Virginia: 632.
jnurse003 (TS): Chronic illness crs progressio. Created for Lam, Christina Karen - russelck . Hello Pete, I am hoping you can assist in mining some data on students who are declared chronic illness minor students. I am looking to see of our declarees who has not taken NSG 390 and NSG 391. I am hoping this information will help inform decisions about expanding the course
jnurse004 (TS): AACN Data for Nursing. How many students were offered admission into the RN/BSN Program for the terms 1151 and 1158 2) How many students enrolled and registered for these terms
jnurse005 (TS):Nursing course analysis Cloned from jlad001 for Schuhmann, Kelly - schuhmkf
schuhmkf@jmu.edu Here’s what I need to know: Any declared Nursing major who has completed CHEM 120, MATH 220 and at least 2 of the following 3 BIO courses: BIO 270, BIO 280, BIO 290 with a grade of C- or better and who has a GPA of 3.0 or above. Any chance you can help me get this info? added the logic of checking the section number 1st digit after calling Shelia in BIO to verify all labs begin with a digit other than 0, and letting labs thru was causing the returned numbers to be overinflated and we are not trying to test that they passed the lab, just the lecture whose section 1st digit=0. 11/3/2015: modified to use saa_adb_courses so can get transfer credit courses, etc.
jnurse006 (TS): Diversity data for nursing. Cloned from jnurse005 for Martineau, Tori - martinvl martinvl@jmu.edu We are in the process of writing a grant that asks for specific numbers of diverse students and enrollment data and you are the one person I know who can help me with this! I am looking for a few specific things for this project: For ALL nursing programs traditional undergraduate BSN, sub-plan of RN/BSN and graduate MSN and DNP for academic years 2010-2011, 2011-2012, 2012-2013, 2013-2014 and 2014-2015: 1) Total enrollment numbers for all programs 2) Total White 3) Total Black 4) Total Asian 5) Total Hispanic 6) Total more than 1 ethnicity row 7) Total Not Specified
jnurse007 (TS): Nursing double major grads. Cloned from jnurse006 per email from Meadows, Rebecca A - meadowra@jmu.edu I am working on a survey for the VA Board of Nursing that asks how many graduates have a degree in a discipline other than nursing. Is there a query that will return this data for a specific term?
jnurse008 (TS): Summary data for RN/BSN. Cloned from jnurse006 for Martineau, Tori Is it possible to get another query for some more data? It seems like it’s survey time here in the Nursing Department and this time I need GPA and age for RN/BSN students from terms 1148 and 1151. This is exactly what I need: Average GPA for students admitted in 1148 and 1151 Average age of students admitted in 1148 and 1151
jnurse009 (TS): Fully admitted, missing mrest. Contains no prompts, all logic is hard coded within the query. Returns all active nursing majors who are fully admitted and have not completed the MREST which is tracked as any of these student milestones: ('ISST','ISST ADV','MRSTA','MRSTP').
jnurse009a (TS): Fully admitted, has finaid. Contains no prompts, all logic is hard coded within the query. Returns all active nursing majors who are fully admitted and who were awarded any type of financial aid in the prompted for academic year.
jnurse010 (NTS): BON data graduates. Prompts for a range of degree conferred terms. Returns data to be sent to the VA Board Of Nursing as defined by Rebecca Meadows. Query must be run by someone with access to highly confidential data as the query contains the last 4 digits of the SSN as required by the BON for student identification.
