CREATE TABLE iqr_oqr.iqr_case (
    file_id varchar(128) NOT NULL,
    measure_set_id int4 NOT NULL,
    provider_id varchar(32) NOT NULL,
    discharge_date date NOT NULL,
    admit_date date NOT NULL,
    patient_id varchar(64) NOT NULL,
    submission_type varchar(32) NOT NULL,
    action_code varchar(16) NULL,
    is_deleted varchar(16) NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    birth_date date NULL,
    submitter_id varchar(32) NULL,
    CONSTRAINT iqr_case_pkey PRIMARY KEY (discharge_date, provider_id, measure_set_id, patient_id, admit_date, submission_type)
);
CREATE INDEX iqr_case_idx1 ON iqr_oqr.iqr_case USING btree (file_id);
CREATE INDEX iqr_case_idx2 ON iqr_oqr.iqr_case USING btree (file_id, discharge_date, provider_id, measure_set_id, patient_id, admit_date, submission_type);
CREATE INDEX iqr_case_idx3 ON iqr_oqr.iqr_case USING btree (discharge_date);

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.iqr_duplicate_cases (
    matching_id int4 NULL,
    file_id varchar(128) NOT NULL,
    provider_id varchar(32) NOT NULL,
    measure_set_id int4 NOT NULL,
    admit_date date NULL,
    discharge_date date NULL,
    patient_id varchar(64) NULL,
    duplicate_criteria int4 NULL,
    first_name varchar(128) NULL,
    last_name varchar(128) NULL,
    birth_date date NULL,
    sex varchar(8) NULL,
    postal_code varchar(16) NULL,
    upload_date date NULL,
    import_provider_id varchar(32) NULL,
    upload_user_name varchar(64) NULL,
    batch_id varchar(64) NULL,
    file_name varchar(512) NULL,
    notification_sent_to varchar(30) NULL,
    notification_sent_date timestamp NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL
);
CREATE INDEX iqr_duplicate_cases_idx1 ON iqr_oqr.iqr_duplicate_cases USING btree (matching_id, discharge_date, provider_id, measure_set_id, patient_id, admit_date);
CREATE INDEX iqr_duplicate_cases_idx2 ON iqr_oqr.iqr_duplicate_cases USING btree (discharge_date, provider_id);

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.iqr_file (
    file_id varchar(128) NOT NULL,
    submission_type varchar(32) NULL,
    action_code varchar(16) NULL,
    measure_set_id int4 NULL,
    provider_id varchar(32) NULL,
    discharge_date date NULL,
    admit_date date NULL,
    patient_id varchar(64) NULL,
    birth_date date NULL,
    provider_name varchar(100) NULL,
    provider_city varchar(40) NULL,
    provider_state varchar(2) NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT iqr_file_pkey PRIMARY KEY (file_id)
);
CREATE INDEX iqr_file_idx1 ON iqr_oqr.iqr_file USING btree (discharge_date);
CREATE INDEX iqr_file_idx2 ON iqr_oqr.iqr_file USING btree (provider_id, measure_set_id, patient_id, discharge_date, admit_date);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.iqr_measure_result (
    file_id varchar(128) NOT NULL,
    submission_type varchar(32) NOT NULL,
    measure_set_id int4 NOT NULL,
    measure_code varchar(16) NULL,
    provider_id varchar(32) NOT NULL,
    patient_id varchar(64) NOT NULL,
    discharge_date date NOT NULL,
    admit_date date NOT NULL,
    action_code varchar(16) NULL,
    is_deleted varchar(16) NULL,
    numerator int4 NULL,
    denominator int4 NULL,
    denominator_exclusion int4 NULL,
    bucket varchar(8) NULL,
    bundle_id varchar(32) NULL,
    feedback_number varchar(32) NOT NULL,
    feedback_description varchar(1024) NOT NULL,
    sample varchar(8) NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT iqr_measure_result_pkey PRIMARY KEY (discharge_date, provider_id, measure_set_id, patient_id, admit_date, feedback_number, submission_type)
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.oqr_case (
    file_id varchar(128) NOT NULL,
    measure_set_id int4 NOT NULL,
    provider_id varchar(32) NOT NULL,
    encounter_date date NOT NULL,
    arrival_time varchar(8) NOT NULL,
    patient_id varchar(64) NOT NULL,
    submission_type varchar(32) NOT NULL,
    action_code varchar(16) NULL,
    is_deleted varchar(16) NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    birth_date date NULL,
    submitter_id varchar(32) NULL,
    CONSTRAINT oqr_case_pkey PRIMARY KEY (encounter_date, provider_id, measure_set_id, patient_id, arrival_time, submission_type)
);
CREATE INDEX oqr_case_idx1 ON iqr_oqr.oqr_case USING btree (file_id);
CREATE INDEX oqr_case_idx2 ON iqr_oqr.oqr_case USING btree (file_id, encounter_date, provider_id, measure_set_id, patient_id, arrival_time, submission_type);
CREATE INDEX oqr_case_idx3 ON iqr_oqr.oqr_case USING btree (encounter_date);

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.oqr_duplicate_cases (
    matching_id int4 NULL,
    file_id varchar(128) NOT NULL,
    provider_id varchar(32) NOT NULL,
    measure_set_id int4 NOT NULL,
    encounter_date date NULL,
    arrival_time varchar(8) NULL,
    patient_id varchar(64) NULL,
    duplicate_criteria int4 NULL,
    first_name varchar(128) NULL,
    last_name varchar(128) NULL,
    birth_date date NULL,
    sex varchar(8) NULL,
    postal_code varchar(16) NULL,
    upload_date date NULL,
    import_provider_id varchar(32) NULL,
    upload_user_name varchar(64) NULL,
    batch_id varchar(64) NULL,
    file_name varchar(512) NULL,
    notification_sent_to varchar(30) NULL,
    notification_sent_date timestamp NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL
);
CREATE INDEX oqr_duplicate_cases_idx1 ON iqr_oqr.oqr_duplicate_cases USING btree (matching_id, encounter_date, provider_id, measure_set_id, patient_id, arrival_time);
CREATE INDEX oqr_duplicate_cases_idx2 ON iqr_oqr.oqr_duplicate_cases USING btree (encounter_date, provider_id);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.oqr_file (
    file_id varchar(128) NOT NULL,
    submission_type varchar(32) NULL,
    action_code varchar(16) NULL,
    measure_set_id int4 NULL,
    provider_id varchar(32) NULL,
    encounter_date date NULL,
    arrival_time varchar(8) NULL,
    patient_id varchar(64) NULL,
    birth_date date NULL,
    provider_name varchar(100) NULL,
    provider_city varchar(40) NULL,
    provider_state varchar(2) NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT oqr_file_pkey PRIMARY KEY (file_id)
);
CREATE INDEX oqr_file_idx1 ON iqr_oqr.oqr_file USING btree (encounter_date);
CREATE INDEX oqr_file_idx2 ON iqr_oqr.oqr_file USING btree (provider_id, measure_set_id, patient_id, encounter_date, arrival_time);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.oqr_measure_result (
    file_id varchar(128) NOT NULL,
    submission_type varchar(32) NOT NULL,
    measure_set_id int4 NOT NULL,
    measure_code varchar(16) NULL,
    provider_id varchar(32) NOT NULL,
    patient_id varchar(64) NOT NULL,
    encounter_date date NOT NULL,
    arrival_time varchar(8) NOT NULL,
    action_code varchar(16) NULL,
    is_deleted varchar(16) NULL,
    numerator int4 NULL,
    denominator int4 NULL,
    denominator_exclusion int4 NULL,
    bucket varchar(8) NULL,
    feedback_number varchar(32) NOT NULL,
    feedback_description varchar(1024) NOT NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT oqr_measure_result_pkey PRIMARY KEY (encounter_date, provider_id, measure_set_id, patient_id, arrival_time, feedback_number, submission_type)
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


--VSS Tables --------------------------------
CREATE TABLE iqr_oqr.provider_validation_sample (
    payment_year int4 NOT NULL,
    pgm varchar(8) NOT NULL,
    provider_id varchar(15) NOT NULL,
    provider_name varchar(100) NULL,
    state_code varchar(2) NOT NULL,
    eligible varchar(1) NOT NULL,
    selected varchar(1) NULL,
    selection_type varchar(16) NULL,
    supplemental_indicator varchar(1) NULL,
    target_reason varchar(32) NULL,
    hai_type varchar(32) NULL,
    uuid uuid NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT provider_validation_sample_pkey PRIMARY KEY (payment_year, pgm, provider_id)
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.provider_validation_sample_archive (
    payment_year int4 NOT NULL,
    pgm varchar(8) NOT NULL,
    provider_id varchar(15) NOT NULL,
    provider_name varchar(100) NULL,
    state_code varchar(2) NOT NULL,
    eligible varchar(1) NOT NULL,
    selected varchar(1) NULL,
    selection_type varchar(16) NULL,
    supplemental_indicator varchar(1) NULL,
    target_reason varchar(32) NULL,
    hai_type varchar(32) NULL,
    uuid uuid NULL,
    create_timestamp timestamp NULL,
    update_timestamp timestamp NULL,
    archive_timestamp timestamp NULL DEFAULT now()
);
CREATE INDEX provider_validation_sample_archive_idx ON iqr_oqr.provider_validation_sample_archive USING btree (payment_year, pgm, provider_id, archive_timestamp);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.validation_case_detail (
    abs_control_number varchar(12) NOT NULL,
    question_code varchar(64) NOT NULL,
    answer_code varchar(256) NULL,
    row_sequence int4 NOT NULL DEFAULT 0,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT validation_case_detail_pkey PRIMARY KEY (abs_control_number, question_code, row_sequence)
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.validation_patient_data (
    abs_control_number varchar(12) NOT NULL,
    npi varchar(50) NULL,
    patient_id varchar(40) NOT NULL,
    last_name varchar(60) NULL,
    first_name varchar(60) NULL,
    birth_date date NULL,
    postal_code varchar(10) NULL,
    ethnicity varchar(1) NULL,
    gender varchar(1) NULL,
    race int4 NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT validation_patient_data_pkey PRIMARY KEY (abs_control_number)
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.validation_status (
    pgm varchar(8) NOT NULL,
    payment_year int4 NOT NULL,
    validation_selection_qtr varchar(5) NOT NULL,
    provider_id varchar(15) NOT NULL,
    abs_control_number varchar(12) NOT NULL,
    file_id varchar(128) NOT NULL,
    validation_status varchar(1) NULL,
    measure_set_id int4 NOT NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    case_id int4 NULL,
    project_name varchar(16) NULL,
    questionnaireuuid varchar(64) NULL,
    record_request_date date NULL,
    record_due_date date NULL,
    record_received_date date NULL,
    CONSTRAINT validation_status_pkey PRIMARY KEY (abs_control_number)
);
CREATE INDEX validation_status_idx1 ON iqr_oqr.validation_status USING btree (pgm, payment_year, validation_selection_qtr, provider_id, abs_control_number);
CREATE INDEX validation_status_idx2 ON iqr_oqr.validation_status USING btree (file_id);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.zero_case_providers (
    pgm varchar(8) NOT NULL,
    payment_year int4 NOT NULL,
    validation_selection_qtr varchar(5) NOT NULL,
    provider_id varchar(15) NOT NULL,
    zero_case_ind varchar(1) NULL,
    zero_hai_ind varchar(1) NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    CONSTRAINT zero_case_providers_pkey PRIMARY KEY (pgm, payment_year, validation_selection_qtr, provider_id)
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.acn_sequence (
    state_code varchar(2) NOT NULL,
    year_month varchar(3) NOT NULL,
    sequence_number int4 NOT NULL,
    CONSTRAINT acn_sequence_pkey PRIMARY KEY (state_code, year_month)
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


CREATE TABLE iqr_oqr.confidence_interval (
    payment_year int4 NOT NULL,
    pgm varchar(8) NOT NULL,
    provider_id varchar(15) NOT NULL,
    calculation_date date NOT NULL,
    pass_fail_ind varchar(1) NOT NULL,
    cum_estmtd_reliab int4 NULL,
    estmtd_reliab_upr_bnd int4 NULL,
    estmtd_reliab_lwr_bnd int4 NULL,
    population_count int4 NULL,
    sample_count int4 NULL,
    create_timestamp timestamp NULL DEFAULT now(),
    update_timestamp timestamp NULL,
    uuper_bound int4 NULL,
    lower_bound int4 NULL
);


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
---------------------------------------------------------------------------------------------------------------------------------------------------
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX