emis_user_manual_data_warehouse
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
emis_user_manual_data_warehouse [2022/02/17 15:38] – [Enrolments] ghachey | emis_user_manual_data_warehouse [2023/12/13 20:52] (current) – [Teachers] ghachey | ||
---|---|---|---|
Line 208: | Line 208: | ||
The table warehouse.TeacherLocation sits on the transition between: | The table warehouse.TeacherLocation sits on the transition between: | ||
- | * teacher reporting derived from the School Surveys; and | + | * teacher reporting derived from the School Surveys |
- | * teacher reporting derived from Appointments, | + | * teacher reporting derived from Appointments, |
- | The tables Establishment and Teacher Appointments define the structure of the teaching establishment: | + | <note important> |
- | The TeacherSurvey table holds the records of where teachers are reported to be by the School Survey. This is where teachers are. Ideally, TeacherSurvey functions as a verification of TeacherAppointments. We can check that teachers are where they are supposed to be and report exceptions. In simpler setups only the surveys are used and not the Establishment/ | + | <note important> |
- | Regardless of the setup, this table brings these two sets of data together | + | Regardless of the setup, this table brings these two sets of data together. |
- | + | ||
- | In there there is a record for each teacher for each year they were active. It contains the gender, DoB, age group of teacher, the school, role, source (i.e. an appointment or reported through survey), whether the teacher is qualified and certified, the education sector, which grade taught, and some other details. | + | |
=== Tables/ | === Tables/ | ||
- | Tables containing data about the number of staff. They come in various disaggregations: | + | Tables containing data about the number of staff and their job title, staff type (i.e. teaching and non-teaching) and teacher type (i.e. regular, special ed.). They come in various disaggregations: |
* warehouse.TeacherJobTable | * warehouse.TeacherJobTable |
emis_user_manual_data_warehouse.1645112323.txt.gz · Last modified: 2022/02/17 15:38 by ghachey