INT_MOTOR_FLEET_POLICY_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 POLICYNUMBER CHARACTER VARYING(40) 40
9 PRODUCT CHARACTER VARYING(3) 3
10 SEQPOLICY INTEGER 4
11 CLAIM_STATE_TYPECODE CHARACTER VARYING(50) 50
12 POLICYID BIGINT 8
13 STATE BIGINT 8
14 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 DESCRIPTION CHARACTER VARYING(2000) 2000
16 FAULTRATING BIGINT 8
17 SC_LOSSCAUSESUBTYPE BIGINT 8
18 LOSSCAUSE BIGINT 8
19 SC_ROADCONDITION BIGINT 8
20 WEATHER BIGINT 8
21 LOSSLOCATIONID BIGINT 8
22 CATASTROPHEID BIGINT 8
23 SC_CLAIMAUTO BIGINT 8
24 REOPENDATE TIMESTAMP 8