ㅊㅇ
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