A01 - System Level (2018-19) - Legacy
Introduction
The A01 - System Level report extracts district level PowerSchool data, including psychological services information. One record is transmitted for each system.
Note: This report must be run for the entire district.
Selection Criteria
Selection criteria determine which database records are used in the report.
This report extracts data that is manually entered at the district level. See the last two fields in the report (above the "Filler" field) for student selection criteria.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
File Path and File Suffix | The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix. For example, a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _A01.txt will save the results to a file named 999201408010915_A01.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server. |
SFTP Connections | Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically. Please refer to Setting Up a SFTP Connection for details on how to create a SFTP connection. |
Report Output
Each of the fields displayed in the output of the report are described below. Understanding the Report Output Table for a definition of each column in the table.
Layout ID | Data Element | Description | [Table]FieldName | Length |
---|---|---|---|---|
A001 | Fiscal Year | The fiscal year of the record. The report extracts the year based on the last day in the current school calendar. | [Terms]LastDay | 4 |
A002 | Period | The reporting period. Always 1. | N/A | 1 |
A003 | System Code | The school system code. This is the district number in PowerSchool. | [Prefs]Value [Prefs]Name=districtnumber | 3 |
A004 | Record Type | Identifies the record layout. Always A01. | N/A | 3 |
A040 | TKES 90% Teaching | Identifies whether the LEA considers 90& course time taught for all or individual SPG teachers of record. Valid values:
| 1 | |
Filler | Filler | Filler | N/A | 107 |
A023 | Psychological Services Evaluation Code – Comprehensive Evaluations by System-Employed School Psychologists | Total number of full initial evaluations and re-evaluations conducted during the school year by school psychologists who are school district employees. | [Prefs]Value [Prefs]Name=GA_PSEC_CESESP | 6 |
A024 | Psychological Services Evaluation Code – Comprehensive Evaluations by Non-System-Employed Psychologists | Total number of full initial evaluations and re-evaluations conducted during the school year on a per-case basis. For example, contract testing, RESA employees, interns, etc. by psychologists who are NOT school district employees. | [Prefs]Value [Prefs]Name=GA_PSEC_CENSEP | 6 |
A025 | Psychological Services Evaluation Code – Less Than Comprehensive Evaluations by All Psychologists | Total number of individual student evaluations, observations, or case consultations not considered a full evaluation, by ALL psychologists who provided services during the year. | [Prefs]Value [Prefs]Name=GA_PSEC_LTCEAP | 6 |
A026 | Psychological Services Evaluation Code – Initial Referrals Not Seen | Total number of students referred for INITIAL full psychological evaluation that were not evaluated by the end of the school year. | [Prefs]Value [Prefs]Name=GA_PSEC_IRNS | 6 |
A027 | Psychological Services Evaluation Code – Re-evaluations Not Completed | Total number of students due for psycho-educational re-evaluation who were not re-evaluated by the end of the school year. | [Prefs]Value [Prefs]Name=GA_PSEC_RNC | 6 |
A028 | Psychological Services Evaluation Code – Students to be Evaluated by System-Employed School Psychologists This Summer | Estimated number of students who will receive psycho-educational evaluations this summer by school psychologists who are district employees. | [Prefs]Value [Prefs]Name=GA_PSEC_SESESPS | 6 |
A029 | Psychological Services Evaluation Code – Students to be Evaluated by Other Psychologists This Summer | Estimated number of students for whom the district will provide psycho-educational evaluations this summer by psychologists who are NOT district employees. | [Prefs]Value [Prefs]Name=GA_PSEC_SEOPS | 6 |
A030 | Psychological Services Consultation Code – Consultations With Parents Only | Total number of consultations with parents of students only by all psychologists providing consultations for the school district this school year. | [Prefs]Value [Prefs]Name=GA_PSCC_CWPO | 6 |
A031 | Psychological Services Consultation Code – Consultations With Student Support Teams | Total number of consultations with student support teams or groups of teachers / administrators by all psychologists providing consultations for the school district this school year. | [Prefs]Value [Prefs]Name=GA_PSCC_CWSST | 6 |
A032 | Psychological Services Consultation Code – Student Consultations | Total number of consultations with students by all psychologists providing consultations for the school district this school year. | [Prefs]Value [Prefs]Name=GA_PSCC_SC | 6 |
A033 | Psychological Services Consultation Code – Other School Consultations | Total number of other school consultations by all psychologists providing consultations for the school district this school year. | [Prefs]Value [Prefs]Name=GA_PSCC_OSC | 6 |
A034 | Psychological Services Consultation Code – All Other Consultations or Services Provided | Total number of all other consultations or other services by all psychologists providing consultations for the school district this school year. | [Prefs]Value [Prefs]Name=GA_PSCC_AOCSP | 6 |
A035 | Private ELL Students | The number of students identified as ELL attending private school. | [Prefs]Value [Prefs]Name=GA_Priv_EL_Stu | 4 |
A036 | Private Immigrant Students | The number of students identified as immigrant attending private school. | [Prefs]Value [Prefs]Name=GA_Priv_Immigrant_Stu | 4 |
A037 | Filler 1 | Filler | N/A | 17 |