create or replace view vw_emr_first_page as
select A.ID,
       A.PAGE_STATUS_CODE,
       A.PAGE_TYPE_CODE,
       A.HOSP_CODE,
       A.PAT_ID,
       A.ZY_ID,
       A.ZY_NO,
       A.ZY_TIMES,
       A.MRN_NO,
       A.MZ_PAT_ID,
       A.DISEASE_CATALOG_CODE,
       A.PAY_WAY_CODE,
       A.HEALTH_CARD_NO,
       A.MEDICARE_CARD_NO,
       A.PAT_NAME,
       decode(A.SEX_CODE, '男', '1', '2') as SEX_CODE,
       to_char(A.BIRTH_DATE, 'yyyy-MM-dd') as BIRTH_DATE,
       A.PAT_AGE,
       nvl(A.BABY_AGE_MONTH || '', '—') as BABY_AGE_MONTH,
       nvl(A.BABY_AGE_DAY || '', '—') as BABY_AGE_DAY,
       nvl(A.BABY_BIRTH_WEIGHT1 || '', '—') as BABY_BIRTH_WEIGHT1,
       nvl(A.BABY_BIRTH_WEIGHT2 || '', '—') as BABY_BIRTH_WEIGHT2,
       nvl(A.BABY_BIRTH_WEIGHT3 || '', '—') as BABY_BIRTH_WEIGHT3,
       nvl(A.BABY_BIRTH_WEIGHT4 || '', '—') as BABY_BIRTH_WEIGHT4,
       nvl(A.BABY_BIRTH_WEIGHT5 || '', '—') as BABY_BIRTH_WEIGHT5,
       nvl(A.BABY_IN_WEIGHT || '', '—') as BABY_IN_WEIGHT,
       A.ID_TYPE_CODE,
       A.ID_NO,
       A.ID_UNKNOW_REASON,
       A.COUNTRY_CODE,
       A.COUNTRY_NAME,
       A.NATION_CODE,
       A.NATION_NAME,
       A.OCCUPATION_CODE,
       A.OCCUPATION_NAME,
       A.MARRIAGE_CODE,
       replace(A.NATIVE_PROVINCE, '省', '') as NATIVE_PROVINCE,
       replace(A.NATIVE_CITY, '市', '') as NATIVE_CITY,
       replace(A.NATIVE_COUNTY, '县', '') as NATIVE_COUNTY,
       replace(A.BIRTH_ADDR_PROVINCE, '省', '') as BIRTH_ADDR_PROVINCE,
       replace(A.BIRTH_ADDR_CITY, '市', '') as BIRTH_ADDR_CITY,
       replace(A.BIRTH_ADDR_COUNTY, '县', '') as BIRTH_ADDR_COUNTY,
       A.BIRTH_ADDR_DETAIL,
       replace(A.CURRENT_ADDR_PROVINCE, '省', '') as CURRENT_ADDR_PROVINCE,
       replace(A.CURRENT_ADDR_CITY, '市', '') as CURRENT_ADDR_CITY,
       replace(A.CURRENT_ADDR_COUNTY, '县', '') as CURRENT_ADDR_COUNTY,
       A.CURRENT_ADDRP_ADDING,
       A.CURRENT_ADDR_ZIP,
       A.CURRENT_ADDR_TEL,
       replace(A.REGISTER_ADDR_PROVINCE, '省', '') as REGISTER_ADDR_PROVINCE,
       replace(A.REGISTER_ADDR_CITY, '市', '') as REGISTER_ADDR_CITY,
       replace(A.REGISTER_ADDR_COUNTY, '县', '') as REGISTER_ADDR_COUNTY,
       A.REGISTER_ADDR_DETAIL,
       A.REGISTER_ADDR_ZIP,
       A.WORK_PLACE,
       A.WORK_TEL,
       A.WORK_ZIP,
       A.CONTACT_NAME,
       A.CONTACT_RELATION_CODE,
       A.CONTACT_RELATION_NAME,
       A.CONTACT_ADDR,
       A.CONTACT_TEL,
       A.DAY_SURGER_FLAG,
       A.IN_PATH_CODE,
       --A.IN_DTIME,
       TO_CHAR(A.IN_DTIME, 'yyyy-MM-dd hh24:mi:ss')IN_DTIME,
       A.IN_DEPT_CODE,
       A.IN_DEPT_NAME,
       A.IN_DEPT_ROOM,
       A.MOVE_DEPT_CODE_LIST,
       A.MOVE_DEPT_NAME_LIST,
       --A.OUT_DTIME,
       TO_CHAR(A.OUT_DTIME, 'yyyy-MM-dd hh24:mi:ss')OUT_DTIME ,
       A.OUT_DEPT_CODE,
       A.OUT_DEPT_NAME,
       A.OUT_DEPT_ROOM,
       A.ACTUAL_IN_DAYS,
       A.MZ_DIAG_ICD_CODE,
       A.MZ_DIAG_ICD_NAME,
       A.DAMAGE_POSION_REASON,
       A.DAMAGE_POSION_ICD_CODE,
       A.PATH_ICD_CODE1,
       A.PATH_ICD_NAME1,
       A.PATH_NO1,
       A.PATH_ICD_CODE2,
       A.PATH_ICD_NAME2,
       A.PATH_NO2,
       A.PATH_ICD_CODE3,
       A.PATH_ICD_NAME3,
       A.PATH_NO3,
       A.DRUG_ALLERGY_FLAG,
       A.DRUG_ALLERGY_NAME,
       A.AUTOPSY_FLAG,
       --DECODE(A.ABO_CODE,'3','4','4','3','6','5','5','6',A.ABO_CODE) as ABO_CODE,
       A.ABO_CODE,
       A.RH_CODE,
       -- DECODE(A.RH_CODE,'0','4',A.RH_CODE) as RH_CODE,
       A.DEPT_DIRECTOR_CODE,
       A.DEPT_DIRECTOR_NAME,
       A.CHIEF_DOCT_CODE,
       A.CHIEF_DOCT_NAME,
       A.CHARGE_DOCT_CODE,
       A.CHARGE_DOCT_NAME,
       A.RESIDENT_DOCT_CODE,
       A.RESIDENT_DOCT_NAME,
       A.RESP_NURSE_CODE,
       A.RESP_NURSE_NAME,
       A.LEARNING_DOCT_CODE,
       A.LEARNING_DOCT_NAME,
       A.INTERN_DOCT_CODE,
       A.INTERN_DOCT_NAME,
       A.GRAD_INTERN_DOCT_CODE,
       A.GRAD_INTERN_DOCT_NAME,
       A.CODING_CODE,
       A.CODING_NAME,
       A.CASE_QUALITY_CODE,
       A.QC_DOCT_CODE,
       A.QC_DOCT_NAME,
       A.QC_NURSE_CODE,
       A.QC_NURSE_NAME,
       to_char(A.QC_DTIME, 'yyyy-MM-dd') as QC_DTIME,
       A.OUT_CODE,
       A.ORDER_REFERRAL_ORG,
       A.REHOSP_AFTER31_FLAG,
       A.REHOSP_AFTER31_PURPOSE,
       nvl(A.COMA_BEFORE_DAY || '', '—') as COMA_BEFORE_DAY,
       nvl(A.COMA_BEFORE_HOUR || '', '—') as COMA_BEFORE_HOUR,
       nvl(A.COMA_BEFORE_MIN || '', '—') as COMA_BEFORE_MIN,
       nvl(A.COMA_AFTER_DAY || '', '—') as COMA_AFTER_DAY,
       nvl(A.COMA_AFTER_HOUR || '', '—') as COMA_AFTER_HOUR,
       nvl(A.COMA_AFTER_MIN || '', '—') as COMA_AFTER_MIN,
       A.CLIN_PATHWAY_FLAG,
       A.CLIN_PATHWAY_CHANGE_FLAG,
       A.CLIN_PATHWAY_OUT_FLAG,
       A.IN_CONDITION_CODE,
       A.OUT_CONDITION_CODE,
       A.RESEARCH_EXAMPLE_FLAG,
       A.TEACHING_EXAMPLE_FLAG,
       A.LIFT_SUPPORT_HOUR,
       A.ICU_CARE_ROOM1,
       A.ICU_CARE_IN_DTIME,
       A.ICU_CARE_OUT_DTIME,
       A.ICU_CARE_ROOM2,
       A.ICU_CARE_IN_DTIME2,
       A.ICU_CARE_OUT_DTIME2,
       A.ICU_CARE_ROOM3,
       A.ICU_CARE_IN_DTIME3,
       A.ICU_CARE_OUT_DTIME3,
       A.MZ_CHN_DIAG_ICD_CODE,
       A.MZ_CHN_DIAG_ICD_NAME,
       A.MZ_CHN_DIAG_Z_CODE,
       A.MZ_CHN_DIAG_Z_NAME,
       A.USE_CHN_DRUG,
       A.USE_CHN_EQUIPMENT,
       A.USE_CHN_TECHNOLOGY,
       A.USEDDIALECTICALNURSING,
       A.USE_CHN_PATHWAY,
       A.CREATE_USER_ID,
       A.CREATE_USER_NAME,
       A.CREATE_DTIME,
       A.MODIFY_USER_ID,
       A.MODIFY_USER_NAME,
       A.MODIFY_DTIME,
       A.REMARK,
       substr(A.PATH_ICD_NAME1, 0, 32) as PATH_ICD_NAME11,
       substr(A.PATH_ICD_NAME1, 33, 80) as PATH_ICD_NAME12,
       A.TREAT_TYPE_CODE
  from EMR_FIRST_PAGE A;