ConnectND and Customized Queries

ConnectND and Customized Queries

Information Technology Services (ITS) has developed customized ConnectND (PeopleSoft) queries to meet informational needs of various departments at DSU. The following queries are available at this time. We are currently working on writing some more useful queries. Please visit this page to see information on new queries as they become available. If none of these queries meet your needs, please contact ITS at 483-2109.



NDU_DSU_SR_01: STUDENT -GRADE DISTRIBUTION

Description: This query gives the names of the students and the grades that they have earned in a particular term.

Data Fields: ID, Last Name, First Name, Class Nbr, Grade (Grade Earned), Units, Term, Institution.

Sorted by: Last Name and then First Name.

Sample result set of the Query



NDU_DSU_SR_02: TERM - STATISTICS

Description: This query gives the list of all students, term units they have passed and the term GPA earned in a particular term.

Data Fields: Last Name, First Name, ID, Units Passed, Term GPA, Term, Institution.

Sorted by: Last Name and then First Name.

Sample result set of the Query



NDU_DSU_SR_03: STUDENT RACE AND GENDER INFO

Description: This query gives the list of students enrolled in a particular term, their Ethnic Group and Gender information.

Data Fields: ID, Last Name, First Name, Middle (Name), Gender, Ethnic Grp, Institution, Term

Sorted by: Last Name and then First Name.

Sample result set of the Query



NDU_DSU_SR_04: STUDENT RACE, GENDER, ACAD LEVEL

Description: This query gives the list of students enrolled in a particular term, their Gender, Ethnic Group and Academic Level (Freshmen/Sophomore/Junior/Senior) information.

Data Fields: ID, Last Name, First Name, Middle (Name), Gender, Ethnic Grp, Academic Level, Institution, Term

Sorted by: Last Name and then by First Name.

Sample result set of the Query




NDU_DSU_SR_05: TERM - STUDENT GRADES

Description: This query gives the list of students and their earned grades in a particular term.

Data Fields: ID, Last Name, First Name, Subject, Catalog, Description(Class Name), Class Nbr, Grade, Units, Term, Institution

Sorted by: Last Name and then by First Name.

Sample result set of the Query



NDU_DSU_SR_06: TERM - CLASSES- GRADES

Description: This query gives the list of all Classes, Students in each class, the grades they have earned in that class.

Data Fields: Subject, Catalog, Description (Class Name), Last Name, First Name, ID, Grade, Units, Class Nbr, Term, Institution.

Sorted by: Subject, Description (Class Name), Last Name and then by First Name. 

Sample result set of the Query



NDU_DSU_SR_07: SECTION STATUS REPORT

Description: This query gives the list of all Classes, instructor teaching the class, Capacity and Enrollment of the class.

Data Fields: Subject, Catalog, Instructor ID, Last Name (of Instructor), First Name (Of Instructor), Class Nbr, Units Taken, Cap Enrl (Enroll Capacity), Tot Enrl (Total Enrolled), Term, Institution.

Sorted by: Subject, Catalog, Last Name and then by First Name.

Sample result set of the Query



NDU_DSU_SR_08: STUDENT ADDRESSES

Description: This query gives the list of all the students in a particular term and all their available addresses.

Data Fields: ID, Last Name, First Name, Middle, FERPA, Address Type (BILL, DORM, HOME, ,LEGL, MAIL, PERM,PREF, PRT), Address 1, Address 2, City, County, St, Postal, Country, Institution, Term.

Sorted by: Last Name, First Name

Sample result set of the Query



NDU_DSU_SR_09: STUDENT AGE DETAILS

Description: This query gives the list of all the students in a particular term and their Date of Birth, Age and Gender information.

Data Fields: Last Name, First Name, Middle,ID, Gender, Ethnic Grp, BirthDate, Age, Institution, Term.

Sorted by: Last Name, First Name

Sample result set of the Query



NDU_DSU_SR_11: INSTRUCTOR- CLASSES REPORT

Description: This query gives a list of all the instructors and the classes they are teaching in a particular semester.

Data Fields: Instructor ID, (Instructor's) Last Name, First Name, Middle, Subject, Catalog, Descr (Name of the Class), Class Nbr, Units taken, Cap Enrl, Tot Enrl, Term, Institution

Sorted by: (Instructor's) Last Name, First Name, Subject Area, Catalog Number

Sample result set of the Query 

 

NDU_DSU_SR_12: FULL TIME STUDENTS

Description: This query lists all the full time students (12 credits or more), units taken, Gender and Ethnic Grp Information

Data Fields: Last Name, First Name, Middle, ID, Gender, Ethnic Grp, Units Taken, Institution, Term.

Sorted by: Last Name, First Name.

Sample result set of the Query



NDU_DSU_SR_13: PART TIME STUDENTS

Description: This query lists all the part time students (less than 12 credit hours), units taken, Gender and Ethnic Grp Information.

Data Fields: Last Name, First Name, Middle, ID, Gender, Ethnic Grp, Units Taken, Institution, Term.

Sorted by: Last Name, First Name.

Sample result set of the Query



NDU_DSU_SR_14: STUDENT GROUPS

Description: This query lists the student groups and the students that belong to these groups.

Data Fields: Group Name, ID, Last Name, First Name, Middle, Institution.

Sorted by: Group Name, Last Name, First Name.

Sample result set of the Query



NDU_DSU_SR_15: CUMULATIVE STATISTICS

Description: This query gives cumulative statistics such as earned Cumulative Units, Cumulative GPA, Primary Program of students in a particular term.

Data Fields: ID, Last Name, First Name, Cumulative Units, Cumulative GPA, Primary Program, Term, Institution.

Sorted by: Last Name, First Name

Sample result set of the Query



NDU_DSU_SR_16: STUDENTS MAJORS AND MINORS

Description: This query lists all the students enrolled in a term, their Degree-Major, Minor information.

Data Fields: ID, Last Name, First Name, Middle, Academic Level, Primary Program, Degree-Major, MJ(Minor)/MN(Minor), Acad Plan 3, Acad Plan 4, Acad Plan 5, Acad Plan 6, Term, Institution.

Sorted by: Last Name, First Name.

Sample result set of the Query



NDU_DSU_SR_17: STUDENTS- EMAIL ADDRESSES

Description: This query lists all the students enrolled in a term, and their available email addresses.

Data Fields: ID, Last Name, First Name, FERPA, Phone Type, Phone, Term, Institution.

Sorted by: Last Name, First Name.

Sample result set of the Query



NDU_DSU_SR_18: STUDENTS- PHONE NUMBERS

Description: This query lists all the students enrolled in a term, and their available phone numbers.

Data Fields: ID, Last Name, First Name, FERPA, Phone Type, Phone, Term, Institution.

Sorted by: Last Name, First Name.

Sample result set of the Query



NDU_DSU_SR_22: EXTRACURR. ACTIVITIES BY TERM

Description: This query lists all the students who are currently enrolled in a term, and their extracurricular activities. (Please note that this does not necessarily mean that the students are participating in those activities for the current term.)

Data Fields: ID, Last Name, First Name, Middle, Sex, Ethnic Grp., BirthDate, Age, Activity, Desc, Activity Type, Institution, Term.

Sorted by: Last Name, First Name.

Sample result set of the Query



NDU_DSU_SR_23: GRADUATES WITH RACE & GENDER

Description: This query lists details of all the students who have graduated in a particular term including their race and gender information.

Data Fields: ID, Last Name, First Name, Middle Name, Sex, Ethnic Grp., Primary Prog, Primary Program Description, Address1, City, St, Postal, Phone, Degree, Degree Nbr, Acad Program, Acad Plan 1, Primary Acad Prog Description, Acad Plan 2, Acad Plan Descr 2, Acad Plan 3, Acad Plan Descr 3, Acad Plan 4, Acad Plan Descr 4, Acad Plan 5, Acad Plan Descr 5

Sorted by: Primary Academic Program, Last Name, Student Degree Nbr.

Sample result set of the Query



NDU_DSU_SR_24: CLASSES AND ROOM ASSIGNMENTS

Description: This query lists all the classes and their facility (room) assignments.

Data Fields: Subject, Catalog, Class Nbr, Descr, Instructor ID, Last Name, First Name, Middle, Unit Taken, Cap Enrl, Tot Enrl, Facil ID, Term, Institution.

Sorted by: Last Name, First Name, Subject, Catalog Nbr.

Sample result set of the Query




NDU_DSU_SR_25: DIRECTED STUDY CLASSES

Description: This query lists all the DIRECTED STUDY classes and their details for a particular term.

Data Fields: Instructor ID, Last Name, First Name, Middle, Subject, Catalog, Class Nbr, Descr , Unit Taken, Cap Enrl, Tot Enrl, Facil ID, Term, Institution.

Sorted by: Last Name, First Name, Subject, Catalog Nbr.

Sample result set of the Query



NDU_DSU_SR_26: ONLINE CLASSES

Description: This query lists all the ONLINE classes and their details for a particular term.

Data Fields: Instructor ID, Last Name, First Name, Middle, Subject, Catalog, Class Nbr, Descr , Unit Taken, Cap Enrl, Tot Enrl, Facil ID, Term, Institution.

Sorted by: Last Name, First Name, Subject, Catalog Nbr.

Sample result set of the Query



NDU_DSU_SR_27: IVN CLASSES

Description: This query lists all the IVN classes and their details for a particular term.

Data Fields: Instructor ID, Last Name, First Name, Middle, Subject, Catalog, Class Nbr, Descr , Unit Taken, Cap Enrl, Tot Enrl, Facil ID, Term, Institution.

Sorted by: Last Name, First Name, Subject, Catalog Nbr.

Sample result set of the Query



NDU_DSU_SR_28: INACTIVE CLASSES

Description: This query lists all the INACTIVE classes on the system.

Data Fields: Subject,Catalog, Descr, Descr, Course ID, Institution, Status.

Sorted by: Subject, Catalog.

Sample result set of the Query




NDU_DSU_SR_29: ACTIVE CLASSES

Description: This query lists all the ACTIVE classes on the system.

Data Fields: Subject,Catalog, Descr, Descr, Course ID, Institution, Status.

Sorted by: Subject, Catalog.

Sample result set of the Query



NDU_DSU_SR_34: DIRECTED STUDY CLASSES-GRADES

Description: This query lists all the DIRECTED STUDYclasses in a particular term, Instructors that are teaching these classes, Students names and their grades.

Data Fields: InstructorID, Last Name, First Name, Middle, Subject, Catalog, Class Nbr, Descr, Unit Taken, Facil ID, ID, Last Name, First Name, Grade, Term, Institution.

Sorted by: Last Name, First Name,Subject, Catalog.

Sample result set of the Query