FCT_WCOM_ITEM_DT_INSIGHT_Q2

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 POLICY INTEGER 4
5 POLICY_NUMBER CHARACTER VARYING(12) 12
6 POLICY_TERMSTART_KEY INTEGER 4
7 ITEMNO SMALLINT 2
8 ITEM_RISKSTATE_KEY INTEGER 4
9 ITEM_RISKSTATE_NAME CHARACTER(10) 10
10 ITEM_DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
11 ITEM_DISTRIBUTION_CHANNEL_LEVEL1 CHARACTER VARYING(13) 13
12 ITEM_DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
13 ITEM_DISTRIBUTION_CHANNEL_LEVEL2 CHARACTER VARYING(29) 29
14 POLICY_DUE_DATE_KEY INTEGER 4
15 ITEM_TERM_STATUS CHARACTER(1) 1
16 ANZSICCD_1993_KEY BIGINT 8
17 ANZSICCD_2006_KEY BIGINT 8
18 ANZSICIR_2006_KEY BIGINT 8
19 EXTENSION_LEVEL1_KEY INTEGER 4
20 EXTENSION_LEVEL1_NAME CHARACTER(1) 1
21 EXTENSION_LEVEL2_KEY BIGINT 8
22 EXTENSION_LEVEL2_NAME CHARACTER VARYING(60) 60
23 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
24 ITEM_CANCEL_REASON_DESC CHARACTER VARYING(60) 60
25 MIN_PREM_FLAG_ITEM CHARACTER VARYING(1) 1
26 MIN_PREM_FLAG_POL_KEY INTEGER 4
27 HAZARD_INDEX_KEY INTEGER 4
28 HAZARD_INDEX CHARACTER VARYING(10) 10
29 MULTIANZSIC_FLAG_KEY INTEGER 4
30 MULTIANZSIC_FLAG CHARACTER VARYING(1) 1
31 NEW_BUSINESS_SOURCE_OF_SALES CHARACTER VARYING(60) 60
32 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
33 BUSINESS_SOURCE_OF_SALES CHARACTER VARYING(60) 60
34 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(2) 2
35 INFORCE_TO_DATE_KEY INTEGER 4
36 POLICY_INCEPTION_DATE_KEY INTEGER 4
37 POLICY_TRANSACTION_DATE_KEY INTEGER 4
38 POLICY_EXPIRY_DATE INTEGER 4
39 PREM_BAND CHARACTER VARYING(9) 9
40 PREM_BAND_KEY INTEGER 4
41 PREM_SEGMENT CHARACTER VARYING(17) 17
42 PREM_SEGMENT_KEY INTEGER 4
43 PREV_INSURANCE_YEARS_KEY INTEGER 4
44 PREV_INSURANCE_YEARS CHARACTER VARYING(10) 10
45 PRIORCLM_KEY INTEGER 4
46 PRIORCLM CHARACTER VARYING(1) 1
47 POLICY_STAGE_LEVEL1_KEY BIGINT 8
48 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
49 CHARGES NUMERIC(38,2) 19
50 GST NUMERIC(38,2) 19
51 STAMP_DUTY NUMERIC(38,2) 19
52 TOTAL_PAID_POLICY_PREMIUM NUMERIC(38,2) 19
53 INITIAL_ESTIMATED_WAGES NUMERIC(11,0) 19
54 CURRENT_WAGES NUMERIC(11,0) 19
55 INITIAL_ESTIMATED_NOEMP INTEGER 4
56 CURRENT_NOEMP INTEGER 4
57 MINIMUM_PREMIUM NUMERIC(11,2) 19
58 TOTAL_BASE_PREMIUM NUMERIC(11,2) 19
59 TOTAL_TECHNICAL_PREMIUM NUMERIC(15,2) 19
60 TOTAL_MODEL_PREMIUM NUMERIC(15,2) 19
61 TOTAL_INDUSTRY_PREMIUM NUMERIC(15,2) 19
62 BASE_PREMIUM_RATE NUMERIC(27,14) 19
63 TECHNICAL_PREMIUM_RATE NUMERIC(5,2) 19
64 MODEL_PREMIUM_RATE NUMERIC(5,2) 19
65 INDUSTRY_PREMIUM_RATE NUMERIC(5,2) 19
66 PURE_MODEL_RATE NUMERIC(5,2) 19
67 MODELUW_VARIANCE NUMERIC(5,2) 19
68 TECHUW_VARIANCE NUMERIC(5,2) 19
69 INDUW_VARIANCE NUMERIC(5,2) 19
70 MIN_PREM_ADJ NUMERIC(11,2) 19
71 MIN_PREM_ADJ_RC CHARACTER(2) 2
72 EXT_BASE_PREM_ADJ NUMERIC(11,2) 19
73 EXT_BASE_PREM_ADJ_RC CHARACTER(2) 2
74 UWRATE_ADJ NUMERIC(5,2) 19
75 UWRATE_ADJ_RC CHARACTER(2) 2
76 ITEM_ITCE NUMERIC(6,2) 19
77 DISCOUNT_PC NUMERIC(4,2) 19
78 DISCOUNT_RC CHARACTER(2) 2
79 LOADING_PC NUMERIC(5,2) 19
80 LOADING_RC CHARACTER(2) 2
81 ENTITY_NAME CHARACTER VARYING(90) 90
82 PREVIOUS_POLICY_NUMBER CHARACTER(14) 14
83 ABN CHARACTER(12) 12
84 ACN CHARACTER(9) 9
85 ACQUIRE_MEMBERSHIP_NUMBER CHARACTER(15) 15
86 WORKCOVER_NUMBER CHARACTER(15) 15
87 END_MOBILE CHARACTER(19) 19
88 END_EMAIL CHARACTER VARYING(120) 120
89 END_CONSENT CHARACTER(1) 1
90 ITEM_CLASS CHARACTER(3) 3
91 ITEM_SUBCLASS CHARACTER(3) 3
92 ITEM_SUBCLASS_KEY BIGINT 8
93 ITEM_TERM_EFFECTIVE_DATE_KEY INTEGER 4
94 ITEM_TERM_EXPIRY_DATE_KEY INTEGER 4
95 ITEM_RISK_ADDRESS CHARACTER VARYING(150) 150
96 ITEM_RISK_POSTCODE NUMERIC(6,0) 19
97 GAZETTEPLUS75 CHARACTER VARYING(1) 1
98 GAZETTEPLUS75_KEY INTEGER 4
99 WA_GAZETTE_DISCOUNT CHARACTER VARYING(1) 1
100 POLICY_TERM_OFFERING_KEY BIGINT 8
101 GROUP_OFFERING_KEY BIGINT 8
102 EARNED_PREMIUM NUMERIC(38,2) 19
103 EARNED_WAGES NUMERIC(15,2) 19
104 SCHEME_KEY BIGINT 8
105 REGO_NO CHARACTER(12) 12
106 SCHEME_TYPE CHARACTER VARYING(4) 4
107 SCHEME_TYPE_DESC CHARACTER VARYING(60) 60
108 POLICY_COMPLTIND CHARACTER(12) 12
109 INSTALFRQ CHARACTER(2) 2
110 POLICY_DURATION_KEY INTEGER 4
111 POLICY_DURATION CHARACTER VARYING(15) 15
112 MULTIYEAR_KEY INTEGER 4
113 COMMISSION NUMERIC(38,2) 19
114 AGENT_NAME CHARACTER VARYING(81) 81
115 AGENT_GROUP CHARACTER VARYING(75) 75
116 AGENT_CLUSTER CHARACTER VARYING(67) 67
117 CORP_PARTNER CHARACTER VARYING(81) 81
118 UW_CODE CHARACTER VARYING(8) 8
119 UW_NAME NATIONAL CHARACTER VARYING(250) 250
120 WAGEDEC_ACT CHARACTER(2) 2
121 WAGEDEC_EST CHARACTER(2) 2
122 CAT_C CHARACTER VARYING(2) 2
123 RENLIKEIND_KEY CHARACTER VARYING(4) 4
124 RISK_MGMT_TYPE CHARACTER(1) 1
125 INCENTIVE_OFFERED INTEGER 4
126 INCENTIVE_PAID INTEGER 4
127 INCENTIVE_EARNED INTEGER 4
128 NAT_BUNDLE_DESC CHARACTER VARYING(60) 60
129 BUNDLE_ID INTEGER 4
130 BUNDLE_INDICATOR CHARACTER VARYING(1) 1
131 BUNDLETYPE CHARACTER VARYING(4) 4
132 BUNDLE_OWNER CHARACTER VARYING(60) 60
133 IDP CHARACTER VARYING(50) 50
134 NEW_TERM_DUE_DATE CHARACTER VARYING(200) 200
135 RBASICPRM NUMERIC(11,2) 19
136 BASIC_PREMIUM NUMERIC(38,2) 19
137 BASICPRM NUMERIC(38,2) 19
138 LY_WAGES NUMERIC(12,1) 19
139 CHANGE_IN_WAGES NUMERIC(26,13) 19
140 LY_RATE NUMERIC(5,2) 19
141 CHANGE_IN_RATE NUMERIC(14,8) 19
142 LY_MIN_PREM CHARACTER VARYING(1) 1
143 LY_PREM NUMERIC(38,2) 19
144 LY_PREM_RENEWED NUMERIC(38,2) 19
145 CANCEL_ON_INCEPTION_KEY INTEGER 4
146 CANCEL_ON_INCEPTION CHARACTER VARYING(1) 1
147 ISSUEDSTATE_KEY INTEGER 4
148 ISSUEDSTATE_NAME CHARACTER(10) 10
149 PREVIOUS_INSURER CHARACTER(9) 9
150 PREVIOUS_INSURER_KEY BIGINT 8
151 AGENCY_NUMBER INTEGER 4
152 LY_BASE_PREMIUM NUMERIC(11,2) 19
153 LY_CURRENT_WAGES NUMERIC(12,1) 19
154 LY_BASIC_PREMIUM NUMERIC(38,2) 19
155 MDLRATE NUMERIC(5,2) 19
156 UNDERWRITER_KEY BIGINT 8
157 AGENT INTEGER 4
158 PREV_INSURER_GROUP CHARACTER VARYING(8) 8
159 PREV_INSURER_GROUP_KEY BIGINT 8
160 POLICY_INFORCE_KEY INTEGER 4