INT_PI_HOME_CLAIM_MOVEMENT

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 EXPOSURE_TYPE CHARACTER VARYING(19) 19
5 FIN_EXPOSURE_TYPE CHARACTER VARYING(10) 10
6 TRANSACTION_DATE TIMESTAMP 8
7 MIN_TRANSACTION_DATE TIMESTAMP 8
8 LOSS_GROUP CHARACTER VARYING(15) 15
9 CUMM_GROSS_INCURRED_EX_GST NUMERIC(38,6) 19
10 SUBLOSS_GROUP CHARACTER VARYING(18) 18
11 RISK_REGION CHARACTER VARYING(8) 8
12 RISK_STATE_NAME CHARACTER VARYING(256) 256
13 RISK_POSTCODE CHARACTER VARYING(60) 60
14 OP_LOB CHARACTER VARYING(16) 16
15 BRAND CHARACTER VARYING(256) 256
16 LOSSCAUSE_MGMT CHARACTER VARYING(40) 40
17 LOSSCAUSE_OPR CHARACTER VARYING(40) 40
18 CLAIM_STATUS CHARACTER VARYING(256) 256
19 LOSS_LIMIT_BANDING CHARACTER VARYING(40) 40
20 CLAIM_TYPE CHARACTER VARYING(256) 256
21 PRODUCT_NAME CHARACTER VARYING(256) 256
22 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
23 ASBESTOS_FLAG CHARACTER VARYING(256) 256
24 MOULD_FLAG CHARACTER VARYING(256) 256
25 TEMP_ACCOMMODATION_FLAG CHARACTER VARYING(256) 256
26 MEDIA_SENSITIVITY CHARACTER VARYING(256) 256
27 EVENT_TYPE CHARACTER VARYING(256) 256
28 LARGE_LOSS_INDICATOR CHARACTER VARYING(3) 3
29 MGMT_CLAIM_FLAG INTEGER 4
30 CLAIM_AGE_DAYS INTEGER 4
31 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
32 MANAGEMENT_CLAIM_COUNT INTEGER 4
33 RECOVERY_CLAIM_COUNT INTEGER 4
34 ADJUSTER_TEAM CHARACTER VARYING(100) 100
35 GROSS_INCURRED_BAND CHARACTER VARYING(12) 12
36 EXPOSURE_GROSS_INCURRED_BAND CHARACTER VARYING(12) 12
37 TEAM CHARACTER VARYING(9) 9
38 CLAIM_AGE_BAND CHARACTER VARYING(256) 256
39 OPEN_RESERVES_EX_GST NUMERIC(38,6) 19
40 NEW_NET_INCURRED_EX_GST NUMERIC(38,6) 19
41 EXISTING_NET_INCURRED_EX_GST NUMERIC(38,6) 19
42 TOTAL_PAYMENTS_EX_GST NUMERIC(38,2) 19
43 TOTAL_RESERVES_EX_GST NUMERIC(38,6) 19
44 OUTSTANDING_ESTIMATES_EX_GST NUMERIC(38,6) 19
45 RECOVERY_ESTIMATES_EX_GST NUMERIC(38,6) 19
46 CURRENT_OUTSTANDING_ESTIMATES_EX_GST NUMERIC(38,6) 19
47 PCP_OUTSTANDING_ESTIMATES_EX_GST NUMERIC(38,6) 19
48 FINALISED_COST NUMERIC(38,2) 19
49 NET_INCURRED_EX_GST NUMERIC(38,6) 19
50 TOTAL_RECOVERIES_EX_GST NUMERIC(38,2) 19
51 GROSS_INCURRED_EX_GST NUMERIC(38,6) 19
52 CLAIM_RNK BIGINT 8
53 NEW_CLAIM_COUNT NUMERIC(38,0) 19
54 REOPEN_COUNT NUMERIC(38,0) 19
55 CLOSED_COUNT NUMERIC(38,0) 19
56 ACTIVE_START_COUNT NUMERIC(38,0) 19
57 ACTIVE_END_COUNT NUMERIC(38,0) 19
58 NEW_CLAIM_COUNT_EXPOSURE INTEGER 4
59 MANAGEMENT_NIC NUMERIC(38,6) 19
60 MANAGEMENT_ESTIMATES NUMERIC(38,6) 19
61 MANAGEMENT_PAYMENTS NUMERIC(38,2) 19
62 BUILDING_ESTIMATES NUMERIC(38,6) 19
63 BUILDING_PAYMENTS NUMERIC(38,2) 19
64 CONTENTS_ESTIMATES NUMERIC(38,6) 19
65 CONTENTS_PAYMENTS NUMERIC(38,2) 19
66 CURR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(38,2) 19
67 PRIOR_FY_LOSS_NET_INCURRED_EX_GST NUMERIC(38,2) 19
68 PRIOR_1FY_LOSS_NET_INCURRED_EX_GST NUMERIC(38,2) 19
69 PRIOR_2FY_LOSS_NET_INCURRED_EX_GST NUMERIC(38,2) 19
70 FIRST_RECEIPT_FLG BIGINT 8
71 ASSESS_FLAG CHARACTER VARYING(12) 12
72 TOTAL_VENDOR_PAYMENTS_EX_GST NUMERIC(38,2) 19
73 TOTAL_CASH_PAYMENTS_EX_GST NUMERIC(38,2) 19
74 FIN_EXPOSURE_ACTIVE_END_COUNT NUMERIC(38,0) 19
75 CURRENT_GROSS_INCURRED_EX_GST NUMERIC(38,6) 19
76 CURRENT_LARGE_LOSS_INDICATOR CHARACTER VARYING(3) 3
77 CURRENT_GROSS_INCURRED_BAND CHARACTER VARYING(12) 12
78 CURRENT_SUBLOSS_GROUP CHARACTER VARYING(18) 18
79 EXPOSURE_BANDING CHARACTER VARYING(15) 15
80 CURRENT_FIN_EXPOSURE_GROSS_INCURRED_BAND CHARACTER VARYING(12) 12
81 ASSESSED_PATH CHARACTER VARYING(12) 12
82 ASSESSED_PROCESS CHARACTER VARYING(12) 12