Incompatibilities on Outer / Region attribute

[Brian Lewis]

iOuter on Island is length 50 - was changed to accommodate longer strings in Kiribati. But lkpRegion should validate this and is only 10. This breaks XYCharts. (specifially pSchoolRead.schoolScatterChart)

‌

Further, editing Regions in Table maintenance allows only 2 chars.

Settle on this being 10 chars like most codes, fix the editing of region, create the appropriate region codes and descriptions in KEMIS (ok elsewhere?) , add referential integrity constraint on iOuter,

[Brian Lewis]

When deploying to KEMIS production, will need to fix existing data to new smaller size for iOuter

INSERT INTO lkpRegion
(codeCode, codeDescription)
VALUES ('OUTER','Outer')
, ('S_TARAWA','South Tarawa')

update Islands
SET iOuter = 'S_TARAWA' WHERE iOuter like 'South%'

[Ghislain Hachey]

Region data updated in production.

[Ghislain Hachey]

Also did

update Islands
SET iOuter = 'OUTER' WHERE iOuter like 'Outer'

‌