search

TSSlade / tusome_db

Repository for design and development of Tusome's M&E database
0 stars 6 forks source link

Update db_scoping_notes.md #4

Closed Dunstonlwangas closed 5 years ago

Dunstonlwangas commented 5 years ago

Hi TS, Thanks. Lets go with your suggestion but for SNE - generally schools are either regular or SNE. If we could have a filter for that,it could help in case one needs information for only SNE but you are right. It is an attribute / category of a school and what about PTTC?

TSSlade commented 5 years ago

Okay, so we're agreed on SNE status being an attribute of a school. I'd thought there were basically three possibilities: (a) it's a mainstream (fully non-SNE) school, (b) it contains a special unit, or (c) it is a fully SNE school. And then in the event it's either (b) or (c), we need to be able to specify what the nature of the SNE support they provide happens to be. Is that correct?

On the PTTC front - to me, these seem like distinct from schools, no? So we treat them as a form of entity-based data, but they're a different list from proper schools. (Still mapped to the appropriate geographic hierarchy, and with joins to the appropriate person-based list.)