FCT_WCOM_POLICY_DMR_INSIGHT_Q2

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 POLICY INTEGER 4
4 QTEPRDUCT CHARACTER(3) 3
5 PRODUCT CHARACTER(3) 3
6 POLICY_TERMSTART_KEY INTEGER 4
7 ITEMNO SMALLINT 2
8 ANZSICCD_1993_KEY BIGINT 8
9 ANZSICCD_2006_KEY BIGINT 8
10 ANZSICIR_2006_KEY BIGINT 8
11 EXTENSION_LEVEL1_KEY INTEGER 4
12 EXTENSION_LEVEL2_KEY BIGINT 8
13 HAZARD_INDEX_KEY INTEGER 4
14 INFORCE_TO_DATE_KEY INTEGER 4
15 POLICY_INCEPTION_DATE_KEY INTEGER 4
16 ITEM_RISKSTATE_KEY INTEGER 4
17 POLICY_STAGE_LEVEL1_KEY BIGINT 8
18 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
19 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
20 ITEM_DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
21 ITEM_DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
22 ITEM_SUBCLASS_KEY BIGINT 8
23 MIN_PREM_FLAG_POL_KEY INTEGER 4
24 MULTIANZSIC_FLAG_KEY INTEGER 4
25 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
26 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
27 POLICY_TRANSACTION_DATE_KEY INTEGER 4
28 POLICY_EXPIRY_DATE INTEGER 4
29 PREM_SEGMENT_KEY INTEGER 4
30 PREV_INSURANCE_YEARS_KEY INTEGER 4
31 PRIORCLM_KEY INTEGER 4
32 POLICY_TERM_OFFERING_KEY BIGINT 8
33 SCHEME_KEY BIGINT 8
34 INSTALFRQ CHARACTER(2) 2
35 MULTIYEAR_KEY INTEGER 4
36 GAZETTEPLUS75_KEY INTEGER 4
37 CAT_C CHARACTER VARYING(2) 2
38 RENLIKEIND_KEY CHARACTER VARYING(4) 4
39 ISSUEDSTATE_KEY INTEGER 4
40 CANCEL_ON_INCEPTION_KEY INTEGER 4
41 POLICY_TERM_STATUS CHARACTER VARYING(1) 1
42 PREVIOUS_INSURER_KEY BIGINT 8
43 AGENT INTEGER 4
44 UNDERWRITER_KEY BIGINT 8
45 PREV_INSURER_GROUP_KEY BIGINT 8
46 POLICY_INFORCE INTEGER 4
47 POLICY_INFORCE_KEY INTEGER 4
48 RISK_MGMT_TYPE CHARACTER(1) 1
49 NAT_BUNDLE_DESC CHARACTER VARYING(60) 60
50 BASIC_PREMIUM NUMERIC(38,2) 19
51 GROSS_FULL_TERM_PAID_POLICY_COUNT NUMERIC(38,0) 19
52 GROSS_NB_COUNT NUMERIC(38,0) 19
53 GROSS_NB_PREMIUM NUMERIC(38,2) 19
54 ISSUED_QUOTE_COUNT NUMERIC(38,0) 19
55 ISSUED_QUOTE_PREMIUM NUMERIC(38,2) 19
56 NET_FULL_TERM_PAID_POLICY_COUNT NUMERIC(38,0) 19
57 NET_NB_COUNT NUMERIC(38,0) 19
58 NET_NB_PREMIUM NUMERIC(38,2) 19
59 TOTAL_PAID_POLICY_COUNT NUMERIC(38,0) 19
60 TOTAL_PAID_POLICY_PREMIUM NUMERIC(38,2) 19
61 TRANSACTION_COUNT NUMERIC(38,0) 19
62 ITEM_COUNT NUMERIC(38,0) 19
63 POLICY_COUNT NUMERIC(38,0) 19
64 ITEM_REFERRAL_COUNT BIGINT 8
65 EARNED_PREMIUM NUMERIC(38,2) 19
66 COMMISSION NUMERIC(38,2) 19
67 CURRENT_NOEMP INTEGER 4
68 CURRENT_WAGES NUMERIC(11,0) 19
69 INITIAL_ESTIMATED_NOEMP INTEGER 4
70 INITIAL_ESTIMATED_WAGES NUMERIC(11,0) 19
71 TOTAL_BASE_PREMIUM NUMERIC(11,2) 19
72 TOTAL_MODEL_PREMIUM NUMERIC(15,2) 19
73 TOTAL_MODEL_PREMIUM_INCL_COMM NUMERIC(38,2) 19
74 TOTAL_INDUSTRY_PREMIUM NUMERIC(15,2) 19
75 TOTAL_TECHNICAL_PREMIUM NUMERIC(15,2) 19
76 EARNED_WAGES NUMERIC(15,2) 19
77 CLAIM_COUNT NUMERIC(38,0) 19
78 CLAIM_GROSSRESERVE NUMERIC(38,2) 19
79 CLAIM_INCURTODATE NUMERIC(38,2) 19
80 CLAIM_PAIDTODATE NUMERIC(38,2) 19
81 CLAIM_RECOVERTODATE NUMERIC(38,2) 19
82 DEVELOPED_CLAIMS_COST NUMERIC(38,7) 19
83 DEVELOPED_LARGE_CLAIMS_COST NUMERIC(38,7) 19
84 LARGE_CLAIM_COUNT NUMERIC(38,0) 19
85 NON_ZERO_CLAIMS_COUNT NUMERIC(38,0) 19
86 POLICY_REFERRAL_COUNT INTEGER 4
87 TOTAL_NO_OF_REFERRALS NUMERIC(38,0) 19
88 POLICY_AVL_FOR_RENEW INTEGER 4
89 BASICPREM NUMERIC(38,2) 19
90 LY_PREM NUMERIC(38,2) 19
91 LY_PREM_RENEWED NUMERIC(38,2) 19
92 POLICY_EXPIRING NUMERIC(38,0) 19
93 POLICY_RENEWED_V1 NUMERIC(38,0) 19
94 POLICY_RENEWED_V2 NUMERIC(38,0) 19
95 LY_BASE_PREMIUM NUMERIC(11,2) 19
96 LY_CURRENT_WAGES NUMERIC(12,1) 19
97 LY_BASIC_PREMIUM NUMERIC(38,2) 19
98 POLICY_TERM_IND_DESC BIGINT 8
99 OVERALL_MOD_RATE NUMERIC(11,2) 19
100 OVERALL_UW_RATE NUMERIC(11,2) 19
101 UWRATE_ADJ NUMERIC(11,2) 19
102 MDLRATE NUMERIC(11,2) 19
103 DEVELOPED_LOSS_RATIO NUMERIC(38,6) 19
104 LOSSRATIOBAND CHARACTER VARYING(12) 12
105 LR_BAND_KEY BIGINT 8