Query Glossary

January 18, 2023

Introduction

Note: Your screen may look different from the screenshots in this article.

In the my.SDSU portal, staff with specific roles will be able to schedule reports, which are called Queries in my.SDSU. The Query names are different from the legacy report names. This glossary will help you locate the correct Query to schedule based on the legacy report name.

  • For instructions on how to schedule a Query, please refer to this guide.
  • For instructions on how to run the Course Demand Report, please refer to this guide.


Note
: More Queries are continuously being added to my.SDSU, so there may be Queries in my.SDSU that are not represented in this guide.

Glossary

Note: Which queries are visible to you will depend on your role(s) in my.SDSU. If you need access to a specific report, please submit a ServiceNow ticket so that my.SDSU team can review your security roles and access.

Note: my.SDSU does not support favoriting queries in Query Scheduler. However, you have the option of reusing run controls you previously created to save time in the future.

my.SDSU Query Name Description Folder Legacy Report Name
SD_ELIGIB_TO_ENRL_PRI_OBJ The Continuing Students Eligible report is now multiple reports in my.SDSU. This report contains all continuing students in a specified period along with their majors, degrees, colleges, departments, and units enrolled.     SR: ENROLLMENT   Continuing Students Eligible to Enroll  
SD_CM_SECT_CRS_DMND   The Course Demand Report is now multiple reports in my.SDSU. This report contains a separate row for each section of a course.    CM: SCHED BUILDING Course Demand Report  
SD_SCT_DMND_SUMMARY The Course Demand Report is now multiple reports in my.SDSU. This report summarizes enrollment for all sections of a course in a single row.  CM: SCHED BUILDING Course Demand Report  
SD_SECT_STDNT_LST The Course Demand Report is now multiple reports in my.SDSU. This report contains a separate row for each student enrolled, on the wait list or in the shopping cart for a course section. CM: SCHED BUILDING Course Demand Report  
SD_CLASS_SCHEDULE_RPT Lists all classes being offered in a specified term. SD: UTILITY REPORT   Download Feature of Class Schedule
SD_SR_ENROLLED_PRI_OBJ Lists all students already enrolled in a specified term with their majors.   SR: ENROLLMENT   Enrolled Students: Majors and/or Minors  
SD_SR_ENROLLED_ALL_OBJ Lists all students already enrolled in a specified term with their majors and minors.   SR: ENROLLMENT   Enrolled Students: Majors and/or Minors  
SD_SOC_FF_NOTES Free Form list of Class Schedule Footnotes converted from SIMS.  CM: SCHED BUILDING   Footnotes/Classnotes  
SD_CM_HOMELESS_SECTIONS Lists all sections of a class that have not been assigned a room.    CM: SCHED BUILDING   Homeless Sections  
SD_CM_SCHED_SECT_LISTING Lists all sections of classes being offered in a specified period.   CM: SCHED BUILDING   Schedule Section Listing  
SD_CM_INST_GRD_RSTR_ACCESS Lists all classes that have not posted their grade rosters in a specified period.   CM: SCHED BUILDING   SOC Instructor Grade Roster Access Not Post  
SD_AD_UG_APP_COUNT_BY_RES Lists application Counts by Residence Status. Access to this report is limited.   UG_ADMISSIONS   N/A  

Explanation of Common Query Filters

Queries provide you with an opportunity to filter your search results before you export them. Each Query will have required filters, marked with an asterisk * and optional filters, marked as [OPTIONAL].

For most filters, you will have the option of typing the criteria directly into the text box or searching for the desired criteria using the magnifying glass Query Glossaryicon. Please see an explanation of common required and optional filters.

Note: If you export your Query as an Excel document, you will also have the option of filtering your data after you run the Query.

Field Name Description
Institution The Institution field will default to SDCMP for SDSU Campus. You cannot choose other campuses, but this prompt is necessary for the other look-ups to work.  
Term You can enter the four digit term or search for a term by using the magnifying glass icon. Terms follow this format: CYYT, where C is the first digit of the Century, YY is the last two digits of the year, and T is the Semester. C will be 1 for 1900’s and 2 for 2000’s. T will be 1 for Winter, 3 for Spring, 5 for Summer, and 7 for Fall. For example, Fall 1999 is 1997, Spring 2023 is 2233.
Campus [Optional] If you would like to filter your results to a specific campus, you can do so using this field. If you leave it blank, you will receive results for all campuses.
College [Optional] If you would like to filter your results to a specific college, you can do so using this field. If you leave it blank, you will receive results for all colleges.  
Dept [Optional]   If you would like to filter your results to a specific department, you can do so using this field. If you leave it blank, you will receive results for all departments.  
Acad Plan [Optional]   If you would like to filter your results to a specific academic plan, you can do so using this field. If you leave it blank, you will receive results for all academic plans.  
Subject [Optional]   If you would like to filter your results to a specific course subject, you can do so using this field. If you leave it blank, you will receive results for all course subjects.  
Eligible Only   If you select this check box, your results will contain only students who are eligible to enroll in classes for a specified term. Please note that being eligible to enroll does not necessarily mean that students have already enrolled.  
Career Check the UGRD (undergrad), GRAD (graduate), and/or GLBL (global campus) Career check boxes to receive any or all of those populations in your results.  
Categorized As