INT_PI_HOME_CLAIM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_CLAIM_ID BIGINT 8
2 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
3 CCR_CC_CLAIM_CLOSEDATE TIMESTAMP 8
4 CCR_CC_CLAIM_CREATETIME TIMESTAMP 8
5 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
6 CCR_CC_CLAIM_REOPENDATE TIMESTAMP 8
7 CCR_CC_CLAIM_REPORTEDDATE TIMESTAMP 8
8 CCR_CC_CLAIM_CATASTROPHEID BIGINT 8
9 CATASTROPHE_NAME CHARACTER VARYING(60) 60
10 CATASTROPHE_NUMBER CHARACTER VARYING(60) 60
11 CCR_CC_CLAIM_LOSSLOCATIONID BIGINT 8
12 CCR_CC_CLAIM_LOSSTYPE BIGINT 8
13 CCR_CC_CLAIM_POLICYID BIGINT 8
14 CCR_CC_CLAIM_SC_CLAIMTYPE BIGINT 8
15 CCR_CC_CLAIM_SC_LOSSCAUSE BIGINT 8
16 CCR_CC_CLAIM_LOSSCAUSE BIGINT 8
17 CCR_CC_CLAIM_SC_INCIDENTREPORT BIGINT 8
18 CCR_CC_POLICY_POLICYNUMBER CHARACTER VARYING(40) 40
19 CCR_CC_POLICY_EFFECTIVEDATE TIMESTAMP 8
20 CCR_CC_POLICY_INCEPTIONDATE TIMESTAMP 8
21 CCR_CC_POLICY_EXPIRATIONDATE TIMESTAMP 8
22 CCR_CCTL_CLAIMSTATE_NAME CHARACTER VARYING(256) 256
23 CCR_CCTL_CLAIMTYPE_NAME CHARACTER VARYING(256) 256
24 CCR_CCTL_HOWREPORTEDTYPE_NAME CHARACTER VARYING(256) 256
25 CCR_CCTL_LOSSCAUSE_NAME CHARACTER VARYING(256) 256
26 CCR_CCTL_LOSSCAUSE_TYPECODE CHARACTER VARYING(50) 50
27 LOSSCAUSE_MGMT CHARACTER VARYING(40) 40
28 LOSSCAUSE_OPR CHARACTER VARYING(40) 40
29 CCR_CCTL_SC_BRAND_NAME CHARACTER VARYING(256) 256
30 CCR_CCTL_SC_CLAIMPRIORITY_NAME CHARACTER VARYING(256) 256
31 RISK_STATE_ID BIGINT 8
32 RISK_STATE_NAME CHARACTER VARYING(256) 256
33 RISK_SUBURB CHARACTER VARYING(60) 60
34 RISK_STATE_TYPECODE CHARACTER VARYING(50) 50
35 RISK_POSTCODE CHARACTER VARYING(60) 60
36 RISK_ZONE_NAME CHARACTER VARYING(255) 255
37 STORM_CAUSE CHARACTER VARYING(1541) 1541
38 CCR_CC_CLAIM_ASSIGNEDUSERID BIGINT 8
39 CCR_CC_CLAIM_ASSIGNEDGROUPID BIGINT 8
40 CCR_CC_CLAIM_CLOSEDOUTCOME BIGINT 8
41 CCR_CC_CLAIM_SC_CLOSEDOUTCOME BIGINT 8
42 CCR_CCTL_SC_PRODUCT_NAME CHARACTER VARYING(256) 256
43 ASBESTOS_FLAG CHARACTER VARYING(256) 256
44 MOULD_FLAG CHARACTER VARYING(256) 256
45 MEDIA_SENSITIVITY CHARACTER VARYING(256) 256
46 INSURED_CONTACTID BIGINT 8
47 CLAIM_CLOSE_REASON CHARACTER VARYING(256) 256
48 ACTIVATION_DATE TIMESTAMP 8
49 REPORT_ONLY CHARACTER VARYING(256) 256
50 RISK_REGION CHARACTER VARYING(8) 8
51 EVENT_TYPE CHARACTER VARYING(256) 256
52 EVENT_START_DATE DATE 4
53 LOSS_GROUP CHARACTER VARYING(15) 15
54 GROSS_INCURRED NUMERIC(18,2) 19
55 GROSS_INCURRED_EX_GST NUMERIC(18,2) 19
56 OUTSTANDING_DEMANDED_EX_GST NUMERIC(38,6) 19
57 RECOVERY_DEMANDED_CREATETIME TIMESTAMP 8
58 RECOVERY_DEMANDED_REC_COUNT INTEGER 4
59 SUBLOSS_GROUP CHARACTER VARYING(18) 18
60 OP_LOB CHARACTER VARYING(16) 16
61 LARGE_LOSS_INDICATOR CHARACTER(3) 3
62 UP_TO_FIRST_CLOSED_MONTH_GROSS_INCURRED_EX_GST NUMERIC(38,6) 19
63 LODGEMENT_TIMESTAMP TIMESTAMP 8
64 LODGEMENT_USERID BIGINT 8
65 LOSS_LIMIT_BANDING CHARACTER VARYING(40) 40
66 EXPOSURE_TYPE CHARACTER VARYING(19) 19
67 TEMP_ACCOMMODATION_FLAG CHARACTER VARYING(256) 256
68 EXCESS_BAND CHARACTER VARYING(256) 256
69 EXPOSURE_BANDING CHARACTER VARYING(15) 15
70 FIRST_PAYMENT_DATE TIMESTAMP 8
71 FIRST_VENDOR_PAYMENT_DATE TIMESTAMP 8
72 FIRST_CASH_PAYMENT_DATE TIMESTAMP 8
73 CASH_SETTLEMENT_DATE DATE 4
74 REPAIR_COMPLETED_DATE DATE 4
75 SUPPLY_COMPLETED_DATE DATE 4
76 FULFILMENT_COMPLETED_DATE DATE 4
77 FIRST_CLOSED_DATE TIMESTAMP 8
78 UP_TO_FIRST_CLOSED_MONTH_ASSESSED_FLAG CHARACTER VARYING(12) 12
79 CLAIM_COUNT SMALLINT 2
80 TOTAL_RESERVES NUMERIC(18,2) 19
81 TOTAL_PAYMENTS NUMERIC(18,2) 19
82 OPEN_RESERVES NUMERIC(18,2) 19
83 FIRST_DAY_NET_INCURRED NUMERIC(18,2) 19
84 NET_INCURRED_EX_GST NUMERIC(18,2) 19
85 ASSESSED_PATH CHARACTER VARYING(12) 12
86 ASSESSED_PROCESS CHARACTER VARYING(12) 12
87 MULTIPLE_ASSESSMENT_FLAG BIGINT 8
88 ASSESSED_REPORT_DATE TIMESTAMP 8