Last Updated 02/24
Tool Search: Educator Census
The Educator Census Extract collects course data to determine which core academic subjects are taught by teachers who are highly qualified in their fields in accordance with Title III of NCLB.
Example Educator Census Report Editor
Report Editor
| Field | Description |
|---|---|
| Date Range | The date range from which data is pulled for the report. |
| Format |
|
| Report Legal Identities | When this checkbox is marked, Campus reports the legal name entered on the Census > People > Identities tab. If only one part of the Protected Identity Information is entered, that part reports and the other name fields report blank. For example, if the Legal First Name is entered but the middle and last name fields are empty, then only the first name reports and the middle and last names report blank.
|
| Select Calendars | The calendar(s) from which data is pulled for the report. |
| Generate Extract | Click to generate the report in the selected format. |
Report Layout
| Column | Description | Type, Format, and Length | Campus Database | Campus Location |
|---|---|---|---|---|
| POSID | The school number where the staff member is assigned. | Numeric, 7 digits | School.number | Census > People > District Assignment > Employment Assignments > Teacher AND Census > People > District Assignment > Employment Assignments > School |
| POSBEGDATE | The start date of the staff member's assignment. | Date field, 10 digits MM/DD/YYYY | EmploymentAssignment. | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > Start Date |
| POSENDDATE | The end date of the staff member's assignment. | Date field, 10 digits MM/DD/YYYY | EmploymentAssignment. endDate | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > End Date |
| POSFTE | The full time equivalency of the staff member's assignment. | Date field, 10 digits MM/DD/YYYY | EmploymentAssignment. fte | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > FTE of Assignment |
| PREK | Reports if this staff member is a pre-kindergarten teacher or not. If the Teacher box is checked and the Teacher Type is marked as PreK in Employment Assignment Information, then this field will report as Y. If not, then this field will report N. | Alphanumeric, 1 character | EmploymentAssignment. alternativeType | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > Teacher |
| K12 | Reports if this staff member is a Kindergarten through Grade 12 Teacher or not. If the Teacher box is checked and the Teacher Type is marked as K-12 in Employment Assignment Information, then this field will report as Y. If not, then this field will report N. | Alphanumeric, 1 character | EmploymentAssignment. alternativeType | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > Teacher |
| SAUADMIN | Reports if this staff member is a Supervisory Union Administrator or not. If SU Admin is checked in Employment Assignment Information, then this field will report as Y. If not, then this field will report as N. | Alphanumeric, 1 character | EmploymentAssignment. suAdmin | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > SU Admin |
| SCHOOLADMIN | Reports if this staff member is a School Administrator or not. If School Admin is checked in Employment Assignment Information, then this field will report as Y. If not, then this field will report as N. | Alphanumeric, 1 character | EmploymentAssignment. schoolAdmin | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > School Admin |
| TECHTEACH | Reports if this staff member is a Technical Center Teacher or not. If Teacher is checked and the Teacher Type is marked as 04: Technical in Employment Assignment Information, than this report will report as Y. If not, than this report will report as N. | Alphanumeric, 1 character | EmploymentAssignment. alternativeType | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > Teacher Type |
| PUPSERV | Reports this staff member's Pupil Support Services role. If Pupil Support is checked in Employment Assignment information, than this field will report as Y. If not, that this field will report as N. | Alphanumeric, 1 character | EmploymentAssignment. pupilSupport | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > Pupil Support |
| ALTPROG | Reports if this staff member is a Alternative Program Teacher or not. If Teacher is checked and the Teacher Type is marked as 03: Alternative Program in Employment Assignment Information, than this field will report as Y. If not, than this field will report as N. | Alpha, 1 character | EmploymentAssignment. alternativeType | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > Teacher Type |
| SPED | Reports if this person is a Special Educator or not. If Special Ed is checked in Employment Assignment information, than this field will report as Y. If not, that this field will report as N. | Alphanumeric, 1 character | EmploymentAssignment. specialed | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > Special Ed |
| SPEDROLE | The Special Education role of the staff member. Options include:
| Alphanumeric, 25 characters | EmploymentAssignment.spedLevel | Census > People > District Assignment > Employment Assignments > Employment Assignment Information > SPED Role |
| COURSENAME | The course name. | Alphanumeric, 50 characters | Course.name | Scheduling > Courses > Course Information > Name |
| COURSEID | The course identification number. | Numeric, 10 digits | Course.stateCode | Scheduling > Courses > Course Information > Number |
| COURSECAT | The course category. | Alphanumeric, 100 characters | Course.abbreviation | Scheduling > Courses > Course Information > Additional Category |
| COURSECATCODE | The course category code. | Numeric, 10 digits | Course.additionalCategory | Scheduling > Courses > Course Information > Additional Code |
| LOCALCOURSEID | The local course identification number. | Numeric, 15 digits | Course.courseID | Scheduling > Courses > Course Information > Number |
| SOURCEORGID | The school number in which that the corresponding course is. | Numeric, 7 digits | School.number | Census > People > District Assignment > Employment Assignments > School |
| QTY | If Special Ed is checked in Employment Assignment Information, this field will report the quantity of students enrolled in the teacher's courses. If Special Ed is not marked, the field will report the number of sections the teacher is teaching for each course. | Numeric, 2 digits | Calculated field | Census > People > District Assignment > Employment Assignment Information > Special Ed |
| COURSEBEGLEVEL | The lowest grade level taught for this course. | Numeric, 2 digits | GradeLevel.name | Scheduling > Courses > Course > Custom Data Elements > Course Grade Code |
| COURSEENDLEVEL | The highest grade level taught for this course. | Numeric, 2 digits | GradeLevel.name | Scheduling > Courses > Course > Custom Data Elements > Course Grade Code |
| FORMERLAST | Any other last name that does not match the current identity of the staff member. | Alphanumeric, 50 characters | Identity.lastName | Census > People > Identities > Last Name |
| ORGID | The district identification number. | Alphanumeric, 5 characters | District.number | System Administration > Resources > District Information > District Editor > District Detail > State District Number. |
| EMPBEGDATE | The employment start date of the staff member. | Date field, 10 digits MM/DD/YYYY | EmploymentAssignment. startDate | Census > People > District Employment > Start Date |
| EMPENDDATE | The employment end date of the staff member. | Date field, 10 digits MM/DD/YYYY | EmploymentAssignment. endDate | Census > People > District Employment > End Date |
| TITLE | The position title of the staff member. | Alphanumeric, 50 characters | EmplyomentAssignment. title | Census > People > District Assignment > Employment Assignments > Teacher And Census > People > District Assignment > Employment Assignments > Title |
| EMPSTATNO | The employment status number of the staff member. | Numeric, 2 digits | Employment. employmentStatus | Census > People > District Employment > Employment Information > Employment Status |
| RACE | The race/ethnicity of the staff member. | Alphanumeric, 50 characters | Identity.raceEthnicity | Census > People > Demographics > Race/Ethnicity And Census > People > Identities > Race/Ethnicity |
| TITLE1 | The title 1 status of the staff member. | Numeric, 1 digit. | EmploymentAssignment. title1 | Census > People > District Assignment > Employment Assignments > Teacher And Census > People > District Assignment > Employment Assignments > Title |
| PERMNUMBER | The permanent staff ID number given to the staff member by the State Department of Education. | Numeric, 10 digits | Employment. employmentID | Census > People > Demographics > Person Identifiers > Staff State ID |
| TEAMTEACHID | If there is a secondary teacher assigned for the course, this field reports the secondary teacher's State Staff ID. | Numeric, 10 digits | Employment. employmentID | Scheduling > Courses > Sections > Section Editor > Team |
| LOCALIDNUM | The local staff number assigned to the staff member by the district. | Numeric, 15 digits | Employment.personID | Census > People > Demographics > Person Identifiers > Local Staff Number |
| FNAME | The staff member's first name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab. | Alphanumeric, 20 characters | Identity.firstName OR Identity.legalFirstName | Census > People > Demographics > Person Information > First Name OR Census > People > Identities > Protected Identity Information > Legal First Name |
| MNAME | The staff member's middle name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab. | Alphanumeric, 20 characters | Identity.middleName OR Identity.legalMiddletName | Census > People > Demographics > Person Information > Middle Name OR Census > People > Identities > Protected Identity Information > Legal Middle Name |
| LNAME | The staff member's last name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab. | Alphanumeric, 20 characters | Identity.lastName OR Identity.legalLastName | Census > People > Demographics > Person Information > Last Name OR Census > People > Identities > Protected Identity Information > Legal Last Name |
| POSTNAME | The suffix of the staff member. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab. | Alphanumeric, 3 characters | Identity.suffix OR Identity.legalSuffix | Census > People > Demographics > Person Information > Suffix OR Census > People > Identities > Protected Identity Information > Legal Suffix |
| DOB | The staff member's date of birth. | Date field, 10 digits MM/DD/YYYY | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date And Census > People > Identities > Identity Information > Birth Date |
| GENDER | The staff member's gender. Campus reports the gender entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the gender reports from the Demographics tab. | Alphanumeric, 1 character M for male, F for female | Identity.gender OR Identity.legalGender | Census > People > Demographics > Person Information > Gender OR Census > People > Identities > Protected Identity Information > Legal Gender |
