INT_CI_INCIDENT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INCIDENT_ID BIGINT 8
2 CLAIM_ID BIGINT 8
3 VEHICLE_ID BIGINT 8
4 INCIDENT_LOSS_CAUSE_ID BIGINT 8
5 INCIDENT_SUB_TYPE_ID BIGINT 8
6 INCIDENT_NATURE_OF_INJURY_ID BIGINT 8
7 INCIDENT_DETAILED_INJURY_TYPE_ID BIGINT 8
8 INCIDENT_REPORT_ONLY_ID BIGINT 8
9 INCIDENT_REPORTED_DATE TIMESTAMP 8
10 INCIDENT_REPORTED_DATE_ID INTEGER 4
11 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
12 INCIDENT_ESTIMATED_REPAIR_COST_AMT NUMERIC(18,2) 19
13 INCIDENT_ESTIMATED_REPAIR_TIME CHARACTER VARYING(60) 60
14 INCIDENT_TOTAL_ESTIMATED_VALUE NUMERIC(18,2) 19
15 INCIDENT_VEHICLE_QUESTIONS_ID BIGINT 8
16 INCIDENT_CLAIMANT_TYPE_ID BIGINT 8
17 INCIDENT_CREATE_DATE TIMESTAMP 8
18 INCIDENT_CREATE_DATE_ID INTEGER 4
19 INCIDENT_CREATE_USER_ID BIGINT 8
20 INCIDENT_FAULT_RATING_ID BIGINT 8
21 INCIDENT_REPORT_METHOD_ID BIGINT 8
22 INCIDENT_INSPECTION_REQUIRED_FLAG INTEGER 4
23 INCIDENT_MAKE_SAFE_REPAIR_REQUIRED_ID BIGINT 8
24 INCIDENT_PRIMARY_BODY_FUNCTION_ID BIGINT 8
25 INCIDENT_RECOVERY_INDICATOR_ID BIGINT 8
26 INCIDENT_REPORTER_RELATIONSHIP_TO_INSURED_ID BIGINT 8
27 INCIDENT_RESULT_OF_INJURY_ID BIGINT 8
28 INCIDENT_EXTERNAL_ASSESSOR_FLAG INTEGER 4
29 INCIDENT_SCOPE_OF_WORK_TYPE_ID BIGINT 8
30 INCIDENT_LOSS_SEVERITY_ID BIGINT 8
31 INCIDENT_UPDATE_DATE TIMESTAMP 8
32 INCIDENT_UPDATE_DATE_ID INTEGER 4
33 INCIDENT_UPDATE_USER_ID BIGINT 8
34 INCIDENT_LOSS_PARTY_ID BIGINT 8
35 INCIDENT_INSPECTION_PLAN_DATE TIMESTAMP 8
36 INCIDENT_INSPECTION_PLAN_DATE_ID INTEGER 4
37 INCIDENT_DAMAGE_DESCRIPTION CHARACTER VARYING(289) 289
38 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS BIGINT 8
39 INCIDENT_REPAIR_DONE_FLAG CHARACTER VARYING(1) 1
40 INCIDENT_ASSESSMENT_DESCRIPTION CHARACTER VARYING(128) 128
41 INCIDENT_ASSESSMENT_STATUS_ID BIGINT 8
42 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE TIMESTAMP 8
43 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_ID INTEGER 4
44 INCIDENT_ASSESSMENT_CLOSE_DATE TIMESTAMP 8
45 INCIDENT_ASSESSMENT_CLOSE_DATE_ID INTEGER 4
46 INCIDENT_ASSESSMENT_COMMENT CHARACTER VARYING(255) 255
47 INCIDENT_ASSESSMENT_INTERNAL_USER_ID BIGINT 8
48 INCIDENT_ASSESSMENT_CLAIMED_ITEM_BUILDING_FLAG INTEGER 4
49 INCIDENT_ASSESSMENT_CLAIMED_ITEM_CONTENT_FLAG INTEGER 4
50 INCIDENT_VEHICLE_DAMAGED_INDICATOR INTEGER 4
51 INCIDENT_VEHICLE_DRIVEABLE_INDICATOR INTEGER 4
52 INCIDENT_VEHICLE_TOWED_INDICATOR INTEGER 4
53 INCIDENT_VEHICLE_REGISTRATION_STATE BIGINT 8