Insu
Tables (3)
claim
- CLAIM_ID — INT — Primary key
- CUST_ID (CUST_ID2) — INT — Foreign key → cust.CUST_ID
- POLY_NO (POLY_NO2) — INT — Foreign key → cntt.POLY_NO
- ACCI_OCCP_GRP2 — VARCHAR(50)
- CHANG_FP_YN — CHAR(1)
- RECP_DATE — DATE
- ORIG_RESN_DATE — DATE
- RESN_DATE — DATE
- CRNT_PROG_DVSN — INT
- ACCI_DVSN — INT
- CAUS_CODE — VARCHAR(10)
- CAUS_CODE_DTAL — VARCHAR(50)
- DSAS_NAME — VARCHAR(100)
- DMND_RESN_CODE — INT
- DMND_RSCD_SQNO — INT
- HOSP_OTPA_STDT — DATE
- HOSP_OTPA_ENDT — DATE
- RESL_CD1 — VARCHAR(20)
- RESL_NM1 — VARCHAR(100)
- VLID_HOSP_OTDA — INT
- HOUSE_HOSP_DIST — DECIMAL(10,2)
- HOSP_CODE — INT
- ACCI_HOSP_ADDR — VARCHAR(100)
- HOSP_SPEC_DVSN — VARCHAR(50)
- CHME_LICE_NO — INT
- PAYM_DATE — DATE
- DMND_AMT — INT
- PAYM_AMT — INT
- PMMI_DLNG_YN — CHAR(1)
- SELF_CHAM — INT
- NON_PAY — INT
- TAMT_SFCA — INT
- PATT_CHRG_TOTA — INT
- DSCT_AMT — INT
- COUNT_TRMT_ITEM — INT
- DCAF_CMPS_XCPA — DECIMAL(12,2)
- NON_PAY_RATIO — DECIMAL(12,9)
- HEED_HOSP_YN — CHAR(1)
cntt
- POLY_NO — INT — Primary key
- CUST_ID (CUST_ID2) — INT — Foreign key → cust.CUST_ID
- CUST_ROLE — TINYINT
- GOOD_CLSF_CDNM — VARCHAR(50)
- CNTT_YM — CHAR(6)
- CLLT_FP_PRNO — INT
- REAL_PAYM_TERM — INT
- SALE_CHNL_CODE — VARCHAR(5)
- CNTT_STAT_CODE — VARCHAR(5)
- EXPR_YM — CHAR(6)
- PAYM_CYCL_CODE — TINYINT
- MAIN_INSR_AMT — BIGINT
- SUM_ORIG_PREM — BIGINT
- MNTH_INCM_AMT — BIGINT
cust
- CUST_ID — INT — Primary key
- SIU_CUST_YN — CHAR(1)
- SEX — TINYINT
- AGE — INT
- RESI_COST — INT
- RESI_TYPE_CODE — INT
- FP_CAREER — CHAR(1)
- CUST_RGST — VARCHAR(6)
- CTPR — VARCHAR(10)
- OCCP_GRP_1 — VARCHAR(20)
- OCCP_GRP_2 — VARCHAR(50)
- WEDD_YN — CHAR(1)
- CHLD_CNT — DECIMAL(3,1)