Student Course Grade Teacher (SCGT) Data Collection (Maryland)

Tool Search: 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 the courses, 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.Image of the Maryland SCGT Extract Editor.Maryland SCGT Extract Editor

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 education 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. Reports the State District Number.

Numeric, 2 digits
School & District Settings > District > District Information > State District Number

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 > Special Ed Fields > Providing School


Student Information > General > Enrollment > Home School


School & District Settings > Schools > School Information > State School Number


EnrollmentMD.providingSchool


EnrollmentMD.homeSchool


School.number
SASIDThe student's unique student statewide identifier (SASID).
Reports the Student State ID.

Numeric, 10 digits
Census > People > Demographics > Student State ID

Person.stateID
Local Student ID Number (LASID)The student's locally-assigned student number.


Numeric, 10 digits

Census > People > Demographics > Student Number

Person. studentNumber
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

Identity.lastName
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


Identity.firstName
 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


Identity.middleName
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



Identity.suffix
Preferred NameAn alternative first name preferred by the student.


Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Preferred Name

Identity.alias
Date of BirthThe student's date of birth.


Date field, 8 characters YYYYMMDD

Census > People > Identities > Current Identity > Birth Date

Identity.birthDate
GradeThe student's state grade level based on enrollment record.


Alphanumeric, 2 characters

Student Information > General > Enrollments > Grade

GradeLevel.stateGrade
 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



Identity.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?

Identity.hispanicEthnicity
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

IdentityRaceEthnicity.federalCode
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



IdentityRaceEthnicity.federalCode
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

IdentityRaceEthnicity.federalCode
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

IdentityRaceEthnicity.federalCode
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

IdentityRaceEthnicity.federalCode
Homelessness StatusIndicates whether the student lacks a fixed, regular, and adequate nighttime residence.

Alphanumeric, 1 character (Y or N)
Student Information > General > Enrollments > State Reporting Fields > Homeless

Enrollment.homeless
Title 1 Indicator

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

Free/Reduced Price Meals

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

POSEligibility.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




EnrollmentMD.foreignexchange

Special Education 

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

SEPlan.exitDate
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

  • Most recent IEP has a Special Ed Start Date prior to or equal to the report's Effective Date, AND
  • IEP Closed Date is less than or equal to the report Run Date, AND
  • 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 > Special Ed > Documents > IEP > Sped Certificate


SEPlan.otherAccommodations


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, Identified Date, Program Exit Date

Lep.programStatus


Lep.identifiedDate


Lep.exitDate
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


Identity.dateEnteredUSSchool


Lep.identifiedDate 

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

Lep.identifiedDate
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

Lep.exitDate
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

Census > People > Demographics > Date Entered US School

Identity.dateEnteredUSSchool
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 > Start Date / End Date

FosterCare.startDate


FosterCare.endDate
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


EnrollmentMD.militaryConnected
Status
Filler 1N/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

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.endYear
LEA Course Code

The unique LEA assigned course code that identifies the course.


Numeric, 10 digits


Scheduling > Courses > Course > Number

Course.number
LEA Section NumberThe unique identifier of the reporting course section.


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

Section.sectionID
Section Title

The section title of the reporting course section.




Alphanumeric, 30 characters

Scheduling > Courses > Course Master > Name

Course.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 > Number


Scheduling > Courses > Sections > Section > SectionID


Scheduling > Courses > Sections > Section > Time of Year

Course.number
 

Section.sectionID
 

Section.termType
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.teachingMethod

Course.scedCourseLevel
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
Filler 2

N/A


N/A
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
Filler 3N/AN/A
Filler 4N/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

SectionStaffHistory.role
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 







Person.staffStateID

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




Person.staffNumber
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.


Reports from the Legal Last Name field in the Protected Identity area of Census. If  that field is null, then the name reports from Current Identity > Last Name field in Demographics.


Alpha, 25 characters

Census > People > Identities > Protected Identity Information > Legal Last Name
Census > People > Demographics > Last Name




Identity.lastName
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.

First pull First Name data from the Protected Identity field if populated.


Reports from the Legal First Name field in the Protected Identity area of Census. If  that field is null, then the name reports from Current Identity > First Name field in Demographics.


Alpha, 25 characters

Census > People > Identities > Protected Identity Information > Legal First Name
Census > People > Demographics > First Name




Identity.firstName
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.


Reports from the Legal Middle Name field in the Protected Identity area of Census if the Legal First Name and Legal Last Name are not null. If the Legal First Name and Legal Last Name are null, then the name reports from Current Identity > Middle Name field in Demographics.


Alpha, 25 characters

Census > People > Identities > Protected Identity Information > Legal Middle Name
Census > People > Demographics > Middle Name




Identity.middleName
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.


Reports from the Legal Middle Name field in the Protected Identity area of Census if the Legal First Name and Legal Last Name are not null. If the Legal First Name and Legal Last Name are null, then the suffix reports from Current Identity > Legal Suffix field in Demographics.


Alpha, 3 characters

Census > People > Identities > Protected Identity Information > Legal Suffix
Census > People > Demographics > Suffix




Identity.suffix
Primary Teacher Maiden Last Name

Reports blank.



Primary Teacher Date of BirthThe primary teacher's date of birth.


Date field, 8 characters YYYYMMDD
Census > People > Demographics > Birth Date

Identity.birthDate
Primary Teacher Gender

Indicates the primary teacher's gender.

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

Reports from the Legal Gender field in the Protected Identity area of Census. If that field is null, then the gender reports from Current Identity > Gender field in Demographics.


Numeric, 1 digit

Census > People > Identities > Protected Identity Information > Legal Gender
Census > People > Demographics > Gender

Identity.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?

Identity.hispanicEthnicity
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






IdentityRaceEthnicity.federalCode
Filler 5N/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


Person.staffStateID
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

Person.staffNumber
Secondary Teacher Last NameThe last name of the secondary teacher.
Reports from the Legal Last Name field in the Protected Identity area of Census. If that field is null, then the name reports from Current Identity > Last Name field in Demographics.



Alpha, 25 characters
Census > People > Identities > Protected Identity Information > Legal Last Name
Census > People > Demographics > Last Name

Identity.lastName
Secondary Teacher First NameThe first name of the secondary teacher.
Reports from the Legal First Name field in the Protected Identity area of Census. If  that field is null, then the name reports from Current Identity > First Name field in Demographics.



Alpha, 15 characters
Census > People > Identities > Protected Identity Information > Legal First Name
Census > People > Demographics > First Name

Identity.firstName
Secondary Teacher Middle NameThe middle name of the secondary teacher.
Reports from the Legal Middle Name field in the Protected Identity area of Census if the Legal First Name and Legal Last Name are not null. If the Legal First Name and Legal Last Name are null, then the name reports from Current Identity > Middle Name field in Demographics.

Alpha, 15 characters
Census > People > Identities > Protected Identity Information > Legal Middle Name
Census > People > Demographics > Middle Name

Identity.middleName
Secondary Teacher Generational SuffixThe generational suffix of the secondary teacher.
Reports from the Legal Middle Name field in the Protected Identity area of Census if the Legal First Name and Legal Last Name are not null. If the Legal First Name and Legal Last Name are null, then the suffix reports from Current Identity > Legal Suffix field in Demographics.

Alpha, 3 characters
Census > People > Identities > Protected Identity Information > Legal Suffix
Census > People > Demographics > Suffix

Identity.suffix
Secondary Teacher Maiden Last Name

Reports blank.



Secondary Teacher Date of BirthThe secondary teacher's date of birth.


Date field, 8 characters YYYYMMDD
Census > People > Demographics > Birth Date

Identity.birthDate
Secondary Teacher Gender

Indicates the secondary teacher's gender.

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

Reports from the Legal Gender field in the Protected Identity area of Census. If that field is null, then the gender reports from Current Identity > Gender field in Demographics.


Numeric, 1 digit

Census > People > Identities > Protected Identity Information > Legal Gender
Census > People > Demographics > Gender

Identity.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?

Identity.hispanicEthnicity
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

IdentityRaceEthnicity.federalCode
Filler 6N/AN/A