|
The Office of Computer Services 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 Computer Services at extension 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, (Instrcutor'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 particlular 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
NDU_DSU_SR_35: NEW STUDENTS ENROLLED- RACE GENDER Description: This query lets you select the group of New Students Enrolled in a particlular term (Collaborative Students, Dual Credit Students, Early Entry Students, First Year Students, Readmit Students, Transfer Students, Transient Students) and gives their race and gender details. Data Fields: ID, Name, Admit Type, Sex, Ethnic Grp Sorted by: Name Sample result set of the Query
|