안녕하세요..!!
매번 질문을 드리는 것 같아서 송구합니다..
코드는 이렇습니다.
select
key_seq as visit_concept_id,
person_id as person_id,
case when form_cd in ('02', '04', '06', '07', '10', '12') and in_pat_cors_type in ('11', '21', '31') then 9203 --입원 + 응급
when form_cd in ('02', '04', '06', '07', '10', '12') and in_pat_cors_type not in ('11', '21', '31') then 9201 --입원 + 입원
when form_cd in ('03', '05', '08', '09', '11', '13', '20', '21', 'ZZ') and in_pat_cors_type in ('11', '21', '31') then 9203 --외래 + 응급
when form_cd in ('03', '05', '08', '09', '11', '13', '20', '21', 'ZZ') and in_pat_cors_type not in ('11', '21', '31') then 9202 --외래 + 외래
else 0
end as visit_concept_id,
TO_DATE(recu_fr_dt, 'yyyymmdd') as visit_start_date,
null as visit_start_time,
case when form_cd in ('02', '04', '06', '07', '10', '12') then TO_DATE(recu_fr_dt, 'yyyymmdd') + vscn - 1
when form_cd in ('03', '05', '08', '09', '11', '13', '20', '21', 'ZZ') and in_pat_cors_type in ('11', '21', '31') then TO_DATE(recu_fr_dt, 'yyyymmdd') + vscn - 1
else TO_DATE(recu_fr_dt, 'yyyymmdd')
end as visit_end_date,
null as to_number(visit_end_time),
44818517 as visit_type_concept_id,
null as provider_id,
ykiho_id as care_site_id,
key_seq as visit_source_value,
null as visit_source_concept_id
from cohort_cdm.NHID_20T;
ora - 00923 from 키워드가 필요한 위치에 없다고 하는데용..
44818517 as visit_type_concept_id,이 행이 잘못되었다고 하는데.. 어떻게 바꿔주면 좋을가용??..