FCT_WCOM_TXN_DMR_INSIGHT_CHG0208348

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 POLICY INTEGER 4
3 PRODUCT CHARACTER(3) 3
4 QTEPRDUCT CHARACTER(3) 3
5 POLICY_TERMSTART_KEY INTEGER 4
6 ITEMNO SMALLINT 2
7 TRANCNT SMALLINT 2
8 ANZSICCD_1993_KEY BIGINT 8
9 ANZSICCD_2006_KEY BIGINT 8
10 ANZSICIR_2006_KEY BIGINT 8
11 EFFECTDTE INTEGER 4
12 TRANSACTION_DATE_KEY INTEGER 4
13 EXTENSION_LEVEL1_KEY INTEGER 4
14 EXTENSION_LEVEL2_KEY BIGINT 8
15 HAZARD_INDEX_KEY INTEGER 4
16 INFORCE_TO_DATE_KEY INTEGER 4
17 POLICY_EXPIRY_DATE INTEGER 4
18 ITEM_RISKSTATE_KEY INTEGER 4
19 POLICY_STAGE_LEVEL1_KEY BIGINT 8
20 POLICY_STAGE_LEVEL2_KEY BIGINT 8
21 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(2) 2
22 ITEM_DISTRIBUTION_CHANNEL_LEVEL1_KEY CHARACTER VARYING(22) 22
23 ITEM_DISTRIBUTION_CHANNEL_LEVEL2_KEY CHARACTER VARYING(22) 22
24 MIN_PREM_FLAG_POL INTEGER 4
25 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
26 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
27 PREM_SEGMENT_KEY INTEGER 4
28 PREV_INSURANCE_YEARS_KEY INTEGER 4
29 PREVIOUS_INSURER_KEY BIGINT 8
30 PREV_INSURER_GROUP_KEY BIGINT 8
31 BASIC_PREMIUM NUMERIC(11,2) 19
32 GROSS_FULL_TERM_PAID_POLICY_COUNT INTEGER 4
33 GROSS_NB_COUNT INTEGER 4
34 GROSS_NB_PREMIUM NUMERIC(15,2) 19
35 ISSUED_QUOTE_COUNT INTEGER 4
36 ISSUED_QUOTE_PREMIUM NUMERIC(15,2) 19
37 NET_FULL_TERM_PAID_POLICY_COUNT INTEGER 4
38 NET_NB_COUNT INTEGER 4
39 NET_NB_PREMIUM NUMERIC(15,2) 19
40 TOTAL_PAID_POLICY_COUNT INTEGER 4
41 TOTAL_PAID_POLICY_PREMIUM NUMERIC(11,2) 19
42 TRANSACTION_COUNT INTEGER 4