INT_PI_MOTOR_CLAIM_INCIDENT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_CLAIM_ID BIGINT 8
2 CCR_CC_INCIDENT_ID BIGINT 8
3 CCR_CC_VEHICLE_ID BIGINT 8
4 CCR_CC_POLICY_ID BIGINT 8
5 CCR_CC_INCIDENT_SC_COVERAGE BIGINT 8
6 CCR_CC_POLICY_SC_LINEOFBUSINESS BIGINT 8
7 POLICY_TYPE CHARACTER VARYING(256) 256
8 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
9 CCR_CC_POLICY_POLICYNUMBER CHARACTER VARYING(40) 40
10 RISK_POSTCODE CHARACTER VARYING(60) 60
11 CCR_CC_CLAIM_LOSSLOCATIONID BIGINT 8
12 CCR_CC_CLAIM_INSUREDDENORMID BIGINT 8
13 CCR_CC_CLAIM_HOWREPORTED BIGINT 8
14 CCR_CCTL_CLAIMCLOSEDOUTCOMETYPE_NAME CHARACTER VARYING(256) 256
15 CCR_CCTL_SC_BRAND_NAME CHARACTER VARYING(256) 256
16 OP_LOB CHARACTER VARYING(16) 16
17 CCR_CCTL_LOSSTYPE_NAME CHARACTER VARYING(256) 256
18 CCR_CCTL_LOSSCAUSE_NAME CHARACTER VARYING(256) 256
19 CCR_CCTL_SC_LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
20 CCR_CCTL_LOSSPARTYTYPE_NAME CHARACTER VARYING(256) 256
21 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
22 LEGACY_CLAIM_FLAG CHARACTER VARYING(3) 3
23 LOSS_GROUP CHARACTER VARYING(15) 15
24 CCR_CCTL_CLAIMSTATE_NAME CHARACTER VARYING(256) 256
25 CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
26 CCR_CCTL_STATE_NAME CHARACTER VARYING(256) 256
27 CCR_CC_ADDRESS_CITY CHARACTER VARYING(60) 60
28 ADDRESS CHARACTER VARYING(165) 165
29 CCR_CC_ADDRESS_LATITUDE NUMERIC(7,5) 19
30 CCR_CC_ADDRESS_LONGITUDE NUMERIC(8,5) 19
31 BOOKING_DATE TIMESTAMP 8
32 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
33 BOOKING_LOCATION_ABCONTACTID BIGINT 8
34 BOOKING_LOCATION CHARACTER VARYING(181) 181
35 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
36 BOOKING_STATE CHARACTER VARYING(256) 256
37 BOOKING_REGION CHARACTER VARYING(8) 8
38 CCR_CC_VEHICLE_LICENSEPLATE CHARACTER VARYING(40) 40
39 CCR_CC_VEHICLE_YEAR BIGINT 8
40 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
41 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
42 CCR_CC_VEHICLE_VIN CHARACTER VARYING(40) 40
43 CCR_CC_VEHICLE_ESTIMATEDSALVAGEVALUE NUMERIC(18,2) 19
44 FLEET_IND CHARACTER VARYING(9) 9
45 CAS_IND CHARACTER VARYING(7) 7
46 REPAIR_AUTHORISED_DATE TIMESTAMP 8
47 ECD_CHANGE_COUNT INTEGER 4
48 ORIGINAL_ECD TIMESTAMP 8
49 CURRENT_ECD TIMESTAMP 8
50 ARRIVAL_DATE TIMESTAMP 8
51 REPAIRS_COMPLETED_DATE DATE 4
52 NO_SHOW INTEGER 4
53 TL_FULFILLED_DATE TIMESTAMP 8
54 VEHICLE_RETURNED_DATE TIMESTAMP 8
55 GLASS_ONLY_FLAG CHARACTER VARYING(3) 3
56 CCR_CCX_SC_ASSESSMENTTOTALLOSS_ASSESSORSSETTLEMENTVALUE NUMERIC(18,2) 19
57 CCR_CCX_SC_ASSESSMENTTOTALLOSS_REPLACEMENTVEHICLE INTEGER 4
58 CCR_CCX_SC_ASSESSMENTTOTALLOSS_SC_TOTALLOSSSTATUS INTEGER 4
59 QUOTE_REQUEST_NUMBER CHARACTER VARYING(13) 13
60 CCR_CCX_SC_PNETQUOTEREQUEST_ID BIGINT 8
61 ASSESSOR_NAME CHARACTER VARYING(181) 181
62 ASSESSOR_USER_ID BIGINT 8
63 EXTERNAL_ASSESSOR_INDICATOR INTEGER 4
64 EXT_ASSESSOR_NAME CHARACTER VARYING(181) 181
65 TL_ASSESSOR_NAME CHARACTER VARYING(181) 181
66 TL_ASSESSOR_ID BIGINT 8
67 INSURED_NAME CHARACTER VARYING(181) 181
68 BROKER_NAME CHARACTER VARYING(120) 120
69 TOTAL_LOSS_CREATETIME TIMESTAMP 8
70 ASSESSED_AS_TOTAL_LOSS CHARACTER VARYING(3) 3
71 LODGEMENT_DATE TIMESTAMP 8
72 CLOSE_DATE TIMESTAMP 8
73 CLAIM_LIFE INTEGER 4
74 VEHICLE_DRIVABLE_FLAG CHARACTER(1) 1
75 VEHICLE_STYLE CHARACTER VARYING(256) 256
76 REPORT_ONLY_FLAG CHARACTER VARYING(256) 256
77 SC_CLAIMAUTO BIGINT 8
78 CCR_CC_INCIDENT_VEHICLEASSESSMENTSTATUS BIGINT 8
79 CALENDAR_DATE_END DATE 4
80 VEHICLE_ARRIVAL_EXCEPTION_FLAG CHARACTER VARYING(3) 3
81 CASH_SETTLEMENT_AMOUNT NUMERIC(38,2) 19
82 CASH_SETTLEMENT_VOLUME NUMERIC(38,0) 19
83 CASH_SETTLEMENT_ASSESSMENT_COMPLETION_DATE TIMESTAMP 8
84 CCR_CC_POLICY_VERIFIED CHARACTER VARYING(1) 1
85 TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
86 MAX_CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
87 REPAIRS_COMPLETED_DATETIME TIMESTAMP 8
88 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
89 SALVAGE_DATE_OF_SALE TIMESTAMP 8
90 SALVAGE_RECEIVED_DATE TIMESTAMP 8
91 SALVAGE_SALE_AMOUNT_GROSS NUMERIC(38,2) 19
92 SALVAGE_SALE_AMOUNT_GST NUMERIC(38,2) 19
93 CCR_CCTL_SC_SALVAGEPROVIDER_NAME CHARACTER VARYING(256) 256
94 SUBROCLOSE_REASON CHARACTER VARYING(25) 25
95 SUBROCLOSEDATE DATE 4
96 SALVAGE_ESTIMATED_AMOUNT NUMERIC(18,2) 19
97 SALVAGE_ACTUAL_AMOUNT NUMERIC(38,2) 19
98 SALVAGE_PERCENTAGE NUMERIC(33,0) 19