Classic Path: KY State Reporting > FRYSC State Report
Search Terms: FRYSC State Report
The FRYSC State Report is submitted to the state in the fall and contains a high level summary of FRYSC activities throughout a given district. This report is used by the state to view the overall levels of FRYSC activities.
Image 1: FRYSC State Report Editor
Report Logic
The following report logic is used:
- Only FRYSC Individual Interventions and Group Programs active within the date range entered on the report editor are reported.
- The report includes students with enrollment records marked State Exclude and/or No Show.
- If a Group Program has no end date, the report will assume the end date is June 30th of the same FRYSC school year as the Group Program's Start Date.
- The Date Range on the report editor will default to the following:
- Start Date will default to 07/01 of the school year selected in the Campus toolbar.
- End Date will default to 06/03 of the school year selected in the Campus toolbar or the current date, whichever is earliest.
- District Edition: The generated filename is structured as follows:
- FRYSC_DistrictNameCo_YYYY_State.pdf
- The District Name is truncated so the word County is truncated to Co and the word Independent is truncated to Ind and any part of the name after the Co or Ind is removed. If a disrict has the word County or Independent, the name is not truncated.
- YYYY represents the 4-digit end year being reported.
- FRYSC_DistrictNameCo_YYYY_State.pdf
- State Edition: The generated file name is structured as FRYSC_YYYY_State.pdf where YYYY is the 4-digit end year being reported.
Generating the FRYSC State Report
Kentucky State Edition Users can generate this report for the entire state.
- Enter the Date Range. Only FRYSC Individual Interventions and Group Programs active within the date range entered are reported.
- Select the report Format.
- PDF - Generates the report in PDF format. This is the only format option available for all Aggregation options.
- FRYSC State Summary CSV - Contains all of the same data as the PDF format (with a few exceptions which are called out in the tables).
- State Individual Intervention CSV - Contains only individual intervention data for the FRYSC Center(s) and calendar(s) selected on the report editor.
- State Group Programs CSV - Contains only only group program data for the FRYSC Center(s) and calendar(s) selected on the report editor.
- Select the FRYSC Center(s) reporting data. Mark the All FRYSC Centers checkbox to report data for all FRYSC centers in the district.
- Select the report Aggregation option:
- Combined Totals - All data is combined into one report. This must be selected in order to generate CSV report formats.
- By School - The report is generated once for each School but is presented as a single PDF.
- By FRYSC Center - The report is generated once for each FRYSC Center but is presented as a single PDF.
- Filter data by selecting an Ad Hoc Filter (optional).
- Select the Calendar(s) reporting data. Mark the All Calendars checkbox to report data from all calendars in the school year.
- Select how the report will be generated:
Generate Report The report will generate immediately and display in a new window in the designated format. Submit to Batch The report can be scheduled for when it generates and will be sent to the Batch Queue tool.
Understanding the FRYSC State Report - PDF Format
See the following sections for more information about each part of the PDF format of the FRYSC State Report.
- Header Elements
- Mode of Intervention Data Elements
- Time Frame Data Elements
- Aggregate Totals Data Elements - Summary Page - Individual Interventions
- Aggregate Totals Data Elements - Summary Page - Group Programs
- Aggregate Totals Data Elements - Detail Page - Individual Interventions
- Aggregate Totals Data Elements - Detail Page - Group Programs
Header Elements
Image 2: FRYSC State Report - Header
An alternative header is generated for each FRYSC Center when the report is aggregated by FRYSC Center.
Data Element | Description | Campus UI and Database Location |
|---|---|---|
| District Number | The district number of the district reporting information. | System Administration > Resources > District Information > State District Number District.number |
| District Name | Name of the district reporting information. | System Administration > Resources > District Information > Name District.name |
County | The name of the county associated with the FRYSC data being reported. | System Administration > Resources > District Information > County |
| Date Range | The date range of information being included on the report. This date range is determined by the dates entered in the Date Range field on the report editor. | KY State Reporting > FRYSC State Report Report > Date Range District.county |
| School(s) | A list of schools from which FRYSC data has been reported. If the report is pulling data from 5 or fewer schools, the list of schools will appear in the report header. If the report is pulling data from 6 or more schools, the header will display the number of schools being reported and the actual list of schools appears as an appendix page at the end of the report. This field is replaced by Reported School Numbers in the CSV formats of the report. | System Administration > Resources > School > Name School.name |
| Reported School Numbers (CSV formats only) | Reports the School Number for each school in the report. | System Administration > Resources > School > Location Number School.number |
Mode of Intervention Data Elements
Image 3: FRYSC State Report - Mode of Intervention Data Elements
Data Element | Description | Campus UI and Database Location |
|---|---|---|
| In-office/School Grounds (Unduplicated) | A count of interventions where the intervention took place in the school office or on school grounds. Logic counts each student who has at least one Intervention where In-office/School Grounds is marked. Each student is only counted once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > In-Office/School Grounds FRYSCStatusKY.mOIInOfficeSchoolGrounds |
| In-office/School Grounds (Duplicated) | A count of interventions where the intervention took place in the school office or on school grounds. Logic counts each student who has at least one Intervention where In-office/School Grounds is marked. Each Intervention with the In-office/School Grounds checkbox marked is counted. Students can be counted more than once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > In-Office/School Grounds FRYSCStatusKY.mOIInOfficeSchoolGrounds |
| Telephone (Unduplicated) | A count of interventions where the intervention took place over the telephone. Logic counts each student who has at least one Intervention where Telephone is marked. Each student is only counted once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Telephone FRYSCStatusKY.mOITelephone |
| Telephone (Duplicated) | A count of interventions where the intervention took place over the telephone. Logic counts each student who has at least one Intervention where Telephone is marked. Each Intervention with the Telephone checkbox marked is counted. Students can be counted more than once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Telephone FRYSCStatusKY.mOITelephone |
Home Visit (Unduplicated) | A count of students who have received a home visit as part of a individual intervention. Logic counts each student who has at least one Intervention where Home Visit is marked. Each student is only counted once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Home Visit FRYSCStatusKY.mOIHomeVisit |
| Home Visit (Duplicated) | A count of students who have received a home visit as part of a individual intervention. Logic counts each student who has at least one Intervention where Home Visit is marked. Each Intervention with the Home Visit checkbox marked is counted. Students can be counted more than once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Home Visit FRYSCStatusKY.mOIHomeVisit |
| Home Visit - PAT (Unduplicated) | A count of students who have received a home visit with PAT status as part of an individual intervention. Logic counts each student who has at least one Intervention where Home Visit - PAT is marked. Each student is only counted once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Home Visit - PAT FRYSCStatusKY.mOIHomeVisitPAT |
Home Visit - PAT (Duplicated) | A count of students who have received a home visit with PAT status as part of an individual intervention. Logic counts each student who has at least one Intervention where Home Visit - PAT is marked. Each Intervention with the Home Visit - PAT checkbox marked is counted. Students can be counted more than once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Home Visit - PAT FRYSCStatusKY.mOIHomeVisitPAT |
| Letter (Unduplicated) | A count of interventions where the intervention involved sending a letter. Logic counts each student who has at least one Intervention where Letter is marked. Each student is only counted once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Letter FRYSCStatusKY.mOILetter |
| Letter (Duplicated) | A count of interventions where the intervention involved sending a letter. Logic counts each student who has at least one Intervention where Letter is marked. Each Intervention with the Letter checkbox marked is counted. Students can be counted more than once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Letter FRYSCStatusKY.mOILetter |
| Email/Text (Unduplicated) | Reports a count of interventions where the Intervention involved sending an email or text. Counts 1 for each student who has at least one Intervention where box is checked. Each student can be counted only once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Email/Text FRYSCStatusKY.mOILetter |
| Email/Text (Duplicated) | Reports a count of interventions where the Intervention involved sending an email or text. Counts 1 for each Individual Intervention where box is checked. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Email/Text FRYSCStatusKY.mOILetter |
| Other (Unduplicated) | A count of interventions where the Mode of Intervention was designated as Other. Logic counts each student who has at least one Intervention where Other is marked. Each student is only counted once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Other FRYSCStatusKY.mOIOther |
| Other (Duplicated) | A count of interventions where the Mode of Intervention was designated as Other. Logic counts each student who has at least one Intervention where Other is marked. Each Intervention with the Other checkbox marked is counted. Students can be counted more than once. | Student Information > General > FRYSC > Individual Detail > Mode of Intervention > Other FRYSCStatusKY.mOIOther |
Time Frame Data Elements
Image 4: FRYSC State Report - Time Frame Data Elements
Data Element | Description | Campus UI and Database Location |
|---|---|---|
Before School | A count of group program records where the Before School time frame is specified. Logic counts 1 for each group program where Before School is marked. A student may count more than once if they have more than one record with the Before School checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > Before School FRYSCGroupProgramKY.TimeFrame |
| During School | A count of group program records where the During School time frame is specified. Logic counts 1 for each group program where During School is marked. A student may count more than once if they have more than one record with the During School checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > During School FRYSCGroupProgramKY.TimeFrame |
| After School | A count of group program records where the After School time frame is specified. Logic counts 1 for each group program where After School is marked. A student may count more than once if they have more than one record with the After School checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > After School FRYSCGroupProgramKY.TimeFrame |
| Intersession | A count of group program records where the Intersession time frame is specified. Logic counts 1 for each group program where Intersession is marked. A student may count more than once if they have more than one record with the Intersession checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > Intersession FRYSCGroupProgramKY.TimeFrame |
| Weekend | A count of group program records where the Weekend time frame is specified. Logic counts 1 for each group program where Weekend is marked. A student may count more than once if they have more than one record with the Weekend checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > Weekend FRYSCGroupProgramKY.TimeFrame |
| Holiday | A count of group program records where the Holiday time frame is specified. Logic counts 1 for each group program where Holiday is marked. A student may count more than once if they have more than one record with the Holiday checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > Holiday FRYSCGroupProgramKY.TimeFrame |
| Winter Break | A count of group program records where the Winter Break time frame is specified. Logic counts 1 for each group program where Winter Break is marked. A student may count more than once if they have more than one record with the Winter Break checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > Winter Break FRYSCGroupProgramKY.TimeFrame |
| Spring Break | A count of group program records where the Spring Break time frame is specified. Logic counts 1 for each group program where Spring Break is marked. A student may count more than once if they have more than one record with the Spring Break checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > Spring Break FRYSCGroupProgramKY.TimeFrame |
| Summer Break | A count of group program records where the Summer Break time frame is specified. Logic counts 1 for each group program where Summer Break is marked. A student may count more than once if they have more than one record with the Summer Break checkbox marked. | Student Information > General > FRYSC > Group Program Detail > Time Frame > Summer Break FRYSCGroupProgramKY.TimeFrame |
Aggregate Totals Data Elements - Summary Page - Individual Interventions
Image 5: FRYSC State Report - Aggregate Totals Data Elements - Individual Interventions
Data Element | Description | Campus UI and Database Location |
|---|---|---|
Unduplicated Contacts - # Students | A count of all students who have at least one active individual intervention for the specified period.
| Student Information > General > FRYSC > Individual Intervention FRYSCStatusKY.interventionForStudent |
| Unduplicated Contacts - # Parents | A count of all students with individual interventions where the intervention was for the parent, for the specified period.
| Student Information > General > FRYSC > Individual Intervention FRYSCStatusKY.interventionForParent |
| Duplicated Student Contacts | A count of all active individual intervention records for the specified period.
| Student Information > General > FRYSC > Individual Intervention FRYSCStatusKY.interventionForStudent |
| Duplicated Parent Contacts | A count of all students with individual interventions where the intervention was for the parent, for the specified period.
| Student Information > General > FRYSC > Individual Intervention FRYSCStatusKY.interventionForParent |
| Behavior Related | A count of all behavior-related individual interventions where the intervention was for the parent, for the specified period.
| Student Information > General > FRYSC > Individual Intervention > Result of Behavior Issue FRYSCStatusKY.resultOfBehavior |
Aggregate Totals Data Elements - Summary Page - Group Programs
Image 6: FRYSC State Report - Aggregate Totals Data Elements - Group Programs
Data Element | Description | Campus UI and Database Location |
|---|---|---|
Unduplicated Contacts - # Students | A count of all students who have at least one active group program for the specified time period.
| Student Information > General > FRYSC > Group Program Detail FRYSCGroupProgramKY.programForStudents |
| Unduplicated Contacts - # Parents | A count of all students who have at least one active group program record the specified time period and the program was intended for the parent.
| Student Information > General > FRYSC > Group Program Detail FRYSCGroupProgramKY.programForParents |
| Duplicated Student Contacts | A count of all students who have at least one active group program for the specified time period.
| Student Information > General > FRYSC > Group Program Detail FRYSCGroupProgramKY.programForStudents |
| Duplicated Parent Contacts | A count of all students who have at least one active group program record the specified time period and the program was intended for the parent.
| Student Information > General > FRYSC > Group Program Detail FRYSCGroupProgramKY.programForParents |
| # of Meetings | The sum of all Meetings for all programs pulled by the report.
| Programs > FRYSC Group Programs > Meetings FRYSCGroupProgramKY.meetingCount |
| Total Contact Count | The total number of unduplicated contacts that took place. This column reports using the following calculation:  Where:
| Student Information > General > FRYSC > Group Program Detail FRYSCGroupProgramKY.programForStudents FRYSCGroupProgramKY.programForParents FRYSCGroupProgramKY.meetingCount |
| Program Hours | The sum of all Total Program Hours for all programs pulled by the report.
| Programs > FRYSC Group Programs > Total Program Hours FRYSCGroupProgramKY.totalProgramHours |
| Number (#) of Volunteers | The sum of all Volunteers for all programs pulled by the report.
| Programs > FRYSC Group Programs > # of Volunteers FRYSCGroupProgramKY.totalVolunteerCount |
| Volunteer Hours | The sum of all Volunteers Hours for all programs pulled by the report.
| Programs > FRYSC Group Programs > Volunteer Hours FRYSCGroupProgramKY.totalVolunteerHours |
Aggregate Totals Data Elements - Detail Page - Individual Interventions
Image 7: FRYSC State Report - Aggregate Totals Data Elements - Individual Interventions
Data Element | Description | Campus UI and Database Location |
|---|---|---|
Category/Type (Individual Intervention Aggregate Totals) | Displays all categories/types of individual interventions and acts as a row label for subsequent totals columns.
| N/A |
| Unduplicated Contacts - # Students | A count of all students who have at least one active individual intervention in the specified category/type for the specified time period.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Students FRYSCStatusKY.interventionForStudent |
| Unduplicated Contacts - # Parents | A count of all students who have at least one active individual intervention in the specified category/type for the specified time period where the intervention was for the parent.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Parent FRYSCStatusKY.interventionForParent |
| Duplicated Student Contacts | A count of all active individual intervention records for the specified category/type in the specified period.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Students FRYSCStatusKY.interventionForStudent |
| Duplicated Parent Contacts | A count of all active individual intervention in the specified category/type for the specified time period where the intervention was for the parent.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Parent FRYSCStatusKY.interventionForParent |
| Behavior Related | A count of all active individual intervention records in the specified category/type for the specified time period where the Intervention resulted in a behavior issue.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Students, Result of Behavior Issue FRYSCStatusKY.resultOfBehavior |
Aggregate Totals Data Elements - Detail Page - Group Programs
Image 8: FRYSC State Report - Aggregate Totals Data Elements - Group Programs
Data Element | Description | Campus UI and Database Location |
|---|---|---|
Category/Type (Group Program Aggregate Totals) | Displays all categories/types of Group Programs and acts as a row label for subsequent totals columns.
| Programs > FRYSC > Group Programs > Program Category FRYSCGroupProgramType |
| Unduplicated Student Contacts | A count of all students who have at least one active group program record, by type.
| Student Information > General > FRYSC > Group Program Detail > Program is for: Students FRYSCGroupProgramKY.groupStatusID FRYSCGroupProgramKY.programForStudent |
| Unduplicated Parent Contacts | A count of all students who have at least one active group program record, by category/type, where the program is for the parent.
| Student Information > General > FRYSC > Group Program Detail > Program is for: Parents FRYSCGroupProgramKY.groupStatusID FRYSCGroupProgramKY.programForParent |
| Duplicated Student Contacts | A count of all active group program records by category/type.
| Student Information > General > FRYSC > Group Program Detail > Program is for: Students FRYSCGroupProgramKY.groupStatusID FRYSCGroupProgramKY.programForStudent |
| Duplicated Parent Contacts | A count of all active group program records by category/type where the program was intended for the parent.
| Student Information > General > FRYSC > Group Program Detail > Program is for: Parents FRYSCGroupProgramKY.groupStatusID FRYSCGroupProgramKY.programForParent |
| # of Meetings | The sum of all Meetings for all programs pulled by the report.
| Programs > FRYSC > Group Programs > # of Meetings FRYSCGroupProgramKY.meetingCount |
| Total Contact Count | Reports the total number of unduplicated “contacts” (essentially, FRYSC activities) that took place. This column reports SUM by group (Unduplicated Contacts: Students + Unduplicated Contacts: Parents) * "#Parents" = the number of students with a FRYSC Group Program record where the “parent” check box is checked. This is an unduplicated value (counts once per student).
| Calculated Example: * Group Program has 10 students and 3 parents (10+3) = 1 |
| Program Hours | The sum of all Total Program Hours for all programs pulled by the report.
| Programs > FRYSC > Group Programs > Total Program Hours FRYSCGroupProgramKY.totalProgramHours |
| # of Volunteers | The sum of Volunteers for all programs pulled by the report.
| Programs > FRYSC > Group Programs > # of Volunteers FRYSCGroupProgramKY.totalVolunteerCount |
| Volunteer Hours | The sum of all Volunteer Hours for all programs pulled by the report.
| Programs > FRYSC > Group Programs > Volunteer Hours FRYSCGroupProgramKY.totalVolunteerHours |
Understanding the CSV Formats
See the following sections for more information about each CSV formats available.
FRSYC State Summary CSV
The FRYSC State Summary CSV contains all of the same data as the PDF format (with a few exceptions which are called out in the tables). Please see the Understanding the FRYSC State Report - PDF Format section and corresponding tables for detailed information about each field.
State Individual Interventions CSV
The State Individual Interventions CSV contains only individual intervention data for the FRYSC Center(s) and calendar(s) selected on the report editor. The Totals row at the beginning of the report will reflect logic detailed in the Summary Page - Individual Interventions section. Subsequent rows reflect the Detail Page - Individual Interventions data element logic.
Data Element | Description | Campus UI and Database Location |
|---|---|---|
| Category | Displays the category for the Individual Intervention in the State Individual Intervention CSV format
| N/A |
| Type | Displays the Individual Group Program Type in the State Individual Intervention CSV format.
| N/A |
| Unduplicated Contacts - # Students | Reports a count of all students who have at least one active individual intervention for the specified period.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Students FRYSCStatusKY.interventionForStudent |
| Unduplicated Contacts - # Parents | Reports a count of all students with individual interventions where Intervention was for the parent, for the specified period.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Parent FRYSCStatusKY.interventionForParent |
| Duplicated Student Contacts | Reports count of all active individual intervention records for the specified period.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Students FRYSCStatusKY.interventionForStudent |
| Duplicated Parent Contacts | Reports a count of all individual interventions where Intervention was for the parent, for the specified period.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Parent FRYSCStatusKY.interventionForParent |
| Behavior Related | Reports a count of all behavior-related individual interventions for the specified period.
| Student Information > General > FRYSC > Individual Intervention > Intervention is for: Students, Result of Behavior Issue FRYSCStatusKY.resultOfBehavior |
State Group Program CSV
The State Group Program CSV contains only only group program data for the FRYSC Center(s) and calendar(s) selected on the report editor. The Totals row at the beginning of the report will reflect logic detailed in the Summary Page - Group Programs section. Subsequent rows reflect the Detail Page - Group Programs data element logic.
Data Element | Description | Campus UI and Database Location |
|---|---|---|
Category | Displays the category for the Group Program in the State Group Programs CSV format.
| Programs > FRYSC > Group Programs > Program Category FRYSCGroupProgramType |
| Type | Displays the Individual Group Program Type in the State Group Programs CSV format.
| Pulls values from the FRYSCGroupProgramType table. |
| Unduplicated Student Contacts | Reports a count of all students who have at least one active group program record for the specified period.
| Student Information > General > FRYSC > Group Program Detail > Program is for: Students FRYSCGroupProgramKY.programForStudent |
| Unduplicated Parent Contacts | Reports a count of all students who have at least one active group program record for the specified period and where program was intended for the parent.
| Student Information > General > FRYSC > Group Program Detail > Program is for: Parents FRYSCGroupProgramKY.programForParent |
| Duplicated Student Contacts | Reports a count of all active group program records for the specified period.
| Student Information > General > FRYSC > Group Program Detail > Program is for: Students FRYSCGroupProgramKY.programForStudent |
| Duplicated Parent Contacts | Reports a count of all active group program record for the specified period where program was intended for the parent.
Count once for each Group Program record (a parent may be counted more than once if they have more than one Group Program record). | Student Information > General > FRYSC > Group Program Detail > Program is for: Parents FRYSCGroupProgramKY.programForParent |
| # of Meetings | Sum all Meetings for all programs pulled by the report. Includes unused programs | Programs > FRYSC > Group Programs > # of Meetings FRYSCGroupProgramKY.meetingCount |
| Total Contact Count | Reports the total number of unduplicated “contacts” (essentially, FRYSC activities) that took place. This column reports SUM by group (Unduplicated Contacts: Students + Unduplicated Contacts: Parents) * "#Parents" = the number of students with a FRYSC Group Program record where the “parent” check box is checked. This is an unduplicated value (counts once per student).
| Calculated Example: * Group Program has 10 students and 3 parents (10+3) = 1 |
| Program Hours | Sum all Total Program Hours for all programs pulled by the report. Includes unused programs. | Programs > FRYSC > Group Programs > Total Program Hours FRYSCGroupProgramKY.totalProgramHours |
| # of Volunteers | Sum all Volunteers for all programs pulled by the report. Includes unused programs. | Programs > FRYSC > Group Programs > # of Volunteers FRYSCGroupProgramKY.totalVolunteerCount |
| Volunteer Hours | Sum all Volunteer Hours for all programs pulled by the report. Includes unused programs. | Programs > FRYSC > Group Programs > Volunteer Hours FRYSCGroupProgramKY.totalVolunteerHours |
