Student Detail
Contents
Introduction
Use the Student Detail option to extract information for the Student Detail extract. You can generate this report for a specific date range or a pre-defined reporting period at the school or district level. You can choose to include segments and totals or only totals.
Student Detail is PowerSchool report TX78.
Selection Criteria
Selection criteria determine which database records are used in the report. For the Student Detail, student demographics, membership, and attendance records are selected.
School Selection
The report selects which school records to use based on the following criteria:
- The school must be associated with a student included in the report.
Student Selection
The report selects which student records to use based on the following criteria:
- The student must not be excluded from PEIMS reporting.
- The student must be enrolled in the district for at least one day during the selected reporting period.
Attendance Selection
The report calculates attendance fields based on the following criteria:
- The attendance item must be flagged as Counts for ADA, OR the Official Attendance Period flag must be set. If the Official Attendance Period is set, the report calculates based on the periods set as the Official Attendance Period.
- If multiple periods are set for either the Official Attendance Period and Counts for ADA indicator and the student is absent for either period, the report calculates the student as absent.
- If a student is marked Absent but the item is counted under the Present for Funding attendance category, the report counts the student as present.
Flexible Attendance Selection
The report calculates flexible attendance fields based on the following criteria:
- The student must have a Flexible Attendance Program Type Code of (02) HSEP or (6) OFSDP.
- The student must have ADA Eligibility Code of (07) Eligible - Flexible Attendance or (08) Ineligible - Flexible Attendance covering each day of enrollment in the flex program.
- Students with an ADA Eligibility Code of (08) Ineligible - Flexible Attendance do not qualify for Special Program Flexible Attendance and will be reported only with Regular Flex Attendance records.
- The student must have a minimum of 45 daily minutes. Days with minutes under 45 are ignored in the calculations.
- Students can have a maximum of 600 daily minutes. Daily minutes over 600 are ignored in the calculations.
- When converting the total flexible minutes into equivalent Days Present and Days Eligible for Special Programs, the total flex minutes for the reporting period are summed, divided by 360 for HSEP and 240 for OFSDP, and rounded down to the nearest half day.
- For Special Programs, flex minutes are counted only for days where the student is a program participant.
Report Input
For help with report navigation and generation, see Generate Reports.
Each of the available run options and data fields for the report is described below.
Field | Description |
|---|---|
Select Schools | At the District Level:
At the School Level:
|
Select Students | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running the report. |
School Year | Choose the school year for the student membership and attendance data you want to include on the report. |
Report Options | Choose Both Detail and Summary to generate the Student Detail with both the detail and summary pages for the students. Choose Student Detail Pages Only to generate the Student Detail with just the detail pages for the students. Choose Summary Pages Only to generate the Student Detail with just the summary reports for the students. |
Reporting Period | Choose the reporting period for the student membership and attendance data you want to include on the report. If you only want to run for a specific date range it does not matter what you put in this field. |
Override Start Date | If you only want to run for certain dates in a Reporting Period, select the first date in the date range from the calendar provided. |
Override End Date | If you only want to run for certain dates in a Reporting Period, select the end date in the date range from the calendar provided. |
Special Programs to Include | Select the special programs to include. Leave this option blank to Include All. |
Grade Levels to Include | Select the Grade Levels to Include. Leave this option blank to Include All. |
Attendance to Include* | Select the attendance to include. |
Report Sort |
|
Run Now | Select this option if the user wants to run the report immediately. |
Schedule | Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are:
|
Report Output
Student Detail
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.
Item # | Data Element | Description | [Table]FieldName |
|---|---|---|---|
1 | Date/Time Run | The date and time the report was run. | Derived |
2 | District Number/Name | The county-district number and name for the students reported. | [Prefs]DistrictName [Prefs]DistrictNumber |
3 | School Year | The school year for this report. | Derived |
Individual Student Detail | |||
4 | ID | The local student ID assigned by the district. | [Students]Student_Number |
5 | Student Info | This column contains the following information:
| StudentCoreFields.PSCore_Legal_First_Name StudentCoreFields.PSCore_Legal_Middle_Name StudentCoreFields.PSCore_Legal_Last_Name StudentCoreFields.PSCore_Legal_Suffix [Schools]Name [Schools]School_Number [Schools]Alternate_School_Number [Students]DOB [Students]SSN [Students]State_StudentNumber [StudentCoreFields]Guardian_LN [StudentCoreFields]Guardian_FN [Students]EntryDate [Reenrollments]EntryDate [Students]FedEthnicity [Students]Street [Students]City [Students]State [Students]Zip [Students]Grade_Level [StudentRace]RaceCd [Students]Gender |
6 | Report Period Indicator and Report Period Date Range | The report periods that the student was in membership. | Derived |
7 | Student Dates | The student's entry and exit dates for the selected school year for the particular reporting periods. | [Students]EntryDate [Students]Exitdate |
8 | Days Taught | The number of days taught for that reporting period for the school attended. | Calculated |
9 | Days Membership | The total days of membership for each student during the specified reporting period. This calculation is based on the total number of days the student was enrolled. | Calculated |
10 | Days Absent | The total days the student was absent during the specified reporting period. Note: Since absences are non-applicable for flex attendance, this field is always 0 for flex attendance records. | Calculated |
11 | Days Eligible | The total number of days the student was present and eligible for Foundation School Program funding during the specified reporting period. This calculation is based on the total number of minutes of membership for that ADA code divided by 240. | Calculated |
12 | Days Ineligible | The total number of days the student was present and ineligible for Foundation School Program funding during the specified reporting period. | Calculated |
13 | Grade/Track | The student's current grade level or instructional track. | [Students]Grade_Level [S_TX_STU_X]State_Grade_Level [S_TX_STU_FLEX_ATT_C]E0017_Grade_Level [S_TX_STU_FLEX_ATT_C]E0975_Instructional_Track |
14 | ADA | The student's ADA code for the reporting period. | [S_TX_STU_STATE_GEN_C]E0787_ADA_Code |
15 | Campus ID of Residence | The unique campus identification number corresponding to the campus attendance area in which the student currently resides. | [S_TX_STU_STATE_GEN_C] E0903_Campus_Residence |
16 | Pregnancy Related Services - Code | A value of 1 in this column indicates that this student is a participant in pregnancy-related services. A value of 0 in this column indicates that this student is not a participant in pregnancy-related services. | [S_TX_SEN_PRS_X]E0939_PRS |
17 | Pregnancy Related Services - Days | The total number of days a female student was present at school or served through Compensatory Education Home Instruction (CEHI) and an eligible recipient of pregnancy-related services during the specified reporting period. | Calculated |
18 | Bilingual/ESL Code | A value of 2 or 3 in this column indicates that this student is a participant in bilingual/ESL services. A value of 0 in this column indicates that this student is not a participant in bilingual/ESL services. | [S_TX_SEN_ESL_X]E1043_ESL_Program [S_TX_SEN_ESL_X]E1042_Bilingual_Program |
19 | Bilingual/ESL Days | The total number of days the student was present and an eligible participant in the state-approved bilingual/ESL program during the specified reporting period. | Calculated |
20 | Career & Tech Code | This displays V1 – V6 for the reporting period. | [S_TX_SEN_CTE_X]E0031_CTE_IND |
21 | Career & Tech Days | The total number of days the student was present and an eligible participant as a V1 – V6 student during the reporting period. | Calculated |
22 | Speech Code | A value of 1 or 2 in this column indicates that this student is a participant in a speech-related program. A value of 0 in this column indicates that this student is not a participant in a speech-related program. | [S_TX_SEN_SPD_X]E0857_Speech |
23 | Speech Days | The total number of days the student was present and an eligible participant in the state-approved speech-related program during the specified reporting period. | Calculated |
24 | Special Education Code | A value of 40 in this column indicates that this student has a special education IEP that provides for the mainstream instructional arrangement/setting. A value of 0 in this column indicates that this student does not have a special education IEP that provides for the mainstream instructional arrangement/setting. | [S_TX_SEN_SPD_X]E0173_Instr_Setting |
25 | Special Education Days | The total number of days a student with a special education individualized education program that provided for the mainstream instructional arrangement/setting was present during the specified reporting period. | Calculated |
26 | Excess Hours Daily Value | The number of excess hours the student has on a daily basis. | Calculated |
27 | Excess Hours Total | The number of excess hours for the reporting period. | Calculated |
28 | GT | A value of 1 in this column indicates that this student is a participant in a gifted and talented program. A value of 0 in this column indicates that this student is not a participant in a gifted and talented program. | [S_TX_SEN_GT_X]E0034_GT |
29 | LEP | A value of 1, F or S in this column indicates that this student is a participant in a limited English proficiency (LEP) program. A value of 0 in this column indicates that this student is not a participant in an LEP program. | [S_TX_SEN_ESL_X]E0790_LEP_Indicator |
30 | Days Absent | A detailed list of the dates the student was absent during the reporting period is displayed. | Calculated |
Summary by Grade for individual grades and Summary by Grade for the entire Campus | |||
31 | Date/Time | The date and time the report was run. | Derived |
32 | District Name | The name of the district for the report. | [Prefs]DistrictName |
33 | District Number | The county-district number for the students reported. | [Prefs]DistrictNumber |
34 | School Year | The school year for this report. | Derived |
35 | Campus Name | The name of the school for the report. | [Schools]Name |
36 | Campus Number | The school number for the students reported. | [Schools]ID |
37 | Grade Level | The grade level that the report is summarizing. | Derived |
Regular Attendance | |||
38 | Report Period | The date range for this report. | Derived |
39 | Days Taught | The number of instructional days during the date range of the report. | Calculated |
40 | Days Membership | The total days of membership for all students in this grade level during the specified reporting period. | Calculated |
41 | Days Absent | The number of days all students in this grade level were absent during a particular reporting period. | Calculated |
42 | Days Present | The number of days all students in this grade level were present during a particular reporting period. | Calculated |
43 | Days Eligible | The total number of days the students in this grade level were present and eligible for Foundation School Program funding during a particular reporting period. | Calculated |
44 | Days Ineligible | The total number of days the students in this grade level were present and ineligible for Foundation School Program funding during a particular reporting period. | Calculated |
45 | Days BIL/ESL Eligible | The total number of days the students in this grade level were present and eligible participants in the state-approved bilingual/ESL program during a particular reporting period. | [S_TX_SEN_ESL_X]E1043_ESL_Program [S_TX_SEN_ESL_X]E1042_Bilingual_Program Calculated |
46 | Days PRS Eligible | The total number of days the female students in this grade level were present at school or served through Compensatory Education Home Instruction (CEHI) and are eligible recipients of pregnancy-related services during a particular reporting period. | [S_TX_SEN_PRS_X]E0939_PRS Calculated |
47 | G&T | The total number of students in this grade level that participate in a gifted and talented program. | [S_TX_SEN_GT_X]E0034_GT Calculated |
Regular Flex Attendance | |||
48 | Report Period | The date range for this report. | Derived |
49 | Days Taught | The number of instructional days during the date range of the report. | Calculated |
50 | Days/Minutes Membership | The total days of membership for all students in this grade level during the specified reporting period. | Calculated |
51 | Days Absent | This field does not apply to flex attendance records. | Always N/A |
52 | Days/Minutes Present | The number of days and minutes all students in this flex attendance program and grade level were present during a particular reporting period. | Calculated |
53 | Days/Minutes Eligible | The total number of days and minutes the students in this grade level and flex attendance program were present and eligible for Foundation School Program funding during a particular reporting period. | Calculated |
54 | Days/Minutes Ineligible | The total number of days and minutes the students in this grade level and flex attendance program were present and ineligible for Foundation School Program funding during a particular reporting period. | Calculated |
55 | Days/Minutes BIL/ESL Eligible | The total number of days and minutes the students in this grade level and flex attendance program were present and eligible participants in the state-approved bilingual/ESL program during a particular reporting period. | [S_TX_STU_Flexible_ATT_C] E1045_Flexible_Prog_Type Calculated |
56 | Days/Minutes PRS Eligible | The total number of days and minutes that female students in this grade level and flex attendance program were present at school or served through Compensatory Education Home Instruction (CEHI) and are eligible recipients of pregnancy-related services during a particular reporting period. | [S_TX_SEN_PRS_X]E0939_PRS Calculated |
57 | G&T | The total number of students in this grade level and flex attendance program that participate in a gifted and talented program. | [S_TX_SEN_GT_X]E0034_GT Calculated |
Special Education Attendance | |||
58 | Report Period | The date range for this report. | Derived |
59 | Instructional Setting | The instructional setting codes and descriptions that students had at this campus. | Derived from:[S_TX_SEN_SPD_X]E0173_Instr_Setting |
60 | Eligible Days Present | The total number of eligible days present for the grade level, campus, and reporting period for each instructional setting. | Calculated |
61 | Excess Hours | The total number of excess hours for the grade level, campus, and reporting period for each instructional setting. | Calculated |
Special Education Flex Attendance | |||
62 | Report Period | The date range for this report. | Derived |
63 | Instructional Setting | The instructional setting codes and descriptions that students had at this campus. | Derived from:[S_TX_SEN_SPD_X]E0173_Instr_Setting |
64 | Eligible Days/Minutes Present | The total number of eligible days present for the grade level, campus, and reporting period for each instructional setting. | Calculated |
Career and Tech Attendance | |||
66 | Report Period Indicator and Reporting Period Dates | The date range for this report. | Derived |
67 | V1 | The number of students in this grade level that were eligible, present, and enrolled in an approved career and technical course that generated one contact hour during a particular reporting period. | [S_TX_SEN_CTE_X]E0031_CTE_IND Calculated |
68 | V2 | The number of students in this grade level that were eligible, present, and enrolled in an approved career and technical course that generated two contact hours during a particular reporting period. | [S_TX_SEN_CTE_X]E0031_CTE_IND Calculated |
69 | V3 | The number of students in this grade level that were eligible, present, and enrolled in an approved career and technical course that generated three contact hours during a particular reporting period. | [S_TX_SEN_CTE_X]E0031_CTE_IND Calculated |
Career and Tech Flex Attendance | |||
70 | Report Period Indicator and Reporting Period Dates | The date range for this report. | Derived |
71 | V1 | The number of students in this grade level that were eligible, present, and enrolled in an approved career and technical course that generated one contact hour during a particular reporting period. The total contact hours based on the calculation of student Service ID's and V Hours from the Student Detail queries. Total V1 Flex Min - Total Number of minutes ([ATTENDANCE]TOTAL_MINUTES or [BELL_SCHEDULE_ITEMS]MINUTES_ATTENDED) the student was eligible and present and enrolled in an approved career and technical course ([COURSES] VOCATIONAL = 1) that generated one contact hour ([S_TX_SEC_X]VOCATIONAL_CONTACT_HOURS = 1 or [S_TX_CRS_X]VOCATIONAL_CONTACT_HOURS = 1) during a particular reporting period | [S_TX_SEC_X]VOCATIONAL_CONTACT_HOURS = 1 or [S_TX_CRS_X]VOCATIONAL_CONTACT_HOURS = 1] Calculated |
| 72 | V2 | The number of students in this grade level that were eligible, present, and enrolled in an approved career and technical course that generated two contact hours during a particular reporting period. The total contact hours based on the calculation of student Service ID's and V Hours from the Student Detail queries. Total V2 Flex Min - Total Number of minutes ([ATTENDANCE]TOTAL_MINUTES or [BELL_SCHEDULE_ITEMS]MINUTES_ATTENDED) the student was eligible and present and enrolled in an approved career and technical course ([COURSES] VOCATIONAL = 1) that generated two contact hours ([S_TX_SEC_X]VOCATIONAL_CONTACT_HOURS = 2 or [S_TX_CRS_X]VOCATIONAL_CONTACT_HOURS = 2) during a particular reporting period | [S_TX_SEC_X]VOCATIONAL_CONTACT_HOURS = 2 or [S_TX_CRS_X]VOCATIONAL_CONTACT_HOURS = 2] Calculated |
73 | V3 | The number of students in this grade level that were eligible, present, and enrolled in an approved career and technical course that generated three contact hours during a particular reporting period. The total contact hours based on the calculation of student Service ID's and V Hours from the Student Detail queries. Total V3 Flex Min - Total Number of minutes ([ATTENDANCE]TOTAL_MINUTES or [BELL_SCHEDULE_ITEMS]MINUTES_ATTENDED) the student was eligible and present and enrolled in an approved career and technical course ([COURSES] VOCATIONAL = 1) that generated three contact hours ([S_TX_SEC_X]VOCATIONAL_CONTACT_HOURS = 3 or [S_TX_CRS_X]VOCATIONAL_CONTACT_HOURS = 3) during a particular reporting period | [S_TX_SEC_X]VOCATIONAL_CONTACT_HOURS = 3 or [S_TX_CRS_X]VOCATIONAL_CONTACT_HOURS = 3] Calculated |