Skip to main content
Skip table of contents

Primary Teacher Validation - Obsolete

Introduction

Important: This report is obsolete as of 18.11.0

Use the Primary Teacher Validation to check for errors that may occur when migrating TEACHERS information to the USERS table. The extract enables you to check that the 'CA_PrimarySchool' is properly marked as NULL (in the case of only one record instance) or 'Y' (in the case of one or more record instances). The report checks for the following issues:

  • Users with only one TEACHERS record explicitly marked as Not Primary.

  • Users with multiple TEACHERS records explicitly marked as Not Primary.

  • Users with multiple TEACHERS records and none of them are marked Primary (that is, they are marked either as Not Primary or NULL).

  • Users with multiple TEACHERS records and two or more of them are marked Primary.

There are no report parameters required for this report. Click Submit to run the report.

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.

Report Output Format: The report output formats for this report are comma delimited and PDF.

Data Element

Description

[Table]FieldName

USERS_DCID

The ID from the Users table.

[Users]UsersDCID

Tch Num

The staff member's ID number.

[Teachers]ID

Teacher

The staff member's name (Last, First, MI)

[Teachers]First_Name

[Teachers]Last_Name

School

The school where the staff member works.

[Schools]Name

CA_PrimarySchool

 

The report outputs Y or N based on the teacher's primary school status. If no primary school status has been explicitly marked, the report outputs NULL.

[Teachers]CA_PrimarySchool

Home

Indicates if the homeschoolid and schoolid field match. The report outputs an "X" if they match and a blank if they do not.

[Users]homeschoolid

[SchoolStaff]schoolid

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.