CREATE OR REPLACE FORCE VIEW "CART_CDAC"."VW_ABSTRACTION_DETAIL_HPMP" ("AB_DETAIL_ID", "AB_ID", "QUESTION_CD", "ANSWER_
ID", "PARENT_QUESTION_CD", "MISMATCH_ID", "ANSWER_VALUE", "ROW_NBR", "ANSWERED", "MISMATCH_REASON", "IQC_DETAIL_NUMERATOR
", "IQC_DETAIL_DENOMINATOR", "CREATE_DATE", "CREATE_USER_ID", "UPDATE_DATE", "UPDATE_USER_ID") AS
  select
 ad.AB_DETAIL_ID,
 ad.AB_ID,
 ad.QUESTION_CD,
 ad.ANSWER_ID,
 ad.PARENT_QUESTION_CD,
 ad.MISMATCH_ID,
 ad.ANSWER_VALUE,
 ad.ROW_NBR,
 ad.ANSWERED,
 ad.MISMATCH_REASON,
 ad.IQC_DETAIL_NUMERATOR,
 ad.IQC_DETAIL_DENOMINATOR,
 ad.CREATE_DATE,
 ad.CREATE_USER_ID,
 ad.UPDATE_DATE,
 ad.UPDATE_USER_ID
from
cart_cdac.abstraction_detail ad,
cart_cdac.abstraction a
where a.ab_id = ad.ab_id
and a.topic_id = 6
with read only


  CREATE OR REPLACE FORCE VIEW "CART_CDAC"."VW_ABSTRACTION_HPMP" ("AB_ID", "CASE_ID", "TOPIC_ID", "ORG_TYPE_ID", "STATUS_
CD", "ADJUDICATION_STATUS_ID", "EXPORT_STATUS_ID", "IMPORT_PROVIDER_ID", "ABSTRACTOR_ID", "IQC_PREF_ID", "ABSTRACTION_TYP
E_ID", "REVISION", "GOLD", "DISCHARGE_DATE", "FIRST_NAME", "LAST_NAME", "ABSTRACTION_DATE", "TOTAL_ABSTRACTION_TIME", "SA
MPLE_REASON", "SAMPLE_DATE", "CERTIFIED", "COMMENT_FIELD", "CART_VERSION", "CART_UPDATE_VERSION", "CDX_HCFACNTL", "COMPAR
E_1", "COMPARE_2", "IQC_NUM_MATCHES", "IQC_NUM_QUESTIONS", "IQC_PERCENT", "IQC_COMMENT", "IMPORT_DATE", "EXPORT_DATE", "U
PDATE_DATE", "UPDATE_USER_ID", "CREATE_DATE", "CREATE_USER_ID") AS
  select
 a.AB_ID,
 a.CASE_ID,
 a.TOPIC_ID,
 a.ORG_TYPE_ID,
 a.STATUS_CD,
 a.ADJUDICATION_STATUS_ID,
 a.EXPORT_STATUS_ID,
 a.IMPORT_PROVIDER_ID,
 a.ABSTRACTOR_ID,
 a.IQC_PREF_ID,
 a.ABSTRACTION_TYPE_ID,
 a.REVISION,
 a.GOLD,
 a.DISCHARGE_DATE,
 a.FIRST_NAME,
 a.LAST_NAME,
 a.ABSTRACTION_DATE,
 a.TOTAL_ABSTRACTION_TIME,
 a.SAMPLE_REASON,
 a.SAMPLE_DATE,
 a.CERTIFIED,
 a.COMMENT_FIELD,
 a.CART_VERSION,
 a.CART_UPDATE_VERSION,
 a.CDX_HCFACNTL,
 a.COMPARE_1,
 a.COMPARE_2,
 a.IQC_NUM_MATCHES,
 a.IQC_NUM_QUESTIONS,
 a.IQC_PERCENT,
 a.IQC_COMMENT,
 a.IMPORT_DATE,
 a.EXPORT_DATE,
 a.UPDATE_DATE,
 a.UPDATE_USER_ID,
 a.CREATE_DATE,
 a.CREATE_USER_ID
from
cart_cdac.abstraction a
where a.topic_id = 6
with read only


  CREATE OR REPLACE FORCE VIEW "CART_CDAC"."VW_CASES_HPMP" ("CASE_ID", "PROVIDER_ID", "ADMIT_DATE", "PATIENT_ID", "PATIEN
T_ID_TYPE_ID", "CREATE_DATE", "CREATE_USER_ID", "UPDATE_DATE", "UPDATE_USER_ID", "SELECTION_TYPE") AS
  select
 c.CASE_ID,
 c.PROVIDER_ID,
 c.ADMIT_DATE,
 c.PATIENT_ID,
 c.PATIENT_ID_TYPE_ID,
 c.CREATE_DATE,
 c.CREATE_USER_ID,
 c.UPDATE_DATE,
 c.UPDATE_USER_ID,
 c.SELECTION_TYPE
from
cart_cdac.cases c ,
cart_cdac.abstraction a
where a.case_id = c.case_id
and a.topic_id = 6
with read only