End-of-Year Process for Org
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. |