using ps query in the reporting instances april 25, 2014
DESCRIPTION
Using PS Query in the Reporting Instances April 25, 2014. Presenter. Judith Ullman, CIS Application and Technical Support Manager [email protected] 212-541-1028. Agenda. Navigation to Query Manager Query Manager Create New Q uery Find Enrollment Record Add Record Add Fields - PowerPoint PPT PresentationTRANSCRIPT
Using PS Query in the Reporting Instances
April 25, 2014
Presenter
Judith Ullman, CIS• Application and Technical Support Manager• [email protected]• 212-541-1028
Agenda
1. Navigation to Query Manager2. Query Manager3. Create New Query
A. Find Enrollment Record B. Add RecordC. Add FieldsD. SaveE. Add CriteriaF. RunG. SortH. Field OrderI. Join Class InfoJ. Add Class FieldsK. Join Name InfoL. Add Name FieldsM. Effective Date CriteriaN. Security Joins
4. Add Query to Favorites5. Questions
Navigation
Navigation
Navigation
Query Manager
Create New Query
Create New Query: Find Record
Create New Query: Add Record
Create New Query: Add Fields
Create New Query: Save
Create New Query: Save
Create New Query: Criteria
Create New Query: Criteria
Create New Query: Criteria
Create New Query: Criteria
Create New Query: Criteria
Create New Query: Run
Create New Query: Run
Create New Query: Sort
Create New Query: Sort
Create New Query: Sort
Create New Query: Sort
Create New Query: Field Order
Create New Query: Field Order
Create New Query: Field Order
Create New Query: Field Order
Create New Query: Field Order
Create New Query: Field Order
Create New Query: Join Class Info
Create New Query: Join Class Info
Create New Query: Join Class Info
Create New Query: Join Class Info
Create New Query: Join Class Info
Create New Query: Join Class Info
Create New Query: Join Class Info
Create New Query: Join Class Info
Create New Query: Add Class Fields
Create New Query: Add Class Fields
Create New Query: Join Name Info
Create New Query: Join Name Info
Create New Query: Join Name Info
Create New Query: Join Name Info
Create New Query: Join Name Info
Create New Query: Add Name Fields
Create New Query: Add Name Fields
Create New Query: Effective Date
Create New Query: Effective Date
Create New Query: Security Joins
Add Query to Favorites
Add Query to Favorites
Add Query to Favorites
Add Query to Favorites
Add Query to Favorites
http://www.cuny.edu/about/administration/offices/CIS/CUNYfirst/reporting.html