INT_CI_CLAIM_EXPERIENCE_CLAIM_CC_STEP3

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_CLAIM_ID BIGINT 8
2 TRANSACTION_EXPOSURE_ID BIGINT 8
3 TRANSACTION_CREATE_DATE TIMESTAMP 8
4 GROSS_INCURRED_AMOUNT NUMERIC(20,2) 19
5 REMAINING_RESERVES NUMERIC(19,2) 19
6 EXCESS_RECOVERY_AMOUNT NUMERIC(18,2) 19
7 PAID_AMOUNT NUMERIC(18,2) 19
8 SETTLEMENT_AMOUNT NUMERIC(18,2) 19
9 EXPENSE_AMOUNT NUMERIC(18,2) 19
10 CLAIM_RECOVERY_AMOUNT NUMERIC(18,2) 19