Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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

Code Block
languagesql
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

  •  Manually set is_confirmation_number_required field in tblConfirmationTypes to 1 for those options requiring mandatory confirmation ID

...