db.migration.V2__init_data_creation.sql Maven / Gradle / Ivy

insert into validationdb.rule_set_implementation(rule_set_impl_sk, rule_set_id, rule_set_impl_name, created_date, updated_date) VALUES ('3dbd047e-f197-493d-a4d0-015db390d418', '19XK4YKQOU7935V', 'demographicRuleSet', sysdate(), sysdate());
insert into validationdb.rule_set_implementation(rule_set_impl_sk, rule_set_id, rule_set_impl_name, created_date, updated_date) VALUES ('2a72c477-ff9e-4f77-a9ac-de7775247db7', 'CMD1FNG5Y6K90U3', 'enrollmentSpanRuleSet', sysdate(), sysdate());
insert into validationdb.rule_set_implementation(rule_set_impl_sk, rule_set_id, rule_set_impl_name, created_date, updated_date) VALUES ('95ce6495-a5b1-498f-8609-bf2e01ccac87', 'NIYHVIJRZBYT9JQ', 'demographicRuleSet', sysdate(), sysdate());
insert into validationdb.rule_set_implementation(rule_set_impl_sk, rule_set_id, rule_set_impl_name, created_date, updated_date) VALUES ('25153be9-119b-4a8f-8714-d594715291cb', 'ADZ465QZ4VGYEQM', 'dataIntegrityRuleSet', sysdate(), sysdate());
insert into validationdb.rule_set_implementation(rule_set_impl_sk, rule_set_id, rule_set_impl_name, created_date, updated_date) VALUES ('d25b5b87-4381-477c-a609-b9d518c1478e', '9W0HJ1CCM7B2DDJ', 'rateRuleSet', sysdate(), sysdate());
insert into validationdb.rule_set_implementation(rule_set_impl_sk, rule_set_id, rule_set_impl_name, created_date, updated_date) VALUES ('c26817ae-1c18-4252-9704-ff96ecddcc2f', 'MQP5IPC6C6JK5E5', 'dateValidationRuleSet', sysdate(), sysdate());

-- Account Demographic Rules
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('fc0e442d-019e-49c2-8837-425d83e442e2', '3dbd047e-f197-493d-a4d0-015db390d418', 'JL4SPBGRY6O9FJE', 'dateOfBirthRule', sysdate(), sysdate());
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('61bd4b6f-c03f-4c6c-bed8-3ff438afbf4a', '3dbd047e-f197-493d-a4d0-015db390d418', '6BIWSQZO9T60F99', 'genderRule', sysdate(), sysdate());
-- Account Enrollment Span Rules
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('56f01ce3-018d-4ed8-9252-829a36462afb', '2a72c477-ff9e-4f77-a9ac-de7775247db7', 'U2STMQEAIRE1X0Q', 'enrollmentSpanOverlapRule', sysdate(), sysdate());
-- Transaction Demographic Rules (Rule Type: TRANSACTION_DATA_VALIDATION, Rule Set: TRANSACTION DEMOGRAPHIC)
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('92a57454-9822-4823-9ad1-a67099404d7d', '95ce6495-a5b1-498f-8609-bf2e01ccac87', 'AU3IUZ2FTSAFAV7', 'dateOfBirthRule', sysdate(), sysdate());
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('d0174556-9ab1-4fbe-968d-9445391074e6', '95ce6495-a5b1-498f-8609-bf2e01ccac87', '84WNR9KAS23XKP3', 'genderRule', sysdate(), sysdate());
-- Transaction Data Integrity Rules (Rule Type: TRANSACTION_DATA_VALIDATION, Rule Set: DATA INTEGRITY)
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('1b239378-cefc-41c1-a943-0d10f11fff54', '25153be9-119b-4a8f-8714-d594715291cb', 'GLPSKJXBMPXDVUI', 'effectiveDatePresenceRule', sysdate(), sysdate());
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('e7d8db47-f207-4b0e-8663-0aa9cd769e09', '25153be9-119b-4a8f-8714-d594715291cb', 'WS5VZS1G91913ZJ', 'endDatePresenceRule', sysdate(), sysdate());

insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('438e8659-a8fc-4ba4-85ae-c1cfbfcef89b', '25153be9-119b-4a8f-8714-d594715291cb', 'HVRI6GGMVXAT2SV', 'subscriberRule', sysdate(), sysdate());
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('84e8d87f-c59f-40ca-b1de-a8621808948d', '25153be9-119b-4a8f-8714-d594715291cb', 'J1BW1EI6UJGNQMY', 'exchangeSubscriberIdRule', sysdate(), sysdate());
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('b2bb7739-b591-4235-986b-33e59fbc9a5e', '25153be9-119b-4a8f-8714-d594715291cb', 'NHS5WV07S2N3AJ9', 'exchangeMemberIdRule', sysdate(), sysdate());
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('eb5c6e42-0377-4901-9de5-8d2976b73d58', '25153be9-119b-4a8f-8714-d594715291cb', 'OLG1QV5NKWHFYLG', 'premiumAmountTotalPresenceRule', sysdate(), sysdate());
-- Transaction Business Rules (Rule Type: BUSINESS_RULE, Rule Set: RATE VALIDATION)
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('80f36786-c8b3-423e-9dcd-55e081bd66c8', 'd25b5b87-4381-477c-a609-b9d518c1478e', '84MBZPRAOZC1NU6', 'premiumTotalRule', sysdate(), sysdate());
-- Transaction Business Rules (Rule Type: BUSINESS_RULE, Rule Set: DATE VALIDATION)
insert into validationdb.rule_implementation(rule_impl_sk, rule_set_impl_sk, rule_id, rule_impl_name, created_date, updated_date) VALUES ('a77c1228-f26c-4942-9296-5afa95a86eb9', 'c26817ae-1c18-4252-9704-ff96ecddcc2f', 'CBU8HBC8P4FV5EA', 'matchEffectiveDateRule', sysdate(), sysdate());