Staff Association Interchange (TSDS) (Texas)

Last Modified on 11/18/2024 10:43 am CST

Tool Search: TSDS Extract

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.

Image of the Staff Association Interchange Report Editor.Staff Association Interchange Report Editor

Report Logic

Click here to expand...

  • 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

FieldDescription
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 TypeXML
Filter By

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

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

PopulationThis 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 FilterSelect 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

Example of the Staff Association Interchange Submission 1 in XML FormatStaff Association Interchange Submission 1 - XML Format

XML Elements

Staff

Example of the Staff extract in XML format.

XML Elements listed below in bold are required. 

XML ElementDescriptionLocation

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 staff member's legal first name.

Submission:

1

KG / PK

CRF / CRW


Alphanumeric, 75 characters		Census > Demographics > Person Information > First Name

Identity.fistName

MiddleName 



The staff member's legal middle name.

Submission:

1

CRF / CRW


Alphanumeric, 75 characters		Census > Demographics > Person Information > Middle Name

Identity.middleName

 LastSurname 

 


The staff member's 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 staff member'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		School & District Settings > District > 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:
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

Example of StaffEducationOrgEmploymentAssociation in XML.

XML ElementDescriptionLocation
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		School & District Settings > District > 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-AuxiliaryRoleIDDoes not report.N/A

StaffResponsibilitiesExtension

Example of StaffResponsibilitiesExtension in XML.

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 ElementDescriptionLocation
TX-LEAReference 

EducationalOrgIdentity >
StateOrganizationId



The State District Number.

Submission:
1

Numeric, 6 digits		School & District Settings > District > District Information > 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  


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

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

AND

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



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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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, 02530004, 02530005, 02530006, 02530007, 02530008, 02850000, 03823000, PES00051, PES00052, PES00053, 
    • Or Service IDs beginning with: 82210XXX , 82931XXX, 83210XXX, 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 ElementDesscriptionLocation
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

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

AND

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


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)

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com