INT_CI_CLAIM_HIST

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 CLAIM_INITIAL_CLOSED_DATE TIMESTAMP 8
3 CLAIM_INITIAL_CLOSED_DATE_ID INTEGER 4
4 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
5 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
6 CLAIM_LATEST_CLOSED_DATE TIMESTAMP 8
7 CLAIM_LATEST_CLOSED_DATE_ID INTEGER 4
8 CLAIM_DURATION_FIRST_CLOSURE INTEGER 4
9 CLAIM_DURATION_BAND_FIRST_CLOSURE_ID INTEGER 4