Common Follow-Up (CFU) Data Collection

Contents

Introduction

The Common Follow-Up Data Collection displays an individual student record for every student in grades 9–13 from the prior school year and includes the following information:

All students admitted and attended school for at least one day in the previous school year.
Demographic data, grade level, diploma type, and entry and exit dates for all students.

It is possible for a student to appear on more than one Common Follow-Up Report if that student was in membership at more than one school during the previous school year.

Note: This report must be approved at the school and LEA levels.

Report Input

Run Data Collection

This report collection is run at the LEA and School level.

Use the following steps to generate the Common Follow-Up data collection.

On the Start Page, click State Reports. The State Reporting Dashboard page appears and displays a list of data collections for the school.
Next to the Common Follow-Up Collection, click Run.
The system validates the data against the business rules set up for the collection and completes the process.
Users have 24 hours to approve their data collection. If approval is not done within the 24 hours, the users must re-run the collection.

Review Data Collection

Next to the Common Follow-Up Collection, click Review.

Select one of the following CFU data collection views from the Data View drop-down menu. The Results section displays the data collection results specific for the selected data view.

Data Collection View	Description
Common Follow-Up Summary Data Review	The Common Follow Up Summary Data Review provides student demographic information, grade level, Diploma Type, and entry and exit dates for all students.
Common Follow-Up Detail Data Review	The Common Follow Up Detail Data Review displays detailed information pertinent to the each of the individual students from the CFU Summary view.

To narrow your search, select one or more filters, if available.
Click Refresh. The Results section displays the filtered data collection results specific for the selected data view.

Note: Click Export to export the data collection results to an Excel spreadsheet.

Review Exceptions

Use the following steps to review exceptions for a data collection.

From the Dashboard, click Review. The Review page appears.
Select Exceptions from the Reviews drop-down menu. Exceptions associated with a report collection display.
Select the exception type from the Choose exception drop-down menu. The Business Rule and Steps to Correct for the selected exception type appear on the page.
The Results section displays detailed information associated with the selected exception.
To narrow your search, select one or more filters, if available.
Click Refresh.

The Results section displays the filtered exception results specific for the selected data view.

Note: Click Export to export the data collection results to an Excel spreadsheet.

PowerSchool provides data validation to promote data integrity by preventing invalid data from being entered or imported into PowerSchool. Refer to the Validation Reports section for detailed list of CFU data and user interface validation checks that provide additional information and the necessary steps to correct exceptions, if applicable.

Back to Top

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Note: This data review is available at both the school level and aggregated for all schools at the LEA level.

Common Follow-Up Summary

Report Output Format: Excel spreadsheet, CSV

Data Element	Description	[Table]FieldName
Diploma Type	Diploma Types as defined in PowerSchool. Note: Only Diploma Types that have student records attached to them will be displayed.	[S_NC_ Academic]Diploma_Type_Code
Grade 9	The cumulative number of students enrolled during the Reporting Term in grade 9 by their Diploma Type	N/A
Grade 10	The cumulative number of students enrolled during the Reporting Term in grade 10 by their Diploma Type	N/A
Grade 11	The cumulative number of students enrolled during the Reporting Term in grade 11 by their Diploma Type	N/A
Grade 12	The cumulative number of students enrolled during the Reporting Term in grade 12 by their Diploma Type	N/A
Grade 13	The cumulative number of students enrolled during the Reporting Term in grade 13 by their Diploma Type	N/A
Total	The total students by Diploma Type	Calculated
Total by Student	The total of each individual column	Calculated

Common Follow Up Detail

Report Output Format: Excel spreadsheet, CSV

Data Element	Description	[Table]FieldName
Student Name	The student’s last and first name. Format: Concatenated Student Last Name, First Name, Middle Initial	[Students]First_Name [Students]Last_Name [Students]Middle_Name
Student Number	The student’s state number	[Students]State_StudentNumber
Gender	The student’s gender. Valid values: M or F.	[Students]Gender
Ethnicity	The student’s ethnic/race code based on the Scheduling/Reporting Ethnicity value.	[Students]Ethnicity
Primary Exceptionality	The student’s primary exceptionality code as of the reporting date.	[S_NC_EC]EC_Primary_DIS
Birthdate	The student’s date of birth.	[Students]DOB
Grade	The student’s current grade level.	[Students]Grade_Level
Graduation Document	The student’s graduation document (Diploma or Certificate). If DIPLOMA_TYPE_CODE is "GCER" or "CERT" then display "Certificate", otherwise display "Diploma"	Derived based on [S_NC_ Academic]Diploma_Type_Code
Diploma Type/Career Development Plan	The student’s Diploma Type and Career Development Plan code if applicable.	[S_NC_ Academic]Diploma_Type_Code
Description
Entry Date	The date of the student's initial enrollment into a school containing grades 9-12 in any school.	S_NC_Academic[Grade_9_Entry_Date]
Exit Date	The date of student's exit date ifstudenthas withdrawnforeach school.	Derived based on [Students]ExitDate or [ReEnrollments]ExitDate
Educational Attainment	The last completed grade level for the student. Note: Last "completed" grade level - not current grade level and not '99' for graduated.	[Students]Grade_Level or [ReEnrollments]Grade_Level
Workforce Development Indicator	Identifies if the student is taking a Workforce Development course: Valid Values: Y – Yes N – No Note: Displays “Y” ifplan is defined.	[S_NC_Academic]Career_Dev_Plan
New Enroll	Based on Entry Date. "C" if prior to July 1 or "E" if on or after July 1 of the reporting year.	New_Enroll
Completer	Based on Exit Code. "C" for completer if code = W4, W6 or W7 or a "N" for a non-completer = W1, W2 or W3.	Career_Plan
Special Status	This field will display "Dropout" for any student with a W2 Dropout Code and Reason. "T" for a W1 student and "X" for a W3 student.	Derived based on [Students]Exit_Code [Students]Dropout_Reason

Back to Top