Student Calendar Fact Template

Contents

Introduction

This report produces all mobility transactions for all students throughout the entire year, not just students active at the end of the year, and not just the last transaction for a student. At least one record exists in this template for every student enrolled in an LEA at any time during the school year.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects records from the Students table based on the following criteria:

The student must be enrolled between the start and end date.
The student must be enrolled in the selected school.

The Student Calendar Fact Template includes all students who are reported in the School Enrollment Template.

Report Input

For help with report generation and navigation, see How to Find and Generate a Report.

Field	Description
Use	Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria If sub-districts are enabled: Select Sub-district - Select the sub-district for which you want to run the report. Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. If running the report for a single student, or group of students, select the students prior to running the report.
Select School Year	Select the school year.
Report Start Date	Enter the start date of the reporting period.
Report End Date	Enter the end date of the reporting period.
Extract the students’ first and last names.	Choose Yes or No to indicate whether to include the students’ first and last names in the report. You must set this to "No" when sending the extract file to the state.
Field Delimiter	Select the field delimiter for the extract file.
Show Column Field Headings	Choose Yes or No to indicate whether to include column headings in the extract file. If Yes is selected, a heading is displayed for each type of data in the report.
Ignore Exclude from State Reporting Flag	Select the Enabled checkbox to ignore the ‘Exclude from State Reporting’ flag.
Processing Options	Choose a time to run the report: Run Now Schedule
Specific Date/Time	If you chose the Schedule for Processing, enter the date the report should run, using the format mm/dd/yyyy or mm-dd-yyyy. An incorrect format displays an alert and the date field is submitted as a blank entry. Schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM: 05.

Report Output

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

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	District Code	The unique 9-digit Administrative Unit Number assigned by the PDE. If sub-district is enabled, the selected sub-district appears in this field.	[Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	9
2	School Year Date	A single date indicating the whole school year; June 30 at the end of the standard school year is used to designate a school year. Thus, the 2017- 2018 school year would be indicated by 2018-06-30. All dates must be entered in ISO format: YYYY-MM-DD.	[Terms]LastDay	Alpha-numeric	10
3	Calendar ID	A unique number used to identify the calendar for this student’s enrollment.	[S_PA_STU_X]Calendar_ID [S_PA_REN_X]Calendar_ID	Alpha-numeric	11
4	Student ID	The PAsecureID assigned to the student.	[Students]State_StudentNumber	Alpha-numeric	10
5	District Code of Residence	The 9-digit AUN of the school district where the student's parent/legal guardian resides.	[Students]DistrictOfResidence [Prefs]Value where [Prefs]Name=PA_DistrictAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	9
6	Funding District Code	The 9-digit AUN for the school district that is financially responsible for the student.	[S_PA_STU_X]Funding_District_Code [S_PA_STU_X]Funding_District_Code [Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	9
7	Residence Status Code	The student’s PIMS residence status code	[S_PA_STU_X]PIMS_Residence_Status_Code [S_PA_REN_X]PIMS_Residence_Status_Code	Alpha-numeric	1
8	Days Enrolled	The number of days the student was enrolled in the school during the reporting period. This value is based on the student’s school entry and exit date and the school calendar.	Calculated	Numeric	3
9	Days Present	The number of days the student was present in attendance at the school during the reporting period. This value is based on the student’s school entry and exit date, the school attendance setup, and the student’s attendance records. This value must be less than or equal to Days Enrolled.	Calculated	Numeric	6
10	Percentage of Time Enrolled for Calendar	For students in membership full-time, 100 is reported. For students in membership part-time, the average percent of time in membership per week is reported	[S_PA_STU_X]Calendar_Enrolled_Time_Percent [S_PA_REN_X]Calendar_Enrolled_Time_Percent If blank, defaults to 100	Numeric	11
11	Current Grade Level	Indication of the student’s grade level.	[Students]Grade_Level Or [Students]Grade_Code if populated	Alpha-numeric	3
12	Not Collected	Formerly Homebound Instruction Minutes.	N/A	N/A	N/A
13	Sending Charter School Code	The 4-digit school number of the charter school that contracted with the educating LEA to educate a charter school student.	[S_PA_STU_X]Charter_School_Location_Code [S_PA_REN_X]Charter_School_Location_Code	Alpha-numeric	4
14	District Code of Sending Charter School	The 9-digit AUN of the charter school that contracted with the educating LEA to educate a charter school student.	[S_PA_STU_X]Charter_School_Code [S_PA_REN_X]Charter_School_Code	Alpha-numeric	9
15	Special Education Indicator	Indicates whether the days enrolled are for a special education student	[S_PA_STU_X]IS_SPED_Student_YN [S_PA_REN_X]IS_SPED_Student_YN	Alpha numeric	1
16	Days Absent - Unexcused	The number of unexcused absences based on local attendance policy. This value must be less than or equal to Days Enrolled.	Calculated using [Prefs]Ps_ADAADM_Defaults_All	Numeric	6