Staff Association Interchange (TSDS) (Texas)

Last Modified on 10/22/2022 10:38 am CDT

Classic View: TX State Reporting > TSDS Extract > Staff Association Interchange

Search Terms: Staff Association Interchange, Staff Interchange, Association Interchange

The Staff Association Interchange is used to exchange a wide variety of personnel, demographic, employment, assignment, teaching, and attendance information about staff of education organizations.

TSDS Extract Editor/Staff Association Interchange

Report Logic

All staff that meet the outlined population criteria that were active at any time between the first day of the calendar and the Effective Date will report.
If a staff member performs duties on more than one campus, assume more than one role, or perform more than one type of service then multiple records report.
The report includes the Primary AND Secondary Teachers assigned to the same course.
To report, a staff member must have an SSN and an active District Assignment on the Effective Date of the report.
For a Course/Section to report, the course must be active, be scheduled into an instructional period, and have a Service ID in the State Code field.
Multiple records will report for individuals who have responsibilities at more than one school or campus, fulfills multiple roles, or performs more than one type of service. Multiple records will also report if an individual is performing multiple services at the same time in a class.
Records will generate all courses that have Include in Monthly Minutes = Yes and a Teacher of Record. If the period is marked as Non-Instructional and Include in Monthly Minutes = Yes, the course will report. If Include in Monthly Minutes = No, a record is not reported.
Staff Association records that are generating from the 090 section of District Assignment will not report Monthly Minutes when a value exists.
If the Role ID (090 Section of District Assignment) is 002, 007, 015, 016, 017, 018, 021, 026, 032, 033, 036, 047, or 087, a record will only report if all of the following fields are populated in the 090 section of the District Assignment record:
- Role ID
- Non-Teaching Service ID
- Population Served
When reporting records for a District Assignment > 090 record, the following fields will not report if they are blank:
- Unique Section Code
- Number Of Students In Class
- Class Type Code
- Monthly Minutes
When reporting records for a District Assignment > 090 record, if the Number of Students in Class contains only zero(s), report this value for TX-NumberOfStudentsInClass (for example, Number of Students in Class = 000, report 000).
Two different types of staff members report records:
- Teacher or Substitute Teacher- Any staff member who has an active District Assignment on the Effective Date and a Social Security number that is not null. This includes the following values for Title or Role ID (090 Section of District Assignment): 002, 007, 015, 016, 017, 018, 021, 026, 032, 033, 036, 047 and 087.
  Only substitutes replacing a teacher who has died, resigned, been terminated, or is on long term leave for at least 1 semester will report as the Substitute Teacher for a section.
  - If Title Code is 087: Teacher or 047: Substitute Teacher, Staff Member will report a record for each course scheduled during the term that contains the Effective Date. Courses that report must have a value in the State Code (Service ID), students scheduled into the course with start dates within the reporting time frame, and must be scheduled in an instructional period. There may need to be multiple records for one course if the students enrolled in the course have different service IDs. If the End Date for a student scheduled in an active course is in the reporting time frame, the student will not be included in the report.
  - Submission 1 ONLY - If Title Code is 087: Teacher or 047: Substitute Teacher and there is more than one classroom Teacher/Staff Member assigned to the Course as Primary and Secondary Teachers, all teachers assigned will report for each course scheduled during the term that contains the Effective Date.
    - The Staff Member in the leadership role (Role ID of 01: Teacher of Record including District Assignments equal to Teacher or Substitute Teacher) reports all of the students in the class for "Number of Students in Class".
    - The other Staff Member (Role ID of 02: Assistant Teacher and Role ID 03: Support Teacher) assigned to the class will report 000 for Number of students.
    - The Teacher of Record (Role ID of 01: Teacher of Record) that reports the Number of Students may not necessarily be displayed in the 'Primary Teacher' field.
  - If Role ID is 002, 007, 015, 016, 017, 018, 021, 026, 032, 033, 036, 047, including a Role ID of 087: Teacher, this will only be reported if Non-Teaching Service ID, Class ID Number, Monthly Minutes, Class Type Code, Population Served and Number of Students in a Class are not blank in the 090 Section of the District Assignment tab.
  - If a staff member has both a title and a 090 Section Role ID that should report, one record should report for each applicable Title and Role ID.
  - The record key for the teacher group includes District ID, Staff ID, Campus ID, Role ID, Service ID and Class ID number. A new record must be reported any time a value is changed in one of the those fields.
- Non-Teacher - Any staff member who has an active District Assignment and an SSN that is not null. This will report if the Role ID section is not equal to 002, 007, 015, 016, 017, 018, 021, 026, 032, 033, 036, 047 and 087 and values are present in Non-Teaching Service ID and Population Served.
  - The record key for the non-teacher group includes District ID, Staff ID, Campus ID, Role ID and Service ID. A new record must be reported any time a value is changed in one of those fields.
  - Number of Students, Class Type Code and Monthly Minutes will all report as blank.
Reporting is based on a 4 week period. This 4 week period contains the week of the fall snapshot date INCLUDING the last Friday in October plus the 3 weeks preceding and based on all Instructional Days for each class (non-instructional time is excluded as well as the time entered in the Daily Prep Minutes field of the Section Editor screen). This time frame is used in the calculation of the number of Monthly Minutes and the total monthly minutes are reported for each class. If the Course/Section is taught by more than one staff member, Primary and Secondary teacher(s), the Staff Members with a District Assignment of Teacher (087) AND Substitute Teacher (047) will report the Monthly Minutes. A class taught for different amounts of time each week report with a cumulative monthly minute total. If a district employs nine week semesters (accelerated block schedules), the data reports on the current semester only.
Examples
- A class that is taught for 1 hour every day reports 1,200 monthly minutes; 60 minutes (minus the Daily Prep Minutes) x 5 days x 4 weeks; all the days in the 4 week period were instructional days.
- A class taught 1 hour three times each week reports 720 monthly minutes; 60 minutes (minus the Daily Prep Minutes) x 3 days x 4 weeks; all the days in the 4 week period were instructional days.
- Class taught for 90 minutes on a A day of an A/B schedule report 900 minutes; 90 minutes x 10 A days.
- A class taught for different amounts of time each week report a cumulative monthly minute total.
- If a district employs nine week semesters (accelerated block schedules),only the data on the current semester reports.
Courses with the State Report Exclude option selected on the Courses tab (Scheduling > Courses > Course) do NOT report.
Sections do NOT report if ALL enrolled students drop the section before the Snapshot Date. The only exception is if one or more of those students completed the course with a Pass Fail Indicator in a Grading Task with code CG or F prior to the Snapshot Date.

Report Logic - Submission 3 Only

The following logic only applies to Submission 3.

Current State School IDs report as well as the following IDs: 701, 720, 750, and 999.
If the District Assignment chosen in Staff History for the Teacher has a Title Code of 087 OR the Substitute Teacher has a Title Code of 047 AND Role (Class Role) has a value of 01, 02 and/or 03, the Section to which they were assigned starting with the last Friday in October reports. ALL Staff History within the current school year from the last Friday in October through the end of the current school year reports.
Teacher (087) and/or Substitute Teacher (047) must have a valid Unique ID.
A record for each Teaching Assignment that occurs during the current school year and assigned to the section (class) starting with the calendar start date reports as long as there were students enrolled in the course. This means one record reports for each section in which the Teacher or Substitute Teacher is assigned.A record will report for the Primary Teacher of a section only unless a Secondary Teacher on the Course > Section has a District Assignment that is equal to Teacher or Substitute Teacher and a Class Roll equal to 01, 02, or 03. In that scenario, a record reports with all of the teaching history for the Primary Teacher and the Secondary Teacher(s) on the Section as long as the additional teachers have a valid UID and an appropriate District Assignment Title.
- The Course must have a valid State code.
- Each Course > Section may only have one Teacher of Record (Primary Teacher) at a time.
- A Course > Section may have one or more than one Assistant Teacher or Support Teacher.
- Assistant Teachers (Class Role 02) and Support Teachers (Class Role 03) can report. These additional teachers must share the same CLASS ID Number as the Teacher of Record (Class Role 01) for the same sections.
If a teacher has multiple Course > Sections (with a State Code that is not blank) in one period, a record reports for each Course > Section.
If the Role ID in the 090 Section of the District Assignment tab is 047 or 087, a record will report only if ALL the following fields are populated in the tab: Non-Teaching Service ID, Class ID Number, Monthly Minutes, Class Type Code, Population Served and Number of Students in a Class.
Records reporting from Course/Section do not need 090 data in order to report.
Staff members do NOT report if
- there was no Active District Assignment during all or part of the current school year with a Title Code of 087or 047.
- their UID is null.
- the Primary Teacher or Teacher fields on the Staff History do not have a value in District Assignment of Teacher or Substitute Teacher and a Role with a value equal to 01, 02, or 03 on Staff History.
- the Section has more than one Teacher of Record (Role: 01) during the same time segment (start and end dates are equal/overlap).
- no students ever attended the Section to which the Teacher/Substitute Teacher was assigned.
- ALL students enrolled in the Course > Section have a blank/null State ID.
- ALL students enrolled in the Course >Section have an ADA Eligibility equal to 0 (not in membership).
- Calendar is marked Calendar Exclude.
- ALL students enrolled in a Course > Section are State Exclude, Grade Level Exclude or No Show.
- Staff members are linked to a course with a Service-ID on the Course or in Roster Batch Edit equal to SA, SR, SS series 01, 8, or 9 (logically developed courses).

Reporting Logic - Class Roster only

Fall Class Roster ONLY reports calendars, courses, sections, teachers, and students associated with grades 1-12.

Student

Fall: Students in grades 1-12
Winter: Students in grades EE, PK, KG and 1-12

Teacher

Fall ONLY - teachers associated to grades 1-12 report
If Secondary Teacher on the Course > Section has a District Assignment that is equal to Teacher or Substitute Teacher AND a Class Role equal to 01, 02 or 03 report a record for both the Primary Teacher and the Secondary Teacher(s) on the Section.
Teacher must have a Title Code of 047 or 087
Teacher must have a Class Role of 01, 02, or 03
Teacher must have been assigned to a course on the Snapshot Date
If a teacher has multiple course > sections (with a State Code that is not blank) in one period, a record will report for each Course > Section.
Report Primary Teacher only EXCEPT:
- For Manual Teacher Section Records Only: If the Role ID in the 090 Section of the District Assignment tab is 047 or 087, report only if ALL the following fields are populated in the tab: Non-Teaching Service ID, Class ID Number, Monthly Minutes, Class Type Code, Population Served and Number of Students in a Class.

Course/Section

Fall: ONLY Courses/Sections associated to grades 1-12
Winter: Courses/Sections for grades EE, PK, KG and 1-12

Generating Alternate Formats

The Version field on the report editor allows you to generate different formats of the Staff Association Interchange. Options for the Version field include the following:

Staff Responsibilities. (Submission 1 Only) When this option is selected ONLY the Staff Responsibilities Extension complex type of the Staff Association Interchange generates.
Teacher Section. (Submission 3 Only) When this option is selected ONLY the Teacher Section Association Extension complex type of the Staff Association Interchange generates.
All. When this option is selected, the standard Staff Association Interchange generates.

Report Editor

Field

Description

Submission

1 - Fall (Prior/Current Year)

ECDS (Early Childhood Data System)

KG
Pre-K

CR (Classroom Roster)

Classroom Roster Fall (CRF)
Classroom Roster Winter (CRW)

Interchanges

Interchanges are XML Schema Definitions (XSDs) which group related complex types.

Select Staff Association.

Fall Snapshot Date

Submission 1 Only

The last Friday in October.

Last Day of School Start Window

Submission 1 Only

Default value is today's date.

Effective Date

Only data as of this date reports. Default value is today's date.

Version

Submission 3 Only

All - The entire Submission 3 Staff Association report generates.
TeacherSectionAssociation - ONLY the TeacherSectionAssociation complex records generate.

Status

Regular
Resubmission
Working Collection

Report Type

XML

Filter By

This field allows you to narrow the report results to specific Calendars, Calendar Years (District), or Schools.

Option	Description
Calendar	This option allows you to select the specific calendar(s) to include in the report.
District	This option allows you to select the specific Calendar Year to include in the report.
School	This option allows you to select the specific school(s) to include in the report.

Population

This option allows you to limit report results to Unique IDs. The Unique ID option only considers students with a Unique ID. The All option considers all students.

Ad Hoc Filter

Select an Ad Hoc filter to limit report results to those that meet filter requirements.

Report Generation

The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance.

Report Example

Staff Association Interchange Submission 1 - XML Format

XML Elements

Staff

XML Elements listed below in bold are required.

XML Element	Description	Location
StaffUniqueStateId	The unique staff ID. Submission: 1 KG / PK CRF / CRW Numeric, 10 digits	Census > People > Demographics > Staff Unique State ID individual.staffStateID
StaffIdentificationCode
IdentificationSystem	This field always reports State. Submission: 1 KG / PK CRF / CRW Alphanumeric, 5 characters	N/A
ID	The social security number without dashes. Submission: 1 KG / PK CRF / CRW Numeric, 9 digits	Census > People > Person Information > SSN Identity.ssn
Name
FirstName	The student's legal first name. Submission: 1 KG / PK CRF / CRW Alphanumeric, 75 characters	Census > Demographics > Person Information > First Name Identity.fistName
MiddleName	The student's legal middle name. Submission: 1 CRF / CRW Alphanumeric, 75 characters	Census > Demographics > Person Information > Middle Name Identity.middleName
LastSurname	The student's legal last name. Submission: 1 KG / PK CRF / CRW Alphanumeric, 75 characters	Census > Demographics > Person Information > Last Name Identity.lastName
GenerationCodeSuffix	Report suffix Name. If null, do not report. Submission: CRF / CRW Coded, 4 characters	Census > Demographics > Person Information > Suffix identity.suffix
Sex	Report gender Name (Female, Male) Submission: CRF / CRW 6 characters	Census > People > Demographics > Person Information > Sex identity.gender
BirthDate *Optional for CR submission	The student's date of birth. Submission: 1 CRF / CRW Date Field, 10 characters YYYY-MM-DD	Census > People > Demographics > Person Information > Birth Date Identity.birthDate
HispanicLatinoEthnicity	Report 1 if person is marked as Yes in the "Is the individual Hispanic/Latino?", field. Otherwise report 0. Submission: CRF / CRW coded, 1 digit	Census > People > Demographics > Person Information > Race/Ethnicity identity.hispanicEthnicity
Race
RacialCategory	Repeat element and report 1 value for every box checked in Race/Ethnicity Report "American Indian -Alaskan Native" if Race/Ethnicity contains a check in American Indian or Alaskan Native Report "Asian" if Race/Ethnicity contains a check in Asian Report "Black -African American" if Race/Ethnicity contains a check in Black or African American Report "Native Hawaiian -Pacific Islander" if Race/Ethnicity contains a check in Native Hawaiian or Other Pacific Islander Report "White" if Race/Ethnicity contains a check in White Submission: CRF / CRW Coded, 34 characters	Census > People > Demographics > Person Information > Race/Ethnicity RaceEthnicity.code
HighestLevelofEducationCompleted	If 01 report "No Degree" If 02 report "Bachelor's" If 03 report "Master's" If 04 report "Doctorate" If null, do not report Submission: CRF / CRW Namefield, 10 characters	Census > People > District Employment > Education
YearsOfPriorTeachingExperience	Report number of full (completed) years between the Teaching Start Year and the report Effective Date If null, do not report Submission: CRF / CRW Numeric, 2 digits	Census > People > District Employment > Teaching Start Year
TX-LEAReference
EducationalOrgIdentity>StateOrganizationId	The state district number. Submission: 1 KG / PK CRF / CRW Numeric, 6 digits	System Administration > Resources > District Information > State District Number District.districtID
TX-PKTeacherRequirement	Report the code in the Value field for staff members with a Credential of "Other." If null, do not report. Submission: KG / PK	Staff > Credentials > Employment Credential > New Employment Credential Information > Credential Type > Other
TX-GenerationCode	The abbreviation following the student's name; e.g., Sr., Jr., 3rd. Submission: 1 Alphanumeric, 2 characters	Census > Demographics > Person Information > Suffix Identity.suffix
TX-Sex	The student's gender. Submission: 1 Alphanumeric, 2 characters	Census > People > Demographics > Person Information > Gender Identity.gender
TX-HispanicLatinoEthnicity	Reports 1 if the student is Hispanic or Latino. Otherwise, the field reports 0. Submission: 1 Numeric, 1 digit	Census > People > Demographics > Person Information > Race/Ethnicity > Hispanic/Latino Identity.hispanicEthnicity
TX-Race
TX-AmericanIndianAlaskaNative	Reports 1 if the student is American Indian or Alaska Native. Otherwise, the field reports 0. Submission: 1 Numeric, 1 digit	Census > People > Demographics > Person Information > Race/Ethnicity > American Indian or Alaska Native RaceEthnicity.code
TX-Asian	Reports 1 if the student is Asian. Otherwise, the field reports 0. Submission: 1 Numeric, 1 digit	Census > People > Demographics > Person Information > Race/Ethnicity > Asian RaceEthnicity.code
TX-BlackAfricanAmerican	Reports 1 if the student is Black or African American. Otherwise, the field reports 0. Submission: 1 Numeric, 1 digit	Census > People > Demographics > Person Information > Race/Ethnicity > Black or African American RaceEthnicity.code
TX-NativeHawaiianPacificIslander	Reports 1 if the student is Native Hawaiian or Other Pacific Islander. Otherwise, the field reports 0. Submission: 1 Numeric, 1 digit	Census > People > Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander RaceEthnicity.code
TX-White	Reports 1 if the student is White. Otherwise, the field reports 0. Submission: 1 Numeric, 1 digit	Census > People > Demographics > Person Information > Race/Ethnicity > White RaceEthnicity.code
TX-StaffTypeCode *Optional for CR Submission	Indicates whether the staff person is on the district payroll or is a contracted instructional staff person. The following codes report: 1 - School District Or Charter School Employee 2 - Contracted Instructional Staff serving as a Classroom Teacher Submission: 1 CRF/ CRW Alphanumeric, 2 characters	Census > District Employment > Employment Information CustomEmployment.value
TXCreditableYearOfServiceIndicator	Reports 1 if Creditable Year of Service is checked. Otherwise, does not report. If multiple District Assignment records exist within the reporting schools/calendars for the staff member, 1 will report if Creditable Year of Service is checked for the most recent record. Otherwise, do not report. Submission: CRW	Staff > District Assignment > Creditable Year of Service
TX-TeacherIncentiveAllotmentDesignation
TX-TeacherIncentiveAllotmentDesignation Code	If Teacher Incentive Designation contains a value, the name reports. Otherwise, does not report. If a teacher has multiple District Assignment records within the reporting schools/calendars AND more than one unique code exists, each instance will be reported. Submission: CRF/CRW	Staff > District Assignment > Teacher Incentive Designation
TX-HighestDegreeLevel	Indicates the highest level of education achieved by a staff person. If the Education level is not selected on the Employee's District Employment, the default value reports. Submission: 1 Alphanumeric, 2 characters	Census > People > District Employment > Employment Information > Education Employment.educationLevel
TX-YearsExperienceInDistrict	The number of full (completed) years between the Start Date and the report Effective Date. Submission: 1 Numeric, 2 digit	Census > People > District Employment > Employment Information > Start Date
TX-TotalYearsOfProfessionalExperience	The number of full (completed) years between the Teaching Start Year and the report Effective Date Submission: 1 Numeric, 2 digit	Census > People > District Employment > Employment Information > Teaching Start Year
TX-ParaprofessionalCertificationIndicator	Reports 1 if the teacher has a Credential Type of Paraprofessional Certification that is active on the Snapshot Date. Otherwise, do not report. Submission: 1 Coded, 1 digit	Update Staff > Credentials > Credential Type

StaffEducationOrgEmploymentAssociation

XML Element	Description	Location
StaffReference
StaffIdentity > StaffUniqueStateID	A unique number assigned by the state Department of Education. Submission: 1 Numeric, 10 digits	Census > People > Demographics > Staff Unique State ID individual.staffStateID
EducationOrganizationReference
EducationalOrgIdentity > StateOrganizationId	Reports the number assigned by the state to identify a school district. Submission: 1 Numeric, 6 digits	System Administration > Resources > District Information > State District Number District.number
TX-PercentDayEmployed	The Full-time equivalent (FTE) of the employee. Submission: 1 Numeric, 3 digits	Census > District Employment > FTE Percent EmploymentAssignment.fte
TX-NumberDaysEmployed	The number of days the employee is under contract. Submission: 1 Numeric, 3 digits	Census > District Employment > Employment Information > Number Days Employed CustomEmployment.value
TX-AuxiliaryRoleID	Does not report.	N/A

StaffResponsibilitiesExtension

ECDS and Class Roster ONLY: Report Primary Teacher only EXCEPT: If Secondary Teacher on the Course > Section has a District Assignment that is equal to Teacher or Substitute Teacher AND a Class Role equal to 01, 02 or 03. A record for both the Primary Teacher and Secondary Teacher(s) on the Section will report.

XML Element	Description	Location
TX-LEAReference
EducationalOrgIdentity > StateOrganizationId	The State District Number. Submission: 1 Numeric, 6 digits	System Administration > Resources > School > School Detail > State District Number District.number
TX-StaffReference
StaffIdentity > StaffUniqueStateId	A unique number assigned by the state Department of Education. Submission: 1 Numeric, 10 digits	Census > People > Demographics > Staff Unique State ID Database: individual.staffStateID
TX-SchoolReference
EducationalOrgIdentity > StateOrganizationId	Reports the County-District number (6 digits) + State School Number (3 digits) of the campus/school where the employee performs their services. Submission: 1 Numeric, 9 digits	System Administration > Resources > School > School Detail > State School Number AND State District Number Database: School.number District.number
TX-StaffRole	Description of the employee's role in an assignment. Submission: 1 Numeric, 3 digits	Census > People > District Assignment > Title (Role ID) EmploymentAssignment.title AND EmploymentAssignment.titleCode
TX-ServiceId	If the Title is equal to 087: Teacher OR the Title is equal to 047: Substitute Teacher, the State Code from the scheduled Courses reports as the Service ID. If Role ID in the 090 Section of the District Assignment tab is equal to the remainder of the Teacher Codes: 002, 007, 015, 016, 017, 018, 021, 026, 032, 033, 036 or 047 AND 087, OR the non-teacher Role ID's, the Non Teaching Service ID code from the 090 Section in the District Assignment tab reports as the Service ID. Courses with a blank State Code (Service ID) do not report. Submission: 1 Numeric, 8 digits	Course Section > Course > State Code OR Census > People > District Assignment > Non-Teaching Service ID Course.stateCode
TX-UniqueSectionCode	If the Title is equal to 087: Teacher OR the Title is equal to 047: Substitute Teacher, the last 14 digits of the SectionID report. If Role ID in the 090 Section of the District Assignment tab is equal to the remainder of the Teacher Codes: 002, 007, 015, 016, 017, 018, 021, 026, 032, 033, 036, the value from the Class ID Number in the 090 Section reports. This field reports blank for non-teacher role IDs. Submission: 1 Alphanumeric, 14 characters	Census > People > District Assignment > 090 Section AND Scheduling> Course> Course Editor> SectionID Section.sectionID
TX-PopulationServed	Identifies the student population for which a service has been designed or is intended. If the Title is equal to 087: Teacher OR the Title is equal to 047: Substitute Teacher, the reported value comes from the Population Served on the Course. 01 reports if the Population Served is null for the Section AND the Course. If the Role ID in the 090 Section of the District Assignment tab is anything other than 087: Teacher, the reported value comes from the Population Served on the District Assignment tab. The following codes report: 01 Regular Students 02 Bilingual Students 03 Compensatory/Remedial Education Students 04 Gifted & Talented Students 05 Career and Technology Students 06 Special Education Students 07 ESL Students 08 Adult Basic Education Students 09 Honors Students 10 Migrant Students Submission: 1 Alphanumeric, 2 characters	Course/Section> Course/Section> Section Editor> Population Served OR Staff ID > Census > People > District Assignment > Population Served Section.populationServed
TX-GradeLevel	Reports the Grade Level if staff record is reporting from the 090 Record area. If blank, nothing reports. Submission: 1 Coded, 2 digits	Census > District Assignments > 090 Record
TX-NumberOfStudentsInClass	Indicates the number of students in membership in the class as of the reporting date. Count is based on total number of active students enrolled in the section. For Title of 087 or 047, reports the number of students with each unique Service ID actively enrolled on the Effective Date. If the class has more than one teacher, reports this value based on the teacher selected as Teacher of Record. All other teachers report as 000. If the Role ID field is populated in the 090 section, reports the value entered in that section, unless the Role ID is 033 or 036, in which case this field reports as 000. For all other 090 Section Role ID's (Non Teacher group 2), this field reports blank. If the Number of Students contains only zero(s), this field will report this value (e.g, Number of Students = 000, then a value of 000 is reported. Submission: 1 Alphanumeric, 3 characters	Scheduling > Courses > Section Roster; Census > People > District Assignment > 090 Record > Number of Students
TX-SharedService ArrangementStaffIndicator	This field reports blank. Submission: 1	N/A
TX-ClassTypeCode	Identifies the type of class providing instruction to students in particular class settings. This is used to differentiate classes providing instruction in a regular setting classroom for non-regular classrooms. Reports a value of 02 if the Title is 087 or 047 and the Course or Section Instructional Setting is populated. Reports the value entered for Class Type Code for all other teacher Role IDs selected in the 090 section. If Null, reports as 01. Submission: 1 Alphanumeric, 2 characters	Census > People > District Assignment > 090 Section > Class Type Code customStaffemploymentAssignment .classtype
TX-MonthlyMinutes	Total number of minutes in a month devoted to a particular class. A month is defined as 4 weeks prior to the as-of date. Reports as a whole number. Monthly Minutes Logic For a teacher Title of 087 or 047, Monthly Minutes is calculated using Period Start and End Times, Lunch Minutes, Daily Prep Minutes from the Section editor and the schedule placement of the course during the week that contains the Effective Date and the three previous weeks. Day Minutes are determined by adding the number of Period Minutes minus Lunch and Daily Prep Minutes. That value is multiplied by the number of days for which the course is scheduled during a week, excluding Non-Instructional Days and Periods. If more than one Teacher and/or Substitute Teacher is assigned to the course section, Monthly Minutes will report only for the Teacher or Record (Role 01). For Role IDs 002, 007, 008, 015, 016, 017, 018, 021, 026, 032, 033, 036 or 047, reports the value from Monthly Minutes from the 090 section of District Assignment. The Non-Teacher Role IDs will report only the Non-Teaching Service ID and Population Served from the 090 Section. The remainder of fields report as blank. Course/Section records only report Monthly Minutes when the Include in Monthly Minutes field on the Course is selected. Submission: 1	Census > People > District Assignment > 090 Section > Monthly Minutes customStaffemploymentAssignment .minutes
TX-NumberDaysTaughtWeek1	The number of days that the course was scheduled during the 1st week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 7 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)
TX-NumberDaysTaughtWeek2	The number of days that the course was scheduled during the 2nd week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 7 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)
TX-NumberDaysTaughtWeek3	The number of days that the course was scheduled during the 3rd week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 7 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)
TX-NumberDaysTaughtWeek4	The number of days that the course was scheduled during the 4th week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 7 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)
TX-NumberMinutesTaughtWeek1	The number of minutes that the course was scheduled during the 1st week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 3000 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)
TX-NumberMinutesTaughtWeek2	The number of minutes that the course was scheduled during the 2nd week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 3000 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)
TX-NumberMinutesTaughtWeek3	The number of minutes that the course was scheduled during the 3rd week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 3000 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)
TX-NumberMinutesTaughtWeek4	The number of minutes that the course was scheduled during the 4th week of the 4 week reporting period. The reporting period equals the week containing the Snapshot Date plus 3 weeks previous. Only days marked as Instructional or marked with a Waiver Event Type of 01/02/04/99 are counted. Only the Teacher of Record on the course reports Only the following Service IDs (State Code) report: 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055 Or Service IDs beginning with: 82200XXX, 82930XXX, 83200XXX, 84200XXX For every unique instance of a Service ID Override and teacher combination, logic will count one single instance of that course (e.g., if 4 students have the same override code and the same teacher, that will count as 1 course for the teacher, in addition to the original course taught by the teacher. if it applies). Submission: 1 Numeric, 3000 digits	Course/Section > Section Schedule Placement AND System Administration > Calendar > Period AND System Administration > Calendar > Calendar > Days > Day Detail > Instruction AND System Admin > Calendar > Calendar > Days > Event Type (01, 02, 03, 04, or 99)

TeacherSectionAssociation

XML Element	Desscription	Location
TeacherReference
StaffUniqueStateId	A unique number assigned by the state Department of Education. Submission: KG / PK CRF / CRW Numeric, 10 digits	Census > People > Demographics > Unique State ID
SectionReference > Section Identity
StateOrganizationID	The State District Number. Submission: KG / PK CRF / CRW Coded, 9 digits	System Administration > Resources > School > School Detail > State School Number AND AND State District Number-Core
UniqueSectionCode	If the Title is equal to 087: Teacher OR the Title is equal to 047: Substitute Teacher, the last 14 digits of the SectionID report. If Role ID in the 090 Section of the District Assignment tab is equal to the remainder of the Teacher Codes: 002, 007, 008, 015, 016, 017, 018, 021, 026, 032, 033, 036, 047, 087 the value from the Class ID Number in the 090 Section reports. This field reports blank for non-teacher role IDs. Submission: KG / PK CRF / CRW Namefield, 14 characters	Census > People > District Assignment > 090 Section AND Scheduling> Course> Course Editor> SectionID
ClassroomPostion	Report name from Role. Submission: KG / PK CRF / CRW Coded	Course/Section > Section > Staff History > Role
BeginDate	Reports the Assignment Begin Date if the course > section is active as of the last Friday in October. If the Start Date in Staff History is equal to null/blank, report the first day of the term the section (class) is scheduled in. If the Start Date in Staff History is populated, report that date. Report ALL Start Dates for ALL Staff Members linked to the section (class). Submission: KG / PK CRF / CRW yyyy-mm-dd, 10 digits	Course/Section > Section > Staff History > Start Date OR System Admin> Calendar> Terms> Term Detail> Start Date
EndDate	Reports the Assignment End Date if the course > section is active as of the last Friday in October. If the End Date in Staff History is equal to null/blank, report the last day of the term the section (class) is scheduled in. If the End Date in Staff History is populated, report that date. Report ALL End Dates for ALL Staff Members linked to the section (class). Submission: KG / PK CRF / CRW yyyy-mm-dd, 10 digits	Course/Section > Section > Staff History > End Date OR System Admin> Calendar> Terms> Term Detail> End Date
TX-CourseSequence	Reports value from Course Sequence. If no value, report blank. Submission: KG / PK CRF / CRW Coded, 2 digits	Course/Section > Course > Course Sequence
TX-StaffRole	1. If the following values are present in the ‘Title’ (District Assignment) or ‘Role ID’(090 section of District Assignment) fields report: values equal to 047 and 087 (Role ID list will populate Title). 2. If the Role ID (090 Section of District Assignment) is 047 or 087, report only if Non-Teaching Service ID, Class ID Number, Monthly Minutes, Class Type Code, Population Served and Number of Students in a Class are not blank in the 090 Section of Dist Assignment tab. 3. A Teacher, Role ID of 087, AND a Substitute Teacher, Role ID of 047, can be reported when manually built in the 090 Section of District Assignment. A teacher OR Substitute teacher to report from the 090 Section does not need an Active Course or students enrolled in the course to report. It needs the required fields completed, see above, to report. 4. On the District Assignment screen, the Title field can have Teacher displayed AND Substitute Teacher displayed, with active courses and students enrolled into the courses, AND a 090 Section completed with a Role ID of 087 OR 047. This would report two 087 Role IDs OR two 047 Role IDs on the extract. Submission: CRF / CRW Coded, 3 digits	Census > People > District Assignment > Title (Role ID)

Was this helpful?