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