INT_WCOM_POLICY_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 POLICY INTEGER 4
4 POLICY_NUMBER CHARACTER VARYING(12) 12
5 POLICY_TERMSTART INTEGER 4
6 PRODUCT CHARACTER(3) 3
7 QTEPRDUCT CHARACTER(3) 3
8 POLICY_INCEPTION_DATE_KEY INTEGER 4
9 POLICY_EXPIRY_DATE INTEGER 4
10 POLICY_TERM_STATUS CHARACTER VARYING(1) 1
11 POLICY_DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
12 POLICY_DISTRIBUTION_CHANNEL_LEVEL1 CHARACTER VARYING(13) 13
13 POLICY_DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
14 POLICY_DISTRIBUTION_CHANNEL_LEVEL2 CHARACTER VARYING(29) 29
15 CPBUSSRC CHARACTER VARYING(10) 10
16 UW_CODE CHARACTER VARYING(8) 8
17 UW_NAME NATIONAL CHARACTER VARYING(250) 250
18 AGENTTYPE CHARACTER(1) 1
19 AGTACCTYP CHARACTER(1) 1
20 AGENT_NAME CHARACTER VARYING(81) 81
21 AGENT_GROUP CHARACTER VARYING(75) 75
22 AGENT_CLUSTER CHARACTER VARYING(67) 67
23 CORP_PARTNER CHARACTER VARYING(81) 81
24 PREM_BAND CHARACTER VARYING(9) 9
25 PREM_SEGMENT CHARACTER VARYING(17) 17
26 PREM_SEGMENT_KEY INTEGER 4
27 PREM_BAND_KEY INTEGER 4
28 PREV_INSURANCE_YEARS CHARACTER VARYING(10) 10
29 PREV_INSURANCE_YEARS_KEY INTEGER 4
30 PREVIOUS_POLICY_NUMBER CHARACTER(14) 14
31 WORKCOVER_NUMBER CHARACTER(15) 15
32 ACQUIRE_MEMBERSHIP_NUMBER CHARACTER(15) 15
33 POLICY_RISK_ADDRESS CHARACTER VARYING(150) 150
34 POLICY_RISK_STATE_KEY CHARACTER VARYING(2) 2
35 POLICY_RISK_STATE_NAME CHARACTER VARYING(10) 10
36 POLICY_RISK_POSTCODE NUMERIC(6,0) 19
37 POSTAL_ADDRESS CHARACTER VARYING(150) 150
38 POSTAL_POSTCODE NUMERIC(6,0) 19
39 EXTENSION_LEVEL1_NAME_POL CHARACTER(1) 1
40 EXTENSION_LEVEL1_KEY_POL INTEGER 4
41 POLICY_CANCEL_REASON_CODE CHARACTER VARYING(2) 2
42 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
43 POLICY_CANCEL_REASON_DESC CHARACTER VARYING(60) 60
44 MIN_PREM_FLAG_POL CHARACTER(1) 1
45 MIN_PREM_FLAG_POL_KEY INTEGER 4
46 LAST_POLICY_AGENT INTEGER 4
47 ENTITY_NAME CHARACTER VARYING(90) 90
48 ABN CHARACTER(12) 12
49 ACN CHARACTER(9) 9
50 END_MOBILE CHARACTER(19) 19
51 END_EMAIL CHARACTER VARYING(120) 120
52 ITCE_POL NUMERIC(6,2) 19
53 END_CONSENT CHARACTER(1) 1
54 PRIORCLM CHARACTER VARYING(1) 1
55 PRIORCLM_KEY INTEGER 4
56 TRADING_PARTY_NAME CHARACTER VARYING(80) 80
57 PARTY_CONTACT_NUMBER CHARACTER VARYING(19) 19
58 PARTY_FACSIMILE_NUMBER CHARACTER VARYING(19) 19
59 AGENCY_NUMBER INTEGER 4
60 CPSTAFF_NUMBER CHARACTER VARYING(10) 10
61 MULTIANZSIC_FLAG CHARACTER VARYING(1) 1
62 MULTIANZSIC_FLAG_KEY INTEGER 4
63 SAQ CHARACTER VARYING(4) 4
64 TSQANS1 CHARACTER VARYING(4) 4
65 TSQANS2 CHARACTER VARYING(4) 4
66 TSQANS3 CHARACTER VARYING(4) 4
67 TSQANS4 CHARACTER VARYING(4) 4
68 TSQANS5 CHARACTER VARYING(4) 4
69 NEW_BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
70 NEW_BUSINESS_SOURCE_OF_SALES CHARACTER VARYING(60) 60
71 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
72 BUSINESS_SOURCE_OF_SALES CHARACTER VARYING(60) 60
73 CPSTAFF_CURRENT CHARACTER VARYING(10) 10
74 NUMBER_OF_LOCATIONS BIGINT 8
75 POLICY_TRANSACTION_DATE_KEY INTEGER 4
76 INFORCE_TO_DATE INTEGER 4
77 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
78 POLICY_STAGE_LEVEL1_KEY BIGINT 8
79 CLAIM_BASIS CHARACTER(1) 1
80 INTERIM_ADJ_FACTOR1 INTEGER 4
81 INTERIM_ADJ_FACTOR2 INTEGER 4
82 FINAL_ADJ_FACTOR1 INTEGER 4
83 FINAL_ADJ_FACTOR2 INTEGER 4
84 NO_OF_YEARS INTEGER 4
85 CALL_UP_FREQUENCY CHARACTER(1) 1
86 MAX_PREMIUM NUMERIC(11,0) 19
87 MAX_RATE NUMERIC(5,2) 19
88 MIN_PREMIUM NUMERIC(11,0) 19
89 MIN_RATE NUMERIC(5,2) 19
90 POLICY_TERM_OFFERING CHARACTER VARYING(9) 9
91 POLICY_TERM_OFFERING_KEY BIGINT 8
92 GROUP_OFFERING CHARACTER VARYING(12) 12
93 GROUP_OFFERING_KEY BIGINT 8
94 SCHEME_TYPE CHARACTER VARYING(4) 4
95 SCHEME_TYPE_DESC CHARACTER VARYING(60) 60
96 SCHEME CHARACTER VARYING(1) 1
97 SCHEME_KEY BIGINT 8
98 POLICY_COMPLTIND CHARACTER(12) 12
99 INSTALFRQ CHARACTER(2) 2
100 POLICY_DURATION_KEY INTEGER 4
101 POLICY_DURATION CHARACTER VARYING(10) 10
102 MULTIYEAR_KEY INTEGER 4
103 MULTIYEAR CHARACTER(2) 2
104 BUNDLE_INDICATOR CHARACTER VARYING(1) 1
105 BUNDLE_ID INTEGER 4
106 BUNDLETYPE CHARACTER VARYING(4) 4
107 NAT_BUNDLE_DESC CHARACTER VARYING(60) 60
108 BUNDLE_OWNER CHARACTER VARYING(60) 60
109 KAM1 CHARACTER VARYING(60) 60
110 KAM2 CHARACTER VARYING(60) 60
111 NAT_ACCOUNT CHARACTER VARYING(60) 60
112 NAT_OWNER CHARACTER VARYING(60) 60
113 FREE_FORMAT_FLAG CHARACTER VARYING(1) 1
114 AUTO_RENEW_FLAG CHARACTER VARYING(64) 64
115 RENLIKEIND_KEY CHARACTER VARYING(4) 4
116 RENLIKEIND CHARACTER VARYING(60) 60
117 CATEGORYCD CHARACTER VARYING(2) 2
118 IDP CHARACTER VARYING(50) 50
119 LY_MIN_PREM_POL CHARACTER VARYING(1) 1
120 POLICY_TERM_IND BIGINT 8
121 POLICY_INFORCE INTEGER 4
122 POLICY_INFORCE_KEY INTEGER 4
123 CLAIM_COUNT NUMERIC(38,0) 19
124 CLAIM_PAIDTODATE NUMERIC(38,2) 19
125 CLAIM_RECOVERTODATE NUMERIC(38,2) 19
126 CLAIM_GROSSRESERVE NUMERIC(38,2) 19
127 CLAIM_INCURTODATE NUMERIC(38,2) 19
128 NON_ZERO_CLAIMS_COUNT NUMERIC(38,0) 19
129 DEVELOPED_CLAIMS_COST NUMERIC(38,7) 19
130 LARGE_CLAIM_COUNT NUMERIC(38,0) 19
131 DEVELOPED_LARGE_CLAIMS_COST NUMERIC(38,7) 19
132 CEDREFPCT INTEGER 4
133 CEDPRMPCT INTEGER 4
134 MAXCEDREF INTEGER 4
135 IBNRIBNER INTEGER 4
136 RISK_MGMT_TYPE CHARACTER(1) 1
137 INCENTIVE_OFFERED INTEGER 4
138 INCENTIVE_PAID INTEGER 4
139 INCENTIVE_EARNED INTEGER 4
140 POLICY_REFERRAL_COUNT INTEGER 4
141 UNPAID_GROSS_PREMIUM NUMERIC(38,2) 19
142 UNPAID_NET_PREMIUM NUMERIC(38,2) 19
143 USERID CHARACTER(8) 8
144 USER_NAME CHARACTER VARYING(100) 100