FCT_CI_EXPOSURE_TRANSACTION

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 EXPOSURE_ID BIGINT 8
2 EXPOSURE_REMAINING_RESERVES NUMERIC(38,2) 19
3 EXPOSURE_RESERVES_AMOUNT NUMERIC(38,2) 19
4 EXPOSURE_SETTLEMENT_FLAG INTEGER 4
5 EXPOSURE_EXCESS_RECOVERY_RESERVE_AMOUNT NUMERIC(38,2) 19
6 EXPOSURE_EXCESS_RECOVERY_AMOUNT NUMERIC(38,2) 19
7 EXPOSURE_EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
8 EXPOSURE_SALVAGE_RECOVERY_RESERVE_AMOUNT NUMERIC(38,2) 19
9 EXPOSURE_SALVAGE_RECOVERY_AMOUNT NUMERIC(38,2) 19
10 EXPOSURE_SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
11 EXPOSURE_DEBT_RECOVERY_RESERVE_AMOUNT NUMERIC(38,2) 19
12 EXPOSURE_DEBT_RECOVERY_AMOUNT NUMERIC(38,2) 19
13 EXPOSURE_DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
14 EXPOSURE_LOSS_ADJUSTER_AMOUNT NUMERIC(38,2) 19
15 EXPOSURE_LOSS_ADJUSTER_FLAG_ID INTEGER 4
16 GROSS_PAID_AMOUNT NUMERIC(38,2) 19
17 EXPOSURE_GROSS_PAID_AMOUNT_BAND_ID INTEGER 4
18 GROSS_INCURRED_AMOUNT NUMERIC(38,2) 19
19 EXPOSURE_GROSS_INCURRED_AMOUNT_BAND_ID INTEGER 4
20 NET_INCURRED_AMOUNT NUMERIC(38,2) 19
21 EXPOSURE_NET_INCURRED_AMOUNT_BAND_ID INTEGER 4
22 GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
23 EXPOSURE_GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
24 NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
25 EXPOSURE_NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4