PowerSchool SIS Utah

Understanding the Report Output Table

The report output tables in this section include the following elements:

  • Data Element – The name of the data element.

  • Description – Additional information about the data element, including state reporting rules.

  • Item # – The numerical order of the data element (first element is 1, second element is 2).

  • [Table] – The name of the table where the data is stored.

  • FieldName – 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.

  • Field Length – The length of the data element when extracted.

  • Data Type – The data type used for the data element, including Alpha (A) and Numeric (N).

  • Begin/End Position – The position of the data element 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.