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:44] – [Flows] ghachey | emis_user_manual_data_warehouse [2021/02/02 02:10] – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 172: | Line 172: | ||
| ==== Teachers ==== | ==== 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> | ||
| === Table warehouse.TeacherLocation === | === Table warehouse.TeacherLocation === | ||
| Line 374: | 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> | ||
| - | ==== Flows ==== | ||
emis_user_manual_data_warehouse.txt · Last modified: 2023/12/13 20:52 by ghachey