INT_INSURED_VEHICLE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CCR_CC_INCIDENT_CLAIMID BIGINT 8
3 CCR_CC_INCIDENT_ID BIGINT 8
4 CCR_CC_INCIDENT_SC_COVERAGE BIGINT 8
5 CCR_CC_INCIDENT_SC_INSUREDVEHICLE BIGINT 8
6 CCR_CC_VEHICLE_STYLE BIGINT 8
7 CCR_CC_COVERAGE_TYPE BIGINT 8
8 CCR_CC_VEHICLE_SC_HIGHPERFORMANCEIND CHARACTER VARYING(1) 1
9 CCR_CC_VEHICLE_SC_UNIQUEVEHICLE CHARACTER VARYING(1) 1
10 CCR_CC_VEHICLE_UNSPECIFIEDVEHICLE_EXT CHARACTER VARYING(1) 1
11 CCR_CC_COVERAGE_SC_RAWPRODUCT CHARACTER VARYING(20) 20
12 CCR_CC_INCIDENT_ASSESSORTYPE_EXT BIGINT 8
13 CCR_CC_INCIDENT_SC_EXTERNALASSESSORIND CHARACTER VARYING(1) 1
14 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
15 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
16 CCR_CC_VEHICLE_YEAR BIGINT 8
17 CCR_CC_VEHICLE_SC_FINANCEIND CHARACTER VARYING(1) 1
18 CCR_CC_VEHICLE_LICENSEPLATE CHARACTER VARYING(40) 40