MCFD_LIFE_POLICY_DAILY

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 POL_NUM CHARACTER VARYING(20) 20
3 POL_STAT_CODE CHARACTER VARYING(20) 20
4 POL_STAT_DESC CHARACTER VARYING(50) 50
5 INSTLMT_POL_FEE_AMT NUMERIC(18,6) 19
6 NUM_POL_OVERDUE_DAYS BIGINT 8
7 POL_PAID_TO_DATE DATE 4
8 POL_BILLED_TO_DATE DATE 4
9 POL_BLLG_DAY_IN_MTH BIGINT 8
10 NXT_PAYT_DATE DATE 4
11 BLLG_REN_DATE DATE 4
12 POL_INSTLMT_PREM_AMT NUMERIC(18,6) 19
13 MNDTE_REF_NUM CHARACTER VARYING(20) 20
14 MNDTE_STAT_CODE CHARACTER VARYING(20) 20
15 PAYER_MNDTE_STAT_DESC CHARACTER VARYING(100) 100
16 PAYER_BSB_NUM CHARACTER VARYING(20) 20
17 PAYER_ACCT_NUM CHARACTER VARYING(20) 20
18 CR_CRD_LST_4_NUM CHARACTER VARYING(20) 20
19 SUM_INSD NUMERIC(18,6) 19
20 ANN_PREM_AMT NUMERIC(18,6) 19
21 INSTLMT_PREM_AMT NUMERIC(18,6) 19
22 EQUIVALENT_ANN_PREM_AMT NUMERIC(18,6) 19
23 POTENTIAL_LAPSE_DATE DATE 4
24 PRDT_GRP_CODE CHARACTER VARYING(20) 20
25 PRDT_DESC CHARACTER VARYING(100) 100
26 CHNL_CODE CHARACTER VARYING(10) 10
27 CHNL_DESC CHARACTER VARYING(50) 50
28 SUB_CHNL_CODE CHARACTER VARYING(20) 20
29 SUB_CHNL_DESC CHARACTER VARYING(50) 50
30 PAYT_METH_CODE CHARACTER VARYING(20) 20
31 PAYT_METH_DESC CHARACTER VARYING(50) 50
32 PAYT_FREQ_CODE CHARACTER VARYING(20) 20
33 PAYT_FREQ_DESC CHARACTER VARYING(50) 50
34 POL_STRT_DATE DATE 4
35 POL_EXPIRY_DATE DATE 4
36 POL_REN_DATE DATE 4
37 POL_STAT_EFF_DATE DATE 4
38 POL_STAT_RGSTN_DATE DATE 4
39 POL_CANCEL_DATE DATE 4
40 SUM_INSD_INDXTN_IND CHARACTER VARYING(3) 3
41 POL_PREM_STAT_CODE CHARACTER VARYING(20) 20
42 POL_PREM_STAT_DESC CHARACTER VARYING(100) 100
43 SD_STATE_CODE CHARACTER VARYING(20) 20
44 SD_STATE_DESC CHARACTER VARYING(50) 50
45 POL_RGSTR_STATE_CODE CHARACTER VARYING(20) 20
46 POL_RGSTR_DESC CHARACTER VARYING(50) 50
47 PREM_INDXTN_IND CHARACTER VARYING(4) 4
48 NOTIFIED_CLM_CNT BIGINT 8
49 ACTV_CLM_CNT BIGINT 8
50 TOT_ACTV_CLM_PAID_AMT NUMERIC(18,6) 19
51 PNDG_CLM_CNT BIGINT 8
52 CLSD_CLM_CNT BIGINT 8
53 TOT_CLSD_CLM_PAID_AMT NUMERIC(18,6) 19
54 LST_CLM_CLSD_DATE DATE 4
55 CLM_BNFT_FLG CHARACTER VARYING(3) 3
56 SUPERCHARGE_DISC_FLG CHARACTER VARYING(3) 3
57 SUPERCHARGE_DISC_STRT_DATE DATE 4
58 SUPERCHARGE_DISC_PCTAGE NUMERIC(10,4) 19
59 BNFT_CODES CHARACTER VARYING(100) 100
60 LST_RENEW_NOTICE_TYP CHARACTER VARYING(20) 20
61 LST_RENEW_SEQ_NUM CHARACTER VARYING(20) 20
62 LST_RENEW_STAT_CODE CHARACTER VARYING(20) 20
63 LST_RENEW_REQ_DATE DATE 4
64 LST_RENEW_PRT_DATE DATE 4
65 NXT_RENEW_NOTICE_TYP CHARACTER VARYING(20) 20
66 NXT_RENEW_NOTICE_DATE DATE 4
67 WELC_LETTER_DATE DATE 4
68 AGNT_CODE CHARACTER VARYING(20) 20
69 ASIS_CODE CHARACTER VARYING(20) 20
70 LST_BUS_LDR_YR CHARACTER VARYING(50) 50
71 BRND_CODE CHARACTER VARYING(50) 50
72 CMPGN_EXCLUSION_FLG CHARACTER VARYING(3) 3
73 OLD_PRDT_SYS_CODE CHARACTER VARYING(10) 10
74 OLD_POL_NUM CHARACTER VARYING(20) 20