FCT_CI_CLAIM_TRANSACTION

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 CLAIM_NUMBER CHARACTER VARYING(40) 40
3 GROSS_PAID_AMOUNT NUMERIC(38,2) 19
4 CLAIM_GROSS_PAID_AMOUNT_BAND_ID INTEGER 4
5 GROSS_INCURRED_AMOUNT NUMERIC(38,2) 19
6 GROSS_INCURRED_AMOUNT_BAND_ID INTEGER 4
7 NET_INCURRED_AMOUNT NUMERIC(38,2) 19
8 NET_INCURRED_AMOUNT_BAND_ID INTEGER 4
9 GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
10 GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
11 NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
12 NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
13 CLAIM_EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
14 CLAIM_EXCESS_RECOVERY_DURATION INTEGER 4
15 CLAIM_SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
16 CLAIM_SALVAGE_RECOVERY_DURATION INTEGER 4
17 CLAIM_DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
18 CLAIM_DEBT_RECOVERY_DURATION INTEGER 4