Student Course Grade Teacher (SCGT) Data Collection (Maryland) [.2124 - .2215]

Classic View: MD State Reporting > SCGT Extract

Search Terms: SCGT Extract

The Student Course Grade Teacher (SCGT) Collection is used to collect data specific to all courses a student has taken during a school year, the final grades the student received in them, and the teacher(s) associated with these courses.

The collection is intended to capture details from a student education viewpoint. This includes demographic information, the courses enrolled by the student, detailed final grade information, alpha and numeric grades, information required to uniquely identify a distinct class and the semester or term, and information about the teacher(s) associated with the student and courses connected in educating the student.

Report Logic

  • A record reports for each course on a student's schedule.
  • Student has/had enrollment in the selected calendar with a start date on or before the extract editor Effective Date.
  • Enrollment type can be Primary, Partial or Special Ed Services.
  • The course must have a State Code that is not null and is not marked as Exclude during the enrollment start and end dates. 
  • If multiple enrollments exist, only the most recent primary enrollment as of the Effective Date on the extract editor reports.
  • If no primary enrollment exists, the most recent enrollment is used.
  • A record reports for each course associated with each primary, secondary and special ed enrollment if the student moved between schools for each school selected during report generation.
  • Current, dropped, past and future courses are reported if they meet report criteria.
  • A record reports for each course associated with each Primary, Secondary, and Special Ed enrollment record if the student moved between schools for each school selected on the extract editor.
  • To prevent duplicate records when students have multiple enrollments in the same school calendar, Campus reports distinct records for each course/section in which the student was enrolled.
  • The report uses the following sort order: Student ID, LEA Course Code, LEA Section Number.
     

The following records do NOT report.

  • Courses marked as Exclude.
  • Courses where the State Code value is null.
  • Students who have no courses in their schedule.
  • Students who have courses in their schedule but all courses have null State Code values.
     Students with State excluded enrollment records or a enrollment records in state excluded calendars.

Calendar Exclude logic is ignored for Summer School calendars. If a summer school calendar is selected, the previous Enrollment must have a Service Type of Primary in order to report.

  • Students with only a summer school enrollment record with no previous school year enrollment nor an enrollment in the reporting year.

Report Editor Fields

FieldDescription
Effective DateData is pulled as of the date selected in this field.
Run DateThe date on which the report was generated. This date appears in the Submission Date field on the report.
Submission NumberDisplays in the file name after the date.  If less than 3 digits, reports with left leading zeros.
Drop DaysSections are excluded from the report if all students have dropped the section after the number of instructional days indicated in this field.
February Collection

When this checkbox is marked, additional Course Completion statuses are considered.

Choose GradesDetermines specific grades to include in the report.
Ad Hoc FilterSelect a filter to limit results to students included in the filter.
Format

Determines the format for the report.

  • Fixed Width (State Format)
  • Comma Separated (CSV)
  • HTML
Select CalendarsThe calendar(s) from which data is pulled for the report.
Generate Report
Submit to Batch

Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Each batch queue file is limited to 10 calendars.

Report Layout

ElementDescriptionLocation
LEA NumberThe two-digit State designation of the reporting LEA.

Numeric, 2 digits
System Administration > Resources > District Information > State District Number
School Number

The reporting school's MSDE School Number.

The school is reported using the following logic:

  • If a summer school is selected during report generation, the school number of the last enrollment in the previous year's regular school year reports.
  • If no enrollment records exist in the last regular school year, the school number of the first enrollment in the reporting year reports.
  • Otherwise, the Home School number reports from the student's enrollment. If the Home School field is null, the school number on the school table tied to the enrollment reports.

Numeric, 4 digits

Student Information > General > Enrollment > Home School

System Administration > Resources > School > State School Number

SASIDThe student's unique student statewide identifier (SASID).

Numeric, 10 digits
Census > People > Demographics > Student State ID
Student Local Identification Number (LOCID)The student's locally-assigned student number.

Numeric, 10 digits

Right justified, left padded with zeros.


Census > People > Demographics > Student Number
Student Last NameThe student's last name.
Reports the last name from the current Identity record. Legal Last Name reports. If Legal Last Name is null, the Last Name reports.

Alphanumeric, 25 characters
Census > People > Identities > Current Identity > Legal Last Name or Last Name
Student First NameThe student's first name.
Reports the first name from the current Identity record. Legal First Name reports. If Legal First Name is null, the First Name reports.
Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Legal First Name or First Name
Student Middle NameThe student's middle name.
Reports the middle name from the current Identity record. Legal Middle Name reports. If Legal Middle Name is null, the Middle Name reports.

Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Legal Middle Name or Middle Name
Student Generational SuffixThe student's generational suffix.
Reports the suffix from the current Identity record. If the Legal First Name and Legal Name are not null, Legal Suffix reports. If the Legal First Name and Legal Middle Name are null, Suffix reports.

Alphanumeric, 3 characters
Census > People > Identities > Current Identity > Legal Suffix or Suffix
Preferred NameAn alternative first name preferred by the student.

Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Preferred Name
Student Date of BirthThe student's date of birth.

Date field, 8 characters YYYYMMDD


Census > People > Identities > Current Identity > Birth Date
Student GradeThe student's state grade level based on enrollment record.

Numeric, 2 digits 01-09


Student Information > General > Enrollments > Grade
Student Gender

Indicates the student's gender.

M: Male

F: Female

X: Non-Binary

Reports the gender from the current Identity record. Legal Gender reports. If Legal Gender is null, Gender reports.


Alphanumeric, 1 character

Census > People > Identities > Current Identity > Legal Gender or Gender
Hispanic or Latino
Ethnicity

Indicates if the student is considered Hispanic/Latino.

If the Is the individual Hispanic/Latino? field = Yes, Y reports. Otherwise, N reports.


Alphanumeric, 1 character  Y or N

Census > People > Demographics > Race Ethnicity > Is the individual Hispanic/Latino?
American Indian or
Alaska Native

Indicates whether the person has origins in any of original peoples of North and South America (including Central America) and who maintains cultural identification through tribal affiliation or community attachment.

1 = Yes

0 = No or Null


Alphanumeric, 1 character

Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native
Asian

Indicates whether the person has origins in any of original peoples of the Far East, Southeast Asia, or the Indian Subcontinent. This area includes Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, Philippine Islands, Thailand, and Vietnam.

2 = Yes

0 = No or Null


Alphanumeric, 1 character

Census > People > Demographics > Race/Ethnicity > Asian
Black or African
American

Indicates whether the person has origins in any of the black racial groups of Africa.

3 = Yes

0 = No or Null


Alphanumeric, 1 character

Census > People > Demographics > Race/Ethnicity > Black or African American
Native Hawaiian or
Other Pacific Islander

Indicates whether the person has origins in any of original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.

4 = Yes

0 = No or Null


Alphanumeric, 1 character

Census > People > Demographics > Race/Ethnicity > Native Hawaiian or Other Pacific Islander
White

Indicates whether the person has origins in any of original peoples of Europe, Middle East, or North Africa.

5 = Yes

0 = No or Null


Alphanumeric, 1 character

Census > People > Demographics > Race Ethnicity > White
Homelessness StatusIndicates whether the student lacks a fixed, regular, and adequate nighttime residence.

Alphanumeric, 1 character
Student Information > General > Enrollments > State Reporting Fields > Homeless
Title 1 Status

Indicates if the student is considered Title 1.

A value of Y is reported for all students in a school where Title 1 = Targeted Assistance Program or Schoolwide eligible targeted assistance or Schoolwide Program and the student is marked Title 1 on their enrollment record. OR if School > Title = Schoolwide Program, a value of Y is reported for all students.

Values are reported as of the Effective Date entered on the extract editor.


Alphanumeric, 1 character Y or N

System Administration > Resources > School > Title 1

Student Information > General > Enrollments > State Reporting Fields > Title 1

FRAM Status

Indicates if the student receives free/reduced price meals. If the Migrant element reports Y, then this field reports F.

Otherwise, the value reports from the FRAM record as of the Effective Date entered on the extract editor.

EligibilityReports

Free

F

Reduced

R

Non-Reimbursable

N

Paid

N


Alphanumeric, 1 character

FRAM > Eligibility
MigrantIndicates whether the student is a migratory student.

Alphanumeric, 1 character Y or N
Student Information > General > Enrollment > State Reporting Fields > Migrant
Foreign Exchange Student

Indicates whether the student is a foreign exchange student.

If the student is in grade 9-12 as of the Effective Date selected on the extract editor, Y reports if the Foreign Exchange record is Y, J1, or F1. Otherwise, N reports.

If the student is not in grades 9-12, N reports.


Alphanumeric, 1 character Y or N

Student Information > General > Enrollment > State Reporting Fields > Foreign Exchange

Special Education Status

Indicates the student's special education services.

Values are reported as of the Effective Date entered on the extract editor.

ValueDescription
2

The student is in Code 504.

2 reports when the student has an active 504 record with a Start Date before the extract editor Effective Date and one of the following:

  • 504 End Date is NULL OR  
  • 504 End Date is after the extract editor Effective Date
    AND the student does not flag as E or 3

Students do NOT need an IEP to report as a 2.

3

The student has exited special education services and has been placed in Code 504.

3 reports when the student has a 504 flag that meets all of the following

  • Active as of extract editor End Date
  •  Start Date is after special ed exit Date
    AND
  • The most recent locked IEP meets ALL of the following.
    •  Special Ed Start Date that is prior to or equal to report extract editor End Date
    • IEP Closed Date is less than or equal to the extract editor Run Date    
    • Exit code is A or J
    • Special Ed Exit date is on or after June 1 YYYY (YYYY is the -2 year of the reporting year end year. June 1, 2015 for the 16-17 reporting year.)
E

The student has exited special education services within the past two school years and is not currently receiving special education services.

E reports when

  • the student’s most recent IEP has a Special Ed Start Date that is prior to or equal to report extract editor Effective Date and the latest IEP Closed Date is less than or equal to the extract editor Run Date
    AND
  • the Exit code is A or J AND Special Ed Exit Date is on or after June 1 YYYY (YYYY is the -2 year of the reporting year end year. June 1, 2015 for the 16-17 reporting year.)

    AND
  • the student has no 504 record OR the student has a 504 record with a Start Date before the Special Ed Exit Date
NThe student does not have an IEP and is not receiving special education services.
Y

The student has an IEP and is receiving special education services.

Y reports when the most recent IEP has a Special Ed Start Date that is prior to or equal to the report extract editor Effective Date and the latest IEP Closed Date is less or equal to the extract editor Run Date AND meets one of the following:

  • Exit code is null
    OR
  • Exit code is not Null and is not A or J
    Or
  • Exit code is  A or J AND Special Ed Exit Date after the report Effective Date



Alphanumeric, 1 character

Student Information > General > Enrollment >Special Ed Fields > Special Ed Status
Special Ed End DateThe date on which special education services ended. This date reports from the most recent IEP as of the Effective Date entered on the extract editor.

Date field, 8 characters YYYYMMDD

Student Information > Special Ed > Documents > IEP > Special Ed Exit Date
Special Ed Certificate

Indicates whether the student is on track to receive a MD High School Certificate of Completion. This is required if Special Education Services = Y.

Y reports when

  • the student's most recent IEP has a Special Ed Start Date prior to or equal to the report's Effective Date, AND
  • the IEP Closed Date is less than or equal to the report Run Date, AND
  • the Special Ed Certificate checkbox is selected, AND
  • one of the following requirements is met:
    • Exit Reason is null, OR
    • Exit Reason is not Null and is not A or J, OR
    • Exit Code is A or J AND Special Ed Exit date equal to or after the report Effective Date.

Otherwise, N reports.



Alphanumeric, 1 character

Student Information > General > Flags 

 Programs Admin > Flags > State Program Type > State Reported

(Flag is tied to state program type of certificate and State Reported checkbox is marked)

English Language Learner

Indicates whether the student has a primary or home language other than English and has been assessed as having limited or no ability to understand, speak or read English.

Students are classified based on the student’s status as of the last reportable day of attendance during the reporting period identified within this record.

EL StatusReports

EL

Y

Exited EL

Y- When extract editor Effective Date is
before the EL Exited Date

Exited EL

E - Reports when the EL Exit date is on or after June 1 YYYY (YYYY is the -2 year of the reporting year end year. June 1, 2015 for the 16-17 reporting year.)

Exited EL

N - Reports when EL Exit date is more than 2 years from June 1st of report generation end year. (June 1, 2017 for the 16-17 reporting year.)

Not EL

N

Pending

N

No Record

N


Alphanumeric, 1 character

Student Information > Program Participation > English Learners (EL) > EL > Program Status
ELL Begin Date/
Entry Into the US

The date when the student began ELL services or entered the United States for the first time.

If the Date Entered US field is null, the Date Entered US School reports.

If the Date Entered US School field is null, the Identified Date from the earliest EL record reports.


Date field, 8 characters YYYYMMDD

Census > People > Demographics > Date Entered US School

Student Information > Program Participation > English Learners (EL) > EL > Identified Date

EL Begin Date The date when the student's ELL services started.

Date field, 8 characters YYYYMMDD
Student Information > Program Participation > English Learners (EL) > EL > Program Start Date
EL End DateThe date when the student's ELL services ended.

Date field, 8 characters YYYYMMDD
Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date
English Learner ELA Assessment Exempt Status 

Indicates the student receiving ESOL services in their first year of enrollment in a U.S. school is exempt from the PARCC English/Language Arts assessment and may substitute the required state assessment with the English Language Proficiency Assessment (ACCESS for ELs 2.0).

When EL Status = Y, Y reports for student’s in their first year of enrollment in a U.S. School. Otherwise, N reports.

Students are exempt if they are within 1 calendar year (365 days) of their first day enrolled in a US school.


Alphanumeric, 1 character

Student Information > Program Participation > English Learners (EL) > EL > Program Status
Foster Care StatusIndicates whether the student is in foster care.

Y reports when the student has an active foster care record as of the report Effective Date selected in the extract editor OR the student’s enrollment end date.

Otherwise, N reports.


Alphanumeric, 1 character Y or N

Student Information > Program Participation > Foster Care
Military Connected Indicator 

Indicates whether the student has a parent or guardian in the military.

 Y   reports when the Military Connected status is   Y  .

 N reports when the Military Connected status is N.

 U   reports when the Military Connected status is   U  .

Otherwise, this element reports blank.


Alphanumeric, 1 character

Student Information > Enrollments > Military Connected Status
Filler N/AN/A
Submission DateThe date the file was submitted to the state. This field reports the Run Date entered on the extract editor.

Date field, 8 characters YYYYMMDD
Run Date field on extract editor
Submission NumberIndicates the submission number based on sequence (starting with 001).

Numeric, 3 digits

Right justified with left leading zeros


Submission Number field on the extract editor
Academic YearThe end year of the calendar selected on the extract editor.

Date field, 4 characters YYYY
Calendar selected on the extract editor
LEA Course Code

The unique LEA assigned course code that identifies the course.


Numeric, 10 digits


Scheduling > Courses > Course > Number
LEA Section NumberThe unique identifier of the reporting course section.

Numeric, 10 digits
Scheduling > Courses > Course > Sections > Section Number
Section Title

The section title of the reporting course section.


Alphanumeric, 30 characters

Scheduling > Courses > Course Master > Name
LEA Class Period

The district identifier for the reported course section.

If students have multiple enrollments within in the same school, distinct records report for each course/section in which the student was enrolled.

For multiple records where the combination of SASID, LEA Course Code, LEA Course Term,  and LEA Section Number are the same, the record where the Course Completion Status is NOT "I" reports. Otherwise, the enrollment record with the most recent start date reports.


Alphanumeric, 50 characters

Scheduling > Courses > Course >

  • Name
  • SectionID
  • Section > Term


Unique LEA Classroom Key ElementsAn additional optional element used as a component of the LEA classroom key. This field reports blank.
N/A
Instruction Outside of School Flag

Indicator of courses taken outside of the student’s primary school and reported on the student’s grade reports or transcripts of which the LEA does not have primary control.

Y reports when Delivery is online or when the SCED Level is Dual Enrollment. Otherwise, this field reports N.


Alphanumeric, 1 character Y or N

Scheduling > Course/Course Master > Delivery or SCED Level
Course Marking Term

The semester or term of the reporting course.

Field values are reported using the following logic:

  • 1Q = The section is scheduled only in sequence 1 of 4 sequences in Calendar > Terms > Term Detail
  • 2Q = The section is scheduled only in sequence 2 of 4 sequences in Calendar > Terms > Term Detail 
  • 3Q = The section is scheduled only in sequence 3 of 4 sequences in Calendar > Terms > Term Detail
  • 4Q = The section is scheduled only in sequence 4 of 4 sequences in Calendar > Terms > Term Detail
  •  1S = The section is scheduled only in sequence 1 of 2 sequences in Calendar > Terms > Term Detail
  • 2S = The section is scheduled only in sequence 2 of 2 sequences in Calendar > Terms > Term Detail
  •  SY = The section is scheduled in both sequences of 2 sequences in Calendar > Term > Term Detail
  •  S = The calendar is marked Summer School

Numeric, 2 digits

System Administration > Calendar > Terms > Term Detail
Transition Course

Indicates whether the course was used by the student as a transition course for CCR.

  • If SCED course level is TRN, T reports
  • If SCED course level is MOD, M reports
  • Otherwise, N reports

Alpha, 1 character

Scheduling > Course/Course Master > SCED Course Level
Course Completion Status

Indicates the completion status of the course at the time of data submission.

This field reports values based on the following logic:

StatusLogic
IPAll courses that have not ended for the student as of the time of the report generation and the student did not receive a grade for the course; e.g., Course Grade is NA. (February Collection ONLY)
F
  • The course's Earned value is 00.00 (Transcript > Transcript Course Editor > Transcript Credit > Earned)
    OR
  • The student's score on the Course > Grading Task is marked State Reported and Passing Score is not marked.
P
  • The course's Earned value is greater than 00.00 (Transcript > Transcript Course Editor > Transcript Credit > Earned)
    OR
  • The student's score on the Course > Grading Task is marked State Reported and Passing Score is marked.
NS
  • All courses that have not yet started (Course > Section > Start Date is after the report generation date). (February Collection ONLY)  
  • When the Course Section Start Date is after the Effective Date entered on the extract editor and the student did not receive a grade for the course; e.g., Course Grade is NA. (February Collection ONLY)
I
  • When the course has ended and the student did not receive a grade for the course; e.g., Course Grade is  NA.
    OR
  • When the course has not ended, February Collection is not checked, and the student did not receive a grade for the course; e.g., Course Grade is NA. Does not include students who were not in the class roster when the section ended.

    OR

  • The Section Score’s associated Score Group State Code is NC.

WDWhen a student has left the course before the course has ended and the student did not receive a grade for the course; e.g., Course Grade is NA.


Alpha, 2 characters

Grading and Standards > Grading Tasks > Grading Task Detail

Scheduling > Courses > Sections > Roster

Grading and Standards > Score Groups & Rubrics > Score Group List Items Detail > State Score
Course Grade-Alpha

The alpha grade earned by the student for the course. If the student has a State Score other than W, the State Score reports. Otherwise, NA reports.

The State Score Code reports from grading tasks that meet the following criteria.

  • Marked as state reported
  • Marked as final
  • If student has more than 1 score tied to the grading task, the score with the highest ID reports.
  • If more than one grading task meets the previous criteria, the grading task with the highest ID reports.

Alpha, 2 characters

Transcript > Transcript Course Editor > Score

Schedule > Courses > Course > Grading Task > Score is marked State Reported

Standards Based- Grade This field reports NA.N/A
FillerN/AN/A
FillerN/AN/A
Teacher Information
Multiple Teacher Course IndicatorIndicates whether the course is taught by multiple teachers.

Alpha, 1 character Y or N
Scheduling > Courses > Course > Section > Staff History > Role = Co-teacher
Primary Teacher SATID

The ten-digit State-Assigned Teacher Identification (SATID) assigned in the Unique Teacher Identifier System (UTIS).

Logic first looks to see if the teacher is considered the Primary Teacher (Course > Section > Staff History > Primary Teacher) and reports their Staff State ID as of the report generation date OR the last primary teacher for courses that have completed OR the primary teacher assigned to the section at the time of reporting for future courses.


Numeric, 10 digits

Course > Section > Staff History > Primary Teacher

Census > People > Demographics > Staff State ID 

Primary Teacher

LOCID

The primary teacher's locally-assigned identifier.

Logic first looks to see if the teacher is considered the Primary Teacher (Course > Section > Staff History > Primary Teacher) and reports their Local Staff Number as of the report generation date OR the last primary teacher for courses that have completed OR the primary teacher assigned to the section at the time of reporting for future courses.


Numeric, 10 digits

Census > People > Demographics > Local Staff Number
Primary Teacher Last Name

The last name of the primary teacher.

Logic first looks to see if the teacher is considered the Primary Teacher (Course > Section > Staff History > Primary Teacher) and reports their last name as of the report generation date OR the last primary teacher for courses that have completed OR the primary teacher assigned to the section at the time of reporting for future courses.


Alpha, 25 characters

Census > People > Demographics > Last Name
Primary Teacher First Name

The first name of the primary teacher.

Logic first looks to see if the teacher is considered the Primary Teacher (Course > Section > Staff History > Primary Teacher) and reports their first name as of the report generation date OR the last primary teacher for courses that have completed OR the primary teacher assigned to the section at the time of reporting for future courses.


Alpha, 25 characters

Census > People > Demographics > First Name
Primary Teacher Middle Name

The middle name of the primary teacher.

Logic first looks to see if the teacher is considered the Primary Teacher (Course > Section > Staff History > Primary Teacher) and reports their middle name as of the report generation date OR the last primary teacher for courses that have completed OR the primary teacher assigned to the section at the time of reporting for future courses.


Alpha, 25 characters

Census > People > Demographics > Middle Name
Primary Teacher Generational Suffix

The generational suffix of the primary teacher.

Logic first looks to see if the teacher is considered the Primary Teacher (Course > Section > Staff History > Primary Teacher) and reports their generational suffix as of the report generation date OR the last primary teacher for courses that have completed OR the primary teacher assigned to the section at the time of reporting for future courses.


Alpha, 3 characters

Census > People > Demographics > Suffix
Primary Teacher Maiden Last Name

The primary teacher's maiden last name.

Logic looks to see if person has a different last name in a previous identity record and if so, reports this last name.


Alpha, 25 characters

Census > People > Identities > Last Name
Primary Teacher Date of BirthThe primary teacher's date of birth.

Date field, 8 characters YYYYMMDD
Census > People > Demographics > Birth Date
Primary Teacher Gender

Indicates the primary teacher's gender.

  • 1 = Male
  • 2 = Female
  • X = Non Binary

Numeric, 1 digit

Census > People > Demographics > Gender
Primary Teacher Ethnicity

Indicates whether or not the primary teacher is considered Hispanic/Latino.

  • Y = Yes
  • N = No or null

Alphanumeric, 1 character

Census > People > Demographics > Is the Individual Hispanic/Latino?
Primary Teacher Race

The five-digit code indicating the primary teacher's race.

  • 10000 = American Indian/Alaskan Native
  • 02000 = Asian
  • 00300 = Black or African American
  • 00040 = Native Hawaiian or Other Pacific Islander
  • 00005 = White

For example, if a teacher is considered both white and black, they would report a value of 00305.


Numeric, 5 digits

Census > People > Demographics > Race Ethnicity
Filler N/AN/A
Secondary Teacher SATID

The ten-digit State-Assigned Teacher Identification (SATID) assigned in the Unique Teacher Identifier System (UTIS).

Logic looks to see if the teacher has a Role = Co-teacher and then reports their Staff State ID.


Numeric, 10 digits

Census > People > Demographics > Staff State ID 
Secondary Teacher LOCID 

The secondary teacher's locally-assigned identifier.

 Logic looks to see if the teacher has a Role = Co-teacher and then reports their Local Staff Number. 


Numeric, 10 digits

Census > People > Demographics > Local Staff Number
Secondary Teacher Last NameThe last name of the secondary teacher.

Alpha, 25 characters
Census > People > Demographics > Last Name
Secondary Teacher First NameThe first name of the secondary teacher.

Alpha, 15 characters
Census > People > Demographics > First Name
Secondary Teacher Middle NameThe middle name of the secondary teacher.

Alpha, 15 characters
Census > People > Demographics > Middle Name
Secondary Teacher Generational SuffixThe generational suffix of the secondary teacher.

Alpha, 3 characters
Census > People > Demographics > Suffix
Secondary Teacher Maiden Last Name

The secondary teacher's maiden last name.

Logic looks to see if person has a different last name in a previous identity record and if so, reports this last name.


Alpha, 25 characters

Census > People > Identities > Last Name
Secondary Teacher Date of BirthThe secondary teacher's date of birth.

Date field, 8 characters YYYYMMDD
Census > People > Demographics > Birth Date
Secondary Teacher Gender

Indicates the secondary teacher's gender.

  • 1 = Male
  • 2 = Female
  • - Non Binary

Numeric, 1 digit

Census > People > Demographics > Gender
Secondary Teacher- Ethnicity

Indicates whether the secondary teacher is Hispanic or Latino.

  • Y = Yes, of Hispanic/Latino origin
  • N = No, not of Hispanic/Latino origin

Alpha, 1 character  Y or N

Census > People > Demographics > Race Ethnicity > is the individual Hispanic/Latino
Secondary Teacher- Race

The five-digit code indicating the secondary teacher's race.

  • 10000 = American Indian/Alaskan Native
  • 02000 = Asian
  • 00300 = Black or African American
  • 00040 = Native Hawaiian or Other Pacific Islander
  • 00005 = White

For example, if a teacher is considered both white and black, they would report a value of 00305.


Numeric, 5 digits

Census > People > Demographics > Race Ethnicity
Filler N/AN/A