The following extensions are included in the InterchangeStaffAssociationExtension:
StaffExtension (not reported from Aeries for PEIMS)
StaffEducationOrgEmploymentAssociationExtension (not reported from Aeries)
StaffResponsibilitiesExtension
TeacherSectionAssociationExtension
ContractedInstructionalStaffFTEExtension (not reported from Aeries)
PayrollExtension (not reported from Aeries)
Submissions:
(1) = Fall PEIMS (Submission 1)
(4) = Extended PEIMS (Submission 4)
(CR) = Class Roster - Fall & Winter
(ECDS-PK) = TSDS ECDS Prekindergarten
(ECDS-KG) = TSDS ECDS Kindergarten
* Aeries Table.Fields that have an asterisk must be mapped on Texas State Reporting > Code Translations.
NOTE:
- (ECDS-PK) Extracts all teachers and their sections based on schools selected for the extract where at least one PK student (STU.GR = -1) was ever enrolled in that section this school year (based on CAR records), including inactive students.
- (ECDS-KG) Extracts all teachers and their sections based on schools selected for the extract where at least one KG student (STU.GR = 0) was ever enrolled in that section this school year (based on CAR records), including inactive students.
TeacherSchoolAssociation
This extension is only extracted for teachers with the following:
- No existing sections (i.e., 0 records listed under Staff > Master Schedule Classes)
- Role Description on Staff > Job Assignments is 087-Teacher (STJ.JC = 087)
- One or more TIA Designations selected on Staff > Staff Data (STF.TIA)
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(CR) | E1524 | TX-UNIQUE-STAFF-ID | STF.SID | Staff | Unique ID |
<TeacherSchoolAssociation> <TeacherReference> <StaffIdentity> <StaffUniqueStateId>XXXXXXXXXX</StaffUniqueStateId> </StaffIdentity> </TeacherReference> </TeacherSchoolAssociation> XXXXXXXXXX = STF.SID | |||||
Rules (FATAL):
Special Warning:
| |||||
(CR) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<TeacherSchoolAssociation> <SchoolReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </EducationalOrgIdentity> </SchoolReference> </TeacherSchoolAssociation> where:
| |||||
Rule (FATAL):
Special Warnings:
|
Additional Rule:
- 30310-000D: The combination of the following fields must be unique for each TeacherSchoolAssociation: TX-UNIQUE-STAFF-ID and CAMPUS-ID.
StaffExtension ↑
(not reported from Aeries for PEIMS)
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(CR) (ECDS-PK) (ECDS-KG) | Staff id | LOC.SC | School Options | Campus | |
STF.ID | Staff | Staff ID | |||
<Staff id="STF_SSS_CCC"> </Staff> where:
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E1524 | TX-UNIQUE-STAFF-ID | STF.SID | Staff | Unique ID |
<Staff id="STF_SSS_CCC"> <StaffUniqueStateId>UUUUUUUUUU</StaffUniqueStateId> </Staff> where UUUUUUUUUU = STF.SID | |||||
Rules (FATAL):
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E1088 | STAFF-IDENTIFICATION-SYSTEM | "State" | ||
<Staff id="STF_SSS_CCC"> <StaffIdentificationCode IdentificationSystem="State"> <ID>SSSSSSSSS</ID> </StaffIdentificationCode> </Staff> | |||||
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E0505 | STAFF-ID | STF.SS | Staff | Social Security # |
<Staff id="STF_SSS_CCC"> <StaffIdentificationCode IdentificationSystem="State"> <ID>SSSSSSSSS</ID> </StaffIdentificationCode> </Staff> where SSSSSSSSS = STF.SS | |||||
Rules (FATAL):
Special Warning:
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E0703 | FIRST-NAME | STF.FN | Staff | First Name |
<Staff id="STF_SSS_CCC"> <Name> <FirstName>First</FirstName> </Name> </Staff> where First = STF.FN | |||||
Special Warning:
| |||||
(CR) | E0704 | MIDDLE-NAME | STF.MN | Staff | Middle Name |
<Staff id="STF_SSS_NNNNNN"> <Name> <MiddleName>MiddleName</MiddleName> </Name> </Staff> where MiddleName = STF.MN Omitted if blank. | |||||
Special Warning:
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E0705 | LAST-NAME | STF.LN | Staff | Last Name |
<Staff id="STF_SSS_CCC"> <Name> <LastSurname>Last</LastSurname> </Name> </Staff> where Last = STF.LN | |||||
Special Warnings:
| |||||
(CR) | E1303 (DC148) | GENERATION-CODE-SUFFIX | STF.SF | Staff | Suffix |
<Staff id="STF_SSS_NNNNNN"> <Name> <GenerationCodeSuffix>Suffix</GenerationCodeSuffix> </Name> </Staff> where Suffix = STF.SF Full DC148 Code Translation is used rather than code. | |||||
(CR) | E1325 (DC119) | SEX | STF.SX | Staff | Sex |
<Staff id="STF_SSS_NNNNNN"> <Sex>Sex</Sex> </Staff> where Sex = STF.SX Full DC119 Code Translation is used rather than code. | |||||
(CR) | E0006 | DATE-OF-BIRTH | STF.BD | Staff | Birthdate |
<Staff id="STF_SSS_NNNNNN"> <BirthDate>YYYY-MM-DD</BirthDate> </Staff> where YYYY-MM-DD = STF.BD | |||||
Rule (FATAL):
| |||||
(CR) | E1375 | HISPANIC-LATINO-ETHNICITY | STF.EC | Staff | Ethnicity |
<Staff id="STF_SSS_NNNNNN"> <HispanicLatinoEthnicity>true/false</HispanicLatinoEthnicity> </Staff> where true/false =
| |||||
(CR) | E1343 (DC097) | RACIAL-CATEGORY | STF.RC1 - STF.RC5 | Staff | Race-Race5 |
<Staff id="STF_SSS_NNNNNN"> <Race> <RacialCategory>Race</RacialCategory> </Race> </Staff> where Race =
One entry for each race associated with the employee. Full DC097 Code Translation is used rather than code. | |||||
(CR) | E1460 (DC077) | HIGHEST-LEVEL-OF-EDUCATION-COMPLETED | STF.EL | Staff | Education Lvl |
<Staff id="STF_SSS_NNNNNN"> <HighestLevelOfEducationCompleted>Level</HighestLevelOfEducationCompleted> </Staff> where Level = STF.EL Full DC077 Code Translation is used rather than code. | |||||
(CR) | E1377 | YEARS-OF-PRIOR-TEACHING-EXPERIENCE | STF.TYS | Staff | Total Years of Edu Service |
<Staff id="STF_SSS_NNNNNN"> <YearsOfPriorTeachingExperience>NN</YearsOfPriorTeachingExperience > </Staff> where NN = STF.TYS | |||||
(CR) (ECDS-PK) (ECDS-KG) | E0212 | DISTRICT-ID | LOC.CC + LOC.DC | School Options | County + District |
<Staff id="STF_SSS_CCC"> <TX-LEAReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDD</StateOrganizationId> </EducationalOrgIdentity> </TX-LEAReference> </Staff> where
| |||||
(CR) | E1073 (C181) | STAFF-TYPE-CODE | not extracted | ||
not required for TSDS | |||||
(ECDS-PK) | E1581 (C207) | PK-TEACHER-REQUIREMENT | STF.ECC | Staff | Early Childhood Cert |
<Staff id="STF_SSS_NNNNNN"> <TX-PKTeacherRequirement>XX</TX-PKTeacherRequirement> </Staff> where XX = STF.ECC if present; omitted if blank | |||||
Special Warnings:
| |||||
(CR) | E1721 (C088) | CREDITABLE-YEAR-OF-SERVICE-INDICATOR-CODE | STF.TICY | Staff | TIA Cred Yr |
<Staff id="STF_SSS_NNNNNN"> <TX-CreditableYearOfServiceIndicator>0/1</TX-CreditableYearOfServiceIndicator> </Staff> where 0/1 = 1 if STF.TICY = true; otherwise 0 | |||||
Rules (FATAL):
| |||||
(CR) | E1722 (DC165) | TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE | STF.TIA | Staff | TIA Designation |
<Staff id="STF_SSS_NNNNNN"> <TX-TeacherIncentiveAllotmentDesignation> <TX-TeacherIncentiveAllotmentDesignationCode>Code1</TX-TeacherIncentiveAllotmentDesignationCode> <TX-TeacherIncentiveAllotmentDesignationCode>Code2</TX-TeacherIncentiveAllotmentDesignationCode> <TX-TeacherIncentiveAllotmentDesignationCode>Code3</TX-TeacherIncentiveAllotmentDesignationCode> </TX-TeacherIncentiveAllotmentDesignation> </Staff> where Code# = STF.TIA, up to three codes Full DC165 Code Translation is used rather than code. | |||||
Rules (FATAL):
|
Additional Rules:
- (4) Only teachers teaching students in ADSY who have teaching responsibilities (Role IDs 047 and 087) should be reported.
- 10020-0028: For each campus registered with TEA as an active instructional campus (except JJAEPs), there should be data for each teacher.
- 30040-000C: The combination of the following fields must be unique for each staff person: TX-UNIQUE-STAFF-ID and DISTRICT-ID.
- 30040-0002: For each staff person, Teacher Class Assignment (TeacherSectionAssociation) data must be reported with a matching TX-UNIQUE-STAFF-ID.
- 30305-0002: TX-UNIQUE-STAFF-ID for a TeacherSectionAssociation must match TX-UNIQUE-STAFF-ID for a staff person. See Referential Integrity for Class Roster.
- 30040-000C: The combination of the following fields must be unique for each staff person: TX-UNIQUE-STAFF-ID and DISTRICT-ID.
- (CR) 30040-0052: For a staff person being reported for the Class Roster collection, the following must not be blank: STAFF-ID, SEX, DATE-OF-BIRTH, HISPANIC-LATINO-ETHNICITY, HIGHEST-LEVEL-OF-EDUCATION-COMPLETED, YEARS-OF-PRIOR-TEACHING-EXPERIENCE, and at least one RACIAL-CATEGORY.
- (CR-Fall) GR1: Fall Submission: Only LEA-employed or contracted staff serving an LEA as of the last Friday in September who have a ROLE-ID 087 (Teacher) or ROLE-ID 047 (Long-term Substitute Teacher) should be reported.
- (CR-Winter) GR1: Winter Submission: Only LEA-employed or contracted staff serving an LEA as of the last Friday in February who have a ROLE-ID 087 (Teacher) or ROLE-ID 047 (Long-term Substitute Teacher) should be reported.
StaffResponsibilitiesExtension ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(1) (4) | E0212 | DISTRICT-ID | LOC.CC + LOC.DC | School Options | County + District |
<StaffResponsibilitiesExtension> <TX-LEAReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDD</StateOrganizationId> </EducationalOrgIdentity> </TX-LEAReference> </StaffResponsibilitiesExtension> where:
| |||||
(1) (4) | E1524 | TX-UNIQUE-STAFF-ID | STF.SID | Staff | Unique ID |
<StaffResponsibilitiesExtension> <TX-StaffReference> <StaffIdentity> <StaffUniqueStateId>XXXXXXXXXX</StaffUniqueStateId> </StaffIdentity> </TX-StaffReference> </StaffResponsibilitiesExtension> where XXXXXXXXXX = STF.SID | |||||
Rule (FATAL):
Special Warning:
| |||||
(1) (4) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<StaffResponsibilitiesExtension> <TX-SchoolReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </EducationalOrgIdentity> </TX-SchoolReference> </StaffResponsibilitiesExtension> where:
| |||||
Rule (FATAL):
| |||||
(1) (4) | E0721 (C021) | ROLE-ID | STJ.JC | Staff | Role Description |
<StaffResponsibilitiesExtension> <TX-StaffRole>XXX</TX-StaffRole> </StaffResponsibilitiesExtension> where XXX = STJ.JC | |||||
Rules (FATAL):
Special Warnings:
| |||||
(1) (4) | E0724 (C022) | SERVICE-ID | CRS.SVC, or | Courses | Service ID |
STJ.SVC | Staff | ||||
<StaffResponsibilitiesExtension> <TX-ServiceId>XXXXXXXX</TX-ServiceId> </StaffResponsibilitiesExtension> where XXXXXXXX = CRS.SVC or STJ.SVC CRS.SVC = responsibilities related to staff member's sections; STJ.SVC = responsibilities related to a staff member's role | |||||
Rules (FATAL):
| |||||
(1) (4) | E1056 | CLASS-ID-NUMBER | LOC.CD | School Options | Code |
MST.SE | Master Schedule | Section | |||
<StaffResponsibilitiesExtension> <TX-UniqueSectionCode>CCCCCCCCCC_SSSS</TX-UniqueSectionCode> </StaffResponsibilitiesExtension> where:
| |||||
Rules (FATAL):
| |||||
(1) (4) | E0747 (C030) | POPULATION-SERVED-CODE | MST.PSV first (originates from CRS.PSV), or | Master Schedule | Population Served |
STJ.PSV | Staff | ||||
<StaffResponsibilitiesExtension> <TX-PopulationServed>XX</TX-PopulationServed> </StaffResponsibilitiesExtension> where XX = MST.PSV if present; otherwise STJ.PSV | |||||
Rules (FATAL):
Special Warnings:
| |||||
(1) | E0017 (C050) | GRADE-LEVEL-CODE | MST.LO | Master Schedule | Grd Range (low) |
<StaffResponsibilitiesExtension> <TX-GradeLevel>XX</TX-GradeLevel> </StaffResponsibilitiesExtension> where XX = MST.LO | |||||
Rule (FATAL):
| |||||
(1) (4) | E0170 | NUMBER-STUDENTS-IN-CLASS | CAR.SC | Course Attendance | (school) |
CAR.SE | Section | ||||
CAR.CN | Crs ID | ||||
STJ.NOS | Staff > Job Assignments | Number of Students | |||
<StaffResponsibilitiesExtension> <TX-NumberOfStudentsInClass>XXX</TX-NumberOfStudentsInClass> </StaffResponsibilitiesExtension> where XXX = count based on CAR.SC, CAR.SE, and CAR.CN as of the Snapshot date; otherwise STJ.NOS (if by role (staff with no sections) | |||||
Rules (FATAL):
| |||||
(1) (4) | E1015 (C169) | ESC-SSA-STAFF-INDICATOR-CODE | |||
<StaffResponsibilitiesExtension> <TX-SharedServiceArrangementStaffIndicator>XX</TX-SharedServiceArrangementStaffIndicator> </StaffResponsibilitiesExtension> where XX = | |||||
Rules (FATAL):
| |||||
(1) (4) | E1055 (C179) | CLASS-TYPE-CODE | MST.CTY, or | Master Schedule | Class Type |
CRS.CTY, or | Courses | ||||
STJ.IT * | Staff > Job Assignments | Instruction Type | |||
<StaffResponsibilitiesExtension> <TX-ClassTypeCode>XX</TX-ClassTypeCode> </StaffResponsibilitiesExtension> where XX =
| |||||
Rule (FATAL):
| |||||
(4) | E1673 (C088) | ADDITIONAL-DAYS-PROGRAM-TEACHER-INDICATOR-CODE | |||
<StaffResponsibilitiesExtension> <TX-AdditionalDaysProgramTeacherIndicator>0/1</TX-AdditionalDaysProgramTeacherIndicator> </StaffResponsibilitiesExtension> where 0/1 = 1 if ...; otherwise 0 | |||||
Rules (FATAL):
| |||||
(1) | E1057 | MONTHLY-MINUTES | MST.MMN, or | Master Schedule | Monthly Minutes |
STJ.MMN | Staff > Job Assignments | ||||
CRS.SVC | Courses > Other | Service ID | |||
Non-flex: STJ.JC, or | Staff > Job Assignments | Role Description | |||
Non-flex: MST.TN1/MST.TN2/MST.TN3 MST.SR1/MST.SR2/MST.SR3 | Master Schedule | Teacher/Tch#2/ Tch#3, Role | |||
Flex: SSE.SR | Master Schedule - Section Staff Members | Staff Role | |||
<StaffResponsibilitiesExtension> <TX-MonthlyMinutes>XXX</TX-MonthlyMinutes> </StaffResponsibilitiesExtension> where XXX = MST.MMN (if by section) or STJ.MMN (if by role)
| |||||
Rules (FATAL):
Special Warnings:
| |||||
(1) | E1604 | NUMBER-DAYS-TAUGHT-WEEK-1 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberDaysTaughtWeek1>X</TX-NumberDaysTaughtWeek1> </StaffResponsibilitiesExtension> where X = calculated number for 1st week of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1605 | NUMBER-DAYS-TAUGHT-WEEK-2 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberDaysTaughtWeek2>X</TX-NumberDaysTaughtWeek2> </StaffResponsibilitiesExtension> where X = calculated number for 2nd week of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1606 | NUMBER-DAYS-TAUGHT-WEEK-3 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberDaysTaughtWeek3>X</TX-NumberDaysTaughtWeek3> </StaffResponsibilitiesExtension> where X = calculated number for 3rd week of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1607 | NUMBER-DAYS-TAUGHT-WEEK-4 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberDaysTaughtWeek4>X</TX-NumberDaysTaughtWeek4> </StaffResponsibilitiesExtension> where X = calculated number for 4th week of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1608 | NUMBER-MINUTES-TAUGHT-WEEK-1 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberMinutesTaughtWeek1>XXX</TX-NumberMinutesTaughtWeek1> </StaffResponsibilitiesExtension> where XXX = calculated number for 1st week of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1609 | NUMBER-MINUTES-TAUGHT-WEEK-2 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberMinutesTaughtWeek2>XXX</TX-NumberMinutesTaughtWeek2> </StaffResponsibilitiesExtension> where XXX = calculated number for 2nd week of the 4 weeks in October that include the last Friday in October, when CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1610 | NUMBER-MINUTES-TAUGHT-WEEK-3 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberMinutesTaughtWeek3>XXX</TX-NumberMinutesTaughtWeek3> </StaffResponsibilitiesExtension> where XXX = calculated number for 3rd week of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1611 | NUMBER-MINUTES-TAUGHT-WEEK-4 | MST | Master Schedule | Calculated |
BEL | School Options | ||||
BEL, DAY | Calendar | ||||
CRS.PE = 1 | Courses | PE | |||
<StaffResponsibilitiesExtension> <TX-NumberMinutesTaughtWeek4>XXX</TX-NumberMinutesTaughtWeek4> </StaffResponsibilitiesExtension> where XXX = calculated number for 4th week of the 4 weeks in October that include the last Friday in October, only if CRS.PE = 1 | |||||
Rules (FATAL):
Special Warning:
|
Additional Rules:
- (4) Only reported for ROLE-IDs 047 and 087.
- (4) For teachers teaching in the ADSY, the Service ID, Population Served and Number of Students in Class are reported.
- (1) GR1: The StaffResponsibilitiesExtension Complex Type is reported for the four weeks in October that include the PEIMS Fall Snapshot date.
- (1) 30090-0053: The Texas School for the Blind and Visually Impaired (227905), the Texas School for the Deaf (227906), and the Texas Juvenile Justice Department (227622) must not submit staff responsibility data.
- (1) 30090-0013: The last three characters of CAMPUS-ID must not be 699 (summer school).
- (1) 30090-0017: For staff responsibilities with the same CAMPUS-ID, SERVICE-ID, and CLASS-ID-NUMBER, the TX-UNIQUE-STAFF-ID values must be different.
- 30090-000A: For a staff responsibility, the following must be provided: DISTRICT-ID, TX-UNIQUE-STAFF-ID, CAMPUS-ID, ROLE-ID, SERVICE-ID, and POPULATION-SERVED-CODE.
- (1) 10020-0013: For each campus registered with TEA as an active instructional campus, except JJAEPs, there should be data for each staff responsibility.
- (1) 40110-0052: If there is at least one student enrollment on a particular CAMPUS-ID-OF-ENROLLMENT, there should be at least one staff responsibility with a matching CAMPUS-ID and a ROLE-ID of 047 or 087, unless the campus is registered with TEA as a JJAEP.
- (4) 30040-0053: For each reported staff person, there must be at least one staff responsibility reported
(4) 30090-000D: The combination of the following fields must be unique for each staff responsibility: DISTRICT-ID, TX-UNIQUE-STAFF-ID, CAMPUS-ID, ROLE-ID, SERVICE-ID, and CLASS-ID-NUMBER.
TeacherSectionAssociationExtension ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(CR) (ECDS-PK) (ECDS-KG) | E1524 | TX-UNIQUE-STAFF-ID | STF.SID | Staff | Unique ID |
<TeacherSectionAssociation> <TeacherReference> <StaffIdentity> <StaffUniqueStateId>UUUUUUUUUU</StaffUniqueStateId> </StaffIdentity> </TeacherReference> </TeacherSectionAssociation> where UUUUUUUUUU = SID | |||||
Rules (FATAL):
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<TeacherSectionAssociation> <SectionReference> <SectionIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </SectionIdentity> </SectionReference> </TeacherSectionAssociation> where CCC = LOC.CC and DDD = LOC.DC and SSS = LOC.SC | |||||
Special Warning:
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E1056 | CLASS-ID-NUMBER | LOC.CD | School Options | Code |
MST.SE | Master Schedule | Section | |||
<TeacherSectionAssociation> <SectionReference> <SectionIdentity> <UniqueSectionCode>CCCCCCCCCCC_SSSS</UniqueSectionCode> </SectionIdentity> </SectionReference> </TeacherSectionAssociation> where:
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E1454 (CD143) | CLASSROOM-POSITION | Non-flex: MST.TP1 | Master Schedule | Position |
Flex: SSM.TP | Scheduling Master Schedule - Section Staff Members | Position | |||
<TeacherSectionAssociation> <ClassroomPosition>Position</ClassroomPosition> </TeacherSectionAssociation> where Position =
| |||||
Special Warning:
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E1065 | ASSIGNMENT-BEGIN-DATE | CAR.DS | Course Attendance | Start Date |
<TeacherSectionAssociation> <BeginDate>YYYY-MM-DD</BeginDate> </TeacherSectionAssociation> where YYYY-MM-DD = CAR.DS (the first date at least one student was enrolled in the teacher's class) | |||||
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E1066 | ASSIGNMENT-END-DATE | CAR.DE | Course Attendance | Stop Date |
<TeacherSectionAssociation> <EndDate>YYYY-MM-DD</EndDate> </TeacherSectionAssociation> where YYYY-MM-DD = CAR.DE (the last date at least one student was enrolled in the teacher's class) | |||||
| |||||
(CR) (ECDS-PK) (ECDS-KG) | E0948 (C135) | COURSE-SEQUENCE-CODE | CRS.CSQ * | Courses > Other | Crs Seq |
<TeacherSectionAssociation> <TX-CourseSequence>X</TX-CourseSequence> </TeacherSectionAssociation> where X = CRS.CSQ C135 code is used rather than full Code Translation. | |||||
(CR) | E0721 (C021) | ROLE-ID | Non-flex: STJ.JC, or | Staff > Job Assignments | Role Description |
MST.TN1/MST.TN2/MST.TN3 MST.SR1/MST.SR2/MST.SR3 | Master Schedule | Teacher/ Tch#2/ Tch#3, Role | |||
Flex: SSE.SR | Master Schedule - Section Staff Members | Staff Role | |||
<TeacherSectionAssociation> <TX-StaffRole>XXX</TX-StaffRole> </TeacherSectionAssociation> where XXX =
| |||||
Rules (FATAL):
|
Additional Rules:
- 30305-000A/50300-000H: The combination of the following fields must be unique for each TeacherSectionAssociation: TX-UNIQUE-STAFF-ID, CAMPUS-ID, CLASS-ID-NUMBER, COURSE-SEQUENCE-CODE, and ASSIGNMENT-BEGIN-DATE.
- 30040-0002: For each staff person, Teacher Class Assignment (TeacherSectionAssociation) data must be reported with a matching TX-UNIQUE-STAFF-ID.
- 30305-0001: For each TeacherSectionAssociation, there must be a Course SectionExtension with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE.
- 30305-0002: TX-UNIQUE-STAFF-ID for a TeacherSectionAssociation must match TX-UNIQUE-STAFF-ID for a staff person.
- 30305-0024: For a TeacherSectionAssociation being reported for the Class Roster collection, the following must not be blank: CLASSROOM-POSITION, ASSIGNMENT-BEGIN-DATE, and ROLE-ID.
- 30305-0026: For each TeacherSectionAssociation, there should be at least one StudentSectionAssociation with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE. See Referential Integrity for Class Roster.
- 30305-0028: If both TeacherSchoolAssociation and TeacherSectionAssociation data are reported with matching TX-UNIQUE-STAFF-ID but different CAMPUS-ID values, then a special warning message will be displayed asking for verification of this teacher’s assignments.
- 40110-0223: For each StudentSectionAssociation where NON-CAMPUS-BASED-INSTRUCTION-CODE on the corresponding Course SectionExtension is 00, there must be at least one TeacherSectionAssociation with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE.
- (ECDS-KG) GR1: For ECDS-KG, teaching staff (ROLE-IDs 087, 047 and 033) who are providing instruction in course sections for grade level KG should be reported for ECDS. If more than one “Teacher of Record” is assigned to a class during the duration of the class, then all “Teachers of Record” must be reported on the TeacherSectionAssociationExtension complex type.
- (CR) GR1: LEA-employed or contracted teaching staff (ROLE-IDs 087 Teacher 047 Long-term Substitute Teacher) should be reported for the Class Roster Fall Submission and the Class Roster Winter Submission.
- For the Class Roster Fall Submission, report TeacherSectionAssociationExtension for all teachers of courses offered in grades 1-12 as of the last Friday in September.
- For the Class Roster Winter Submission, report TeacherSectionAssociationExtension for all teachers of courses offered in grades EE-12 as of the last Friday in February.
- (CR) 30040-0054: If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is not reported, then Teacher Class Assignment (TeacherSectionAssociation) data must be reported with a matching TX-UNIQUE-STAFF-ID.
- (CR) 30040-0055: If TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE is reported, then there must be a TeacherSchoolAssociation or a TeacherSectionAssociation with a matching TX-UNIQUE-STAFF-ID.