This table lists the impact of org rollover data for End of Year process.
|
Resource Name |
Table Name |
Column Name |
DEX Element/Selection Rule |
Impacted by EOY |
Date/School Year Based Filters |
Impact with parallel multiple School Years |
Comments |
|---|---|---|---|---|---|---|---|
|
localEducationAgencies |
PREFS |
VALUE |
selection rule |
No |
No |
Impacted |
If modified after rollover, will have an impact on the previous year submission as well |
|
localEducationAgencies |
PREFS |
NAME |
selection rule |
No |
No |
Impacted |
If modified after rollover will have an impact on the previous year submission as well |
|
localEducationAgencies |
S_TX_DISTRICT_GTPROGRAMS_S |
EFFECTIVE_DATE |
|
No |
Yes |
No Impact |
None |
|
localEducationAgencies |
S_TX_DISTRICT_GTPROGRAMS_S |
E1645_GT_PROGRAM_CODES |
|
No |
Yes |
No Impact |
None |
|
localEducationAgencies |
S_TX_CTEPROGRAMS_S |
SCHOOL_YEAR |
|
No |
Yes |
No Impact |
None |
|
localEducationAgencies |
S_TX_CTEPROGRAMS_S |
CTE_PROGRAMS |
|
No |
Yes |
No Impact |
None |
|
schools |
SCHOOLS |
SCHOOL_NUMBER |
|
No |
Yes |
No Impact |
None |
|
schools |
SCHOOLS |
LOW_GRADE |
|
No |
Yes |
No Impact |
None |
|
schools |
SCHOOLS |
HIGH_GRADE |
|
No |
Yes |
No Impact |
None |
|
schools |
SCHOOLS |
STATE_EXCLUDEFROMREPORTING |
selection rule |
No |
No |
Impacted |
If the school is exclude from reporting then same school will not be reportable for next school years as well |
|
schools |
SCHOOLS |
NAME |
NameOfInstitution |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
ABBREVIATION |
ShortNameOfInstitution |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOLADDRESS |
StreetNumberName |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOLCITY |
City |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOLSTATE |
stateAbbreviationDescriptor |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOLZIP |
PostalCode |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOLPHONE |
telephoneNumber |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOLFAX |
telephoneNumber |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
ALTERNATE_SCHOOL_NUMBER |
identificationCode |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
S_TX_SCH_SCHOOLS_X |
PRIMARYSCHOOLRECORD |
selection rule |
No |
No |
Impacted |
Primary School Setup changed after rollover will also affect the previous year submission |
|
schools |
STUDENTS |
min_grade |
selection rule |
No |
No |
Impacted |
Student Identifying Information if modified after rollover, will impact the previous year submission as well |
|
schools |
STUDENTS |
max_grade |
selection rule |
No |
No |
Impacted |
Student Identifying Information if modified after rollover, will impact the previous year submission as well |
|
schools |
STUDENTS |
STATE_EXCLUDEFROMREPORTING |
selection rule |
No |
No |
Impacted |
Students marked Exclude from Reporting in the new School Year will be excluded from pubishing for previous School Years as well |
|
schools |
STUDENTS |
ENTRYDATE |
selection rule |
No |
No |
Impacted |
Student Identifying Information if modified after rollover, will impact the previous year submission as well |
|
schools |
STUDENTS |
EXITDATE |
selection rule |
No |
No |
Impacted |
Student Identifying Information if modified after rollover, will impact the previous year submission as well |
|
schools |
STUDENTS |
ADA_ELIGIBILITY |
selection rule |
No |
No |
Impacted |
Student Identifying Information if modified after rollover, will impact the previous year submission as well |
|
schools |
SECTIONS |
TERMID |
|
No |
Yes |
No Impact |
|
|
schools |
SECTIONS |
SCHOOLID |
|
No |
Yes |
No Impact |
|
|
schools |
TERMS |
YEARID |
|
Yes |
Yes |
No Impact |
|
|
schools |
TERMS |
SCHOOLID |
|
Yes |
Yes |
No Impact |
|
|
schools |
S_TX_STU_SCHOOL_ENR_C |
SCHOOLID |
|
No |
Yes |
No Impact |
|
|
schools |
S_TX_STU_SCHOOL_ENR_C |
YEARID |
|
No |
Yes |
No Impact |
|
|
schools |
S_TX_STU_SCHOOL_ENR_C |
ENTRYDATE |
|
No |
Yes |
No Impact |
|
|
schools |
S_TX_STU_SCHOOL_ENR_C |
EXITDATE |
|
No |
Yes |
No Impact |
|
|
schools |
S_TX_STU_SCHOOL_ENR_C |
ADA_ELIGIBILITY |
|
No |
Yes |
No Impact |
|
|
schools |
S_STU_X |
EXCLUDEFROMEDFI |
selection rule |
No |
No |
Impacted |
Students marked Exclude from EDFI in the new School Year will be excluded from pubishing for previous School Years as well |
|
schools |
S_TX_SCH_SCHOOLS_X |
CSW_PLACEHOLDER |
selection rule |
No |
No |
Impacted |
School marked for ChildFind in the School year will impact when Student not marked for same school as a ChildFind |
|
schools |
S_TX_STU_CHARTER_WAITLIST_C |
WAITLIST_CAMPUS_ID |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_STU_CHARTER_WAITLIST_C |
WAITLIST_EFFECTIVE_DATE |
|
No |
Yes |
No Impact |
None |
|
schools |
CALENDAR_DAY |
cd.DATE_VALUE |
|
No |
Yes |
No Impact |
None |
|
schools |
CALENDAR_DAY |
cd.SCHOOLID |
|
No |
Yes |
No Impact |
None |
|
schools |
SCHOOLS |
SCHOOL_NUMBER |
selection rule |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
LOW_GRADE |
selection rule |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
HIGH_GRADE |
selection rule |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOL_NUMBER |
selection rule |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOL_YEAR |
selection rule |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
SCHOOLS |
SCHOOL_NUMBER |
selection rule |
No |
No |
Impacted |
The school info when modified after roll-over will have an impact on previous year submissions. |
|
schools |
S_TX_SCH_ELO_C |
SCHOOL_YEAR |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1614_ELO_TYPE |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1621_ELO_RIGCOURSE_MIN |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1720_ELO_RIGCOURSE_DAYS |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1621_ELO_MENTOR_MIN |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1720_ELO_MENTOR_DAYS |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1621_ELO_TUTOR_MIN |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1720_ELO_TUTOR_DAYS |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1621_ELO_PHYSACT_MIN |
|
No |
Yes |
No Impact |
|
|
schools |
S_TX_SCH_ELO_C |
E1720_ELO_PHYSACT_DAYS |
|
No |
Yes |
No Impact |
|
|
schools |
S_TX_SCH_ELO_C |
E1621_ELO_ACADSUPP_MIN |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1720_ELO_ACADSUPP_DAYS |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1621_ELO_EDENRICH_MIN |
|
No |
Yes |
No Impact |
None |
|
schools |
S_TX_SCH_ELO_C |
E1720_ELO_EDENRICH_DAYS |
|
No |
Yes |
No Impact |
None |
|
ssaOrgAssociationExts |
S_TX_DISTRICT_SHARED_SERV_S |
E0777_FISCAL_AGENT |
fiscalAgentDistrictId |
No |
No |
Impacted |
Shared services when modified after rollover will have an impact on the previous year submissions. |
|
ssaOrgAssociationExts |
S_TX_DISTRICT_SHARED_SERV_S |
E0776_SHARED_SERVICE |
SSATypeDescriptor |
No |
No |
Impacted |
Shared services when modified after rollover will have an impact on the previous year submissions. |