INT_MOTOR_FLEET_CLAIM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ID BIGINT 8
2 CLAIMNUMBER CHARACTER VARYING(40) 40
3 LOSSDATE TIMESTAMP 8
4 REPORTEDDATE TIMESTAMP 8
5 UPDATETIME TIMESTAMP 8
6 CLOSEDATE TIMESTAMP 8
7 SC_EXCESS NUMERIC(18,2) 19
8 INCIDENT_ID BIGINT 8
9 POLICYNUMBER CHARACTER VARYING(40) 40
10 PRODUCT CHARACTER VARYING(3) 3
11 SEQPOLICY INTEGER 4
12 SC_COVERAGESOURCEKEY INTEGER 4
13 CLAIM_STATE_TYPECODE CHARACTER VARYING(50) 50
14 CC_COVERAGE_RAWPRODUCT CHARACTER VARYING(20) 20
15 POLICYID BIGINT 8
16 STATE BIGINT 8
17 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 DESCRIPTION CHARACTER VARYING(2000) 2000
19 FAULTRATING BIGINT 8
20 SC_LOSSCAUSESUBTYPE BIGINT 8
21 LOSSCAUSE BIGINT 8
22 SC_ROADCONDITION BIGINT 8
23 WEATHER BIGINT 8
24 LOSSLOCATIONID BIGINT 8
25 CATASTROPHEID BIGINT 8
26 SC_CLAIMAUTO BIGINT 8
27 VEHICLELOSSPARTY BIGINT 8
28 SC_COVERAGE BIGINT 8
29 SC_INSUREDVEHICLE BIGINT 8
30 REOPENDATE TIMESTAMP 8
31 REFERENCE_EXT CHARACTER VARYING(15) 15
32 PROFITCENTRE_EXT CHARACTER VARYING(60) 60
33 COSTCENTRE_EXT CHARACTER VARYING(15) 15
34 SC_RAWPRODUCTCLASS CHARACTER VARYING(20) 20
35 SC_RAWPRODUCTSUBCLASS CHARACTER VARYING(20) 20
36 SC_TPINSURED CHARACTER VARYING(1) 1