ㅊㅇ

Tables (4)

TBHEDD01 (요양기관 정보)

  • INVST_YYYY (Key) — 조사연도 — Primary key — NOT NULL
  • MDC_ENTR_ID (Key2) — 의료기관ID — Primary key — NOT NULL
  • DMD_ENTR_DEPT_CD (Key3) — Foreign key → TBHEDE05.DMD_ENTR_DEPT_CD — NOT NULL
  • MDC_ENTR_NM (Field)
  • MDC_KIND_CD (Field7)
  • REG_NO (Field2)
  • TEL_NO (Field3)
  • EDPS_ENTR_ID (Field4) — 전산업체id
  • EDPS_ENTR_NM (Field5)
  • EDPS_ENTR_CHPS_INFO (Field6)
  • EDPS_ENTR_TEL_NO (Field8) — 전산업체 전화번호
  • DETAIL_QSTNNR_PRETN_DT (Field9) — 세부조사표 제출일자

TBHEDE01 (전산업체 정보)

  • INVST_YYYY (Key) — Primary key — NOT NULL
  • EDPS_ENTR_ID (Key2) — Primary key — NOT NULL
  • EDPS_ENTR_NM (Field)
  • EDPS_ENTR)REPR_NM (Field2)
  • REG_NO (Field3)
  • TEL_NO (Field4)
  • CHPS_INFO (Field5)
  • ASSN_YN (Field6)

TBHEDE04 (진료비 전산업체 인센티브 지급 상세)

  • DMD_ENTR_ID (Key2) — 전산업체ID — Primary key — NOT NULL
  • INVST_YYYY (Key5) — 조사연도 — Foreign key → TBHEDD01.INVST_YYYY — NOT NULL
  • MDC_ENTR_ID (Key23) — 의료기관ID — Foreign key → TBHEDD01.MDC_ENTR_ID — NOT NULL
  • DMD_ENTR_DEPT_CD (Key32) — Foreign key → TBHEDD01.DMD_ENTR_DEPT_CD — NOT NULL
  • RDAMT_YN (Field) — 50% 감액 여부
  • EARLY_PRETN_YN (Field2) — 조기제출여부
  • DETAIL_PRETN_YN (Field3) — 세부제출여부
  • LAST_PAY_YN (Field4) — 100% 감액 여부
  • LAST_PAY_AMT (Field5) — 최종지급금액
  • Field6

TBHEDE05 (전산업체 부서)

  • DMD_ENTR_DEPT_CD (Key3) — Primary key — NOT NULL
  • DMD_ENTR_NM (Field)
  • DMD_ENTR_DEPT_NM (Field2)
  • INVST_YYYY (Key) — Foreign key → TBHEDE01.INVST_YYYY — NOT NULL
  • EDPS_ENTR_ID (Key2) — Foreign key → TBHEDE01.EDPS_ENTR_ID — NOT NULL