INT_PI_MOTOR_INSURED_INCIDENT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 INSURED_CCR_CC_INCIDENT_CLAIMID BIGINT 8
3 INSURED_CCR_CC_INCIDENT_ID BIGINT 8
4 REPAIR_ACTUAL_COMPLETION_DATE TIMESTAMP 8
5 INSURED_CCR_CC_COVERAGE_TYPE BIGINT 8
6 INSURED_CCR_CC_VEHICLE_STYLE BIGINT 8
7 CCR_CCX_SC_ASSESSMENTBOOKING_SC_ASSESSMENTPROCESSTYPE BIGINT 8
8 ASSESSOR_CCR_CC_USER_CONTACTID BIGINT 8
9 VEHICLE_RETURNED_DATE TIMESTAMP 8
10 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
11 ABLOCATION_CCR_AB_ADDRESS_STATE BIGINT 8
12 CCR_ABTL_SC_LOCATIONCONTACTTYPE_ID BIGINT 8
13 INSURED_INCIDENT_REPAIR_COST_NET_GST NUMERIC(31,2) 19
14 REPAIRER_CCR_AB_ABCONTACT_ID BIGINT 8
15 REPAIRER_CCR_AB_ADDRESS_STATE BIGINT 8
16 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
17 CCR_CC_VEHICLE_SC_HIGHPERFORMANCEIND CHARACTER VARYING(1) 1
18 CCR_CC_VEHICLE_SC_UNIQUEVEHICLE CHARACTER VARYING(1) 1
19 CCR_CC_INCIDENT_ASSESSORTYPE_EXT BIGINT 8
20 CCR_CC_INCIDENT_SC_EXTERNALASSESSORIND CHARACTER VARYING(1) 1
21 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
22 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
23 CCR_CC_VEHICLE_YEAR BIGINT 8
24 CCR_CC_VEHICLE_SC_FINANCEIND CHARACTER VARYING(1) 1
25 CCR_CC_VEHICLE_LICENSEPLATE CHARACTER VARYING(40) 40
26 TOTAL_LOSS_CREATETIME TIMESTAMP 8
27 MAX_TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
28 CLAIMANT_TOTAL_PAYMENTS_INSURED NUMERIC(38,2) 19
29 FULFILMENT_VALUE_INSURED NUMERIC(38,2) 19
30 VEHICLE_COLLECTED_DATE TIMESTAMP 8
31 VEHICLE_COLLECTED_DATE_DERV TIMESTAMP 8
32 RECOMMENDED_REPAIRER_FLAG CHARACTER VARYING(3) 3