Clarify multiple options for field of study lookups

[Brian Lewis]

Figure out what we need, and what we can dispense with.

[Brian Lewis]

DB Table	Lookups collection	Name in editableLists collection	Use
lkpSubject (TRSubject)	Subjects	Subjects	FieldOfStudy of Teacher, Censusworkbook, ifID references ISCEDField
FieldOfStudy	FieldsOFStudy	not editable?	Scholarships - identically populated in FEDEMIS, MIEMIS, KEMIS
FieldsOfStudyGroups	FieldsOFStudyGroups	not editable	Tier 1 Tier 2 Tier 3
ISCEDField	ISCEDFields	ISCED FIelds	Fields defined by ISCED, in hierarchy (ISCED-F 2013) UIS Survey?
ISDECFieldGroup	ISCEDFieldGroups	ISCED Field Groups	ISCED Defined
ISCEDFieldGroupBroad	ISCEDFieldGroupsBroad	ISCED Field Groups Broad	ISCED Defined
lkpTeacherFieldOfStudy	not used	not used	Delete?

‌

[Brian Lewis]

@Ghislain Hachey I agree we can remove lkpTeacherFieldOfStudy, pls confirm and I’ll delete from the repo and remove from all dbs on waspinator.

[Brian Lewis]

Note that you can see what lookups are used in the CensusWorkbook from the metaData page e.g. MIEMIS_CENSUS.xlsx:

‌

[Brian Lewis]

‌

[Ghislain Hachey]

Yes, let’s go ahead a delete that everywhere once and for all.

[Brian Lewis]

supercedes #1320