|
Documented Queries
Home <> Information <>
Queries
<> Reports <>
Processes |
|
Go
to
Prospect and Applicant Queries
Go to Student Queries
Go to Course and Faculty Queries |
|
Prospect and Applicant Queries |
|
Applications Received |
This query delivers a list of
applicants who've applied to the college within the date
range specified. |
|
Applied Not Enrolled |
This query delivers a list of
applicants who've applied to the college but have not yet
enrolled. |
New Applicants
(New 11/15/2006) |
The
purpose of this query is to report students who have applied
to the college in a specified date range for a specific
admit term but are not enrolled for classes in that admit
term or since. |
Not Enrolled and Not Graduated
(Added 2/27/2008) |
This query looks for students who were
enrolled in a term or range of terms and who are not
enrolled in the term you specify in the selection. |
|
3C Query Checklist Item Status |
The
query Checklist Item Status is designed to provide you
information on specific checklist items; typically the
status of Initiated or Complete. |
|
3C Query Letter Assigned |
The
query Letter Assigned is designed to provide you information
on the students who have been assigned a specific letter and
the communication is not complete. |
|
Complete BAPP Checklist |
The
query Complete Baccalaureate Application Checklist is
designed to provide a list of all students who have a
completed checklist. |
|
back to top |
|
Student Queries |
|
Attendance Info by Org
Attendance Info by Class |
The
S_ATTENDANCE_INFO_ORG query is designed to allow you to access all
attendance entries and non-entries by term, academic org, and campus.
The
S_ATTENDANCE_INFO_CLASS query is designed to allow you to access all
attendance entries and non-entries by term and class number.
|
|
Check Enrollment Figures |
The purpose of this query is to ascertain enrollment figures based on
Academic Term, Academic Org and Campus. |
|
Dual Low GPA |
The purpose of this query is
to show Dual Credit students who have a
cumulative GPA which has fallen below 3.0. |
|
Grads By Plan |
The purpose of this query is to provide names of students who
have completed (graduated) particular plans
within a given term. |
LD_Select_Admit
(Updated 3/6/2007) |
This query
delivers a list of students who received a certain communications letter
such as admissions or denial. |
|
New Students |
This query delivers a list of
new students' contact information by campus. |
|
Non US Citizens Enrolled |
The purpose of this
query is to identify enrolled students who are non US citizens. |
|
Non US Citizens Addresses |
The purpose of this query is to provide
addresses of students who are non US citizens. |
|
Plan Cum GPA |
This query delivers a list
of all students currently active in the program and plan specified along with their
term and cumulative GPA and credits. |
|
Program
Class by Term |
The purpose of this query
is to list the academic plans and contact
information of the students enrolled in a specific class. |
|
Program
Completed |
This query is no longer available.
Please use the GRADS_BY_PLAN
query. |
Program Plan
(Updated 11/28/2006) |
This query lists all students currently active in the
program and plan specified. The query does not
look at the student’s enrollment. |
|
Program
Plan by Term |
This query lists all students
currently active in a specific program and plan and enrolled in
at least one class for the term specified. |
|
Program Plan Subplan |
This query lists students active in a program, plan and subplan as of
a specified date. The query does not
look at the student’s enrollment. |
|
Service Indicator No Enroll |
The
purpose of this query is to provide a list of students, by plan, who have a
specific service indicator and are not enrolled
in the term specified. |
|
Specific Courses |
The
purpose of this query is to list all students who are enrolled in specific courses during a selected term. |
|
SSS3EXT |
The
purpose of this query is to show course enrollment
of students within a particular student group(s). |
|
STGRP Acad |
This query provides a
snapshot view of the academic status of
the students in specified student groups along with their advisor and degree
earned (if any). |
|
STGRP Bio Demo |
This query provides demographic data and contact information
of students in specified student groups. |
|
STGRP Classes
STGRP_Classes_2
(Updated 11/20/2006) |
The
purpose of these queries is to provide tracking information for specified
student groups relative to the classes they are taking for a given term.
For S_SR_STGRP_CLASSES, the results include the start and end dates of the
students' courses and instructor/advisor information. For
S_SR_STGRP_CLASSES_2, gender and ethnicity replaces the dates
of the courses as well as the instructor/advisor information. |
|
STGRP Cum Grad |
This
query delivers a list of all students currently active in the student group(s) along with GPA
specified regardless of enrollment. |
|
STGRP Service Indicators |
This
query provides a view by term of students in specified student groups who
have service indicators. |
|
Students by Acad
Org |
The purpose of this query is to list all
students who are enrolled in a class with the academic organization
for the term selected. |
|
Student Email Addresses |
The purpose of this
query is to list all students' addresses, phone
numbers and email addresses in a class
specified. |
|
Students Location |
Students by
term, location code and plan, enrolled in classes at that location for that
term with results including ethnicity, gender, and DOB. |
|
Testscores |
The
purpose of this query is to list all students who have taken a specific test like the CPT within a certain
date range along with the scores. |
Unpaid Registered Students
S_SF_DUEDT_CAMP
(Updated 8/9/2006) |
The purpose
of this query is to provide a list of students by due date
and campus who have
registered for classes in a specific term but have not yet
paid their tuition. |
Warning Probation
(Updated 4/17/2007) |
The
purpose of this query is to list students who have been placed on warning or probation, have been dismissed
or suspended, or are in good standing. |
Withdrawals
(Updated 8/9/2006) |
This query details
by academic term, date range and academic group which students were OPS
(system) dropped for non-payment. |
|
back to top |
|
Course
and Faculty Queries |
Audit (Grade Roster)
(Updated 11/15/2006) |
The purpose of this query is
to list grade entries and grade changes to the grade roster. |
|
Audit (Workload) |
This query will identify
the user that makes a change to an instructor’s workload. |
Base for Budgeted
 |
This query lists all full time instructors for the
terms specified, with the Instructor Assignment and the sum of the workload
for the base workload. |
|
Cancelled Class
Cancelled Class 2
|
S_CFM_CANCELLED_CLASS will identify the classes that have been cancelled and
have an attribute. S_CFM_CANCELLED_CLASS_2 will identify classes cancelled
that do not have an attribute. |
|
Class Association 1
|
The
purpose of this query is to list the classes in the term that have the number 1 in the
class association field which is invalid. |
|
Classes by Instruct Mode |
The Classes by Instruction Mode query gives a list of all classes offered in
the term specified that are scheduled with the
Instruction Mode inputted. |
|
Class Instructor |
The purpose of this query is to list all the
instructors assigned to classes in the term and academic org
specified. |
|
Class Section 9999
|
The purpose of this query is to list the classes in the term that have the section number of 9999. |
|
Class Status
|
The purpose of this query is to list the classes in the status of active,
stop further enrollment, tentative section, or cancelled section for a
specific term, campus and academic org. |
|
Credential_Cross_Check |
The purpose of this query is to find any instructors not properly
credentialed for their classes. |
DD_Associated Class
(Updated 10/27/2006) |
The purpose of this query is to list the Associated Class number for
Dynamically Dated classes in a given term. |
|
DD Bad Dates
|
The
purpose of this query is to identify the Dynamically Dated classes with the same dates as
other sessions. |
|
DD
Session No Dynamic Date
|
The
purpose of this query is to list the DD session classes
that do not have their dynamic dates calculated. |
|
Enrollment By Subject |
The
purpose of this query is to help track enrollment
in classes with a particular subject prefix like MAT that
starts and ends within a specified time period. |
Facility Check
(Updated 8/22/2006) |
The purpose of this query is to find all the
rooms at your location that are not set to check for facility conflicts
when scheduling classes. |
Instructor Workload
(Updated 8/9/2006) |
The purpose of this query is to list all instructors for the given term or
range of terms who have non-instructional assignments with workload. |
Instructors and Courses
(updated 8/20/2007) |
The purpose of this query is to list the courses that all the
instructors are credentialed to teach. |
|
Instructor TBA
|
The purpose of this query is to list all
classes in the term you have selected that an
instructor has not been assigned to the class.
|
|
Less Than
15 Hours
|
The purpose of the query is to list
employees with instructor status that are scheduled for less than 15 hours
of workload in the classroom. |
|
List Course ID |
The purpose of this query is to list all the
courses in the catalog. |
|
Location and
Facility |
The purpose of this query is to
list all classes scheduled in a selected location
and facility for the selected term. |
Missing Facility
(Updated 7/6/06) |
This query is for finding all
the non-cancelled classes for the term selected that do not have a classroom assigned to it. |
|
Missing Grades |
The purpose of this query is to identify grade rosters by approval status for
end of term grade submission tracking. |
Missing_Meeting_Pattern
(Updated 7/6/2006) |
This query lists all the classes for the term selected
that do not have a meeting pattern
entered in the Schedule of Classes Meetings page. |
|
No Consent
|
The purpose of this query is to list all classes that do not have No
Consent on the consent area of schedule of classes on enrollment tab. |
|
Post
|
This query llists the classes with
instructors with a grade roster access other than Post. Post is
needed to enter and approve grades. |
|
Term Workload
|
This query lists all
instructors for a given term and academic org with their contract FTE details.
|
Variable Credit Courses
(Updated 10/30/2006) |
This query lists all the variable credit classes that are
offered in the term and campus selected. The min and max units in the
Assoc Class unit columns should always be the same. |
Withdrawals
(Updated 8/9/2006) |
This query details
by academic term, date range and academic group which students were OPS
(system) dropped for non-payment. |
|
Workload Discrepancies |
This query details by
academic term, which classes have a workload discrepancy between the
workload screen and the sum work load on the schedule of classes. |
|
back to top |
