emis_user_manual_data_warehouse
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
emis_user_manual_data_warehouse [2020/09/07 03:45] – [Teachers] ghachey | emis_user_manual_data_warehouse [2022/02/17 15:27] – [Flows] ghachey | ||
---|---|---|---|
Line 141: | Line 141: | ||
<note important> | <note important> | ||
- | Each of these views produce the same data but with different disaggregations (i.e. down to school level, district level and nation wide and by gender). Each record will have the following data which must be used in various formulas to produce the final indicators. There is a bold emphasis on the most important ones to produce most flow indicators with enough precision. These flows use the reconstructed cohort methods and must have consistent collection of enrolments and repeaters for two consecutive years. | + | Each of these views produce the same data but with different disaggregations (i.e. down to school level, district level and nation wide and by gender). Each record will have the following data which must be used in various formulas to produce the final indicators. There is a bold emphasis on the most important ones to produce most flow indicators with enough precision. These flows use the reconstructed cohort methods and must have consistent collection of enrolments and repeaters for two consecutive years. |
* **Enrol**: the enrolments (e.g. Grade 5 enrolments for 2018-19) | * **Enrol**: the enrolments (e.g. Grade 5 enrolments for 2018-19) | ||
Line 369: | Line 369: | ||
Same of warehouse.enrol except this table aggregates this data up to District, Authority, SchoolTypeCode and is used as the basis for higher level aggregations of any of these enrolment data items. | Same of warehouse.enrol except this table aggregates this data up to District, Authority, SchoolTypeCode and is used as the basis for higher level aggregations of any of these enrolment data items. | ||
+ | |||
+ | ==== Teachers ==== | ||
+ | |||
+ | === Table warehouse.TeacherQual === | ||
+ | |||
+ | Intermediate table to assist in calculation of Certified / Qualified. This table shows, for each teacher, the qualifications reported, and the first year of that report. It is assembled from both the School Surveys, and any named qualifications reported in the web UI. | ||
+ | |||
+ | <note warning> | ||
+ | |||
Line 433: | Line 442: | ||
<note important> | <note important> | ||
- | Consolidates the overall result of inspections. Filter on InspectionType to restrict to accreditations | + | Consolidates the overall result of inspections |
<note important> | <note important> |
emis_user_manual_data_warehouse.txt · Last modified: 2023/12/13 20:52 by ghachey