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