INT_MOTOR_INSURED_INCIDENT_CI

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 VEHICLE_COLLECTED_DATE TIMESTAMP 8
11 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
12 ABLOCATION_CCR_AB_ADDRESS_STATE BIGINT 8
13 CCR_ABTL_SC_LOCATIONCONTACTTYPE_ID BIGINT 8
14 INSURED_INCIDENT_REPAIR_COST_NET_GST NUMERIC(31,2) 19
15 REPAIRER_CCR_AB_ABCONTACT_ID BIGINT 8
16 REPAIRER_CCR_AB_ADDRESS_STATE BIGINT 8
17 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
18 CCR_CC_VEHICLE_SC_HIGHPERFORMANCEIND CHARACTER VARYING(1) 1
19 CCR_CC_VEHICLE_SC_UNIQUEVEHICLE CHARACTER VARYING(1) 1
20 INSURED_INCIDENT_REPAIR_COST_GROSS_GST NUMERIC(31,2) 19
21 CCR_CC_INCIDENT_SC_EXTERNALASSESSORIND CHARACTER VARYING(1) 1
22 RECOMMENDED_REPAIRER_FLAG CHARACTER VARYING(3) 3
23 MAX_TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8