Documentation

User Tools

Site Tools

Trace:
emis_developer_manual

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
emis_developer_manual [2026/01/02 20:44] – [Public REST API] ghacheyemis_developer_manual [2026/01/02 20:47] (current) – ghachey
Line 1092: Line 1092:
  
 <note important>One thing that we are not able to deliver from the local server is the google fonts; and the (phasing out) fontawesome fonts. The google fonts have to come from google. So if these are not previously loaded (in browser cache) then we need an internet connection to get them. This is really the only thing that forces us across the internet now. If Pacific EMIS cannot get these google fonts; then the ‘character equivalent’ of each icon in font family material-icons is displayed. Hence you see odd bits of text on the screen where there should be an icon. There is not much we can do about this, but it is worth noting that this is not affected by remote mode; in fact in remote mode, if there is no internet connection, then you would need to get all the libraries from browser cache for the app to have a hope of working.</note> <note important>One thing that we are not able to deliver from the local server is the google fonts; and the (phasing out) fontawesome fonts. The google fonts have to come from google. So if these are not previously loaded (in browser cache) then we need an internet connection to get them. This is really the only thing that forces us across the internet now. If Pacific EMIS cannot get these google fonts; then the ‘character equivalent’ of each icon in font family material-icons is displayed. Hence you see odd bits of text on the screen where there should be an icon. There is not much we can do about this, but it is worth noting that this is not affected by remote mode; in fact in remote mode, if there is no internet connection, then you would need to get all the libraries from browser cache for the app to have a hope of working.</note>
 +
 ===== Low Level Documentation and API ===== ===== Low Level Documentation and API =====
  
Line 1121: Line 1122:
   *   Also use pTeacherRead.TeacherSurveyV which provides denormalised values (school, surveyYear).   *   Also use pTeacherRead.TeacherSurveyV which provides denormalised values (school, surveyYear).
  
-===== Accessing TeacherSurvey XML =====+=== Accessing TeacherSurvey XML ===
  
 The functions pTeacherRead.Activities and pTeacherRead.TeacherQualCert shred the source XML on TeacherSurvey into relational records. The functions pTeacherRead.Activities and pTeacherRead.TeacherQualCert shred the source XML on TeacherSurvey into relational records.
  
-===== Main functions =====+=== Main functions ===
  
   * Handles both formats (PDF/XLSX) of source XML to produce a common rowset — consumers downstream of these functions deal with a consistent data format regardless of collection source.   * Handles both formats (PDF/XLSX) of source XML to produce a common rowset — consumers downstream of these functions deal with a consistent data format regardless of collection source.
Line 1151: Line 1152:
   * Includes teaching staff and non‑teaching staff (A, X).   * Includes teaching staff and non‑teaching staff (A, X).
  
-==== Common filters on TeacherLocation ====+=== Common filters on TeacherLocation ===
  
 TAMX in ('T','M') — filters to staff performing some teaching duty. M staff also perform Admin or X Other duties. TAMX in ('T','M') — filters to staff performing some teaching duty. M staff also perform Admin or X Other duties.
Line 1169: Line 1170:
 All teacher reporting from the warehouse should ultimately draw from warehouse.TeacherLocation so that interpretations of Allocated and Qualified/Certified match those embodied in pTeacherRead.TeacherQualCert. All teacher reporting from the warehouse should ultimately draw from warehouse.TeacherLocation so that interpretations of Allocated and Qualified/Certified match those embodied in pTeacherRead.TeacherQualCert.
  
-==== Examples ====+=== Examples ===
  
 <code sql> <code sql>
Line 1197: Line 1198:
 To overcome this, we weight a teacher's activities as a fraction of all their teaching activities. If Teacher A has 2 activities (1 in ISCED 1 and 1 in ISCED 2), their weighting for ISCED 1 is 0.5 and for ISCED 2 is 0.5, so their contribution to the page total is 1. To overcome this, we weight a teacher's activities as a fraction of all their teaching activities. If Teacher A has 2 activities (1 in ISCED 1 and 1 in ISCED 2), their weighting for ISCED 1 is 0.5 and for ISCED 2 is 0.5, so their contribution to the page total is 1.
  
-==== Terminology ====+=== Terminology ===
  
 FTPT (Full Time / Part Time) weighting — teaching activities in some group (ISCED, EdLevel, Sector, Class Level) as a fraction of the total teaching activities of that teacher. FTPT (Full Time / Part Time) weighting — teaching activities in some group (ISCED, EdLevel, Sector, Class Level) as a fraction of the total teaching activities of that teacher.
Line 1219: Line 1220:
 Summary: a teacher will have entries in this table (for a given year) for each ISCED Level in which they teach; exactly one of these records will have Allocated = 1. Summary: a teacher will have entries in this table (for a given year) for each ISCED Level in which they teach; exactly one of these records will have Allocated = 1.
  
-==== Head Count (unweighted totals) ====+=== Head Count (unweighted totals) ===
  
 Head Count = number of teachers who do any activity in that group regardless of other activities. One teacher may be included in multiple categories; head counts cannot be summed without double counting. Head Count = number of teachers who do any activity in that group regardless of other activities. One teacher may be included in multiple categories; head counts cannot be summed without double counting.
emis_developer_manual.txt · Last modified: 2026/01/02 20:47 by ghachey