INT_MOTOR_COMBINED_COST_CLAIM_BASE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 CLAIM_ID BIGINT 8
3 INCIDENT_ID BIGINT 8
4 COMBINED_TYPE CHARACTER VARYING(10) 10
5 COMBINED_COST_SUBTYPE CHARACTER VARYING(512) 512
6 COMBINED_COST_VOLUME INTEGER 4
7 COMBINED_COST_DATE TIMESTAMP 8
8 COMBINED_COST_AMOUNT NUMERIC(38,2) 19
9 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
10 ASSESSMENT_PROCESS_GROUP_NAME CHARACTER VARYING(13) 13
11 VEHICLE_STYLE_ID BIGINT 8
12 LOSS_PARTY_TYPE_ID BIGINT 8
13 PNETQUOTEREQUEST_NUMBER CHARACTER VARYING(13) 13
14 VEHICLE_DETAIL_HIERARCHY CHARACTER VARYING(162) 162
15 VEHICLE_YEAR CHARACTER VARYING(20) 20
16 VEHICLE_MAKE CHARACTER VARYING(60) 60
17 VEHICLE_MODEL CHARACTER VARYING(80) 80
18 SC_NVIC CHARACTER VARYING(15) 15
19 ASSESSMENT_CENTRE_TYPE_ID BIGINT 8
20 QUOTEREQUEST_STATUS BIGINT 8
21 POLICY_COVERAGE_TYPE_ID BIGINT 8
22 ALIGNED_REPAIRER_PUBLICID CHARACTER VARYING(64) 64
23 ALIGNED_REPAIRER_ASSESSMENT_CC_ID BIGINT 8
24 REPAIRER_NAME CHARACTER VARYING(120) 120
25 ASSESSOR_NAME CHARACTER VARYING(181) 181
26 ASSESSMENT_CENTRE_NAME CHARACTER VARYING(120) 120
27 ASSESSMENT_CENTRE_STATE_NAME CHARACTER VARYING(256) 256
28 ASSESSMENT_CENTRE_REGION_NAME CHARACTER VARYING(15) 15
29 TOTAL_LOSS_COMBINED_VOLUME INTEGER 4
30 FLEET_IND CHARACTER VARYING(9) 9
31 CAS_IND CHARACTER VARYING(7) 7
32 CASH_SETTLE_TYPE BIGINT 8
33 CASH_SETTLE_REASON BIGINT 8
34 CASH_SETTLE_USER_ID BIGINT 8
35 CASH_SETTLE_DATE TIMESTAMP 8
36 BOOKING_CREATE_DATE TIMESTAMP 8
37 VEHICLE_ARRIVE_DATE TIMESTAMP 8
38 COMBINED_COST_COMPLETED_DATE TIMESTAMP 8
39 REPORT_DATE DATE 4
40 CLAIM_NUMBER CHARACTER VARYING(40) 40
41 BRAND_ID BIGINT 8
42 CATASTROPHE_ID BIGINT 8
43 CLAIM_DECISION_ID BIGINT 8
44 LINE_OF_BUSINESS_ID BIGINT 8
45 POLICYID BIGINT 8
46 POLICYNUMBER CHARACTER VARYING(40) 40
47 LOSS_CAUSE_ID BIGINT 8
48 LOSS_CAUSE_SUB_TYPE_ID BIGINT 8
49 LOSS_LOCATION_ADDRESS CHARACTER VARYING(167) 167
50 LOSS_CITY CHARACTER VARYING(60) 60
51 LOSS_LONGITUDE NUMERIC(8,5) 19
52 LOSS_LATITUDE NUMERIC(7,5) 19
53 LOSS_STATE_ID BIGINT 8
54 LOSS_REGION_NAME CHARACTER VARYING(15) 15
55 LOSS_POSTCODE CHARACTER VARYING(60) 60
56 EVENT_LOSS_POSTCODE INTEGER 4
57 RISK_LOCATION_ADDRESS CHARACTER VARYING(167) 167
58 RISK_CITY CHARACTER VARYING(60) 60
59 RISK_LONGITUDE NUMERIC(8,5) 19
60 RISK_LATITUDE NUMERIC(7,5) 19
61 RISK_POSTCODE CHARACTER VARYING(60) 60
62 RISK_REGION_NAME CHARACTER VARYING(15) 15
63 RISK_STATE_ID BIGINT 8
64 RISK_STATE_NAME CHARACTER VARYING(256) 256
65 LOSS_STATE_NAME CHARACTER VARYING(256) 256
66 LIABILITY_ASSESSMENT_ID BIGINT 8
67 LOSS_DATE DATE 4
68 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
69 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
70 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
71 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
72 CLAIM_PROCESS_TYPE_ID BIGINT 8
73 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
74 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
75 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
76 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
77 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
78 CCR_CC_POLICY_POLICYTYPE BIGINT 8
79 CCR_HST_CC_CLAIM_INSUREDDENORMID BIGINT 8
80 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
81 LODGEMENT_DATE TIMESTAMP 8