INT_PI_HOME_STOCK_MOVEMENT_INTEGRATION

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_MONTH TIMESTAMP 8
2 CLAIM_ID BIGINT 8
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
5 TRANSACTION_DATE TIMESTAMP 8
6 LOSS_GROUP CHARACTER VARYING(15) 15
7 SUBLOSS_GROUP CHARACTER VARYING(18) 18
8 RISK_REGION CHARACTER VARYING(8) 8
9 RISK_STATE_NAME CHARACTER VARYING(256) 256
10 RISK_POSTCODE CHARACTER VARYING(60) 60
11 CLAIM_STATUS CHARACTER VARYING(256) 256
12 LOSS_LIMIT_BANDING CHARACTER VARYING(40) 40
13 CLAIM_TYPE CHARACTER VARYING(256) 256
14 ADJUSTER_TEAM CHARACTER VARYING(100) 100
15 BRAND CHARACTER VARYING(256) 256
16 OP_LOB CHARACTER VARYING(16) 16
17 LOSSCAUSE_MGMT CHARACTER VARYING(40) 40
18 LOSSCAUSE_OPR CHARACTER VARYING(40) 40
19 PRODUCT_NAME CHARACTER VARYING(256) 256
20 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
21 ASBESTOS_FLAG CHARACTER VARYING(256) 256
22 MOULD_FLAG CHARACTER VARYING(256) 256
23 TEMP_ACCOMMODATION_FLAG CHARACTER VARYING(256) 256
24 MEDIA_SENSITIVITY CHARACTER VARYING(256) 256
25 INSURED_CONTACT_NAME CHARACTER VARYING(181) 181
26 EVENT_TYPE CHARACTER VARYING(256) 256
27 OUTSTANDING_DEMANDED_EX_GST NUMERIC(38,6) 19
28 RECOVERY_DEMANDED_REC_COUNT INTEGER 4
29 LARGE_LOSS_INDICATOR CHARACTER VARYING(3) 3
30 ONLINE_LODGEMENT_FLAG CHARACTER VARYING(1) 1
31 EXPOSURE_TYPE CHARACTER VARYING(19) 19
32 INGOING_ESTIMATE_EX_GST NUMERIC(38,6) 19
33 TOTAL_INGOING_ESTIMATE_EX_GST NUMERIC(38,6) 19
34 NEW_NET_INCURRED_BY_MONTH_FLAG SMALLINT 2
35 ACTIVE_START_COUNT NUMERIC(38,0) 19
36 NEW_CLAIM_COUNT NUMERIC(38,0) 19
37 REOPEN_COUNT NUMERIC(38,0) 19
38 CLOSED_COUNT NUMERIC(38,0) 19
39 ACTIVE_END_COUNT NUMERIC(38,0) 19
40 TRANSACTION_DAYS_NEW NUMERIC(38,0) 19
41 TRANSACTION_DAYS_AGE_BAND CHARACTER VARYING(10) 10
42 LAST_TOUCHED_DAYS_DURATION NUMERIC(38,0) 19
43 LAST_TOUCHED_DAYS_DURATION_BAND CHARACTER VARYING(10) 10
44 REOPEN_DURATION_DAYS INTEGER 4
45 REOPEN_DURATION_DAYS_BAND CHARACTER VARYING(12) 12
46 REOPEN_INTERVAL_DAYS NUMERIC(38,0) 19
47 OPEN_RESERVES_EX_GST NUMERIC(38,6) 19
48 TOTAL_NIC_REOPENED NUMERIC(38,6) 19
49 NEW_NET_INCURRED_EX_GST NUMERIC(38,6) 19
50 EXISTING_NET_INCURRED_EX_GST NUMERIC(38,6) 19
51 TOTAL_PAYMENTS_EX_GST NUMERIC(38,2) 19
52 TOTAL_RESERVES_EX_GST NUMERIC(38,6) 19
53 BUILDING_TYPE_COST NUMERIC(38,6) 19
54 CONTENTS_TYPE_COST NUMERIC(38,6) 19
55 OUTSTANDING_ESTIMATES_EX_GST NUMERIC(38,6) 19
56 RECOVERY_ESTIMATES_EX_GST NUMERIC(38,6) 19
57 CURRENT_OUTSTANDING_ESTIMATES_EX_GST NUMERIC(38,6) 19
58 CURRENT_RECOVERY_ESTIMATES_EX_GST NUMERIC(38,6) 19
59 PCP_OUTSTANDING_ESTIMATES_EX_GST NUMERIC(38,6) 19
60 FINALISED_COST NUMERIC(38,2) 19
61 NET_INCURRED_EX_GST NUMERIC(38,6) 19
62 TOTAL_RECOVERIES_EX_GST NUMERIC(38,2) 19
63 NON_CUM_GROSS_INCURRED_EX_GST NUMERIC(38,6) 19
64 GROSS_INCURRED_EX_GST NUMERIC(38,6) 19
65 MANAGEMENT_CLAIM_COUNT INTEGER 4
66 RECOVERY_CLAIM_COUNT INTEGER 4
67 MANAGEMENT_NIC NUMERIC(38,6) 19
68 MANAGEMENT_ESTIMATES NUMERIC(38,6) 19
69 MANAGEMENT_PAYMENTS NUMERIC(38,2) 19
70 GROSS_INCURRED_BAND CHARACTER VARYING(12) 12
71 LODGEMENT_DATE DATE 4
72 CLOSE_DATE DATE 4
73 CURR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
74 PRIOR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
75 PRIOR_1FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
76 PRIOR_2FY_LOSS_NET_INCURRED_EX_GST NUMERIC(18,2) 19
77 CURR_FY_LOSS_NEW_CLAIM_COUNT NUMERIC(38,0) 19
78 PRIOR_FY_LOSS_NEW_CLAIM_COUNT NUMERIC(38,0) 19
79 PRIOR_FY_LOSS_ACTIVE_END_COUNT NUMERIC(38,0) 19
80 PRIOR_MONTH_LODGED_NET_INCURRED_EX_GST NUMERIC(18,2) 19
81 TOTAL_VENDOR_PAYMENTS_EX_GST NUMERIC(18,2) 19
82 TOTAL_CASH_PAYMENTS_EX_GST NUMERIC(18,2) 19
83 FIRST_PAYMENT_DATE TIMESTAMP 8
84 FIRST_VENDOR_PAYMENT_DATE TIMESTAMP 8
85 FIRST_CASH_PAYMENT_DATE TIMESTAMP 8
86 ASSESS_FLAG CHARACTER VARYING(12) 12
87 ASSESSMENT_CATEGORY CHARACTER VARYING(11) 11
88 MAX_TRANSACTION_DATE DATE 4
89 CURR_FY_LOSS_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
90 PRIOR_FY_LOSS_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
91 PRIOR_MONTH_LODGED_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
92 CLAIM_AGE_DAYS INTEGER 4
93 CLAIM_AGE_BAND CHARACTER VARYING(256) 256
94 DAYS_OF_FINALISED_CLAIM INTEGER 4
95 FINALISED_CLAIM_AGE_BAND CHARACTER VARYING(256) 256
96 CLOSED_MONTH_NET_INCURRED_EX_GST NUMERIC(38,6) 19
97 CLOSED_STATUS CHARACTER VARYING(15) 15
98 PRIOR_FY_LOSS_NEW_NET_INCURRED_EX_GST NUMERIC(18,2) 19
99 PRIOR_FY_LOSS_EXISTING_NET_INCURRED_EX_GST NUMERIC(18,2) 19
100 PRIOR_FY_LOSS_NEW_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
101 PRIOR_FY_LOSS_EXISTING_GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
102 EXISTING_NON_LARGE_NIC NUMERIC(38,6) 19
103 EXISTING_LARGE_NIC NUMERIC(38,6) 19
104 ASSESSED_PATH CHARACTER VARYING(12) 12
105 ASSESSED_PROCESS CHARACTER VARYING(12) 12