• Home
• com.brihaspathee.zeus
• premium-billing
• 1.0.1
• 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

/** Joshua Newman Account details **/
INSERT INTO premiumbillingdb.account(account_sk, account_number, line_of_business_type_code, created_date, updated_date) VALUES ('044b15b2-7e64-4620-9dcf-63a6d519013c','IQW3FG32M2RHJ3M','HIX', sysdate(), sysdate());

INSERT INTO premiumbillingdb.enrollment_span(enrollment_span_sk, enrollment_span_code, enrollment_type, account_sk, state_type_code, marketplace_type_code, business_unit_type_code, coverage_type_code, start_date, end_date, exchange_subscriber_id, effectuation_date, plan_id, product_type_code, group_policy_id, delinq_ind, paid_through_date, claim_paid_through_date,  status_type_code, effective_reason, term_reason, created_date, updated_date) VALUES ('bf760f46-93c0-4619-aae0-7e957c15bdfe', 'PKY8AQ3IM5BV2QY', 'ACTIVE', '044b15b2-7e64-4620-9dcf-63a6d519013c', 'FL', 'FFM', 'MP_FL', 'FAM', '2024-01-01 00:00:00', '2024-12-31 00:00:00','936626462', NULL, '89355FL0234597','HMO', '52627424', false, NULL, NULL, 'PRE_MEMBER', 'MBS', null, SYSDATE(),SYSDATE());

INSERT INTO premiumbillingdb.premium_span(premium_span_sk, enrollment_span_sk, premium_span_code, 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 ('a7106eea-5371-454c-95f0-6b62acb54615', 'bf760f46-93c0-4619-aae0-7e957c15bdfe', 'V7C1TROLXEGP3NI', '2024-01-15 00:00:00', '2024-06-15 00:00:00', 'ACTIVE', 1, '03', 150, 150, 0, 0, 10, sysdate(),sysdate());
INSERT INTO premiumbillingdb.premium_span(premium_span_sk, enrollment_span_sk, premium_span_code, 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 ('ec0434a8-06e5-4e7b-9bec-4722ca4850b9', 'bf760f46-93c0-4619-aae0-7e957c15bdfe', 'F0EHWG2GBIYRADJ', '2024-07-01 00:00:00', '2024-12-23 00:00:00', 'ACTIVE', 2, '03', 150, 150, 0, 0, 20, sysdate(),sysdate());

INSERT INTO premiumbillingdb.member_premium(member_premium_sk, premium_span_sk, member_code, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('6dfe06fb-05e8-4f2e-88c0-7441bd0b5e43', 'a7106eea-5371-454c-95f0-6b62acb54615', 'H4PJZCB3DLOVS96', '93662646201', 150, sysdate(), sysdate());
INSERT INTO premiumbillingdb.member_premium(member_premium_sk, premium_span_sk, member_code, exchange_member_id, individual_premium_amount, created_date, updated_date) VALUES ('d421d90b-74a9-4df9-add9-a1f84ef9908f', 'ec0434a8-06e5-4e7b-9bec-4722ca4850b9', 'H4PJZCB3DLOVS96', '93662646201', 150,sysdate(), sysdate());