meta_ver1
Tables (16)
Dev_Death
- uniq_no — int
- seq — int
- patno — varchar(255)
- death_dt — datetime
- cf_typ — varchar(255)
- death_typ — varchar(255)
- death_cause_im — varchar(255)
- death_cause_mid — varchar(255)
- death_cause_pre — varchar(255)
- date_err — varchar(50)
- birth_drr — varchar(50)
- include_yn — varchar(50)
Dev_Diagnosis
- d_seq — int
- patno — varchar
- meddate — datetime
- meddatetime — datetime
- other_dt — datetime
- dschdate — datetime
- dschdatetime — varchar
- meddept — varchar
- meddr — varchar
- patfg — varchar
- diagcode — varchar
- main_yn — varchar
- impressyn — varchar
- admdia_yn — varchar
- dscdia_yn — varchar
- ro_yn — varchar
- visit_id — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- cancel_yn — varchar
- include_yn — varchar
Dev_Drug
- tbnm — varchar(255)
- uniq_no — int
- ordseqno — int
- patno — varchar(255)
- patfg — varchar
- meddept — varchar(255)No
- meddate — datetime
- orddate — datetime
- actdate — datetime
- methodcd — varchar
- ordcd — varchar(255)
- day — varchar(255)
- cnt — varchar(255)
- actcnt — varchar(255
Dev_Measurement
- tbnm — varchar
- uniq_no — int
- exam_gb — varchar
- patno — varchar
- meddept — varchar
- patfg — varchar
- meddate — datetime
- orddate — datetime
- acptdt — datetime
- execdt — datetime
- verificationdt — datetime
- otherdt — datetime
- ordcode — varchar
- rslt_typ — varchar
- rsltnum — float
- rslttxt — varchar
- unit — varchar
- nr_lw — float
- nr_up — float
- provider — varchar
- ordergb — varchar
- act_gb — varchar
- visit_id — varchar
- dcyn — varchar
- prn_yn — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
Dev_Procedure
- tbnm — varchar
- uniq_no — int
- ordseqno — int
- exec_seq — int
- other_seqno — int
- patno — varchar
- meddept — varchar
- patfg — varchar
- meddate — datetime
- opdate — datetime
- orddate — datetime
- actdt — datetime
- ordcode — varchar
- cnt — varchar
- actcnt — varchar
- day — int
- ordtyp — varchar
- ordgb — varchar
- orddr — varchar
- wardno — varchar
- visit_id — varchar
- dc_yn — varchar
- prn_yn — varchar
- prnact_yn — varchar
- cancel_yn — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
Dev_Specimen
- tbnm — varchar
- uniq_no — int
- execcd — varchar
- spcno — varchar
- patno — varchar
- patfg — varchar
- meddept — varchar
- meddate — datetime
- orddate — datetime
- acptdt — datetime
- coldt — datetime
- spc_cd — varchar
- unit — varchar
- samplesite — varchar
- sample_qty — float
- sample_cnt — int
- tisscd — varchar
- tissnm — varchar
- tisstxt — varchar
- diagcd — varchar
- opcd — varchar
- result — varchar
- com_gb — varchar
- cancel_yn — varchar
- dc_yn — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
Dev_clinicalnote
- tbnm — varchar
- uniq_no — int
- frm_no — int
- patno — varchar
- meddept — varchar
- meddate — datetime
- medtime — datetime
- frmdt — datetime
- patfg — varchar
- frmkey — varchar
- frmnm — varchar
- grid_key — varchar
- grid_nm — varchar
- mrit_key — varchar
- mrit_nm — varchar
- attr_key — varchar
- attr_nm — varchar
- col1 — varchar
- col2 — varchar
- cont_nm — varchar
- rslt_typ — varchar
- data_num — float
- data_txt — varchar
- data_dt — datetime
- rslt_cd — varchar
- meddr — varchar
- visit_id — varchar
- cancel_yn — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
Dev_cost
- tbnm — varchar
- uniq_no — int
- ordtbnm — varchar
- rcpseq — int
- seqno — int
- ordseqno — int
- Patno — varchar
- patfg — varchar
- meddate — datetime
- orddate — datetime
- rcpdate — datetime
- day — int
- meddept — varchar
- orddr — varchar
- ordcode — varchar
- cnt — int
- instyp — varchar
- unitprice — varchar
- oneprice — varchar
- spcamt — varchar
- addamt — varchar
- rcpamt — varchar
- ownrat — varchar
- paidby_pat — varchar
- paidby_payer — varchar
- sugatyp — varchar
- drg_gb — varchar
- rcpstat — varchar
- visit_id — varchar
- cancel_yn — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
Dev_device
- tbnm — varchar
- uniq_no — int
- ordseqno — int
- op_seqno — int
- op_ordseq — int
- Patno — varchar
- patfg — varchar
- meddate — datetime
- orddate — datetime
- actdt — datetime
- Ord_cd — varchar
- Cnt — int
- Day — int
- Act_cnt — int
- meddept — varchar
- orddr — varchar
- wardno — varchar
- ord_gb — varchar
- dc_yn — varchar
- prn_yn — varchar
- act_yn — varchar
- op_yn — varchar
- cancel_yn — varchar
- visit_id — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
Dev_payer
- tbnm — varchar
- uniq_no — int
- patno — varchar
- meddate — datetime
- orddate — datetime
- day — int
- endt — datetime
- Isty_start_dt — datetime
- Isty_fnsh_dt — datetime
- sugatyp — varchar
- payerid — varchar
- cancel_yn — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
Dev_period
- patno — varchar
- min_dt — datetime
- max_dt — datetime
- btdt — datetime
- diedt — datetime
- date_err — varchar
- tbnm — varchar
- uniq_no — int
- local_cd — varchar
- national_cd — varchar
- korname — varchar
- engname — varchar
- fromdt — datetime
- todt — datetime
- vld_gb — varchar
Dev_provider
- tbnm — varchar
- uniq_no — int
- userid — varchar
- year_of_birth — datetime
- day_of_birth — datetime
- Resno2 — int
- Sex — varchar
- EMPNO — varchar
- Userstat — varchar
- DEPTCODE — varchar
- Order_GB — varchar
- Date_error — varchar
- include_yn — varchar
Dev_siteinfo
- tbnm — varchar
- uniq_no — int
- site_cd — varchar
- site_name_en — varchar
- site_name_kr — varchar
- zip_cd — varchar
- opendt — datetime
- regdt — datetime
- vld_gb — varchar
- date_err — varchar
- include_yn — varchar
dev_observation
- tbnm — varchar
- uniq_no — int
- frm_no — int
- patno — varchar
- patfg — varchar
- meddate — datetime
- medtime — datetime
- frmdt — datetime
- frmkey — varchar
- frm_nm — varchar
- item_key — varchar
- item_nm — varchar
- attr_key — varchar
- attr_nm — varchar
- cont_nm — varchar
- rslt_typ — varchar
- rslt_cd — varchar
- rslt_txt — varchar
- rslt_num — float
- unit — varchar
- meddr — varchar
- visit_id — varchar
- cancel_yn — varchar
- death_err — varchar
- birth_err — varchar
- date_err — varchar
- include_yn — varchar
dev_person
- Tbnm — varchar
- Uniq_no — int
- Patno — varchar
- Sex — varchar
- Btdt — datetime
- Fir_idno — int
- race_gb — varchar
- ZIPCODE — varchar
- FRNYN — varchar
- Btime_GB — varchar
- Death_error — varchar
- Date_error — varchar
- include_yn — varchar
dev_visit
- tbnm — varchar(300)
- uniq_no — int
- visit_seq — int
- patno — varchar(255)
- patfg — int(255)
- visit_date — datetime
- visit_time — datetime
- dsch_date — datetime
- dsch_time — datetime
- visit_length — int
- med_dep — varchar(255)
- med_dr — varchar(255)
- dschor_dr — varchar(255)
- wardno — varchar
- adm_path — varchar(255)
- dsch_rslt — varchar(255)
- cancel_yn — varchar(50)
- preceding_log — varchar(100)
- date_err — varchar(50)
- death_err — varchar(50)
- birth_err — varchar(50)
- include_yn — varchar(50