INT_WCOM_CLAIM_SUMMARY

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICY INTEGER 4
2 PRODUCT CHARACTER(3) 3
3 POLICYNUMBER CHARACTER VARYING(12) 12
4 POLICYTERM_START_DATE DATE 4
5 POLICYTERM_DUE_DATE DATE 4
6 CLAIM_COUNT NUMERIC(38,0) 19
7 PAIDTODATE NUMERIC(38,2) 19
8 RECOVERTODATE NUMERIC(38,2) 19
9 GROSSRESERVE NUMERIC(38,2) 19
10 INCURTODATE NUMERIC(38,2) 19
11 NON_ZERO_CLAIMS_COUNT NUMERIC(38,0) 19
12 DEVELOPED_CLAIMS_COST NUMERIC(38,7) 19
13 LARGE_CLAIM_COUNT NUMERIC(38,0) 19
14 DEVELOPED_LARGE_CLAIMS_COST NUMERIC(38,7) 19