Before applying the migration 

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:

INSERT INTO "core_ModuleConfiguration" (id, module, version, config, is_disabled_until, is_exposed, layer) 
VALUES 
  ('f2af6904131b420b98374a82ec037b74', 'fe-claim', '1.0.0', '{"claimForm.autoGenerateClaimCode": 1, "ClaimMasterPanelExt.isAdditionalPanelEnabled": 1, "claimForm.numberOfAdditionalDiagnosis": 2, "claimForm.isCareTypeMandatory": 1, "claimForm.isExplanationMandatoryForIPD": 1, "claimForm.showOrdinalNumber": 1, "claimValidationMultipleServicesExplanationRequired": 1, "claimForm.isClaimedDateFixed": 1, "reviews.defaultFilters": {"claimStatus": {"value": 4, "filter": "status: 4"}, "claimedUnder": {"value": 1000000, "filter": "claimed_Lte: \"1000000\""}}}', NULL, 1, 'fe'),
  ('f2af6904131b420b98374a82fd147b74', 'fe-core', '1.0.0', '{"allowSecondCalendar": 1, "currency": "NPR", "secondCalendarFormattingLang": "en", "secondCalendarFormatting": "DD-MM-YYYY"}', NULL, 1, 'fe'),
  ('f2af9604242b420b98374a82ef037b74', 'fe-insuree', '1.0.0', '{"insureeForm.isInsureeFirstServicePointRequired": 1, "showInsureeSummaryAddress": 1, "renderLastNameFirst": false}', NULL, 1, 'fe'),
  ('f2af9604242b420b98374a82ef037c86', 'fe-location', '1.0.0', '{"healthFacilityForm.isHealthFacilityStatusEnabled": 1, "healthFacilityForm.isHealthFacilityContractMandatory": 1}', NULL, 1, 'fe'),
  ('f2af9604242b431b98374a82ef038d86', 'fe-home', '1.0.0', '{"HomePageContainer.showHomeMessage": true, "HomePageContainer.homeMessageURL": "https://claimdoc.hib.gov.np/notice/get.php", "HomePageContainer.showHealthFacilityMessage": 1}', NULL, 1, 'fe'),
  ('f2af9604398b431b98374a82ef038d86', 'fe-policy', '1.0.0', '{"familyOrInsureePoliciesSummary.defaultPageSize": 2, "familyOrInsureePoliciesSummary.rowsPerPageOptions": [2,5,10], "familyOrInsureePoliciesSummary.onlyActiveOrLastExpired": false, "familyOrInsureePoliciesSummary.orderByExpiryDate": "-expiryDate"}', NULL, 1, 'fe');

Backend:

INSERT INTO "core_ModuleConfiguration" (id,"module","version",config,is_disabled_until,is_exposed,layer) VALUES
	 ('f2af9604-398b-431b-9837-5b83ef038d86','core','1.0.0','{"secondary_calendar": "Nepal"}',NULL,0,'be');


MSSQL Insert statements:

INSERT INTO core_ModuleConfiguration (id,module,version,config,is_disabled_until,is_exposed,layer) VALUES
	 (N'f2af690413ee420b98374a82ec037b74',N'fe-claim',N'1.0.0',N'{
 "claimForm.autoGenerateClaimCode" : 1, "ClaimMasterPanelExt.isAdditionalPanelEnabled": 1 ,"claimForm.numberOfAdditionalDiagnosis": 2, "claimForm.isCareTypeMandatory" : 1,"claimForm.isExplanationMandatoryForIPD": 1, "claimForm.showOrdinalNumber" : 1, "claimValidationMultipleServicesExplanationRequired": 1, "claimForm.isClaimedDateFixed": 1,         "reviews.defaultFilters" : {
            "claimStatus": {"value": 4,"filter": "status: 4"},
            "claimedUnder": {"value": 1000000,"filter": "claimed_Lte: \"1000000\""}
        }
}',NULL,1,N'fe'),
	 (N'f2af6904131b420b98374a82fd147b74',N'fe-core',N'1.0.0',N'{"allowSecondCalendar" : 1, "currency" : "NPR", "secondCalendarFormattingLang": "en", "secondCalendarFormatting": "DD-MM-YYYY"
}',NULL,1,N'fe'),
	 (N'f2af9604242b420b98374a82ef037b74',N'fe-insuree',N'1.0.0',N'{
 "insureeForm.isInsureeFirstServicePointRequired": 1, "showInsureeSummaryAddress":1, "InsureeSummary.showInsureeProfileLink": true
}',NULL,1,N'fe'),
	 (N'f2af9604242b420b98374a82ef037c86',N'fe-location',N'1.0.0',N'{
 "healthFacilityForm.isHealthFacilityStatusEnabled": 1, "healthFacilityForm.isHealthFacilityContractMandatory":1
}',NULL,1,N'fe'),
	 (N'f2af9604242b431b98374a82ef038d86',N'fe-home',N'1.0.0',N'{"HomePageContainer.showHomeMessage": true, "HomePageContainer.homeMessageURL": "https://claimdoc.hib.gov.np/notice/get.php", "HomePageContainer.showHealthFacilityMessage": 1}',NULL,1,N'fe'),
	 (N'f2af9604398b431b98374a82ef038d86',N'fe-policy',N'1.0.0',N'{"familyOrInsureePoliciesSummary.defaultPageSize": 2, "familyOrInsureePoliciesSummary.rowsPerPageOptions": [2,5,10], "familyOrInsureePoliciesSummary.onlyActiveOrLastExpired": false, "familyOrInsureePoliciesSummary.orderByExpiryDate": "-expiryDate"}',NULL,1,N'fe');

Backend:

INSERT INTO core_ModuleConfiguration (id,module,version,config,is_disabled_until,is_exposed,layer) VALUES
	 (N'f2af9604398b431b98375b83ef038d86',N'core',N'1.0.0',N'{"secondary_calendar": "Nepal"}',NULL,0,N'be');

Insuree status 

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');

Claim attachments 

INSERT INTO public."claim_ClaimAttachment_ClaimAttachmentType"
("ValidityFrom", "ValidityTo", "LegacyID", "ClaimAttachmentTypeId", "ClaimAttachmentType", is_autogenerated, claim_general_type)
VALUES('2024-02-13 22:58:25.039', NULL, NULL, 3, 'claimdoc', true, 'URL');

Family confirmation ID

Manual migration of data

Migration of Feedback ID 0 in Claims 

update tblClaim set FeedbackID = null where FeedbackID = 0