TeacherSurvey additional data of interest

[Ghislain Hachey]

It seems the workbook census contains some additional data that could easily be pulled out of the XML rows and put into the table columns for ease of access.

• tchYears
• tchYearsSchool
• tchInservice
• tchInserviceYear
• tchYearStarted

And how to fill those from workbook? FSM/RMI has date of hire.

[Ghislain Hachey]

And

• tchSalary
• tchSalaryCurr
• tchSalaryPeriod
• tchSalaryScale

‌

[Ghislain Hachey]

Modify loadCensusStaff to load some new data directly into TeacherSurvey:

• Annual_Salary into tchSalary (or tchSalaryCurr?)
• Date_of_Hire into tchYearStarted (or used for tchYearsSchool?). Scratch this one. Date_of_Hire already goes on TeacherIdentity’s tDatePSAppointed

‌

[Ghislain Hachey]

And some additional data that should be easily pulled into TeacherIdentity.

• ethnicity
• ethnicity group (race)
• nationality

‌

[Ghislain Hachey]

Issue #1329 was marked as a duplicate of this issue.