FCT_WCOM_TXN_DT_INSIGHT_CHG0208348

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 POLICY_NUMBER CHARACTER VARYING(12) 12
4 PRODUCT CHARACTER(3) 3
5 ITEM_CLASS CHARACTER(3) 3
6 ITEM_SUBCLASS CHARACTER(3) 3
7 ITEM_SUBCLASS_KEY BIGINT 8
8 POLICY INTEGER 4
9 ITEMNO SMALLINT 2
10 ITEM_RISKSTATE_KEY INTEGER 4
11 ITEM_RISKSTATE_NAME CHARACTER(10) 10
12 ENTITY_NAME CHARACTER VARYING(90) 90
13 POLICY_STAGE_LEVEL1_KEY_POLICY BIGINT 8
14 POLICY_STAGE_LEVEL1_KEY BIGINT 8
15 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
16 POLICY_STAGE_LEVEL2_KEY BIGINT 8
17 POLICY_STAGE_LEVEL2 CHARACTER VARYING(25) 25
18 NEW_BUSINESS_SOURCE_OF_SALES CHARACTER VARYING(60) 60
19 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
20 BUSINESS_SOURCE_OF_SALES CHARACTER VARYING(60) 60
21 DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
22 DISTRIBUTION_CHANNEL_LEVEL1 CHARACTER VARYING(13) 13
23 DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
24 DISTRIBUTION_CHANNEL_LEVEL2 CHARACTER VARYING(29) 29
25 POLICY_TERMSTART_KEY INTEGER 4
26 POLICY_DUE_DATE_KEY INTEGER 4
27 POLICY_INCEPTION_DATE_KEY INTEGER 4
28 ITEM_TERM_EFFECTIVE_DATE_KEY INTEGER 4
29 ITEM_TERM_EXPIRY_DATE_KEY INTEGER 4
30 EFFECTIVE_DATE_KEY INTEGER 4
31 TRANSACTION_DATE_KEY INTEGER 4
32 TRANSACTION_TIME INTEGER 4
33 TRANCNT SMALLINT 2
34 TRANSACTION_COUNT INTEGER 4
35 CANCEL_REASON_KEY CHARACTER VARYING(2) 2
36 CANCEL_REASON_DESC CHARACTER VARYING(60) 60
37 TRANSACTION_REASON_CODE CHARACTER VARYING(4) 4
38 TRANSACTION_REASON_DESCRIPTION CHARACTER(20) 20
39 TRAN_TYPE CHARACTER VARYING(2) 2
40 POLICY_STATUS CHARACTER VARYING(1) 1
41 MULTIANZSIC_FLAG_KEY INTEGER 4
42 MULTIANZSIC_FLAG CHARACTER VARYING(1) 1
43 EXTENSION_LEVEL1_NAME CHARACTER(1) 1
44 EXTENSION_LEVEL2_NAME CHARACTER VARYING(60) 60
45 PREM_BAND_KEY INTEGER 4
46 PREM_BAND CHARACTER VARYING(9) 9
47 PREM_SEGMENT_KEY INTEGER 4
48 PREM_SEGMENT CHARACTER VARYING(17) 17
49 AGENCY_NUMBER INTEGER 4
50 CPSTAFF_NUMBER CHARACTER VARYING(10) 10
51 CPSTAFF_CURRENT CHARACTER VARYING(8) 8
52 PRIORCLM_KEY INTEGER 4
53 PRIORCLM CHARACTER VARYING(1) 1
54 PREVIOUS_POLICY_NUMBER CHARACTER(14) 14
55 ANZSICCD_1993_KEY BIGINT 8
56 ANZSICCD_2006_KEY BIGINT 8
57 ANZSICIR_2006_KEY BIGINT 8
58 EXTENSION_LEVEL1_KEY INTEGER 4
59 EXTENSION_LEVEL2_KEY BIGINT 8
60 ITEM_EXTENSION_LEVEL1_KEY INTEGER 4
61 ITEM_EXTENSION_LEVEL2_KEY BIGINT 8
62 HAZARD_INDEX_KEY INTEGER 4
63 HAZARD_INDEX CHARACTER VARYING(10) 10
64 PREV_INSURANCE_YEARS CHARACTER VARYING(10) 10
65 ABN CHARACTER(12) 12
66 ACN CHARACTER(9) 9
67 ACQUIRE_MEMBERSHIP_NUMBER CHARACTER(15) 15
68 WORKCOVER_NUMBER CHARACTER(15) 15
69 END_MOBILE CHARACTER(19) 19
70 END_EMAIL CHARACTER VARYING(120) 120
71 END_CONSENT CHARACTER(1) 1
72 ITEM_RISK_ADDRESS CHARACTER VARYING(150) 150
73 ITEM_RISK_POSTCODE NUMERIC(6,0) 19
74 POLICY_TRANSACTION_DATE_KEY INTEGER 4
75 POLICY_EXPIRY_DATE INTEGER 4
76 SCHEME_KEY BIGINT 8
77 REFUND_REASON_KEY INTEGER 4
78 REFUND_REASON CHARACTER VARYING(65) 65
79 INSTALFRQ CHARACTER(2) 2
80 POLICY_DURATION_KEY INTEGER 4
81 MULTIYEAR_KEY INTEGER 4
82 COMM_ADJ_RC CHARACTER VARYING(65) 65
83 INITIAL_ESTIMATED_WAGES NUMERIC(11,0) 19
84 CURRENT_WAGES NUMERIC(11,0) 19
85 INITIAL_ESTIMATED_NOEMP INTEGER 4
86 CURRENT_NOEMP INTEGER 4
87 MIN_PREM_FLAG_TRAN CHARACTER VARYING(1) 1
88 DISCOUNT_PC NUMERIC(4,2) 19
89 DISCOUNT_RC CHARACTER(2) 2
90 LOADING_PC NUMERIC(5,2) 19
91 LOADING_RC CHARACTER(2) 2
92 CHARGES NUMERIC(11,2) 19
93 GST NUMERIC(11,2) 19
94 STAMP_DUTY NUMERIC(11,2) 19
95 INFORCE_TO_DATE_KEY INTEGER 4
96 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(2) 2
97 ITEM_DISTRIBUTION_CHANNEL_LEVEL1_KEY CHARACTER VARYING(22) 22
98 ITEM_DISTRIBUTION_CHANNEL_LEVEL2_KEY CHARACTER VARYING(22) 22
99 MIN_PREM_FLAG_POL_KEY INTEGER 4
100 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(2) 2
101 PREV_INSURANCE_YEARS_KEY INTEGER 4
102 BASIC_PREMIUM NUMERIC(11,2) 19
103 GROSS_FULL_TERM_PAID_POLICY_COUNT INTEGER 4
104 GROSS_NB_COUNT INTEGER 4
105 GROSS_NB_PREMIUM NUMERIC(15,2) 19
106 ISSUED_QUOTE_COUNT INTEGER 4
107 ISSUED_QUOTE_PREMIUM NUMERIC(15,2) 19
108 NET_FULL_TERM_PAID_POLICY_COUNT INTEGER 4
109 NET_NB_COUNT INTEGER 4
110 NET_NB_PREMIUM NUMERIC(15,2) 19
111 TOTAL_PAID_POLICY_COUNT INTEGER 4
112 TOTAL_PAID_POLICY_PREMIUM NUMERIC(11,2) 19
113 POLICY_TERM_OFFERING_KEY BIGINT 8
114 GROUP_OFFERING_KEY BIGINT 8
115 EARNED_PREMIUM NUMERIC(12,2) 19
116 ESTWAGES NUMERIC(11,0) 19
117 ACTWAGES NUMERIC(11,0) 19
118 ESTNOEMP INTEGER 4
119 ACTNOEMP INTEGER 4
120 GAZETTEPLUS75_KEY INTEGER 4
121 COMMISSION NUMERIC(11,2) 19
122 COMMISSION_ADJ NUMERIC(4,2) 19
123 AGENT_NAME CHARACTER VARYING(81) 81
124 AGENT_GROUP CHARACTER VARYING(75) 75
125 AGENT_CLUSTER CHARACTER VARYING(67) 67
126 CORP_PARTNER CHARACTER VARYING(81) 81
127 CAT_C CHARACTER VARYING(2) 2
128 RENLIKEIND_KEY CHARACTER VARYING(4) 4
129 IDP CHARACTER VARYING(50) 50
130 CANCEL_ON_INCEPTION_KEY INTEGER 4
131 ISSUEDSTATE_KEY INTEGER 4
132 PREVIOUS_INSURER_KEY BIGINT 8
133 UNDERWRITER_KEY BIGINT 8
134 UW_CODE CHARACTER VARYING(8) 8
135 AGENT INTEGER 4
136 PREV_INSURER_GROUP CHARACTER VARYING(8) 8
137 PREV_INSURER_GROUP_KEY BIGINT 8
138 POLICY_INFORCE_KEY INTEGER 4