• Home
• com.brihaspathee.zeus
• member-mgmt-service
• 1.0.3
• source code
• V2__init_data_creation.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

/** Balaji Varadharajan Account details **/
INSERT INTO membermgmtdb.account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('e29f6d8d-51c8-4259-b789-1aac0e5fcfe7','5LOQKYBP1NQX17E','HIX', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', sysdate(), sysdate());

INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('1817da35-c65d-469d-a7ce-d6eb1569ffe9','e29f6d8d-51c8-4259-b789-1aac0e5fcfe7','G8RKJY77IYPBYXU','Balaji', 'M', 'Varadharajan','HOH','1983-05-21 00:00:00','MALE',5.8,155.6, 'MC6L56Z5GRGHEK2', 'MARKETPLACE', SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('4c5c3b7c-0950-49e8-b483-72fca0f428f2', 'HP86QL1UWE0UAKZ', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', 'RES', '13377 Batten Lane', null, 'Odessa', 'FL', '12101', '33556', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a0e9af18-f109-4a9c-bba3-e7824cf99616', 'L89ZMCJ50PM36TW', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', 'MAIL', 'P.O Box 23646', null, 'Odessa', 'FL', '12101', '33556', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('24629daf-e0c7-4dd9-9f8b-64360a50793b', 'KI0QVIJKYERYY9G', '1817da35-c65d-469d-a7ce-d6eb1569ffe9','MOBILE', '813-357-9150', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a018f0ce-f269-4353-ac97-0c88df8477df', '50QGOOCJ3K2IMZC', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', 'PERSONAL', '[email protected]', true, 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('f60459a2-dc26-44ec-88d2-027c541cda7c', 'TBVHIU74HUHFMZP', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('266b2753-220f-45d8-928c-a4e8fb2e42eb', 'CZ8TRC5GYH6UGTH', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', 'SPOKEN', 'ENG', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('56c65d79-6556-42d5-89fa-3eeef4a993fa', '224QAUBU304JVPK', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', 'WRITTEN', 'SPA', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('b0d97992-bc5b-4d53-8e68-68176914b8bb', 'Y2BF30P04IH1IOR', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', 'SSN', '023-53-5234', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', true, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('1f4684b7-834d-41ad-a150-658da294c54c', 'I5LXC5ELIEO0G2O', 'e29f6d8d-51c8-4259-b789-1aac0e5fcfe7', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2022-01-01 00:00:00', '2022-12-31 00:00:00','245247345','89355FL0234597', '63456345','HMO','2022-10-01 00:00:00','ENROLLED', 'MBS', null, 'MC6L56Z5GRGHEK2', 'MARKETPLACE', false, SYSDATE(),SYSDATE());

INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('12573e17-7244-4e49-a152-38d59b03e2f6', 'CNH182BAIO3321D', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '1f4684b7-834d-41ad-a150-658da294c54c', '2022-01-01 00:00:00', '2022-06-30 00:00:00', 'ACTIVE', 1, '03', 150, 150, 0, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('96aedae2-95b1-4181-bd2b-cfc26179e044', 'GT5PSZ6FBWEOH69', '55UCZGSHBH98VKM', 'MARKETPLACE','1f4684b7-834d-41ad-a150-658da294c54c', '2022-07-01 00:00:00', '2022-12-31 00:00:00', 'ACTIVE', 2, '03', 150, 150, 0, 0, 20, sysdate(),sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('6dfe06fb-05e8-4f2e-88c0-7441bd0b5e43', '12573e17-7244-4e49-a152-38d59b03e2f6', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', '24524734501', 150, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('d421d90b-74a9-4df9-add9-a1f84ef9908f', '96aedae2-95b1-4181-bd2b-cfc26179e044', '1817da35-c65d-469d-a7ce-d6eb1569ffe9', '24524734501', 150,sysdate(), sysdate());

INSERT INTO membermgmtdb.broker(broker_sk, account_sk, broker_code, broker_name, broker_id, agency_name, agency_id, account_number_1, account_number_2, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('803b938c-b4ee-4d98-be3c-0e36ddd845b1','e29f6d8d-51c8-4259-b789-1aac0e5fcfe7', 'K8Y3XMEKND1X8L2', 'Ben Stokes', '53234534', 'Sapphire Brokers Inc.', '63363754', '523645-63456', null, 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2022-01-01 00:00:00', null, sysdate(), sysdate());
INSERT INTO membermgmtdb.sponsor(sponsor_sk, account_sk, sponsor_code, sponsor_id, sponsor_name, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('66aff58a-a9f0-43ce-8f03-2699f4f5bb30','e29f6d8d-51c8-4259-b789-1aac0e5fcfe7', '1MFGMD2ATZLCX9N', '023-53-5234', 'Balaji Varadharajan', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2022-01-01 00:00:00', null, sysdate(), sysdate());
INSERT INTO membermgmtdb.payer(payer_sk, account_sk, payer_code, payer_name, payer_id, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('97fc21a9-a202-4e5d-9dd0-625c7f3f3cf0', 'e29f6d8d-51c8-4259-b789-1aac0e5fcfe7', '8G0R6X17WMER37G', 'Zeus Health', '5235343', 'MC6L56Z5GRGHEK2', 'MARKETPLACE', '2022-01-01 00:00:00', null, sysdate(), sysdate());

/** Pooja Mohanakrishnan Account **/
INSERT INTO membermgmtdb.account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('c601259a-6b0f-4a18-882f-d645e934d092','652C183K1DEBCNC','HIX', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', sysdate(), sysdate());


INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('2fca4989-037a-496f-9b59-cffd3990a5dd','c601259a-6b0f-4a18-882f-d645e934d092','KMOO76CXLXGGSB4','Pooja', 'D', 'Mohanakrishnan','HOH','1985-12-10 00:00:00','FEMALE',5.3,113.2, '0ZSDCU8DSL7G6AO', 'MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('912817ff-e351-4aa8-b727-89292fe00fc7', 'J3BZ172D3ISJDPO', '2fca4989-037a-496f-9b59-cffd3990a5dd', 'RES', '9737 Lake View Lane', 'Apt 303', 'Tampa', 'FL', '12057', '33626', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', '2020-12-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('503d5c9c-f8a9-47a3-95ee-12c03f9dbcfd', 'AKTTBZ6DNJURU73' ,'2fca4989-037a-496f-9b59-cffd3990a5dd', 'MAIL', 'P.O Box 74567', null, 'Tampa', 'FL', '12057', '33626', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', '2020-12-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('90f0e60d-05af-4fe2-ad2e-9696cacfd1ad','8AMLJ42HALDDBGD','2fca4989-037a-496f-9b59-cffd3990a5dd','MOBILE', '813-357-9151', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', '2020-12-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('89c37c07-4fe9-4e77-a2aa-1ee3c34af9a7', 'TCNRRBB7Y7IWNTM','2fca4989-037a-496f-9b59-cffd3990a5dd', 'PERSONAL', '[email protected]', true, '0ZSDCU8DSL7G6AO', 'MARKETPLACE', '2020-12-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('3f562524-d5f2-4ae6-8f43-59b6b7910ae8', '42ZMZ0WY3IZPLLY','2fca4989-037a-496f-9b59-cffd3990a5dd', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-12-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('edee8c04-8e39-4bc2-a736-8c3c937ba07f', 'WD5W7OAFW4GH5LC', '2fca4989-037a-496f-9b59-cffd3990a5dd', 'SPOKEN', 'ENG', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', '2020-12-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('3e12bff3-c69f-4f34-b7ad-ed453036fb7e', 'X3TY01S9ZZL4HJQ', '2fca4989-037a-496f-9b59-cffd3990a5dd', 'WRITTEN', 'SPA', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', '2020-12-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('da66a1f6-e5c5-481a-93a3-58e15bf41d1f', '1WISWCYI2B1XFDD', '2fca4989-037a-496f-9b59-cffd3990a5dd', 'SSN', '856-34-9568', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', true, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('ba557400-0afa-4475-bbe9-59503233716a', 'XYFHOHJFGH5CC6V', 'c601259a-6b0f-4a18-882f-d645e934d092', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2022-01-01 00:00:00', '2022-12-31 00:00:00','64574573', '09643FL0234597', '74845784','HMO','2021-12-20 00:00:00','ENROLLED', 'MBS', null, '0ZSDCU8DSL7G6AO', 'MARKETPLACE', false, SYSDATE(),SYSDATE());
INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('be2a834b-8718-48c7-a3fa-a2aeef9162db', 'WU5ZTKX5XHMTLWG', 'c601259a-6b0f-4a18-882f-d645e934d092', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2023-01-01 00:00:00', '2023-12-31 00:00:00','64574573', '34526FL0234597', '84584578','HMO','2022-12-15 00:00:00','ENROLLED', 'MBS', null, 'DXB424JH4JXTZWT', 'MARKETPLACE', false, SYSDATE(),SYSDATE());

INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('f203d69f-ac11-4efb-9f2e-3bb91ad4e0b5', 'B0AXB3PL5GBCRYA', '0ZSDCU8DSL7G6AO', 'MARKETPLACE', 'ba557400-0afa-4475-bbe9-59503233716a', '2022-01-01 00:00:00', '2022-12-31 00:00:00', 'ACTIVE', 1, '03', 150, 150, 0, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('088d7dc1-beee-4fb6-987e-4b4447942de3', '174GMP35EQZLOE0', 'DXB424JH4JXTZWT', 'MARKETPLACE', 'be2a834b-8718-48c7-a3fa-a2aeef9162db', '2023-01-01 00:00:00', '2023-06-30 00:00:00', 'ACTIVE', 1, '03', 150, 100, 50, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('0ef78434-95cc-4063-add0-41fda59c2ead', '9T2QLZYA302OHB0', '00LS0O6YGQPMC5G', 'MARKETPLACE', 'be2a834b-8718-48c7-a3fa-a2aeef9162db', '2023-07-01 00:00:00', '2023-12-31 00:00:00', 'ACTIVE', 2, '03', 150, 125, 25, 0, 20, sysdate(),sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('11f766dc-9fe1-4a29-8dd1-4f1c07d1cf43', 'f203d69f-ac11-4efb-9f2e-3bb91ad4e0b5', '2fca4989-037a-496f-9b59-cffd3990a5dd', '6457457301', 150, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('4f14aa2e-f850-4a8c-9200-5419a4cb890a', '088d7dc1-beee-4fb6-987e-4b4447942de3', '2fca4989-037a-496f-9b59-cffd3990a5dd', '6457457301', 150, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('d30feb25-9c0e-4190-88d3-f7a65d370448', '0ef78434-95cc-4063-add0-41fda59c2ead', '2fca4989-037a-496f-9b59-cffd3990a5dd', '6457457301', 150,sysdate(), sysdate());


/** Doe Family Account - Contains three members, John, Mary and Christy **/
INSERT INTO membermgmtdb.account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('66097166-c971-4d99-83b1-0086b8ec6f4e','O70RIWIWR7GSXAJ','HIX', '4HSM54WFZKETCFS', 'MARKETPLACE',sysdate(), sysdate());

/** John Doe Details **/
INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('8de41197-dfb3-4f1a-93ed-2fb034b8ce87','66097166-c971-4d99-83b1-0086b8ec6f4e','J11WCUSYKYV5B7S','John', 'P', 'Doe','HOH', '1978-07-13 00:00:00','MALE',5.5,173.56, '4HSM54WFZKETCFS', 'MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('21961677-878c-4848-8c93-99fc4c964ddd', 'BMUJ8565C9W9450', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', 'RESIDENCE', '8945 Main Street', 'Apt 303', 'Salem', 'MA', '25009', '78453', '4HSM54WFZKETCFS', 'MARKETPLACE' ,'2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('9140cb63-7f30-49ea-9f54-4b32fe14ca29', 'DSND8Y2NMMZZUQD', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', 'MAIL', 'P.O Box 92345', null, 'Salem', 'MA', '25009', '79456', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('201e451e-0c19-4caf-9d2a-9a5b9a3c8a4f', 'FJOYKKXB7LMDJK5', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87','MOBILE', '973-456-7835', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('1a9aaec0-f584-49f3-af26-6e803c7e392b', '3DIFIOAHI9LAG99', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', 'PERSONAL', '[email protected]', true, '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('9e94ecfd-48ac-47f0-bde4-b9ad75d8f884', 'XEHXIQT58LUGFFJ', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('982acf04-e508-4416-8faa-330fe0ec89f9', '6JPHAKLHQCKSMTJ', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', 'SPOKEN', 'ENG', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('0af84ee8-5a07-43f0-9792-a0e3241d1ec9', 'QH3LAAI0FIH4HAJ', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', 'WRITTEN', 'SPA', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('d9a8cfcc-d1aa-492c-9b3c-38a406927b6e', '6AJFHK7N348BSHB', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', 'SSN', '345-74-3463', '4HSM54WFZKETCFS', 'MARKETPLACE', true, SYSDATE(), SYSDATE());

/** Mary Doe Details **/

INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('02fe5093-5581-4e6d-8bfe-48055add707c','66097166-c971-4d99-83b1-0086b8ec6f4e','IK6S1UU7F2WZJYP','Mary', 'J', 'Doe', 'SPE', '1979-05-25 00:00:00','FEMALE',5.2,110.34, '4HSM54WFZKETCFS', 'MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b230b042-1c86-4eae-8bb7-03ff42381f80', '10PNJMDMOWNAP6Q', '02fe5093-5581-4e6d-8bfe-48055add707c', 'RESIDENCE', '8945 Main Street', 'Apt 303', 'Salem', 'MA', '25009', '78453', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('40dae692-8239-4a70-877f-cb0a832cc54e', 'JEDSKBCMZ2HH5EJ', '02fe5093-5581-4e6d-8bfe-48055add707c', 'MAIL', 'P.O Box 92345', null, 'Salem', 'MA', '25009', '79456', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('68fbd8b5-597b-46d3-9f19-53c42739efc7','GIW3F4641DSG7N5', '02fe5093-5581-4e6d-8bfe-48055add707c','MOBILE', '973-456-7836', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('ad5de35c-7fc3-4e58-821f-08e028cccad3', 'OLKWX144DH0E9BU', '02fe5093-5581-4e6d-8bfe-48055add707c', 'PERSONAL', '[email protected]', true, '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('7dd38503-8e01-4090-89fa-beb74f7f2696', 'EUA0MU7CV3OPYTG', '02fe5093-5581-4e6d-8bfe-48055add707c', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b0b9e5ae-6b96-4acd-9964-faf38de025ed', '5YEQY0Q6NV291K3', '02fe5093-5581-4e6d-8bfe-48055add707c', 'SPOKEN', 'ENG', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('4d00932a-e494-4fa5-bad6-5038814217b8', 'XZXRYN2U2SKFGYF', '02fe5093-5581-4e6d-8bfe-48055add707c', 'WRITTEN', 'SPA', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('2cd489bb-2e5c-48f7-ac27-1563b8f118ca', '8WOZ40J1WNPMAY4', '02fe5093-5581-4e6d-8bfe-48055add707c', 'SSN', '567-23-7457', '4HSM54WFZKETCFS', 'MARKETPLACE', true, SYSDATE(), SYSDATE());

/** Christy Doe Details **/
INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('0b21b364-b21c-4d06-914a-13089e063424','66097166-c971-4d99-83b1-0086b8ec6f4e','L2U3HF42S0YA9E8','Christy', 'D', 'Doe', 'CHD', '2002-05-10 00:00:00','FEMALE',5.3,109.78, '4HSM54WFZKETCFS', 'MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('723c819c-8d5f-4a01-aa63-303db9dc1a8b', 'MGDSPC4F4RD86SS', '0b21b364-b21c-4d06-914a-13089e063424', 'RES', '8945 Main Street', 'Apt 303', 'Salem', 'MA', '25009', '78453', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('ce57121a-81db-4635-834a-bc1dc8a4a827', 'EMD5W05GK7Q51SJ', '0b21b364-b21c-4d06-914a-13089e063424', 'MAIL', 'P.O Box 92345', null, 'Salem', 'MA', '25009', '79456', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('bb2b8f4d-2389-48d3-b86e-f1e32bc1d8b6','UQV29XT8JJ4R0NM', '0b21b364-b21c-4d06-914a-13089e063424','MOBILE', '973-456-7835', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('45ad19b4-16c6-4399-9a16-cba62e439bee', '8QWGL8HHTV0UH2T', '0b21b364-b21c-4d06-914a-13089e063424', 'PERSONAL', '[email protected]', true, '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('7e4403ad-9a61-4c3c-adf7-2085cd39841d', '7F98OCB9NTMZZM4', '0b21b364-b21c-4d06-914a-13089e063424', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('bea69ee6-a66d-40c3-a033-accd0efd1d11', 'IQ70021O4D0RIP4', '0b21b364-b21c-4d06-914a-13089e063424', 'SPOKEN', 'ENG', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('67161d0d-b79a-4c86-95c8-ef29af87bbad', 'EYNUYX84JCPRJYE', '0b21b364-b21c-4d06-914a-13089e063424', 'WRITTEN', 'SPA', '4HSM54WFZKETCFS', 'MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('c3d1f17b-90e8-4547-8052-542be9d661d6', 'R2MM8Z6LNP4ROHF', '0b21b364-b21c-4d06-914a-13089e063424', 'SSN', '845-85-6457', '4HSM54WFZKETCFS', 'MARKETPLACE', true, SYSDATE(), SYSDATE());

/** Enrollment and Premium spans associated with Doe family account **/
INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('db427035-8db3-40ca-8843-d9b5db7a7b45', 'KHEBBHBIZIFZWBK', '66097166-c971-4d99-83b1-0086b8ec6f4e', 'MA', 'FFM', 'MP_MA', 'ACTIVE', 'FAM', '2021-01-01 00:00:00', '2021-12-31 00:00:00', '53456345', '74567MA9523646', '47457757','HMO', '2021-05-01 00:00:00','ENROLLED','MBS',null, '4HSM54WFZKETCFS', 'MARKETPLACE', false, SYSDATE(),SYSDATE());
INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('5d28dbe4-8c14-484f-9a2a-90c1d88c49b6', 'A31V1DTQB6CXFEQ', '66097166-c971-4d99-83b1-0086b8ec6f4e', 'MA', 'FFM', 'MP_MA', 'ACTIVE', 'FAM', '2022-01-01 00:00:00', '2022-12-31 00:00:00', '53456345', '74567MA6346634', '74567744','HMO', '2022-05-01 00:00:00','ENROLLED','MBS',null, '3WO51CQC965V574', 'MARKETPLACE', false, SYSDATE(),SYSDATE());
INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('42030d4a-1b0d-4abc-a577-3d8886cd3156', 'QMK7E376BM1HKKQ', '66097166-c971-4d99-83b1-0086b8ec6f4e', 'MA', 'FFM', 'MP_MA', 'ACTIVE', 'FAM', '2023-01-01 00:00:00', '2023-05-31 00:00:00', '53456345', '74567MA6346634', '34566736','HMO', '2022-12-15 00:00:00','ENROLLED','MBS','VOLWITH','B7E4ZGXPD1RXN2T','MARKETPLACE', false, SYSDATE(),SYSDATE());
INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('5ae71640-e272-4e65-ba2d-c3219a28ff3c', 'LAALVUSCQT8DXBR', '66097166-c971-4d99-83b1-0086b8ec6f4e', 'MA', 'FFM', 'MP_MA', 'ACTIVE', 'FAM', '2023-06-01 00:00:00', '2023-09-30 00:00:00', '53456345', '74567MA6346634', '73464634','HMO', '2023-04-15 00:00:00','ENROLLED','MBS','VOLWITH','K1QGTY05LJ9S3WT', 'MARKETPLACE', false, SYSDATE(),SYSDATE());
INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('c848c96a-64d3-4846-97f3-b258f1f78807', 'RPLCVHK4C34BEVI', '66097166-c971-4d99-83b1-0086b8ec6f4e', 'MA', 'FFM', 'MP_MA', 'ACTIVE', 'FAM', '2023-10-01 00:00:00', '2023-12-31 00:00:00', '53456345', '74567MA6346634', '84534575','HMO', '2023-08-21 00:00:00','ENROLLED','MSB',null,'3W7TAGTTRAEL6UL', 'MARKETPLACE', false, SYSDATE(),SYSDATE());

INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('75d161c4-8bed-4bfd-a67e-65c613cfc4d7', '3SKS1M2QI5AA7GV', '4HSM54WFZKETCFS', 'MARKETPLACE', 'db427035-8db3-40ca-8843-d9b5db7a7b45', '2021-01-01 00:00:00', '2021-04-30 00:00:00', 'ACTIVE', 1, '03', 350, 250, 100, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('d575815a-f873-4b40-95e1-62bdf96d0e0f', 'FW2WTMWR733EZ2W', 'PBYFQ99L63V2VWI', 'MARKETPLACE', 'db427035-8db3-40ca-8843-d9b5db7a7b45', '2021-05-01 00:00:00', '2021-07-31 00:00:00', 'ACTIVE', 2, '03', 350, 225, 125, 0, 20, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('a0f609d1-3c68-48dc-afed-7ce98ef67c8c', 'QTU1UOVAVVY0VFY', 'J3152B0N17FQ1TO', 'MARKETPLACE', 'db427035-8db3-40ca-8843-d9b5db7a7b45', '2021-08-01 00:00:00', '2021-12-31 00:00:00', 'ACTIVE', 3, '03', 350, 275, 75, 0, 30, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('f591721f-5274-4f00-a7fa-eec760708dcd', '9MZLHX7MCQKAYBY', '4HSM54WFZKETCFS', 'MARKETPLACE', '5d28dbe4-8c14-484f-9a2a-90c1d88c49b6', '2022-01-01 00:00:00', '2022-06-30 00:00:00', 'ACTIVE', 1, '03', 400, 250, 150, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('29cab3e7-b919-4e76-9427-1abed999d214', '5K66CDQH3WGZW82', 'VCKSWETIS0F56R3', 'MARKETPLACE', '5d28dbe4-8c14-484f-9a2a-90c1d88c49b6', '2022-07-01 00:00:00', '2022-12-31 00:00:00', 'ACTIVE', 2, '03', 400, 300, 100, 0, 20, sysdate(),sysdate());

INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('551b963f-27cd-4aac-a2e8-04809583ff08', '2HZFC3DNJZJYGS7', 'B7E4ZGXPD1RXN2T', 'MARKETPLACE', '42030d4a-1b0d-4abc-a577-3d8886cd3156', '2023-01-01 00:00:00', '2023-03-31 00:00:00', 'ACTIVE', 1, '03', 400, 250, 150, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('bee9bec6-8656-4a77-8b2c-f0310456b3f6', 'SV6HYXMAQC1FKJU', 'CYBUVKRQSKX7C82', 'MARKETPLACE', '42030d4a-1b0d-4abc-a577-3d8886cd3156', '2023-04-01 00:00:00', '2023-05-31 00:00:00', 'ACTIVE', 2, '03', 400, 300, 100, 0, 20, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('0525a212-d8ec-4418-923f-b856bc541338', 'U426AQM7XNP4TYY', 'K1QGTY05LJ9S3WT', 'MARKETPLACE', '5ae71640-e272-4e65-ba2d-c3219a28ff3c', '2023-06-01 00:00:00', '2023-07-31 00:00:00', 'ACTIVE', 3, '03', 400, 250, 150, 0, 30, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('9cd2614c-2002-4a30-ade1-92a7c38ca424', 'N6D19DEW08JSQQG', 'OQN31R4GOEKZE0F', 'MARKETPLACE', '5ae71640-e272-4e65-ba2d-c3219a28ff3c', '2023-08-01 00:00:00', '2023-09-30 00:00:00', 'ACTIVE', 4, '03', 400, 300, 100, 0, 40, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('02c368af-6265-4d6e-a1fe-ad2ba960cd69', 'QKBK5BIN7KLJ1CO', '3W7TAGTTRAEL6UL', 'MARKETPLACE', 'c848c96a-64d3-4846-97f3-b258f1f78807', '2023-10-01 00:00:00', '2023-10-31 00:00:00', 'ACTIVE', 5, '03', 400, 250, 150, 0, 50, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('57f91f13-6614-4ea0-aea3-7027515e8e55', '4BBP82ZFUYGMGH7', 'E64KNB0XQXNPCUI', 'MARKETPLACE', 'c848c96a-64d3-4846-97f3-b258f1f78807', '2023-11-01 00:00:00', '2023-12-31 00:00:00', 'ACTIVE', 6, '03', 400, 300, 100, 0, 60, sysdate(),sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('da8c9a66-4c12-4ad5-9edd-76db68c07b32', '75d161c4-8bed-4bfd-a67e-65c613cfc4d7', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('927c0a2d-f0fc-4b1f-8f41-b5848d1558f2', '75d161c4-8bed-4bfd-a67e-65c613cfc4d7', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('e405fdc5-6fbb-4865-8134-17c3d7658bb7', '75d161c4-8bed-4bfd-a67e-65c613cfc4d7', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c77687f7-00db-4c4f-9d95-723cd2de1e43', 'd575815a-f873-4b40-95e1-62bdf96d0e0f', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('9c6570cc-5723-47cc-bdb7-1f6c4348a263', 'd575815a-f873-4b40-95e1-62bdf96d0e0f', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('90319a0f-b1e8-441f-badf-29da29dc6585', 'd575815a-f873-4b40-95e1-62bdf96d0e0f', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('0dd25209-6f3b-4286-8dc7-5779e6a62581', 'a0f609d1-3c68-48dc-afed-7ce98ef67c8c', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('d06d7ce8-0555-4a0b-84d2-666af4b8cc0d', 'a0f609d1-3c68-48dc-afed-7ce98ef67c8c', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('e2281bca-aee6-4b6f-8213-f770e2e15b24', 'a0f609d1-3c68-48dc-afed-7ce98ef67c8c', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('adfe37e4-74b4-42dc-a885-1c636333a5ca', 'f591721f-5274-4f00-a7fa-eec760708dcd', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('71b3eb05-d2c9-4c2b-9035-e5bcd659c982', 'f591721f-5274-4f00-a7fa-eec760708dcd', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('424e9579-26eb-4ede-9267-d158d206c02d', 'f591721f-5274-4f00-a7fa-eec760708dcd', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 100,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('273db9b7-ef42-46c2-900a-abd08dd88bb0', '29cab3e7-b919-4e76-9427-1abed999d214', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 150, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('a62ade61-6f42-4766-b585-2d0d2b86618d', '29cab3e7-b919-4e76-9427-1abed999d214', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 150, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('4e2bcf49-80c4-4aed-8602-f9288ad22193', '29cab3e7-b919-4e76-9427-1abed999d214', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 100, sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('479fa818-d0a3-4fe5-a862-887414e90e8c', '551b963f-27cd-4aac-a2e8-04809583ff08', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 250, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('23abd227-edc2-48f1-a2d2-f8021dca6c77', '551b963f-27cd-4aac-a2e8-04809583ff08', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('9c67ef3e-c95f-4e86-8447-1dcc8f9ced1b', '551b963f-27cd-4aac-a2e8-04809583ff08', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50, sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('43eb9b94-ce33-4d57-913b-ece435c4abad', 'bee9bec6-8656-4a77-8b2c-f0310456b3f6', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 250, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8db24ed2-97ce-4609-8685-66482d10b835', 'bee9bec6-8656-4a77-8b2c-f0310456b3f6', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('897a8414-8e2b-4e3c-9548-1baff9113ef8', 'bee9bec6-8656-4a77-8b2c-f0310456b3f6', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50, sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('813ac183-5530-4576-8b7c-8a39b1b71b37', '0525a212-d8ec-4418-923f-b856bc541338', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 250, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('370e9d5b-854c-43bd-8c1d-6343262ce3e4', '0525a212-d8ec-4418-923f-b856bc541338', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('e4491c46-c1be-4a8a-95fa-f4c68584c51d', '0525a212-d8ec-4418-923f-b856bc541338', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50, sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('7d2c6b7c-b9ff-4fd8-8237-12acd6330136', '9cd2614c-2002-4a30-ade1-92a7c38ca424', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 250, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('30945765-1b27-47a6-b44f-97bb24d97d4b', '9cd2614c-2002-4a30-ade1-92a7c38ca424', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('dfaf9a64-a6a3-4518-ad56-adc4cd3ce125', '9cd2614c-2002-4a30-ade1-92a7c38ca424', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50, sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('75d38957-218d-4f70-a829-a96a7a778def', '02c368af-6265-4d6e-a1fe-ad2ba960cd69', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 250, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('b21d391c-0811-4755-b1f4-7f08e89d01ca', '02c368af-6265-4d6e-a1fe-ad2ba960cd69', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('28798fd0-95f1-4d3f-b563-9a4758f876d7', '02c368af-6265-4d6e-a1fe-ad2ba960cd69', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50, sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('029c3d8c-9bbf-4366-bfd4-aa57eab2a32a', '57f91f13-6614-4ea0-aea3-7027515e8e55', '8de41197-dfb3-4f1a-93ed-2fb034b8ce87', '5345634501', 250, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('2ab44e7d-3ac8-4e68-9d74-a738bad8d76e', '57f91f13-6614-4ea0-aea3-7027515e8e55', '02fe5093-5581-4e6d-8bfe-48055add707c', '5345634502', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('6b2ef3f9-89cf-481b-aa14-aa1689d16dbd', '57f91f13-6614-4ea0-aea3-7027515e8e55', '0b21b364-b21c-4d06-914a-13089e063424', '5345634503', 50, sysdate(), sysdate());

/** Miller Family Account - Contains four members, Timothy, Sandra, Anna and Elsa **/

INSERT INTO membermgmtdb.account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('7c820beb-c01e-4332-9abf-926d61674dad','ZHIW6SA5CFTSKT8','HIX', 'ZLUD6R2Q3F0M42G','MARKETPLACE', sysdate(), sysdate());

/** Timothy Miller Details **/
INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('37d7b2a8-4dec-46bf-a6ce-298fdc4e5766','7c820beb-c01e-4332-9abf-926d61674dad','E67VLZIC7ECOOMD','Timothy', 'K', 'Miller','HOH', '1975-03-20 00:00:00','MALE',5.4,164.78, 'ZLUD6R2Q3F0M42G','MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b7d47dd7-bbfb-4835-b201-8fc2ff4a44c1', 'CQDLOWD86PE2TRR', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', 'RES', '15673 Rangeland Blvd', null, 'Atlanta', 'GA', '13121', '53453', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a4c934e8-d643-479c-9ba7-2aa90e6afdb0', 'BGTKFKVNPCOWT4K', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', 'MAIL', 'P.O Box 63456', null, 'Atlanta', 'GA', '13121', '79456', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('64bd00bb-5ce5-4dc5-beb6-ba42152dc92e','17GKJ1TNXK8JOLR', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766','MOBILE', '567-345-7347', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('81232747-e239-48e8-8b8c-a17afa1ea281', 'A18IKDILA36Q3VE', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', 'PERSONAL', '[email protected]', true, 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2370409e-8a29-4b34-a097-47aadbee18b2', 'I22839DN41KF0LO', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', 'WORK', '[email protected]', false, null,'ZEUS-UI', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2f7761bd-d91a-4ec5-95a5-5c2eac7734fa', '5ZXY6CRKRZE3CYI', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', 'SPOKEN', 'ENG', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b592bb6f-8cb3-4581-9e3b-bcaa6dada50a', 'X4YIOOBKW9J65ZC', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', 'WRITTEN', 'SPA', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('8280a701-8ef4-4187-87da-e71705835495', 'LRZ2YMHFCU9H7Y2', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', 'SSN', '845-12-7347', 'ZLUD6R2Q3F0M42G','MARKETPLACE', true, SYSDATE(), SYSDATE());


/** Sandra Miller Details **/

INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('14416c14-9c25-4bf3-bdb2-dcd73314a070','7c820beb-c01e-4332-9abf-926d61674dad','RGJ4IAGTP0YA2A3','Sandra', 'T', 'Miller', 'SPE', '1981-02-14 00:00:00','FEMALE',5.2,110.34, 'ZLUD6R2Q3F0M42G','MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('db611cf6-364d-4c5e-a6cc-284849b25936', 'UHWHKU1TKVHXYW2', '14416c14-9c25-4bf3-bdb2-dcd73314a070', 'RES', '8945 Main Street', 'Apt 303', 'Salem', 'MA', '25009', '78453', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('05474828-b111-4e02-94c9-1a464c1f4a77', 'OG04E8LHD98HPSK', '14416c14-9c25-4bf3-bdb2-dcd73314a070', 'MAIL', 'P.O Box 92345', null, 'Salem', 'MA', '25009', '79456', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('309510bb-544c-4a8e-9450-22edab6d9ecc','OG0MDMOQQVRIFVF', '14416c14-9c25-4bf3-bdb2-dcd73314a070','MOBILE', '567-236-8457', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2e4eeb0c-643e-4122-b1f8-ff3d28c3f58d', 'E72KYIQK1TAADMD', '14416c14-9c25-4bf3-bdb2-dcd73314a070', 'PERSONAL', '[email protected]', true, 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('e56f3e79-76c6-4156-88f0-7fd19c227627', 'FFOXHJSKKYPTMAB', '14416c14-9c25-4bf3-bdb2-dcd73314a070', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('c860b486-4cde-42fd-bc30-e0462fb84bfa', 'TF3LK3KK82H9ZMQ', '14416c14-9c25-4bf3-bdb2-dcd73314a070', 'SPOKEN', 'ENG', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('f0f0acb5-9fd6-4673-baee-b5f31888bc03', 'ZUVP68GAQ8XH2TC', '14416c14-9c25-4bf3-bdb2-dcd73314a070', 'WRITTEN', 'SPA', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('67d4dcf4-fad6-42e2-8fac-c18c1da3c85a', 'RK6VWJ7WXGIEZO1', '14416c14-9c25-4bf3-bdb2-dcd73314a070', 'SSN', '034-23-7327', 'ZLUD6R2Q3F0M42G','MARKETPLACE', true, SYSDATE(), SYSDATE());


/** Anna Miller Details **/
INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('4f63af0d-7e47-414a-bd73-e73bd87641d6','7c820beb-c01e-4332-9abf-926d61674dad','9BA4HYLCXLNDV13','Anna', 'A', 'Miller', 'CHD', '2000-06-15 00:00:00','FEMALE',5.2,104.94, 'ZLUD6R2Q3F0M42G','MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2372cf9a-84f3-4b52-8d07-ad7d52c267e2', 'V376V4YXJ5Z9EG9', '4f63af0d-7e47-414a-bd73-e73bd87641d6', 'RES', '8945 Main Street', 'Apt 303', 'Salem', 'MA', '25009', '78453', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('e9cf911d-61d5-44a5-9962-aeb05a6bb9b4', 'WDHTOKT1KM7866Z', '4f63af0d-7e47-414a-bd73-e73bd87641d6', 'MAIL', 'P.O Box 92345', null, 'Salem', 'MA', '25009', '79456', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('5cd6af86-bf51-4a78-92c4-833e3201f958', '1OV40UT2CGYTE9O', '4f63af0d-7e47-414a-bd73-e73bd87641d6','MOBILE', '577-246-8357', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('f4859f53-3969-4594-a587-4f802be4f2ba', 'W5MZI1D5W1CE49Z', '4f63af0d-7e47-414a-bd73-e73bd87641d6', 'PERSONAL', '[email protected]', true, 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('0709ac77-9edc-455b-972e-e9e91823daaf', 'A9NH01H8RTKS95V', '4f63af0d-7e47-414a-bd73-e73bd87641d6', 'WORK', '[email protected]', false, null,'ZEUS-UI', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('98eb9644-4d79-4bc8-ae35-7628dda00a1b', '3YK7XX7H1SCZ3DD', '4f63af0d-7e47-414a-bd73-e73bd87641d6', 'SPOKEN', 'ENG', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('46088e1f-7fc4-491f-8221-b967466617cc', '3SNUZXGYQVLV5FU', '4f63af0d-7e47-414a-bd73-e73bd87641d6', 'WRITTEN', 'SPA', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('eadbf83e-584b-49d3-b34f-fba7bcb94da6', 'SN10GQTJ0GY2WDT', '4f63af0d-7e47-414a-bd73-e73bd87641d6', 'SSN', '734-24-7334', 'ZLUD6R2Q3F0M42G','MARKETPLACE', true, SYSDATE(), SYSDATE());

/** Elsa Miller Details **/
INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('d44a7af9-f2c9-465d-abe0-03b645d9b331','7c820beb-c01e-4332-9abf-926d61674dad','12PF9HFVXFQ51BB','Elsa', 'I', 'Miller', 'CHD', '1998-07-12 00:00:00','FEMALE',5.4,111.76, 'ZLUD6R2Q3F0M42G','MARKETPLACE',SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('098a215c-ab00-4787-9f84-d8d03f1e16c1', 'I8QZFOYBBU516J4', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', 'RES', '8945 Main Street', 'Apt 303', 'Salem', 'MA', '25009', '78453', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('405fdbb6-5a57-4daa-b548-29a3135d5874', 'AHK6YUG7S67N57D', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', 'MAIL', 'P.O Box 92345', null, 'Salem', 'MA', '25009', '79456', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('789ec38d-5c18-4674-82a7-707db55c9dc0', 'FHJ5TKQY4A45PRP', 'd44a7af9-f2c9-465d-abe0-03b645d9b331','MOBILE', '545-736-2463', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-08 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('41a8ed9a-4c02-40df-bb2b-16705be48a06', '76EFEA5W772XU6W', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', 'PERSONAL', '[email protected]', true, 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('4ea5db4a-0c70-4c34-8d3b-f20f033c762f', 'I94U8FOE9HEAIC5', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', 'WORK', '[email protected]', false, null,'ZEUS-UI', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a65f6a0b-9e98-4f66-91f0-6db86e4e6caf', 'F5KGXVZV137R8KJ', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', 'SPOKEN', 'ENG', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('33da1a16-4b10-4a94-a329-5e6829fbb38a', 'SQCUNMEHCLUEUHP', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', 'WRITTEN', 'SPA', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '2020-11-10 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('4205f1bf-babd-426d-8921-d281f2dce28d', 'MNWZK43YM0Y7BG7', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', 'SSN', '347-63-2737', 'ZLUD6R2Q3F0M42G','MARKETPLACE', true, SYSDATE(), SYSDATE());


/** Enrollment and Premium spans associated with the Miller account **/


INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('99ca8481-cb3b-4b8e-a802-94647310f082', 'FZPEQJ67EHHJ7BP', '7c820beb-c01e-4332-9abf-926d61674dad', 'GA', 'FFM', 'MP_GA', 'ACTIVE', 'FAM', '2021-01-01 00:00:00', '2021-12-31 00:00:00', '26345734', '23562GA8923523', '36346346','HMO','2021-05-01 00:00:00','ENROLLED','MBS',null,'ZLUD6R2Q3F0M42G','MARKETPLACE', false, SYSDATE(),SYSDATE());
INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('d63b2860-7371-4ad7-939c-5cc5e0af2fe1', '6NLTEJ2883NDLJ7', '7c820beb-c01e-4332-9abf-926d61674dad', 'GA', 'FFM', 'MP_GA', 'ACTIVE', 'FAM', '2022-01-01 00:00:00', '2022-12-31 00:00:00', '26345734', '23562GA6023564', '63235635','HMO','2022-05-01 00:00:00','ENROLLED','MSB',null,'BM4KY8ROZIMWU43','MARKETPLACE', false, SYSDATE(),SYSDATE());

INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('dad77e1e-bfb3-4367-940f-0201857bd69c', 'HEJB5XUAP7F9XNE', 'ZLUD6R2Q3F0M42G','MARKETPLACE', '99ca8481-cb3b-4b8e-a802-94647310f082', '2021-01-01 00:00:00', '2021-02-28 00:00:00', 'ACTIVE', 1, '03', 400, 300, 100, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('59d17885-4a18-4ca2-b270-3bef4ed55f4f', '7NCPT9ZFIU5T2X6', 'YLT0EDSE9Z5XEI7','MARKETPLACE', '99ca8481-cb3b-4b8e-a802-94647310f082', '2021-03-01 00:00:00', '2021-08-31 00:00:00', 'ACTIVE', 2, '03', 400, 275, 125, 0, 20, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('c3f9d414-b47b-4639-a34f-5b5e48e34973', '6ENOJEGDD3TMWLR', 'IG1MFNL7AGLMNR4','MARKETPLACE', '99ca8481-cb3b-4b8e-a802-94647310f082', '2021-09-01 00:00:00', '2021-12-31 00:00:00', 'ACTIVE', 3, '03', 400, 325, 75, 0, 30, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('e2f0a63d-d74b-4642-a09e-9aeeb50d3843', 'FZMVI4RHM1QFBZY', 'BM4KY8ROZIMWU43','MARKETPLACE', 'd63b2860-7371-4ad7-939c-5cc5e0af2fe1', '2022-01-01 00:00:00', '2022-03-31 00:00:00', 'ACTIVE', 1, '03', 500, 300, 200, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('40b2dc62-25e9-4981-bfde-ddf2a8380962', 'BJGBEG6SFTS57NS', '4VRP1D5WMEM5V75','MARKETPLACE', 'd63b2860-7371-4ad7-939c-5cc5e0af2fe1', '2022-04-01 00:00:00', '2022-06-30 00:00:00', 'ACTIVE', 2, '03', 500, 350, 150, 0, 20, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('a41a0d91-a643-4101-b1e2-21c0b291a529', 'EJEMQXQ97PS3OY0', 'TUP2WP74OXM5TF2','MARKETPLACE', 'd63b2860-7371-4ad7-939c-5cc5e0af2fe1', '2022-07-01 00:00:00', '2022-10-31 00:00:00', 'ACTIVE', 3, '03', 500, 325, 175, 0, 20, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('4fce1156-457b-4003-be25-99d00561523f', '4YVH77GZW6R602U', 'R3NJVJTVRE41K8N','MARKETPLACE', 'd63b2860-7371-4ad7-939c-5cc5e0af2fe1', '2022-11-01 00:00:00', '2022-12-31 00:00:00', 'ACTIVE', 4, '03', 500, 375, 125, 0, 20, sysdate(),sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('fed5ad64-a9f1-4df6-ba8d-fdb8e5726a27', 'dad77e1e-bfb3-4367-940f-0201857bd69c', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', '2634573401', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c8180090-43a7-4c67-9beb-0c0aa36f1992', 'dad77e1e-bfb3-4367-940f-0201857bd69c', '14416c14-9c25-4bf3-bdb2-dcd73314a070', '2634573402', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('9ee3922e-e22a-4c2d-8b13-4efefe784083', 'dad77e1e-bfb3-4367-940f-0201857bd69c', '4f63af0d-7e47-414a-bd73-e73bd87641d6', '2634573403', 50,sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('fa48c7b5-6b71-41c9-aea6-acd87a754104', 'dad77e1e-bfb3-4367-940f-0201857bd69c', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', '2634573404', 50,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('bda250b2-2d41-4b73-b822-1baae6371d88', '59d17885-4a18-4ca2-b270-3bef4ed55f4f', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', '2634573401', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('ac53ac85-defe-438e-ae1b-e2939d813d61', '59d17885-4a18-4ca2-b270-3bef4ed55f4f', '14416c14-9c25-4bf3-bdb2-dcd73314a070', '2634573402', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('04027eaa-8004-4ed6-83ba-fdf347fa1c18', '59d17885-4a18-4ca2-b270-3bef4ed55f4f', '4f63af0d-7e47-414a-bd73-e73bd87641d6', '2634573403', 50,sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('243d7ddc-abde-4f62-81ab-b0d05646ffae', '59d17885-4a18-4ca2-b270-3bef4ed55f4f', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', '2634573404', 50,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('1dbb133e-9068-4a72-9dcb-ab02eb3b6541', 'c3f9d414-b47b-4639-a34f-5b5e48e34973', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', '2634573401', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('9c1b49de-49a1-4f79-a959-81f5c803bd07', 'c3f9d414-b47b-4639-a34f-5b5e48e34973', '14416c14-9c25-4bf3-bdb2-dcd73314a070', '2634573402', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('cd88f3a3-090d-4094-bd29-e143c0f5c096', 'c3f9d414-b47b-4639-a34f-5b5e48e34973', '4f63af0d-7e47-414a-bd73-e73bd87641d6', '2634573403', 50,sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('84b2f15d-a546-4bae-aa95-7e47fd66fd1a', 'c3f9d414-b47b-4639-a34f-5b5e48e34973', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', '2634573404', 50,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('692efe5a-52ba-4a04-9728-813f4d799422', 'e2f0a63d-d74b-4642-a09e-9aeeb50d3843', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', '2634573401', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('9370abc0-2421-4598-a13a-cdb366c9f84a', 'e2f0a63d-d74b-4642-a09e-9aeeb50d3843', '14416c14-9c25-4bf3-bdb2-dcd73314a070', '2634573402', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('696787c8-edc5-456d-bd42-2ae3530ba7bd', 'e2f0a63d-d74b-4642-a09e-9aeeb50d3843', '4f63af0d-7e47-414a-bd73-e73bd87641d6', '2634573403', 100,sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('9d184da9-f971-4e35-9d5f-195e85b88adc', 'e2f0a63d-d74b-4642-a09e-9aeeb50d3843', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', '2634573404', 100,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('0a8558b4-c3ce-4366-bc76-39bad19c16cf', '40b2dc62-25e9-4981-bfde-ddf2a8380962', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', '2634573401', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c3054552-5066-40b6-93b3-4b548381c519', '40b2dc62-25e9-4981-bfde-ddf2a8380962', '14416c14-9c25-4bf3-bdb2-dcd73314a070', '2634573402', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('23b7e08b-dd48-41c2-9290-c1303c673a82', '40b2dc62-25e9-4981-bfde-ddf2a8380962', '4f63af0d-7e47-414a-bd73-e73bd87641d6', '2634573403', 100,sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c5d827f0-9e7a-42ca-ae99-88ab7094cc1f', '40b2dc62-25e9-4981-bfde-ddf2a8380962', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', '2634573404', 100,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('46659d0e-576e-4913-b7e6-f2058f9ca7aa', 'a41a0d91-a643-4101-b1e2-21c0b291a529', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', '2634573401', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('fa0d39dd-4198-432e-83e6-f2f47f2a6233', 'a41a0d91-a643-4101-b1e2-21c0b291a529', '14416c14-9c25-4bf3-bdb2-dcd73314a070', '2634573402', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('f9b1e634-8835-4dae-95d4-6ea8f957d244', 'a41a0d91-a643-4101-b1e2-21c0b291a529', '4f63af0d-7e47-414a-bd73-e73bd87641d6', '2634573403', 100,sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('ffd68823-c131-4970-b59c-ae925a9a248d', 'a41a0d91-a643-4101-b1e2-21c0b291a529', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', '2634573404', 100,sysdate(), sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('688a90c4-e7aa-409f-8741-85fe36bc0045', '4fce1156-457b-4003-be25-99d00561523f', '37d7b2a8-4dec-46bf-a6ce-298fdc4e5766', '2634573401', 200, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8ee71ef6-2fdd-4153-b3d5-e3ed3fbe04d1', '4fce1156-457b-4003-be25-99d00561523f', '14416c14-9c25-4bf3-bdb2-dcd73314a070', '2634573402', 100, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('a5c5689c-1c7b-4c8a-8571-3fbe44c191bf', '4fce1156-457b-4003-be25-99d00561523f', '4f63af0d-7e47-414a-bd73-e73bd87641d6', '2634573403', 100,sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('9935dd9f-6256-4245-82f6-c08066fda042', '4fce1156-457b-4003-be25-99d00561523f', 'd44a7af9-f2c9-465d-abe0-03b645d9b331', '2634573404', 100,sysdate(), sysdate());

/** Anderson Family Account - Contains four members, Mason, Nyra, Logan and Della **/

INSERT INTO account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('8d5e9f70-a184-4984-afee-809fa6baa019','JLJW5XFC0GXP1GZ','HIX', 'OHOBW5A5QJELEXK', 'MARKETPLACE', sysdate(), sysdate());

/** Mason Anderson Details **/
INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('68152817-a26e-41f6-adc3-9dd8e2edc67b','8d5e9f70-a184-4984-afee-809fa6baa019','DB6KT2CPV4BNG0K','Mason', 'G', 'Anderson','HOH', '1965-02-05 00:00:00','MALE',5.7,175.23, 'OHOBW5A5QJELEXK', 'MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('6c3dfebb-8ad0-4737-91db-85a1b88a1cbe', 'PHSDU3L2WI1KEM9', '68152817-a26e-41f6-adc3-9dd8e2edc67b', 'RESIDENCE', '8346 Hanley Road', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a7c8a830-cb3c-4224-a71f-af3d2d180724', 'GXHCZ5J564MZ39X', '68152817-a26e-41f6-adc3-9dd8e2edc67b', 'MAIL', 'P.O Box 35353', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b7945c92-079e-4eef-9392-39f919f7ad96','VCGMAE9E749TFTA', '68152817-a26e-41f6-adc3-9dd8e2edc67b','MOBILE', '567-345-8347', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('f038566a-4101-478b-a9e3-234f32201bc4', 'KTAAXRLN4ZQ8R3N', '68152817-a26e-41f6-adc3-9dd8e2edc67b', 'PERSONAL', '[email protected]', true, 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('217ab8e4-36cb-4c1a-97f3-7210093baf42', '1G1BSSQFW0CPB0R', '68152817-a26e-41f6-adc3-9dd8e2edc67b', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2753bc68-7d59-4f9d-b83c-91c2d29e1da3', 'HZS52NBU3IOSCJ6', '68152817-a26e-41f6-adc3-9dd8e2edc67b', 'SPOKEN', 'ENG', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('afe0da79-ffa8-40db-a229-94eb589616b1', 'E030K9S4U4U07H6', '68152817-a26e-41f6-adc3-9dd8e2edc67b', 'WRITTEN', 'SPA', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('662a5d64-548d-4fce-b52e-a1e0156224d7', 'BBCQ3555GBWHKBX', '68152817-a26e-41f6-adc3-9dd8e2edc67b', 'SSN', '843-63-3645', 'OHOBW5A5QJELEXK', 'MARKETPLACE', true, sysdate(), sysdate());


/** Nyra Anderson Details **/

INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('411863a4-da9d-4f27-a6dd-c526d04ed5bb','8d5e9f70-a184-4984-afee-809fa6baa019','7P6XOKO7701Q6UN','Nyra', 'A', 'Anderson', 'SPE', '1968-07-23 00:00:00','FEMALE',5.4,120.56, 'OHOBW5A5QJELEXK', 'MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('59238383-363d-465b-941f-1d7c1becaf0f', 'Y6PTCKNBXDH2Z0I', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', 'RESIDENCE', '8346 Hanley Road', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('d0c1db5e-5701-4a14-9caa-2fc5ef6cde23', '1ZAAHECP3S0CLH6', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', 'MAIL', 'P.O Box 35353', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('49747398-4110-43e2-9631-106517ec81b2','PJ6QN6FODFOPC5I', '411863a4-da9d-4f27-a6dd-c526d04ed5bb','MOBILE', '567-236-8348', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('317864ef-bb93-4492-a10e-1811bcb402dc', 'O0CVEMAEPHGTLD1', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', 'PERSONAL', '[email protected]', true, 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('4dc170d7-df36-4ebb-bbb6-767991bd0c48', 'XHMT297URAJIJPS', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('3304db0d-d847-4de6-b9eb-5c79ae9c02ab', '8IYWKS6F73FYLEO', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', 'SPOKEN', 'ENG', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('20f79cee-05d2-4219-bf29-dd6335040936', 'GM98POTKYCVI0Q9', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', 'WRITTEN', 'SPA', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('3979e757-d61f-4fae-82ed-b5396d303969', '4H8Q7O2VXCW9DLJ', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', 'SSN', '436-24-6346', 'OHOBW5A5QJELEXK', 'MARKETPLACE', true, sysdate(), sysdate());


/** Logan Anderson Details **/
INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('3932e90a-a08e-4525-85a0-60a295c6f15d','8d5e9f70-a184-4984-afee-809fa6baa019','7LTZRXOZ3IDQTQ2','Logan', 'E', 'Anderson', 'CHD', '2000-06-15 00:00:00','MALE',5.1,105.43, 'OHOBW5A5QJELEXK', 'MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('dfb0798c-a6c6-40e1-b6d1-b9915c5cc0b8', 'YXZ5K9LFB2U8UKE', '3932e90a-a08e-4525-85a0-60a295c6f15d', 'RESIDENCE', '8346 Hanley Road', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('f1261a11-2e06-40a0-bd35-efcbd38c2757', 'MD6Q52PL8FQFFDK', '3932e90a-a08e-4525-85a0-60a295c6f15d', 'MAIL', 'P.O Box 35353', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a4e6ba35-d388-4263-b96f-063e86371d17', 'FCPQD6TK8HK1RBM', '3932e90a-a08e-4525-85a0-60a295c6f15d','MOBILE', '577-246-8349', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-08 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b0d292b5-eaef-4073-acef-c029782a7813', 'ANPE1FRSSQZZCJ9', '3932e90a-a08e-4525-85a0-60a295c6f15d', 'PERSONAL', '[email protected]', true, 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('f15eb507-2509-4012-b44a-bf62ee31d933', 'QTMGYFJ547YWOK5', '3932e90a-a08e-4525-85a0-60a295c6f15d', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('528df438-5656-4b88-bf1f-3c1a928ad844', 'YW3WUBVUJH877QL', '3932e90a-a08e-4525-85a0-60a295c6f15d', 'SPOKEN', 'ENG', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('88c09226-742a-4808-9bc7-5360c6e42b30', '7F185K876VKLW1L', '3932e90a-a08e-4525-85a0-60a295c6f15d', 'WRITTEN', 'SPA', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('ab162df5-b5e7-4839-bb94-c0bac2eab0b1', 'MY9S263JWB0RNRK', '3932e90a-a08e-4525-85a0-60a295c6f15d', 'SSN', '096-24-6246', 'OHOBW5A5QJELEXK', 'MARKETPLACE', true, sysdate(), sysdate());

/** Della Anderson Details **/
INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('e5b02550-2584-4431-8d3e-182fd24488f7','8d5e9f70-a184-4984-afee-809fa6baa019','JL1EH7RZ3EV7AQY','Della', 'K', 'Anderson', 'CHD', '1998-07-12 00:00:00','FEMALE',5.4,111.76, 'OHOBW5A5QJELEXK', 'MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('d2a4bb25-17b3-4fa7-bb82-8c75c6dc4b81', 'SPBDDV3WTMRLEFU', 'e5b02550-2584-4431-8d3e-182fd24488f7', 'RESIDENCE', '8346 Hanley Road', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('7453ea61-cec5-4ec5-b862-82261867749a', 'VJXMUFGYU9K0G3M', 'e5b02550-2584-4431-8d3e-182fd24488f7', 'MAIL', 'P.O Box 35353', null, 'Tampa', 'FL', '12057', '33616', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('d4420c14-894a-4a9c-9fb4-1bb0a9e931e9', '6GBAU8WB2IYTK25', 'e5b02550-2584-4431-8d3e-182fd24488f7','MOBILE', '545-736-8350', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-08 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('94d52e4f-2e9c-48ad-9e69-5024bd653cda', '3F0XDI9X51MPXIU', 'e5b02550-2584-4431-8d3e-182fd24488f7', 'PERSONAL', '[email protected]', true, 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('8d4a0f76-7a04-4d96-9564-2f18ecf7529c', 'UQAGV0ZLLSJJT62', 'e5b02550-2584-4431-8d3e-182fd24488f7', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b5b0a345-1a98-48da-9fd8-a644bf0e0f6b', 'G96LBO9ZIH8BQCJ', 'e5b02550-2584-4431-8d3e-182fd24488f7', 'SPOKEN', 'ENG', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('985c13d0-6313-4425-9a03-9607072911bf', 'HBO3J3C08DNVHZL', 'e5b02550-2584-4431-8d3e-182fd24488f7', 'WRITTEN', 'SPA', 'OHOBW5A5QJELEXK', 'MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('efbfec2e-69a0-4473-98a8-afec8cacb95d', 'X2QHYGENFOMN5DP', 'e5b02550-2584-4431-8d3e-182fd24488f7', 'SSN', '009-62-6246', 'OHOBW5A5QJELEXK', 'MARKETPLACE', true, sysdate(), sysdate());


/** Enrollment and Premium spans associated with the Anderson account **/


INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('cc02536b-6c99-4aa2-9def-8a6faaa43ec7', 'QE7IPD9HS444ZIK', '8d5e9f70-a184-4984-afee-809fa6baa019', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2022-01-01 00:00:00', '2022-12-31 00:00:00', '94577857', '89355FL0234597', '84567485','HMO','2021-12-15 00:00:00','ENROLLED','OHOBW5A5QJELEXK', 'MARKETPLACE', false, sysdate(),sysdate());
INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('305ee973-f032-47df-9116-c3adf9d3103e', '669MM0S9D068XXO', '8d5e9f70-a184-4984-afee-809fa6baa019', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2023-01-01 00:00:00', '2023-06-30 00:00:00', '94577857', '89355FL0234598', '04584786','HMO','2022-12-25 00:00:00','ENROLLED','DQY1C725PJ086D1', 'MARKETPLACE', false, sysdate(),sysdate());

INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type,  coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('43009423-7052-4457-8987-26c79de74323', 'K2PO9LXOBNYJ1YX', '8d5e9f70-a184-4984-afee-809fa6baa019', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2023-07-01 00:00:00', '2023-08-31 00:00:00', '94577857', '89355FL0234599', '94584784','HMO','2023-06-10 00:00:00','ENROLLED','4FVTN9JRDUHG0Q0', 'MARKETPLACE', false, sysdate(),sysdate());
INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type,  coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('ea3ee1da-1017-4260-8ea0-5a21ee59c13e', 'XX8PWLSVBP4ADJ9', '8d5e9f70-a184-4984-afee-809fa6baa019', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2023-09-01 00:00:00', '2023-12-31 00:00:00', '94577857', '89355FL0234600', '39467568','HMO','2023-08-13 00:00:00','ENROLLED','H3IFIF0IHFHJU2T', 'MARKETPLACE', false, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('9187f14c-68d5-44d4-8990-35bb67feb417', '9TMVNC1Z8T1Z8PW', 'OHOBW5A5QJELEXK', 'MARKETPLACE', 'cc02536b-6c99-4aa2-9def-8a6faaa43ec7', '2022-01-01 00:00:00', '2022-02-28 00:00:00', 'ACTIVE', 1, '03', 400, 300, 100, 0, 10, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('b999d5cf-5d7c-42f1-a794-443d53ff6feb', 'DEPBG0EC4L8Y63Z', 'A48I71Z089TQPYW', 'MARKETPLACE', 'cc02536b-6c99-4aa2-9def-8a6faaa43ec7', '2022-03-01 00:00:00', '2022-08-31 00:00:00', 'ACTIVE', 2, '03', 400, 275, 125, 0, 20, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('e4e360a6-7122-4595-bc2d-c8520c17997c', 'OU282KB5VBP6PZN', 'GCNGAFNI6BFLDFK', 'MARKETPLACE', 'cc02536b-6c99-4aa2-9def-8a6faaa43ec7', '2022-09-01 00:00:00', '2022-12-31 00:00:00', 'ACTIVE', 3, '03', 400, 325, 75, 0, 30, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('eec3260b-1baa-4163-8035-d5ea5b9e0a3b', 'G59ZY263FYYFZYS', 'DQY1C725PJ086D1', 'MARKETPLACE', '305ee973-f032-47df-9116-c3adf9d3103e', '2023-01-01 00:00:00', '2023-02-28 00:00:00', 'ACTIVE', 1, '03', 500, 300, 200, 0, 10, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('92dce632-93d4-4646-a1ef-898e94df8731', 'BROCSZQ5W3FOYVS', '6II14EQKUKPQPVR', 'MARKETPLACE', '305ee973-f032-47df-9116-c3adf9d3103e', '2023-03-01 00:00:00', '2023-03-31 00:00:00', 'ACTIVE', 2, '03', 500, 350, 150, 0, 20, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('7ede557e-0096-4ca3-870c-da79b3cca385', 'LX63XWFZDGEF6JI', 'S4NW6KBUNEITF4Z', 'MARKETPLACE', '305ee973-f032-47df-9116-c3adf9d3103e', '2023-04-01 00:00:00', '2023-05-31 00:00:00', 'ACTIVE', 3, '03', 500, 325, 175, 0, 20, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('19eb6004-d401-4633-aa86-344888be7e32', '05CKLG01KO3WBP2', 'BQ6ZL7E8L9ABTZO', 'MARKETPLACE', '305ee973-f032-47df-9116-c3adf9d3103e', '2023-06-01 00:00:00', '2023-06-30 00:00:00', 'ACTIVE', 4, '03', 500, 375, 125, 0, 20, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('6424f03c-30d7-4000-9b68-0fa5e6c88387', '6S5OP7BWC249J33', '4FVTN9JRDUHG0Q0', 'MARKETPLACE', '43009423-7052-4457-8987-26c79de74323', '2023-07-01 00:00:00', '2023-08-31 00:00:00', 'ACTIVE', 1, '03', 500, 325, 175, 0, 20, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('0f68f3a3-4ef6-46e9-9f4b-357d9dd25599', '9YOCNCGKGUAPIZL', 'H3IFIF0IHFHJU2T', 'MARKETPLACE', 'ea3ee1da-1017-4260-8ea0-5a21ee59c13e', '2023-09-01 00:00:00', '2023-12-31 00:00:00', 'ACTIVE', 1, '03', 500, 375, 125, 0, 20, sysdate(),sysdate());


INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('712ea1c8-e942-4961-b300-722054c38c67', '9187f14c-68d5-44d4-8990-35bb67feb417', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 200, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('77229842-0979-48bb-9ad9-9d4ca1b56670', '9187f14c-68d5-44d4-8990-35bb67feb417', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 100,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8790b9ce-a2ed-47e5-903e-43d18ba8af73', '9187f14c-68d5-44d4-8990-35bb67feb417', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('e738eb26-e1c7-4d83-a94e-4a5fa59d4965', 'b999d5cf-5d7c-42f1-a794-443d53ff6feb', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 200, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8d8fe56b-1c30-4623-960d-4849e5d05eac', 'b999d5cf-5d7c-42f1-a794-443d53ff6feb', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 100,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c762e122-5747-41b5-ba62-b403c352a8bd', 'b999d5cf-5d7c-42f1-a794-443d53ff6feb', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('a3696665-8632-4067-8320-13ee0344c091', 'e4e360a6-7122-4595-bc2d-c8520c17997c', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 200, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('26ce8525-22c5-4139-ac10-61a9e5f7490c', 'e4e360a6-7122-4595-bc2d-c8520c17997c', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 100,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8435894a-ecaf-4502-b942-e87e089fefc0', 'e4e360a6-7122-4595-bc2d-c8520c17997c', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8edb1d68-f0e5-4b62-b55b-22ff4d92d70d', 'eec3260b-1baa-4163-8035-d5ea5b9e0a3b', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('3d240afe-302d-475d-a01d-a7b921b2d6de', 'eec3260b-1baa-4163-8035-d5ea5b9e0a3b', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('399f1ee8-015a-4d33-968a-ad0a78196a22', 'eec3260b-1baa-4163-8035-d5ea5b9e0a3b', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('25faa506-3eca-47be-8b4f-058a0e2534a7', '92dce632-93d4-4646-a1ef-898e94df8731', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('2c284e45-4e33-4a95-8fb4-460916a98cce', '92dce632-93d4-4646-a1ef-898e94df8731', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('619a66c3-0b02-4001-b220-ae538f98128f', '92dce632-93d4-4646-a1ef-898e94df8731', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('2794054c-ac2d-4569-86b4-555d4b95db39', '7ede557e-0096-4ca3-870c-da79b3cca385', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('68789846-05b7-49f9-9853-a22c23b3242a', '7ede557e-0096-4ca3-870c-da79b3cca385', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('05d35702-57e5-471c-ade4-352615e166b2', '7ede557e-0096-4ca3-870c-da79b3cca385', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('58601608-9b72-4643-871d-6dc82b07cb88', '19eb6004-d401-4633-aa86-344888be7e32', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('342a9c52-32b9-475e-97e0-1865a9b059d5', '19eb6004-d401-4633-aa86-344888be7e32', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('67f7a870-80ad-4d73-88d7-28f648f6edcb', '19eb6004-d401-4633-aa86-344888be7e32', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('1f100083-fe62-440b-be20-ee12f7a7a2cb', '6424f03c-30d7-4000-9b68-0fa5e6c88387', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('1c7b4816-9929-4db2-9228-3f2a19c62900', '6424f03c-30d7-4000-9b68-0fa5e6c88387', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('39f0e22c-b5cb-4a9a-a958-b7ec30576f28', '6424f03c-30d7-4000-9b68-0fa5e6c88387', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('a196f10a-d69f-4757-934e-8167be6f06da', '0f68f3a3-4ef6-46e9-9f4b-357d9dd25599', '411863a4-da9d-4f27-a6dd-c526d04ed5bb', '9457785702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8e7f61d1-3a6e-4df2-8a27-b23ec10c6328', '0f68f3a3-4ef6-46e9-9f4b-357d9dd25599', '3932e90a-a08e-4525-85a0-60a295c6f15d', '9457785703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('1fc5d619-aeef-4231-a147-b81dfd3e71d3', '0f68f3a3-4ef6-46e9-9f4b-357d9dd25599', 'e5b02550-2584-4431-8d3e-182fd24488f7', '9457785704', 100,sysdate(), sysdate());

/** Lewis Family Account - Contains four members, Eli, Maya, Kai and Ruby **/

INSERT INTO account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('d3839c1c-de45-43c5-8023-58591b76d0f1','T1TRHS49PK42IAZ','HIX', 'N1K0C357M0TAXXK','MARKETPLACE', sysdate(), sysdate());

/** Eli Lewis Details **/
INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('5451cde0-2419-4efa-bf40-2c242fb5a6fe','d3839c1c-de45-43c5-8023-58591b76d0f1','VZS76630WQNUWAY','Eli', 'M', 'Lewis','HOH', '1973-04-24 00:00:00','MALE',5.4,165.34, 'N1K0C357M0TAXXK','MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('53b31e50-d4e8-41ef-96c1-d2cd9fcd2256', '1PZA0NKTMUER079', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', 'RESIDENCE', '834 Hillsborough Ave', null, 'Tampa', 'FL', '12057', '33646', 'N1K0C357M0TAXXK','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('ff1247e7-fcb5-41a3-a2ee-355a10a9be0b', '56NECLHB44H61ZC', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', 'MAIL', 'P.O Box 85485', null, 'Tampa', 'FL', '12057', '33646', 'N1K0C357M0TAXXK','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('327efb5c-e87c-4c65-a2a4-1f479b63a7f2','CHK58H3GIELRU72', '5451cde0-2419-4efa-bf40-2c242fb5a6fe','MOBILE', '567-236-9636', 'N1K0C357M0TAXXK','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('c41ec3d1-ca26-494c-a67a-70b29e502de6', '4ZVA4E0JHV9MJHO', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', 'PERSONAL', '[email protected]', true, 'N1K0C357M0TAXXK','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('5dd88af6-b1ce-4b64-a3c0-ec24f5eea869', '9KCYXRVEAHS37PU', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', 'WORK', '[email protected]', false, null,'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('64b1826a-df3c-4d46-90b2-8ad247f74f6c', 'MRXE51UXDSFF2WD', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', 'SPOKEN', 'ENG', 'N1K0C357M0TAXXK','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('6aad83f6-949d-4fc7-9e6e-b2c3c379abc8', '1U47T03GFUIJB5Z', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', 'WRITTEN', 'SPA', 'N1K0C357M0TAXXK','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('9f331746-a389-430f-912c-e1701528e91f', 'HIQFS7STXRR0BK5', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', 'SSN', '045-74-7374', 'N1K0C357M0TAXXK','MARKETPLACE', true, sysdate(), sysdate());


/** Maya Lewis Details **/

INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('d7f11156-7bfa-4648-8e69-a6bc45186be1','d3839c1c-de45-43c5-8023-58591b76d0f1','3K8FAI38HNQEC02','Maya', 'D', 'Lewis', 'SPE', '1975-05-15 00:00:00','FEMALE',5.1,115.35, 'IOP52040ETXAO1N','MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('ffe3e897-f585-4b16-a9a1-e683d7bc1aa6', 'OULNZ91S0EN95LW', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', 'RESIDENCE', '834 Hillsborough Ave', null, 'Tampa', 'FL', '12057', '33646', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('7552e96e-4693-4de8-83ba-62434a349c2a', 'X3WT65ZM0P6LYAS', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', 'MAIL', 'P.O Box 85485', null, 'Tampa', 'FL', '12057', '33646', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2ed4b9d5-92d1-4d28-b9c0-398ea6970e6a','BAKDPFWLUFV4UH9', 'd7f11156-7bfa-4648-8e69-a6bc45186be1','MOBILE', '567-236-9637', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('8fbfb7af-4547-47f2-afb7-ce92965321b1', 'MGH5IIV4JXLJG7H', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', 'PERSONAL', '[email protected]', true, 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('59e15fe6-1e68-4850-94ed-06cd99bc32c8', 'GS4I6LTWFT8V88U', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', 'WORK', '[email protected]', false, null,'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('75435ea8-2430-495c-ba73-f4c0c0cf5853', 'MQQJ4Q27VJD9S9F', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', 'SPOKEN', 'ENG', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('3c392e42-d8d9-4f0f-a82a-d03825114488', 'DZ35WIH1QY0ZFF2', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', 'WRITTEN', 'SPA', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('71b06980-01a7-4313-9414-97f5e94ada52', 'GN5W5LLPHXN4C35', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', 'SSN', '527-73-2576', 'IOP52040ETXAO1N','MARKETPLACE', true, sysdate(), sysdate());


/** Kai Lewis Details **/
INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('77e2678e-4919-4480-8243-d4c8b4d262b6','d3839c1c-de45-43c5-8023-58591b76d0f1','O4E5UOK5XC8DPKU','Kai', 'L', 'Lewis', 'CHD', '1998-07-23 00:00:00','MALE',5.9,155.53, 'IOP52040ETXAO1N','MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('22f4c57e-2b58-4501-95a3-c70971eb29af', 'IKDUUDZEN3VV3L6', '77e2678e-4919-4480-8243-d4c8b4d262b6', 'RESIDENCE', '834 Hillsborough Ave', null, 'Tampa', 'FL', '12057', '33646', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a6cc7acd-8e42-45a8-848f-f918702363ca', 'D4KKC5O9QVC3HWF', '77e2678e-4919-4480-8243-d4c8b4d262b6', 'MAIL', 'P.O Box 85485', null, 'Tampa', 'FL', '12057', '33646', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('b85122fb-9bbc-4cf2-ac7a-de127a660d50', 'BK85YY1TR2C0FTZ', '77e2678e-4919-4480-8243-d4c8b4d262b6','MOBILE', '567-236-9638', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-08 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('7e740b70-0e27-44c5-a2c0-7804b466e70b', 'WBLYNSH4OU6DQF5', '77e2678e-4919-4480-8243-d4c8b4d262b6', 'PERSONAL', '[email protected]', true, 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('91f7f147-e2e8-424b-8f80-b7736bdb6e9e', 'Z6TQIFWHXMYYZ4Q', '77e2678e-4919-4480-8243-d4c8b4d262b6', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('c764c6bc-2db9-42cd-8ae5-a71cbc6144a5', 'FU7RSWY37BX4J5X', '77e2678e-4919-4480-8243-d4c8b4d262b6', 'SPOKEN', 'ENG', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('f1242d9f-2dac-4da6-8dfc-de2084a0fad3', 'P6ZL4ZZERVZGPH1', '77e2678e-4919-4480-8243-d4c8b4d262b6', 'WRITTEN', 'SPA', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('187cd737-80d7-403a-8044-a9f138af074c', 'QF6KQXR9GJ6GSY8', '77e2678e-4919-4480-8243-d4c8b4d262b6', 'SSN', '626-64-6264', 'IOP52040ETXAO1N','MARKETPLACE', true, sysdate(), sysdate());

/** Ruby Lewis Details **/
INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('beecf9e2-3137-40a5-823b-73b029e45fa2','d3839c1c-de45-43c5-8023-58591b76d0f1','4KE6IWEWMCIFIUD','Ruby', 'D', 'Lewis', 'CHD', '1999-05-24 00:00:00','FEMALE',5.1,116.83, 'IOP52040ETXAO1N','MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('dfb5326a-f1d8-4fd4-96ed-79fc6f23c577', 'ZTU04SO2KCIKLNF', 'beecf9e2-3137-40a5-823b-73b029e45fa2', 'RESIDENCE', '834 Hillsborough Ave', null, 'Tampa', 'FL', '12057', '33646', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('4a9847df-72d0-414c-a520-f4a5b747314e', '2OL2G1G7UDKO7TM', 'beecf9e2-3137-40a5-823b-73b029e45fa2', 'MAIL', 'P.O Box 85485', null, 'Tampa', 'FL', '12057', '33646', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a813cff9-c445-4e80-9de1-25b7f38a0aa8', 'QCQ4FKHDX8NRR3S', 'beecf9e2-3137-40a5-823b-73b029e45fa2','MOBILE', '567-236-9639', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-08 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('cff97101-544a-475e-bfea-8439af176cfb', 'DWW5IQBT4XS9IOO', 'beecf9e2-3137-40a5-823b-73b029e45fa2', 'PERSONAL', '[email protected]', true, 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary,  ztcn, source,start_date, end_date, created_date, updated_date) VALUES ('adf29f3e-fd15-4b45-86fe-1e852a7ed328', '5FOLZK0HDNDKN3P', 'beecf9e2-3137-40a5-823b-73b029e45fa2', 'WORK', '[email protected]', false, null,'ZEUS-UI', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('0c0bcf76-eab5-4d6a-a0cb-208b048a0990', '5YR5PH3GX4DJLMP', 'beecf9e2-3137-40a5-823b-73b029e45fa2', 'SPOKEN', 'ENG', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('dd943440-9387-4c68-9988-0c218fb960ad', 'C5NSDFTYEIK9XUF', 'beecf9e2-3137-40a5-823b-73b029e45fa2', 'WRITTEN', 'SPA', 'IOP52040ETXAO1N','MARKETPLACE', '2020-11-10 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('261a8915-d4d5-4143-856f-e01f5e1caa09', '2ZDZM75QJOTSZR4', 'beecf9e2-3137-40a5-823b-73b029e45fa2', 'SSN', 'IOP52040ETXAO1N','MARKETPLACE', '746-46-2746', true, sysdate(), sysdate());


/** Enrollment and Premium spans associated with the Lewis account **/

/** Family Enrollment spans **/
INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('2fe39d9c-fb6d-4fce-84c9-67c415a6d7c5', 'SZYP1OH8FCA18UW', 'd3839c1c-de45-43c5-8023-58591b76d0f1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2022-01-01 00:00:00', '2022-12-31 00:00:00', '05474667', '89355FL0234605', '63467345','HMO','2021-12-15 00:00:00','ENROLLED','N1K0C357M0TAXXK','MARKETPLACE', false, sysdate(),sysdate());

INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('1f9ec427-752b-4456-962c-e6799283335d', 'F6SNVSAIJ3JSMR8', 'd3839c1c-de45-43c5-8023-58591b76d0f1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2023-01-01 00:00:00', '2023-06-30 00:00:00', '05474667', '89355FL0234606', '84564357','HMO','2022-12-25 00:00:00','ENROLLED','R5T9RQTCS3O0RY4','MARKETPLACE', false, sysdate(),sysdate());
INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('a0d7fb98-89e4-486e-b849-3f8e17f96f18', 'PA2QSC173TXPVDC', 'd3839c1c-de45-43c5-8023-58591b76d0f1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2023-07-01 00:00:00', '2023-12-31 00:00:00', '05474667', '89355FL0234607', '83356785','HMO','2022-12-25 00:00:00','ENROLLED','OWYVC5MFR7XPZH6','MARKETPLACE', false, sysdate(),sysdate());

/** Dependent Coverage Only Enrollment spans **/
INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('ee0d022f-1f21-492e-ba48-4912577155cc', 'Z8VTEB7S1SMV53P', 'd3839c1c-de45-43c5-8023-58591b76d0f1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2022-01-01 00:00:00', '2022-12-31 00:00:00', '05474667', '89355FL0234597', '34563457','HMO','2021-12-15 00:00:00','ENROLLED','IOP52040ETXAO1N','MARKETPLACE', false, sysdate(),sysdate());

INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('77416113-bef6-497b-b1d8-827d5f16a524', 'FN1KWZTORHT4ZZO', 'd3839c1c-de45-43c5-8023-58591b76d0f1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2023-01-01 00:00:00', '2023-06-30 00:00:00', '05474667', '89355FL0234598', '73463556','HMO','2022-12-25 00:00:00','ENROLLED','MOUD29N8Y0CBPUL','MARKETPLACE', false, sysdate(),sysdate());
INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('d2616506-aa9a-49fa-9f32-68d6c3bdfcf7', 'PE4ZIQPGSZIEBLK', 'd3839c1c-de45-43c5-8023-58591b76d0f1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2023-07-01 00:00:00', '2023-08-31 00:00:00', '05474667', '89355FL0234599', '73578534','HMO','2023-06-10 00:00:00','ENROLLED','XEMQFIF7JMLD3Q9','MARKETPLACE', false, sysdate(),sysdate());
INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('564f29f8-bac1-4e91-a936-89d18b78d7ec', 'ERKTYGOWBOF92O6', 'd3839c1c-de45-43c5-8023-58591b76d0f1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'DEP', '2023-09-01 00:00:00', '2023-12-31 00:00:00', '05474667', '89355FL0234600', '95456746','HMO','2023-08-13 00:00:00','ENROLLED','ITS2JSTOBOQREPW','MARKETPLACE', false, sysdate(),sysdate());

/** Family Coverage Premium Spans **/

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('9e0386d4-02b4-4d32-af10-17f788290fbb', 'R7PQ4WS4UUG97J0', 'N1K0C357M0TAXXK', 'MARKETPLACE','2fe39d9c-fb6d-4fce-84c9-67c415a6d7c5', '2022-01-01 00:00:00', '2022-12-31 00:00:00', 'ACTIVE', 1, '03', 150, 150, 0, 0, 10, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('dd6f8e55-b8a9-4ae4-9d30-0d5e536dd5a7', 'B8S4BBHWUOCFP3X', 'R5T9RQTCS3O0RY4', 'MARKETPLACE', '1f9ec427-752b-4456-962c-e6799283335d', '2023-01-01 00:00:00', '2023-06-30 00:00:00', 'ACTIVE', 1, '03', 150, 150, 0, 0, 20, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('aa27b884-d4a8-4bae-8710-5f8cfd794f95', 'Z0XPP8MISWW8SAJ', 'OWYVC5MFR7XPZH6', 'MARKETPLACE','a0d7fb98-89e4-486e-b849-3f8e17f96f18', '2023-07-01 00:00:00', '2023-10-31 00:00:00', 'ACTIVE', 1, '03', 150, 150, 0, 0, 30, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('e2c5ec82-7f7f-4d5f-8880-e0156956ffbd', 'XWPQFXMEX2BLMX1', '2TWGYQDZA08ZFO4', 'MARKETPLACE','a0d7fb98-89e4-486e-b849-3f8e17f96f18', '2023-11-01 00:00:00', '2023-12-31 00:00:00', 'ACTIVE', 2, '03', 150, 150, 0, 0, 30, sysdate(),sysdate());

/** Dependent Only Coverage Premium Spans **/
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('e8c4a64e-567a-47dc-ae4b-200d97774ab1', '1BKCG0VSGOY8Q5N', 'IOP52040ETXAO1N', 'MARKETPLACE','ee0d022f-1f21-492e-ba48-4912577155cc', '2022-01-01 00:00:00', '2022-02-28 00:00:00', 'ACTIVE', 1, '03', 400, 300, 100, 0, 10, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('126f9d3a-0478-4579-9caa-047a2ca8ee32', '2O210V9XZLVGLZG', 'QKWHOJLGFCRV67J', 'MARKETPLACE','ee0d022f-1f21-492e-ba48-4912577155cc', '2022-03-01 00:00:00', '2022-08-31 00:00:00', 'ACTIVE', 2, '03', 400, 275, 125, 0, 20, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('561ea3ad-1e6b-4db7-b9c8-ed3745939ebb', 'SWZAE942CIOZOCC', 'FM1BNFBKAQ8IH30', 'MARKETPLACE','ee0d022f-1f21-492e-ba48-4912577155cc', '2022-09-01 00:00:00', '2022-12-31 00:00:00', 'ACTIVE', 3, '03', 400, 325, 75, 0, 30, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('9aebed1b-83d8-46c3-8d97-ca3b2f8bb099', 'F79VT2GKXEK2U10', 'MOUD29N8Y0CBPUL', 'MARKETPLACE','77416113-bef6-497b-b1d8-827d5f16a524', '2023-01-01 00:00:00', '2023-02-28 00:00:00', 'ACTIVE', 1, '03', 500, 300, 200, 0, 10, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('c60308a3-c684-460d-a6ce-fa0454231977', 'Y3YXZ7U4T5IHZE4', 'XCT9ZL7J3MTKU0X', 'MARKETPLACE','77416113-bef6-497b-b1d8-827d5f16a524', '2023-03-01 00:00:00', '2023-03-31 00:00:00', 'ACTIVE', 2, '03', 500, 350, 150, 0, 20, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('d0ca0be0-5cad-47e3-8580-efc1abef50de', 'LZT23U85NN30H9B', 'MJWJEF5PWIHDGH5', 'MARKETPLACE','77416113-bef6-497b-b1d8-827d5f16a524', '2023-04-01 00:00:00', '2023-05-31 00:00:00', 'ACTIVE', 3, '03', 500, 325, 175, 0, 20, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('a566c032-a56a-4747-8fce-ee81e9333001', '2FPRM6UWRKIFZLI', 'JI37MZWZMJ9C4JE', 'MARKETPLACE','77416113-bef6-497b-b1d8-827d5f16a524', '2023-06-01 00:00:00', '2023-06-30 00:00:00', 'ACTIVE', 4, '03', 500, 375, 125, 0, 20, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('01dd80b7-f3fe-468b-ac91-94d1ec8689a0', '34JQ5CDHMUWEOQX', 'XEMQFIF7JMLD3Q9', 'MARKETPLACE','d2616506-aa9a-49fa-9f32-68d6c3bdfcf7', '2023-07-01 00:00:00', '2023-08-31 00:00:00', 'ACTIVE', 1, '03', 500, 325, 175, 0, 20, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('7c9ea538-f2bc-4849-917c-4595fba5a4b4', 'OG6GX5PUZFYQA4B', 'ITS2JSTOBOQREPW', 'MARKETPLACE','564f29f8-bac1-4e91-a936-89d18b78d7ec', '2023-09-01 00:00:00', '2023-12-31 00:00:00', 'ACTIVE', 1, '03', 500, 375, 125, 0, 20, sysdate(),sysdate());

/** Family Coverage Member Premiums **/

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('b720cc8f-7be2-4ec0-a9b9-e4fc02caa02d', '9e0386d4-02b4-4d32-af10-17f788290fbb', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', '0547466701', 150, sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('1f2650b5-da8d-4119-84dd-f01fd8547f96', 'dd6f8e55-b8a9-4ae4-9d30-0d5e536dd5a7', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', '0547466701', 150,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('3e223eba-dd74-4366-97e1-3dd15b795a9d', 'aa27b884-d4a8-4bae-8710-5f8cfd794f95', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', '0547466701', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('67659a53-a098-4df9-acfb-0abf9e4cba86', 'e2c5ec82-7f7f-4d5f-8880-e0156956ffbd', '5451cde0-2419-4efa-bf40-2c242fb5a6fe', '0547466701', 150,sysdate(), sysdate());

/** Dependent Coverage Member Premiums **/
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('90995b8e-804d-4e60-97ff-ea3d5ed22c01', 'e8c4a64e-567a-47dc-ae4b-200d97774ab1', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 200, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('1231b1fd-51b1-44bf-bffc-842c1c9435fd', 'e8c4a64e-567a-47dc-ae4b-200d97774ab1', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 100,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('f00c4c02-b50e-4fff-bccd-78f21c207b44', 'e8c4a64e-567a-47dc-ae4b-200d97774ab1', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c8d0bb18-78e3-4898-a137-c7c1a7f35d00', '126f9d3a-0478-4579-9caa-047a2ca8ee32', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 200, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('6cff1a7e-6b65-49bd-97ba-8651ec31696b', '126f9d3a-0478-4579-9caa-047a2ca8ee32', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 100,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('129def9d-402a-43c5-b8fd-93ffba9bf571', '126f9d3a-0478-4579-9caa-047a2ca8ee32', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('7a027458-1550-4144-8811-c8b02317067a', '561ea3ad-1e6b-4db7-b9c8-ed3745939ebb', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 200, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('894ed242-9d2d-42c6-8a12-290941786233', '561ea3ad-1e6b-4db7-b9c8-ed3745939ebb', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 100,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('5197847b-7b8a-4df5-901a-0977c6737f94', '561ea3ad-1e6b-4db7-b9c8-ed3745939ebb', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('14201f0e-c1e9-45f3-ba26-68d3f09f420b', '9aebed1b-83d8-46c3-8d97-ca3b2f8bb099', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('7016325b-8a5f-49e7-ac69-3478f63ed4ab', '9aebed1b-83d8-46c3-8d97-ca3b2f8bb099', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('a5a0f3b8-300f-4abd-be48-bc79020c2e7d', '9aebed1b-83d8-46c3-8d97-ca3b2f8bb099', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('8a6fe184-b598-4134-99e0-aafedf8aefb4', 'c60308a3-c684-460d-a6ce-fa0454231977', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('667a5504-3b3c-4a14-b57b-8f767baed04e', 'c60308a3-c684-460d-a6ce-fa0454231977', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('218c6288-8762-4039-9e50-2118239634d5', 'c60308a3-c684-460d-a6ce-fa0454231977', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('bc673b55-7154-46f6-8d6e-0365ba56d504', 'd0ca0be0-5cad-47e3-8580-efc1abef50de', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('de31fc44-4630-4a43-9c65-05aa03d278f1', 'd0ca0be0-5cad-47e3-8580-efc1abef50de', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('3394d02d-9355-49e6-936f-2a98910a1764', 'd0ca0be0-5cad-47e3-8580-efc1abef50de', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('31e610a8-364c-45d2-9312-f840e8d59cf3', 'a566c032-a56a-4747-8fce-ee81e9333001', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('126b0843-d1d9-4b79-8a40-a28ab615430e', 'a566c032-a56a-4747-8fce-ee81e9333001', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('f6ff3633-76f2-4013-b41e-d48df4bfd1ab', 'a566c032-a56a-4747-8fce-ee81e9333001', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('bb8b2a4b-1bdf-4652-85af-56c016952482', '01dd80b7-f3fe-468b-ac91-94d1ec8689a0', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('de749609-d668-4a82-8c63-07f89072f110', '01dd80b7-f3fe-468b-ac91-94d1ec8689a0', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('d5c00ffb-0d2e-47c9-a248-ea4b90f66b81', '01dd80b7-f3fe-468b-ac91-94d1ec8689a0', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('bb951b3d-a35d-4b91-ae86-d0801cd4c495', '7c9ea538-f2bc-4849-917c-4595fba5a4b4', 'd7f11156-7bfa-4648-8e69-a6bc45186be1', '0547466702', 250, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c313647f-ad32-4a2f-a8ab-567c850c6cad', '7c9ea538-f2bc-4849-917c-4595fba5a4b4', '77e2678e-4919-4480-8243-d4c8b4d262b6', '0547466703', 150,sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('53e4603e-711e-4efe-9bb9-156da965b688', '7c9ea538-f2bc-4849-917c-4595fba5a4b4', 'beecf9e2-3137-40a5-823b-73b029e45fa2', '0547466704', 100,sysdate(), sysdate());

/** Lincoln King Account details **/

INSERT INTO account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('bd6fff28-cad7-475f-b082-aa440924e549','K0S0NELOTEFHPDG','HIX', 'Q811JNQWPP6SH94', 'MARKETPLACE', sysdate(), sysdate());

INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('e3336592-1435-40f2-8153-04262e3d1cba','bd6fff28-cad7-475f-b082-aa440924e549','J3YOBZTMZGGNIK1','Lincoln', 'J', 'King','HOH','1974-08-21 00:00:00','MALE',5.4,178.6, 'Q811JNQWPP6SH94', 'MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('e63af544-b3df-42a3-bcef-7c38f6fe560f', 'Z5ZXIE3ASNZIZ1P', 'e3336592-1435-40f2-8153-04262e3d1cba', 'RESIDENCE', '6736 Ridge Plains Blvd', null, 'Odessa', 'FL', '12101', '33556', 'Q811JNQWPP6SH94', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('97e90147-dfa0-4126-bc2c-301d894bad00', '54VYK6MAQCQPNWZ', 'e3336592-1435-40f2-8153-04262e3d1cba', 'MAIL', 'P.O Box 62556', null, 'Odessa', 'FL', '12101', '33556', 'Q811JNQWPP6SH94', 'MARKETPLACE','2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('7189a642-4387-481c-a35d-ec2f4f76ce0b', 'MYYQWARXKQ5J06B', 'e3336592-1435-40f2-8153-04262e3d1cba','MOBILE', '813-357-9161', 'Q811JNQWPP6SH94', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('7b76a24a-2333-4ad8-bf80-2d7d6d12f7a0', 'FR50Q9MCK9IMFJ7', 'e3336592-1435-40f2-8153-04262e3d1cba', 'PERSONAL', '[email protected]', true, 'Q811JNQWPP6SH94', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('103f1b8d-44b6-4801-90a1-c265610ce902', '8GB889276VTNAPZ', 'e3336592-1435-40f2-8153-04262e3d1cba', 'WORK', '[email protected]', false,  null, 'ZEUS-UI','2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('25f035b0-2fec-4067-9f13-0257b4a126b6', '87IUE173Y66MTBL', 'e3336592-1435-40f2-8153-04262e3d1cba', 'SPOKEN', 'ENG', 'Q811JNQWPP6SH94', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('66893302-196b-4cf3-b116-35ed994e6175', 'OEBRG2KCHAD26WB', 'e3336592-1435-40f2-8153-04262e3d1cba', 'WRITTEN', 'SPA', 'Q811JNQWPP6SH94', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('6e65a5b8-693a-4f56-90c9-91327e915588', '8WDC5HWNMDH5P7R', 'e3336592-1435-40f2-8153-04262e3d1cba', 'SSN', '834-62-6746', 'Q811JNQWPP6SH94', 'MARKETPLACE', true, sysdate(), sysdate());

INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('33c2bd6e-458a-4100-adb5-b591502e8c0d', 'AZVLRLJ8YB96N3H', 'bd6fff28-cad7-475f-b082-aa440924e549', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2023-01-01 00:00:00', '2023-12-31 00:00:00','955747647','89355FL0234597', '73467573','HMO','2022-10-01 00:00:00','ENROLLED','Q811JNQWPP6SH94', 'MARKETPLACE', false, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('533de075-451a-48c7-92a4-afdee2f6b5d4', 'JZMK2P2PDH3JB1P', 'Q811JNQWPP6SH94', 'MARKETPLACE', '33c2bd6e-458a-4100-adb5-b591502e8c0d', '2023-01-01 00:00:00', '2023-06-30 00:00:00', 'ACTIVE', 1, '03', 150, 100, 50, 0, 10, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('6a634063-9628-4556-97ff-7a97333ad009', 'ZHOOHJZTH4G7GKZ', 'FAXE0US7NPUYLDN', 'MARKETPLACE', '33c2bd6e-458a-4100-adb5-b591502e8c0d', '2023-07-01 00:00:00', '2023-12-31 00:00:00', 'ACTIVE', 2, '03', 150, 150, 0, 0, 20, sysdate(),sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('53b4259f-594a-4ce4-9b1d-c3696d727f5a', '533de075-451a-48c7-92a4-afdee2f6b5d4', 'e3336592-1435-40f2-8153-04262e3d1cba', '95574764701', 150, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('a9cd6c89-cc9c-4c53-b29d-f33f71009f8a', '6a634063-9628-4556-97ff-7a97333ad009', 'e3336592-1435-40f2-8153-04262e3d1cba', '95574764701', 150, sysdate(), sysdate());

/** Ryan Baker Account details **/

INSERT INTO account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('a9823b71-e48c-4ad2-9c80-d2998219b7a9','XTL6NWIUL837V3M','HIX','21D79B066V1CBPO', 'MARKETPLACE', sysdate(), sysdate());

INSERT INTO member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('4124d9bc-449b-4726-a327-5ec6e8a24963','a9823b71-e48c-4ad2-9c80-d2998219b7a9','D643R689ER27R3O','Ryan', 'T', 'Baker','HOH','1975-10-14 00:00:00','MALE',5.9,175.4,'21D79B066V1CBPO', 'MARKETPLACE',sysdate(), sysdate());

INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('03dead91-8de6-4369-bc50-a38eb1a2e6c1', 'VITQ09O5LT9E8QB', '4124d9bc-449b-4726-a327-5ec6e8a24963', 'RESIDENCE', '7364 Hillsborough Avenue', null, 'Tampa', 'FL', '12057', '33626','21D79B066V1CBPO', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('073c5a5f-1972-41a1-9c44-68df828002f8', 'NQ5Q2JNHOZRZAHU', '4124d9bc-449b-4726-a327-5ec6e8a24963', 'MAIL', 'P.O Box 73465', null, 'Tampa', 'FL', '12057', '33626','21D79B066V1CBPO', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('3d05dec9-2a9a-4d65-aa97-e32a59838232', 'X8SF8VEXRVYFPWU', '4124d9bc-449b-4726-a327-5ec6e8a24963','MOBILE', '813-357-9161','21D79B066V1CBPO', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('36031b64-8702-4876-b02b-856666736230', 'DMQNYV4AEZKIBU2', '4124d9bc-449b-4726-a327-5ec6e8a24963', 'PERSONAL', '[email protected]', true,'21D79B066V1CBPO', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('c0e962fe-ed03-4688-bf15-c6cadf4f1318', 'OHAW4V9GH6XE061', '4124d9bc-449b-4726-a327-5ec6e8a24963', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a455b815-c742-476d-8b8f-869e07d2ff23', '3O9UVXTWALNQHWD', '4124d9bc-449b-4726-a327-5ec6e8a24963', 'SPOKEN', 'ENG','21D79B066V1CBPO', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());
INSERT INTO member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('ba164be2-4cf9-45b8-a75a-1c925fef00a0', 'MFEQNSBTTUYA1OD', '4124d9bc-449b-4726-a327-5ec6e8a24963', 'WRITTEN', 'SPA','21D79B066V1CBPO', 'MARKETPLACE', '2021-12-15 00:00:00', null, sysdate(), sysdate());

INSERT INTO member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('54b84a87-3ef3-4a14-adb8-2931c5069692', '813KJNACDM9S3PW', '4124d9bc-449b-4726-a327-5ec6e8a24963', 'SSN', '636-73-7456','21D79B066V1CBPO', 'MARKETPLACE', true, sysdate(), sysdate());

INSERT INTO enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('708c3ceb-10f2-470d-96e2-9a0d52479f7a', 'RP7ZOZSFSJXSHT9', 'a9823b71-e48c-4ad2-9c80-d2998219b7a9', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2023-01-01 00:00:00', '2023-12-31 00:00:00','673585836','89355FL0234597', '63456387','HMO','2022-10-01 00:00:00','ENROLLED','21D79B066V1CBPO', 'MARKETPLACE', false, sysdate(),sysdate());

INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('3a95613d-b9f5-4c19-99ef-484aa4a3cb34', 'YHBF0BI2393JYBM', '21D79B066V1CBPO', 'MARKETPLACE', '708c3ceb-10f2-470d-96e2-9a0d52479f7a', '2023-01-01 00:00:00', '2023-06-30 00:00:00', 'ACTIVE', 1, '03', 150, 100, 50, 0, 10, sysdate(),sysdate());
INSERT INTO premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('4a73f039-4dde-487a-9928-502498e74edc', 'G7VSAP4XB30LVYT', 'PU0EL7734JJF5J5', 'MARKETPLACE', '708c3ceb-10f2-470d-96e2-9a0d52479f7a', '2023-07-01 00:00:00', '2023-12-31 00:00:00', 'ACTIVE', 2, '03', 150, 150, 0, 0, 20, sysdate(),sysdate());

INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('c217bc88-7144-4a08-b596-2610d8133809', '3a95613d-b9f5-4c19-99ef-484aa4a3cb34', '4124d9bc-449b-4726-a327-5ec6e8a24963', '67358583601', 150, sysdate(), sysdate());
INSERT INTO member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('57b1d87b-7f5a-4ba8-aa50-8f905715d532', '4a73f039-4dde-487a-9928-502498e74edc', '4124d9bc-449b-4726-a327-5ec6e8a24963', '67358583601', 150, sysdate(), sysdate());


/** Joshua Newman Account details **/
INSERT INTO membermgmtdb.account(account_sk, acct_number, line_of_business_type_code, ztcn, source, created_date, updated_date) VALUES ('529cd421-7a19-4675-86a2-16a6f95e5cb1','IQW3FG32M2RHJ3M','HIX', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', sysdate(), sysdate());

INSERT INTO membermgmtdb.member(member_sk, account_sk, member_code, first_name, middle_name, last_name, relationship_type_code, date_of_birth, gender_type_code, height, weight, ztcn, source, created_date, updated_date) VALUES ('24869cc0-d038-41b0-897e-a95661715ed7','529cd421-7a19-4675-86a2-16a6f95e5cb1','H4PJZCB3DLOVS96','Joshua', 'D', 'Newman','HOH','1986-03-25 00:00:00','MALE',5.10,163.6, 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', SYSDATE(), sysdate());

INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('41ac70d3-0794-4519-9264-7b6f3bf7626d', 'H062RS92Q80Q9PF', '24869cc0-d038-41b0-897e-a95661715ed7', 'RES', '62334 Barbour Trail', null, 'Odessa', 'FL', '12101', '33556', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_address(member_address_sk, member_address_code, member_sk, address_type_code, address_line_1, address_line_2, city, state_type_code, fips_code, zip_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('bc371aa0-f5af-4c2c-9701-59d61167fcb3', 'F8URDFGH35Z6HH0', '24869cc0-d038-41b0-897e-a95661715ed7', 'MAIL', 'P.O Box 73474', null, 'Odessa', 'FL', '12101', '33556', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_phone(member_phone_sk, member_phone_code, member_sk, phone_type_code, phone_number, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('10964d7c-b0d4-4f40-830c-aab98885e1ef', 'LODI6PG0PXIQCI0', '24869cc0-d038-41b0-897e-a95661715ed7','MOBILE', '813-256-7463', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('19187554-58c5-4729-b909-c2f4925eb0c5', 'X15KFSLHQH59T11', '24869cc0-d038-41b0-897e-a95661715ed7', 'PERSONAL', '[email protected]', true, 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_email(member_email_sk, member_email_code, member_sk, email_type_code, email, is_primary, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('e1d1b629-c174-441e-ab8b-57b1881a198d', '7PXB9AIUSCVIBA3', '24869cc0-d038-41b0-897e-a95661715ed7', 'WORK', '[email protected]', false, null, 'ZEUS-UI', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('d58e5ce6-4017-4971-a2fb-0af1795028f1', 'L6OON1SOPEQ9JE7', '24869cc0-d038-41b0-897e-a95661715ed7', 'SPOKEN', 'ENG', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());
INSERT INTO membermgmtdb.member_language(member_language_sk, member_language_code, member_sk, language_type_code, language_code, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('5b261e2c-36be-473b-90fb-8e0a27262071', '4DQTAD5N7QC8RA7', '24869cc0-d038-41b0-897e-a95661715ed7', 'WRITTEN', 'SPA', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '2021-12-15 00:00:00', null, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.member_identifier(member_identifier_sk, member_identifier_code, member_sk, identifier_type_code, identifier_value, ztcn, source, is_active, created_date, updated_date) VALUES ('7cd23ba5-1041-447c-8d12-8922f9938532', '0RHAB45C7582XYF', '24869cc0-d038-41b0-897e-a95661715ed7', 'SSN', '847-73-7263', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', true, SYSDATE(), SYSDATE());

INSERT INTO membermgmtdb.enrollment_span(enrlmnt_span_sk, enrollment_span_code, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, enrollment_type, coverage_type_code, start_date, end_date, exchange_subscriber_id, plan_id, group_policy_id, product_type_code, effectuation_date, status_type_code, effective_reason, term_reason, ztcn, source, delinq_ind, created_date, updated_date) VALUES ('27f4af2c-e4c6-424c-9aa8-17a34b001f85', 'PKY8AQ3IM5BV2QY', '529cd421-7a19-4675-86a2-16a6f95e5cb1', 'FL', 'FFM', 'MP_FL', 'ACTIVE', 'FAM', '2024-01-01 00:00:00', '2024-12-31 00:00:00','936626462','89355FL0234597', '52627424','HMO',NULL,'PRE_MEMBER', 'MBS', null, 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', false, SYSDATE(),SYSDATE());

INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('9ed9a58d-6f02-4085-a61c-39596febba35', 'V7C1TROLXEGP3NI', 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '27f4af2c-e4c6-424c-9aa8-17a34b001f85', '2024-01-01 00:00:00', '2024-06-30 00:00:00', 'ACTIVE', 1, '03', 150, 150, 0, 0, 10, sysdate(),sysdate());
INSERT INTO membermgmtdb.premium_span(premium_span_sk, premium_span_code, ztcn, source, enrollment_span_sk, start_date, end_date, status_type_code, sequence, csr_variant, total_prem_amt, total_resp_amt, aptc_amt, other_pay_amt, csr_amt, created_Date, updated_date) VALUES ('23ff8f59-1743-4f25-941e-f2108d5298ea', 'F0EHWG2GBIYRADJ', '4C7951WB42WUODZ', 'MARKETPLACE', '27f4af2c-e4c6-424c-9aa8-17a34b001f85', '2024-07-01 00:00:00', '2024-12-31 00:00:00', 'ACTIVE', 2, '03', 150, 150, 0, 0, 20, sysdate(),sysdate());

INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('862e973d-e72d-45d8-9438-fa6bce90f6b9', '9ed9a58d-6f02-4085-a61c-39596febba35', '24869cc0-d038-41b0-897e-a95661715ed7', '93662646201', 150, sysdate(), sysdate());
INSERT INTO membermgmtdb.member_premiums(member_premium_sk, premium_span_sk, member_sk, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('45963034-b63e-4cc4-ba48-8125b3f5049c', '23ff8f59-1743-4f25-941e-f2108d5298ea', '24869cc0-d038-41b0-897e-a95661715ed7', '93662646201', 150,sysdate(), sysdate());

INSERT INTO membermgmtdb.broker(broker_sk, account_sk, broker_code, broker_name, broker_id, agency_name, agency_id, account_number_1, account_number_2, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('a8b92fdf-9de8-415d-bb7f-82a6f12dcad0','529cd421-7a19-4675-86a2-16a6f95e5cb1', 'ROV2OSZR8JO1L3E', 'Ben Stokes', '53234534', 'Sapphire Brokers Inc.', '63363754', '523645-63456', null, 'Z3TZSX8XGFXYIPL', 'MARKETPLACE', '2022-01-01 00:00:00', null, sysdate(), sysdate());
INSERT INTO membermgmtdb.sponsor(sponsor_sk, account_sk, sponsor_code, sponsor_id, sponsor_name, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2e3749a8-b43c-4fd6-a37d-1d144c7e46a8','529cd421-7a19-4675-86a2-16a6f95e5cb1', 'BTN3VWPYI3J38HC', '847-73-7263', 'Joshua Newman', 'C916WXWNSD3SAUA', 'MARKETPLACE', '2022-01-01 00:00:00', null, sysdate(), sysdate());
INSERT INTO membermgmtdb.payer(payer_sk, account_sk, payer_code, payer_name, payer_id, ztcn, source, start_date, end_date, created_date, updated_date) VALUES ('2e3749a8-b43c-4fd6-a37d-1d144c7e46a8', '529cd421-7a19-4675-86a2-16a6f95e5cb1', '6IY735QFYRAW4A4', 'Zeus Health', '5235343', '2CWSQZ4203D1XMR', 'MARKETPLACE', '2022-01-01 00:00:00', null, sysdate(), sysdate());