This table lists the impact of staff rollover data for End of Year process.
|
Resource Name |
Table |
Column |
DEX Element/Selection Rule |
Impacted by EOY |
Date/School Year Based Filters |
Impact with parallel multiple School Years |
Comments |
|---|---|---|---|---|---|---|---|
|
staffs |
USERS |
SIF_STATEPRID |
staffs selection rule |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_USR_X |
EXCLUDEFROMEDFI |
staffs selection rule |
No |
No |
Impacted |
Students Excluded after rollover will also impact previous year submissions |
|
staffs |
S_TX_USR_FIN_C |
PERCENT_DAY_EMPLOYED |
|
No |
Yes |
No Impact |
None |
|
staffs |
S_TX_USR_FIN_C |
NUMBER_DAYS_EMPLOYED |
|
No |
Yes |
No Impact |
None |
|
staffs |
S_TX_USR_FIN_C |
YEARID |
|
No |
Yes |
No Impact |
None |
|
staffs |
S_TX_USR_FIN_C |
RECORD_TYPE |
|
No |
Yes |
No Impact |
None |
|
staffs |
S_TX_USR_RESP_C |
E0721_ROLE_ID |
|
No |
Yes |
No Impact |
None |
|
staffs |
S_TX_USR_RESP_C |
E0724_SERVICE_ID |
|
No |
Yes |
No Impact |
None |
|
staffs |
S_TX_USR_RESP_C |
SCHOOLID |
|
No |
Yes |
No Impact |
None |
|
staffs |
SCHOOLSTAFF |
SCHOOLID |
staffs selection rule |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
SECTIONTEACHER |
TEACHERID |
|
No |
No |
No Impact |
None |
|
staffs |
SECTIONTEACHER |
ROLEID |
|
No |
No |
No Impact |
None |
|
staffs |
S_TX_SEC_X |
EXCLUDE_FROM_090 |
staffs selection rule |
No |
No |
Impacted |
If excluded from sections then that section will not report for the school year |
|
staffs |
S_TX_STU_STATE_GEN_C |
E0787_ADA_CODE |
staffs selection rule |
Yes |
No |
Impacted |
Student Identifying Information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_STU_STATE_GEN_C |
ENTER_DATE |
staffs selection rule |
Yes |
No |
Impacted |
ENTER_DATE between FirstYearDay and LastYearDay |
|
staffs |
S_TX_CRS_X |
EXCLUDE_FROM_090 |
staffs selection rule |
No |
No |
Impacted |
If excluded from courses then that course will not report for the school year |
|
staffs |
S_USR_X |
HIGHLYQUALIFIEDTEACHER |
HighlyQualifiedTeacher |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
USERS |
FEDETHNICITY |
HispanicLatinoEthnicity |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E0730_HIGHEST_DEGREE |
LevelOfEducation |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E0130_TOTAL_YEARS_EXP |
YearsPriorProfessional |
Yes |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E1377_YRS_PRIOR_TEACH_EXP |
YearsPriorTeaching |
Yes |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E1670_PARAPROF_CERT_IND |
ParaprofessionalCertification |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E1721_CREDIT_YEAR_SVC_IND |
CreditableYear |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E0161_YEARS_EXP_IN_DIST |
YearsExperienceDistrict |
Yes |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E1073_STAFF_TYPE_CODE |
StaffType |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E1581_PK_TEACHER_REQ |
PKTeacherRequirement |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
TEACHERRACE |
RACECD |
staffs selection rule |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffs |
S_TX_USR_X |
E1722_TCH_INC_ALLOT |
staffs selection rule |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSchoolAssociations |
USERS |
SIF_STATEPRID |
staffSchoolAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSchoolAssociations |
SCHOOLSTAFF |
SCHOOLID |
staffSchoolAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSchoolAssociations |
S_USR_X |
EXCLUDEFROMEDFI |
staffSchoolAssociations |
No |
No |
Impacted |
Students marked Exclude from EdFi in the new School Year will be excluded from pubishing for previous School Years as well |
|
staffSchoolAssociations |
S_TX_USR_X |
E1722_TCH_INC_ALLOT |
staffSchoolAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSchoolAssociations |
S_TX_USR_X |
E1721_CREDIT_YEAR_SVC_IND |
staffSchoolAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSchoolAssociations |
SECTIONTEACHER |
SECTIONID |
|
No |
No |
No Impact |
None |
|
staffSchoolAssociations |
SECTIONTEACHER |
TEACHERID |
|
No |
No |
No Impact |
None |
|
staffSchoolAssociations |
SECTIONS |
ID |
|
No |
No |
No Impact |
None |
|
staffSchoolAssociations |
SECTIONS |
SCHOOLID |
|
No |
No |
No Impact |
None |
|
staffSchoolAssociations |
TERMS |
ID |
|
No |
Yes |
No Impact |
None |
|
staffSchoolAssociations |
TERMS |
SCHOOLID |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
E0721_ROLE_ID |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
YEARID |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
SCHOOLID |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
E0724_SERVICE_ID |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationAssignmentAssociations |
USERS |
SIF_STATEPRID |
staffEducationOrganizationAssignmentAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffEducationOrganizationAssignmentAssociations |
USERS |
TITLE |
staffEducationOrganizationAssignmentAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffEducationOrganizationAssignmentAssociations |
USERS |
TEACHERNUMBER |
staffEducationOrganizationAssignmentAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
E0724_SERVICE_ID |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
E0747_POPULATION_SERVED |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
E0170_NUMBER_STUDENTS |
|
No |
Yes |
No Impact |
when ur.E0170_NUMBER_STUDENTS between 0 and 999 then ur.E0170_NUMBER_STUDENTS |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
E1057_MONTHLY_MINUTES |
|
No |
Yes |
No Impact |
when ur.E1057_MONTHLY_MINUTES between 1 and 12000 then ur.E1057_MONTHLY_MINUTES |
|
staffEducationOrganizationAssignmentAssociations |
S_TX_USR_RESP_C |
E0017_GRADE_LEVEL_CODE |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_USR_FIN_C |
PERCENT_DAY_EMPLOYED |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_USR_FIN_C |
NUMBER_DAYS_EMPLOYED |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_USR_FIN_C |
YEARID |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_USR_FIN_C |
RECORD_TYPE |
|
No |
Yes |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
USERS |
SIF_STATEPRID |
staffEducationOrganizationEmploymentAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffEducationOrganizationEmploymentAssociations |
S_USR_X |
EXCLUDEFROMEDFI |
staffEducationOrganizationEmploymentAssociations |
No |
No |
Impacted |
Students marked Exclude from EdFi in the new School Year will be excluded from pubishing for previous School Years as well |
|
staffEducationOrganizationEmploymentAssociations |
SCHOOLSTAFF |
SCHOOLID |
staffEducationOrganizationEmploymentAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffEducationOrganizationEmploymentAssociations |
SECTIONTEACHER |
ROLEID |
|
No |
No |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
SECTIONS |
ID |
|
No |
No |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
SECTIONS |
SCHOOLID |
|
No |
No |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
SECTIONS |
TEACHER |
|
No |
No |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_SEC_X |
EXCLUDE_FROM_090 |
staffEducationOrganizationEmploymentAssociations |
No |
No |
Impacted |
If excluded from sections then that section will not report for the school year |
|
staffEducationOrganizationEmploymentAssociations |
CC |
SECTIONID |
|
No |
No |
No Impact |
|
|
staffEducationOrganizationEmploymentAssociations |
S_STU_X |
EXCLUDEFROMEDFI |
staffEducationOrganizationEmploymentAssociations |
No |
No |
Impacted |
Students marked Exclude from EdFi in the new School Year will be excluded from pubishing for previous School Years as well |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_STU_STATE_GEN_C |
E0787_ADA_CODE |
staffEducationOrganizationEmploymentAssociations |
Yes |
No |
Impacted |
Student Identifying Information if modified after rollover, will impact the previous year submission as well |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_STU_STATE_GEN_C |
ENTER_DATE |
staffEducationOrganizationEmploymentAssociations |
Yes |
No |
Impacted |
ENTER_DATE between FirstYearDay and LastYearDay |
|
staffEducationOrganizationEmploymentAssociations |
COURSES |
COURSE_NUMBER |
|
No |
No |
No Impact |
None |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_CRS_X |
EXCLUDE_FROM_090 |
|
No |
No |
No Impact |
If excluded from courses then that course will not report for the school year |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_USR_X |
E1722_TCH_INC_ALLOT |
staffEducationOrganizationEmploymentAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffEducationOrganizationEmploymentAssociations |
S_TX_USR_X |
E1721_CREDIT_YEAR_SVC_IND |
staffEducationOrganizationEmploymentAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSectionAssociations |
SECTIONS |
SECTION_NUMBER |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONS |
COURSE_NUMBER |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONS |
SCHOOLID |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONS |
TEACHER |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONTEACHER |
SECTIONID |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONTEACHER |
TEACHERID |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONTEACHER |
ROLEID |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONTEACHER |
START_DATE |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
SECTIONTEACHER |
END_DATE |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
SCHOOLSTAFF |
SCHOOLID |
staffSectionAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSectionAssociations |
SCHOOLSTAFF |
TEACHERID |
staffSectionAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSectionAssociations |
USERS |
TEACHERNUMBER |
staffSectionAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
YEARID |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
SCHOOLID |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
SECTIONID |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E0721_ROLE_ID |
|
No |
Yes |
No Impact |
E0721_ROLE_ID not in 033,036 if the E0721_ROLE_ID is 033 then CourseCode = '01010000' |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E0724_SERVICE_ID |
|
No |
Yes |
No Impact |
E0724_SERVICE_ID not in SA,SE,SR,SS |
|
staffSectionAssociations |
SECTIONTEACHER |
TEACHERID |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
SECTIONTEACHER |
SECTIONID |
|
No |
No |
No Impact |
None |
|
staffSectionAssociations |
USERS |
SIF_STATEPRID |
staffSectionAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSectionAssociations |
USERS |
TEACHERNUMBER |
staffSectionAssociations |
No |
No |
Impacted |
staff information if modified after rollover, will impact the previous year submission as well |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1673_ADSY_TEACHER_IND |
|
No |
Yes |
No Impact |
|
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1057_MONTHLY_MINUTES |
|
No |
Yes |
No Impact |
when ur.E1057_MONTHLY_MINUTES between 1 and 12000 then ur.E1057_MONTHLY_MINUTES |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1604_DAYS_TAUGHT_WEEK_1 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1605_DAYS_TAUGHT_WEEK_2 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1606_DAYS_TAUGHT_WEEK_3 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1607_DAYS_TAUGHT_WEEK_4 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1608_MINUTES_TAUGHT_WEEK_1 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1609_MINUTES_TAUGHT_WEEK_2 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1610_MINUTES_TAUGHT_WEEK_3 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E0170_NUMBER_STUDENTS |
|
No |
Yes |
No Impact |
when ur.E0170_NUMBER_STUDENTS between 0 and 999 then ur.E0170_NUMBER_STUDENTS |
|
staffSectionAssociations |
S_TX_USR_RESP_C |
E1611_MINUTES_TAUGHT_WEEK_4 |
|
No |
Yes |
No Impact |
None |
|
staffSectionAssociations |
S_USR_X |
EXCLUDEFROMEDFI |
staffSectionAssociations |
No |
No |
Impacted |
Students marked Exclude from EdFi in the new School Year will be excluded from pubishing for previous School Years as well |
|
contractedInstructionalStaffFTEExts |
S_TX_DISTRICT_FIN_S |
RECORD_TYPE |
|
No |
Yes |
No Impact |
None |
|
contractedInstructionalStaffFTEExts |
S_TX_DISTRICT_FIN_S |
YEARID |
|
No |
Yes |
No Impact |
None |
|
contractedInstructionalStaffFTEExts |
S_TX_DISTRICT_FIN_S |
ORGANIZATION_CODE |
|
No |
Yes |
No Impact |
None |
|
contractedInstructionalStaffFTEExts |
S_TX_DISTRICT_FIN_S |
PROGRAM_INTENT_CODE |
|
No |
Yes |
No Impact |
None |
|
contractedInstructionalStaffFTEExts |
S_TX_DISTRICT_FIN_S |
TOTAL_CONTRACT_INST_STAFF_FTE |
|
No |
Yes |
No Impact |
None |