Understanding the Report Output Table

The report output tables include the following elements:

• Item # or Position – Either the numerical order of the data element (first element is 1, second element is 2), or the position in the report. For example, if there is a string of data elements, such as 2009YNYN08091989, the particular element may start at position 5. In this example, position 5 is Y.
• Data Element – The name of the data element.
• Description – Additional information about the data element, including state reporting rules.
• [Table] – The name of the table where the data is stored.
• Field Name – The name of the field where the data is stored.

Note: The Table name appears in brackets with the Field Name directly following. Example: [Table]FieldName.

• Data Type – The field type used for the data element, such as character string, numeric, etc.
• Field Length – The length of the data element when extracted.

Setup is required to support State Reporting Platform (SRP) reports. Districts need to configure ReportWorks Preferences if you have not already done so. Additional information for configuring for the State Reporting Platform is available in article 62620 on PowerSource.

• If you have already configured ReportWorks Preferences, no additional setup is required.
• If you have not configured ReportWorks Preferences, please refer to the "ReportWorks Preferences" section of the ReportWorks Setup Guide on PowerSource. This section will provide steps for configuring the scheduler node for the report queue.

The SRP report output is available in Report Queue > ReportWorks.

General Information, first introduced on April 11, 2014: To improve consistency across student-level Consolidated Collections reports PowerSchool has developed a "core fields query". The core fields query is used in student-level reports to gather student details and assure consistent data submissions to ODE.

With the core fields query, consolidated field changes to reports need only be made one time, instead of updating the code for each individual student-level report. Past examples of field changes are the addition of American Indian tribal membership code and tribal enrollment number, also Teacher Filler instead of teacher's USID and name.

Each individual report continues to have its own query to determine the correct selection of students to be included.

Note: The elements on the SSID Information page are the fields used in the "core fields query" for student-level Consolidated Collections Reports.