FCT_CUST_PRODUCT_COMMERCIAL_INSURANCE_PH

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(3) 3
2 COVERAGEKEY BIGINT 8
3 PRDT_HOLDNG_NUM CHARACTER VARYING(41) 41
4 POL_NUM CHARACTER VARYING(30) 30
5 CVRG_NUM INTEGER 4
6 TRM_ID INTEGER 4
7 CRNT_TXN_NUM INTEGER 4
8 PRDT_BRAND_CODE CHARACTER VARYING(8) 8
9 PRODUCT CHARACTER VARYING(8) 8
10 CLASS CHARACTER VARYING(30) 30
11 SUBCLASS CHARACTER VARYING(30) 30
12 PROD_STRUCT1 CHARACTER VARYING(50) 50
13 PROD_STRUCT2 CHARACTER VARYING(50) 50
14 PROD_STRUCT3 CHARACTER VARYING(50) 50
15 PROD_STRUCT4 CHARACTER VARYING(50) 50
16 PROD_STRUCT5 CHARACTER VARYING(50) 50
17 PROD_STRUCT6 CHARACTER VARYING(50) 50
18 CVRG_UPSELL_DATE DATE 4
19 CVRG_RENEWED_DATE DATE 4
20 CVRG_CHG_EFF_DATE DATE 4
21 CVRG_EXPIRY_DATE DATE 4
22 POL_INC_DATE DATE 4
23 ANN_PREM_AMT NUMERIC(13,2) 19
24 CANC_LAPSE_IND CHARACTER VARYING(30) 30
25 CANCEL_RSN_CODE CHARACTER VARYING(30) 30
26 CANCEL_RSN_DESC CHARACTER VARYING(60) 60
27 TXN_INFORCE_IND INTEGER 4
28 STATEISSUE CHARACTER VARYING(30) 30
29 OCCUPATN CHARACTER VARYING(30) 30
30 ANZSIC2006_L1_CODE CHARACTER VARYING(10) 10
31 ANZSIC2006_L1_DESC CHARACTER VARYING(200) 200
32 ANZSIC2006_L2_CODE CHARACTER VARYING(10) 10
33 ANZSIC2006_L2_DESC CHARACTER VARYING(200) 200
34 ANZSIC2006_L3_CODE CHARACTER VARYING(10) 10
35 ANZSIC2006_L3_DESC CHARACTER VARYING(200) 200
36 RISK_STATE CHARACTER VARYING(30) 30
37 RISK_STATE_NAME CHARACTER VARYING(28) 28
38 RISK_SUBURB CHARACTER VARYING(40) 40
39 RISK_POSTCODE CHARACTER VARYING(10) 10
40 ICAZONE CHARACTER VARYING(10) 10
41 ICAGROUP CHARACTER VARYING(50) 50
42 SUMINSURED NUMERIC(15,0) 19
43 TURNOVER BIGINT 8
44 CRNT_TXN_DATE DATE 4
45 TXN_TYPE_CODE CHARACTER VARYING(30) 30
46 TXN_TYPE_DESC CHARACTER VARYING(19) 19
47 PAYT_FREQ_CODE CHARACTER(4) 4
48 PAIDSTATUS CHARACTER VARYING(30) 30
49 ORIG_PAIDSTATUS CHARACTER VARYING(30) 30
50 BUSNESSRC CHARACTER VARYING(30) 30
51 PACKAGE CHARACTER VARYING(60) 60
52 CPBUSSRC CHARACTER VARYING(30) 30
53 CPSTAFFNO CHARACTER VARYING(30) 30
54 BDM_STATE_CODE CHARACTER VARYING(10) 10
55 AGNT_CODE CHARACTER VARYING(30) 30
56 CHANNEL_STRUCT1 CHARACTER VARYING(100) 100
57 CHANNEL_STRUCT2 CHARACTER VARYING(100) 100
58 CHANNEL_STRUCT3 CHARACTER VARYING(100) 100
59 CHANNEL_STRUCT4 CHARACTER VARYING(200) 200
60 CHANNEL_STRUCT5 CHARACTER VARYING(200) 200
61 ADVOCATE_ACCNT_TYPE CHARACTER VARYING(50) 50
62 ADVOCATE_STRUCT1 CHARACTER VARYING(50) 50
63 ADVOCATE_STRUCT2 CHARACTER VARYING(200) 200
64 ADVOCATE_STRUCT3 CHARACTER VARYING(200) 200
65 ADVOCATE_STRUCT4 CHARACTER VARYING(200) 200
66 ADVOCATE_STRUCT5 CHARACTER VARYING(200) 200
67 ADVOCATE_STRUCT6 CHARACTER VARYING(200) 200
68 PREVIOUS_INSURER_CODE CHARACTER(4) 4
69 PREVIOUS_INSURER_DESC CHARACTER VARYING(60) 60
70 QANTAS_FLAG CHARACTER VARYING(3) 3
71 QANTAS_MEMBER_NUM CHARACTER VARYING(20) 20
72 BRANCH CHARACTER VARYING(30) 30
73 TSTMPDUTY NUMERIC(15,2) 19
74 BUSINESS_SOURCE_CODE CHARACTER VARYING(4) 4
75 CHANNEL_CODE CHARACTER VARYING(30) 30
76 AGTACCTYP CHARACTER VARYING(30) 30
77 WC_EST_EMP_CNT NUMERIC(9,0) 19
78 WC_ACT_EMP_CNT INTEGER 4
79 WC_EST_EMP_WAGES NUMERIC(13,2) 19
80 WC_ACT_EMP_WAGES NUMERIC(11,0) 19
81 MVBODTYPE CHARACTER VARYING(30) 30
82 MVBODTYPE_DESC CHARACTER VARYING(60) 60
83 ROLECLASS CHARACTER VARYING(30) 30
84 ROLECLASS_DESC CHARACTER VARYING(60) 60
85 PAI_AGE INTEGER 4
86 SNAPSHOT_DATE CHARACTER VARYING(8) 8