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:42] – [Teachers] ghachey | emis_user_manual_data_warehouse [2020/09/07 03:45] – [Teachers] ghachey | ||
---|---|---|---|
Line 160: | Line 160: | ||
* Transition Rate (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol | * Transition Rate (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol | ||
- | A sample workbook how this many of the flow indicators | + | A sample workbook |
{{ : | {{ : | ||
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 375: | Line 370: | ||
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. | ||
- | |||
- | ==== Flows ==== | ||
emis_user_manual_data_warehouse.txt · Last modified: 2023/12/13 20:52 by ghachey