The Massachusetts School to Career Connecting Activities Initiative

 


8d - Custom Reports

Custom Reports

If you don`t find exactly the report or criteria you want/need, you can explore the following custom reporting options and/or you may email jleonard@skillslibrary.com for advice or assistance in getting the data you want.

Custom Criteria for Part I: Report Criteria:

One of the options is to write customized criteria in the custom criteria box. This allows you to write criteria using fields other than those on this screen, or to write criteria that use "or" statements. If you ever want to write a report using customized criteria, you can email jleonard@skillslibrary.com for assistance. Or, if you are familiar with SQL language or comfortable learning how to write these statements, you can experiment and write your own criteria. For example, you could write the following criteria:

(EmplName=`ABC Software` or EmplName=`XYZ Software`) Finds records where the employer name is ABC Software or XYZ Software
CityOfResidence=`Mill Valley` Finds records where the City of Residence is Mill Valley. Useful if you data enter this information and if, for example, you want to know how many students from a regional school live in a particular community.
Left(ParticipantName,1) = `A` Finds records where the participant name begins with A. This, and the next example, can be useful if you are working on editing and reviewing records and want to look at a few at a time.
Left(ParticipantName,1) between `A` and `D` Finds records where the participant name is between A and D.
CreatedDate=`4/21/2010` Finds records where the date the record was created is 4/21/2010
IndustryCluster=`Health Care` Finds records where the industry cluster is Health Care
TypeOfPay=`Paid` Finds records where the placement is employer paid, based on the Type of Pay checkboxes on the Placement Screen
TypeOfPay=`Unpaid` Finds records where the placement is unpaid, based on the Type of Pay checkboxes on the Placement Screen
TypeOfPay=`Sponsored` Finds records where the placement wage is subsdized or sponsored, such as YouthWorks or ARRA programs, based on the Type of Pay checkboxes on the Placement Screen
(SchoolProgram=`Mill Valley High School` or NameActivity=`Mill Valley School to Career`) Finds records where the school is Mill Valley High School or the Activity Name is Mill Valley School to Career. (Notice that "OR" statements should be in parentheses.)
NOTE: You can find field names by looking at the DATABASE FIELD List in this website or by looking at the field name is the custom reports.

Custom Reports in Part II: Reports

One of the sections on the list of reports provides a custom-report routine. There are two types of custom reports. One will provide a list, based on fields that you check off on the list of fields. The other will provide a count, also based on fields that you check off on the list of fields. Custom reports can be saved and run again. The image below shows the custom report screen for creating a list. You can check the fields you want; sort by any field; and add "Where" criteria to select certain records. If you don`t want to sort or select particular records, you can leave "PlanID" and "PlanID greater than 0" on the screen. A similar screen allows you to create a count of records for any subgroups, such as a count by employer name or a count by activity name.

Check the Database Field List in this website to learn more about the field names used on these screens.

1 - INTRODUCTION TO THE DATABASE - VIDEO
1a - Key Points About the Database
1b - REGISTERING AND SIGNING IN - VIDEO
1c - Navigating the Database Screens
2 - USING THE PLACEMENT SCREEN - VIDEO
2a -Classifying Placements - Activity Name, Program Checkboxes, Job Title, etc.
2b. Classifying and Defining STEM Placements
2c - Placement and WBLP Screen - Sharing via Email/Username
2d - Participants with more than one work experience
2d - Worksites with multiple participants - Using the COPY WBLP button
2e - Placement Screen - Required and Optional Fields
2g - Work and Learning Program Elements (Preview of FY19 elements)
2h - Career Areas
2z - Deleting Placement Screen Records
3 - USING THE JOB DESCRIPTION AND SKILLS/TASKS SCREENS - VIDEO
4 - USING THE PERFORMANCE REVIEW SCREEN - VIDEO
5 - ACTIVITY SCREEN - VIDEO
6 - Reflection Screen
7 - Importing
8 - REPORTS MENU AND EMPLOYER SCREENS - POWERPOINT PRESENTATION
8a - About the Reports/Admin Menu
8b - Connecting Activities Quarterly Report
8c - Connecting Activities Qualifying Wages Report
8d - Custom Reports
8e - Employer Screens
9 - Sharing, Collaboration and Privacy
9a - UPDATING MY ACCOUNT SETTINGS - VIDEO
9b - Add | Invite New Usernames
9c - Using the "One-Step WBLP Review Screen" for Supervisors
9d: Instructions for students to create their WBLPs online
DATABASE FIELD LIST
What's New in the Database
Winter/Spring 2019 Webinar Series