FCT_CI_LOSS_CAUSE_REPORT

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CLAIM_NUMBER CHARACTER VARYING(40) 40
2 EXPOSURE_NUMBER CHARACTER VARYING(40) 40
3 POLICY_NUMBER CHARACTER VARYING(40) 40
4 POLICY_EFFECTIVE_DATE TIMESTAMP 8
5 POLICY_EXPIRATION_DATE TIMESTAMP 8
6 BRAND_NAME CHARACTER VARYING(256) 256
7 INSURED_NAME CHARACTER VARYING(181) 181
8 EXPOSURE_CLAIMANT_NAME CHARACTER VARYING(181) 181
9 EXPOSURE_PRIMARY_COVERAGE CHARACTER VARYING(256) 256
10 EXPOSURE_COVERAGE_SUBTYPE CHARACTER VARYING(256) 256
11 INCIDENT_LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
12 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
13 INCIDENT_FAULT_RATING_NAME CHARACTER VARYING(256) 256
14 EXPOSURE_DECISION CHARACTER VARYING(256) 256
15 EXPOSURE_STATUS CHARACTER VARYING(256) 256
16 TRANSACTION_REMAINING_RESERVES NUMERIC(38,2) 19
17 TRANSACTION_GROSS_PAYMENT_AMOUNT NUMERIC(38,2) 19