INT_WCOM_CLAIM_DETAILS

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 POLICY INTEGER 4
3 PRODUCT CHARACTER(3) 3
4 POLICYNUMBER CHARACTER VARYING(12) 12
5 POLICYTERM_START_DATE DATE 4
6 POLICYTERM_DUE_DATE DATE 4
7 RISK_STATE_KEY CHARACTER(2) 2
8 POLICY_PREMIUM NUMERIC(38,2) 19
9 PREM_BAND CHARACTER VARYING(6) 6
10 CLAIM_COUNT INTEGER 4
11 CLAIM_ID BIGINT 8
12 CLAIMNUMBER CHARACTER VARYING(40) 40
13 LOSSDATE TIMESTAMP 8
14 CREATETIME TIMESTAMP 8
15 CLOSEDATE TIMESTAMP 8
16 DATEREPORTED TIMESTAMP 8
17 REOPENDATE TIMESTAMP 8
18 CC_POLICYNUMBER CHARACTER VARYING(40) 40
19 CHDRSTATUS CHARACTER VARYING(1) 1
20 NATUREOFINJURY CHARACTER VARYING(50) 50
21 INJURYBODYLOCATION CHARACTER VARYING(50) 50
22 HOURSWORKEDPERWEEK NUMERIC(10,2) 19
23 WEEKLYRATE NUMERIC(10,2) 19
24 AGENCYOFINJURY CHARACTER VARYING(50) 50
25 MECHANISMOFINJURY CHARACTER VARYING(50) 50
26 AGENCYBREAKDOWN CHARACTER VARYING(50) 50
27 CLAIMTYPE CHARACTER VARYING(4) 4
28 EVENTCLM INTEGER 4
29 SOURCE INTEGER 4
30 PAIDTODATE NUMERIC(38,2) 19
31 RECOVERTODATE NUMERIC(38,2) 19
32 GROSSRESERVE NUMERIC(38,2) 19
33 INCURTODATE NUMERIC(38,2) 19
34 NON_ZERO INTEGER 4
35 CLAWINVOLVEMENT CHARACTER VARYING(1) 1
36 LIABILITY_STATUS CHARACTER VARYING(256) 256
37 CLAIM_STATE CHARACTER VARYING(256) 256
38 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
39 BODY_LOCATION_NAME CHARACTER VARYING(2000) 2000
40 AGENCY_BREAKDOWN_NAME CHARACTER VARYING(2000) 2000
41 MECHANISM_OF_INJURY_NAME CHARACTER VARYING(2000) 2000
42 NATURE_OF_INJURY_NAME CHARACTER VARYING(2000) 2000
43 AGENCY_OF_INJURY_NAME CHARACTER VARYING(2000) 2000
44 UPDATE_TIME TIMESTAMP 8
45 LAST_EST_DATE TIMESTAMP 8
46 DEVELOPED_CLAIMS_COST NUMERIC(38,7) 19
47 LARGE_CLAIM_COUNT INTEGER 4
48 DEVELOPED_LARGE_CLAIMS_COST NUMERIC(38,7) 19