CDM

테이블 (8)

concept (Untitled)

  • 컨셉아이디 (concept_id) — integer — 기본 키 — NOT NULL
  • Field

검사결과(laboratory result) (MEASUREMENT)

  • 생성된 검사 번호 (measurement_id) — integer — 기본 키 — NOT NULL
  • 생성된 환자 번호 (person_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • 생성된 의사 번호 (provider_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • Key (visit_occurrence_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • Key (visit_detail_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • Field2 (measurement_concept_id) — integer
  • Field (measurement_date) — date
  • Field2 (measurement_datetime) — datetime
  • Field3 (measurement_time) — varchar(10)
  • Field4 (measurement_type_concept_id) — integer
  • Field5 (operator_concept_id) — integer
  • Field6 (value_as_number) — float
  • Field (value_as_concept_id) — integer
  • Field (unit_concept_id) — integer
  • Field2 (range_low) — float
  • Field3 (range_high) — float
  • Field (measurement_source_value) — varchar(50)
  • Field2 (measurement_source_concept_id) — integer
  • Field3 (unit_source_value) — varchar(50)
  • Field4 (value_source_value) — varchar(50)

기준정보 (PERSON)

  • Key (person_id) — integer — 기본 키 — NOT NULL
  • Field (gender_concept_id) — integer
  • Field2 (year_of_birth) — integer
  • Field (month_of_birth) — integer
  • Field2 (day_of_birth) — integer
  • Field3 (birth_datetime) — datetime
  • Field4 (death_datetime) — datetime
  • Field (race_concept_id) — integer
  • Field (ethnicity_concept_id) — integer
  • Field (location_id) — integer
  • Field (provider_id) — integer
  • Field (care_site_id) — integer
  • Field (person_source_value) — varchar(50)
  • Field (gender_source_value) — varchar(50)
  • Field (gender_source_concept_id) — integer
  • Field (race_source_value) — varchar(50)
  • Field (race_source_concept_id) — integer
  • Field (ethnicity_source_value) — varchar(50)
  • Field (ethnicity_source_concept_id) — integer

기준정보 (PROVIDER)

  • Key (provider_id) — integer — 기본 키 — NOT NULL
  • Field (provider_name) — varchar(255)
  • Field (npi) — varchar(20)
  • Field2 (dea) — varchar(20)
  • Field3 (specialty_concept_id) — integer
  • Field4 (care_site_id) — integer
  • Field5 (year_of_birth) — integer
  • Field (gender_concept_id) — integer
  • Field (provider_source_value) — varchar(50)
  • Field (specialty_source_value) — varchar(50)
  • Field (specialty_source_concept_id) — integer
  • Field (gender_source_value) — varchar(50)
  • Field (gender_source_concept_id) — integer

기준정보 (VISIT_OCCURRENCE)

  • Key (visit_occurrence_id) — integer — 기본 키 — NOT NULL
  • Field (person_id) — integer
  • Field (visit_concept_id) — integer
  • Field2 (visit_start_date) — date
  • Field3 (visit_start_datetime) — datetime
  • Field4 (visit_end_date) — date
  • Field5 (visit_end_datetime) — datetime
  • Field6 (visit_type_concept_id) — integer
  • Field7 (provider_id) — integer
  • Field (care_site_id) — integer
  • Field2 (visit_source_value) — varchar(50)
  • Field3 (visit_source_concept_id) — integer
  • Field4 (admitted_from_concept_id) — integer
  • Field5 (admitted_from_source_value) — varchar(50)
  • Field (discharge_to_concept_id) — integer
  • Field (discharge_to_source_value) — varchar(50)
  • Field (preceding_visit_occurrence_id) — integer

기준정보 (VISIT_DETAIL)

  • Key (visit_detail_id) — integer — 기본 키 — NOT NULL
  • Field (person_id) — integer
  • Field (visit_detail_concept_id) — integer
  • Field2 (visit_detail_start_date) — date
  • Field3 (visit_detail_start_datetime) — datetime
  • Field (visit_detail_end_date) — date
  • Field2 (visit_detail_end_datetime) — datetime
  • Field3 (visit_detail_type_concept_id) — integer
  • Field (provider_id) — integer
  • Field2 (care_site_id) — integer
  • Field3 (visit_detail_source_value) — string(50)
  • Field4 (visit_detail_source_concept_id) — integer
  • Field5 (admitted_from_source_value) — varchar(50)
  • Field (admitted_from_concept_id) — integer
  • Field2 (discharge_to_source_value) — varchar(50)
  • Field6 (discharge_to_concept_id) — integer
  • Field7 (preceding_visit_detail_id) — integer
  • Field8 (visit_detail_parent_id) — integer
  • Field (visit_occurrence_id) — integer

약(medication) (DEUG_EXPOSURE)

  • 생성된 약물 노출 번호 (drug_exposure_id) — integer — 기본 키 — NOT NULL
  • 생성된 환자 번호 (person_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • 생성된 의사 번호 (provider_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • Key (visit_occurrence_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • Key (visit_detail_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • ☆약물 표준용어 아이디 (drug_concept_id) — integer
  • 약물 노출 시작날짜 (drug_exposure_start_date) — date
  • 약물 노출 시작날짜/시간 (drug_exposure_start_datetime) — datetime
  • 약물 노출 종료날짜 (drug_exposure_end_date) — date
  • 약물 노출 종료날짜 /시간 (drug_exposure_end_datetime) — datetime
  • 약물 노출 알려진 종료날짜 (verbatim_end_date) — date
  • ☆약물 타입 아이디 (drug_type_concept_id) — integer
  • 약물 종료 이유 (stop_reason) — varchar(20)
  • 리필 횟수 (refills) — integer
  • 약물 처방 용량 (quantity) — float
  • 약물 처방 기간 (days_supply) — integer
  • 약품 처방 지침 (sig) — varchar(MAX)
  • ☆약물 관리경로 아이디 (route_concept_id) — integer
  • 약물 수량 (lot_number) — varchar(50)
  • EDI code (drug_source_value) — varchar(50)
  • ?? (drug_source_concept_id) — integer
  • 약물 관리경로 정보 (route_source_value) — varchar(50)
  • 약물 단위 정보 (dose_unit_source_value) — varchar(50)

약(medication) (DRUG_ERA)

  • Key (drug_era_id) — integer — 기본 키 — NOT NULL
  • Key (person_id) — integer — 외래 키 → 기준정보.Key — NOT NULL
  • Field (drug_concept_id) — integer
  • Field2 (drug_era_start_datetime) — datetime
  • Field3 (drug_era_end_datetime) — datetime
  • Field4 (drug_exposure_count) — integer
  • Field (gap_days) — integer