Islands Region not showing in schools

[Ghislain Hachey]

After loading the region for all the islands of Chuuk and Yap they are not showing as auto-selected in the schools profiles as shown below. What am I missing?

Below the code to load the Islands' regions. Also note I do not see any referential integrity on the columns iOuter like there is with iGroup on Districts.

BEGIN TRANSACTION

SELECT TOP 5 * FROM Islands;

UPDATE Islands SET iOuter='OI' WHERE iCode='1';
UPDATE Islands SET iOuter='OI' WHERE iCode='2';
UPDATE Islands SET iOuter='OI' WHERE iCode='3';
UPDATE Islands SET iOuter='OI' WHERE iCode='4';
UPDATE Islands SET iOuter='OI' WHERE iCode='5';
UPDATE Islands SET iOuter='OI' WHERE iCode='6';
UPDATE Islands SET iOuter='OI' WHERE iCode='7';
UPDATE Islands SET iOuter='OI' WHERE iCode='8';
UPDATE Islands SET iOuter='OI' WHERE iCode='9';
UPDATE Islands SET iOuter='OI' WHERE iCode='10';
UPDATE Islands SET iOuter='OI' WHERE iCode='11';
UPDATE Islands SET iOuter='L' WHERE iCode='12';
UPDATE Islands SET iOuter='L' WHERE iCode='13';
UPDATE Islands SET iOuter='L' WHERE iCode='14';
UPDATE Islands SET iOuter='L' WHERE iCode='15';
UPDATE Islands SET iOuter='L' WHERE iCode='16';
UPDATE Islands SET iOuter='L' WHERE iCode='17';
UPDATE Islands SET iOuter='L' WHERE iCode='18';
UPDATE Islands SET iOuter='L' WHERE iCode='19';
UPDATE Islands SET iOuter='L' WHERE iCode='20';
UPDATE Islands SET iOuter='L' WHERE iCode='21';
UPDATE Islands SET iOuter='L' WHERE iCode='22';
UPDATE Islands SET iOuter='L' WHERE iCode='23';
UPDATE Islands SET iOuter='L' WHERE iCode='24';
UPDATE Islands SET iOuter='L' WHERE iCode='25';
UPDATE Islands SET iOuter='L' WHERE iCode='26';
UPDATE Islands SET iOuter='L' WHERE iCode='27';
UPDATE Islands SET iOuter='L' WHERE iCode='28';
UPDATE Islands SET iOuter='OI' WHERE iCode='29';
UPDATE Islands SET iOuter='OI' WHERE iCode='30';
UPDATE Islands SET iOuter='OI' WHERE iCode='31';
UPDATE Islands SET iOuter='OI' WHERE iCode='32';
UPDATE Islands SET iOuter='OI' WHERE iCode='33';
UPDATE Islands SET iOuter='OI' WHERE iCode='34';
UPDATE Islands SET iOuter='OI' WHERE iCode='35';
UPDATE Islands SET iOuter='OI' WHERE iCode='36';
UPDATE Islands SET iOuter='OI' WHERE iCode='37';
UPDATE Islands SET iOuter='OI' WHERE iCode='38';
UPDATE Islands SET iOuter='OI' WHERE iCode='39';
UPDATE Islands SET iOuter='OI' WHERE iCode='40';
UPDATE Islands SET iOuter='L' WHERE iCode='41';
UPDATE Islands SET iOuter='MI' WHERE iCode='64';
UPDATE Islands SET iOuter='OI' WHERE iCode='67';
UPDATE Islands SET iOuter='OI' WHERE iCode='68';
UPDATE Islands SET iOuter='OI' WHERE iCode='70';
UPDATE Islands SET iOuter='OI' WHERE iCode='72';
UPDATE Islands SET iOuter='OI' WHERE iCode='75';
UPDATE Islands SET iOuter='OI' WHERE iCode='76';
UPDATE Islands SET iOuter='OI' WHERE iCode='78';
UPDATE Islands SET iOuter='OI' WHERE iCode='79';
UPDATE Islands SET iOuter='OI' WHERE iCode='80';
UPDATE Islands SET iOuter='OI' WHERE iCode='82';
UPDATE Islands SET iOuter='OI' WHERE iCode='83';
UPDATE Islands SET iOuter='OI' WHERE iCode='84';
UPDATE Islands SET iOuter='OI' WHERE iCode='85';
UPDATE Islands SET iOuter='OI' WHERE iCode='86';
UPDATE Islands SET iOuter='MI' WHERE iCode='90';
UPDATE Islands SET iOuter='OI' WHERE iCode='91';
UPDATE Islands SET iOuter='MI' WHERE iCode='92';
UPDATE Islands SET iOuter='OI' WHERE iCode='96';
UPDATE Islands SET iOuter='OI' WHERE iCode='97';
UPDATE Islands SET iOuter='OI' WHERE iCode='98';
UPDATE Islands SET iOuter='OI' WHERE iCode='99';

SELECT TOP 5 * FROM Islands;

COMMIT;

[Brian Lewis]

Is this just because the iOuter value for the Island is read from the Islands table in Lookups service; these values are loaded on application startup and won't reflect these externally made changes?

[Ghislain Hachey]

Actually, it is showing but the code only is showing, not the actual region (location in FSM) is showing. Seems there is no referential integrity either.

[Brian Lewis]

fix(schools): in School Info, decode school region code to show region description

Resolves #661

→ <<cset 15a02b80edd7>>

[Brian Lewis]

Probably this was never noticed because until recently the code and the description for regions have been the same - Urban = Urban, Rural = Rural