Before applying the migration
| Code Block | ||
|---|---|---|
| ||
UPDATE FP SET OfficerId = NULL FROM tblFeedbackPrompt FP LEFT OUTER JOIN tblOfficer O ON O.OfficerId = FP.OfficerId WHERE O.OfficerId IS NULL |
Implementation specific settings
The following settings are to be configured within NHIB modular instance to comply with implementation requirements.
PSSQL Insert statements:
...
| Code Block | ||
|---|---|---|
| ||
INSERT INTO "tblInsureeStatusReason"
("ValidityFrom","ValidityTo","LegacyID","StatusReasonId","StatusReason","Code",status_type) VALUES
('2023-09-22 14:48:46.595',NULL,NULL,1,'Work Emigration','IN001','IN'),
('2023-09-22 14:48:46.595',NULL,NULL,2,'Study Emigration','IN002','IN'),
('2023-09-22 14:48:46.595',NULL,NULL,3,'Covid','DE001','DE'),
('2023-09-22 14:48:46.595',NULL,NULL,4,'Heart attack','DE002','DE');
|
Family confirmation ID
- Manually set is_confirmation_number_required field in tblConfirmationTypes to 1 for those options requiring mandatory confirmation ID