| 1 |
INCIDENT_ASSESSMENT_DESCRIPTION |
CHARACTER VARYING(128) |
128 |
| 2 |
ASSESSMENT_CONTENT_ITEM_CATEGORY_NAME |
CHARACTER VARYING(256) |
256 |
| 3 |
ASSESSMENT_CONTENT_ITEM_ACTION_NAME |
CHARACTER VARYING(256) |
256 |
| 4 |
ASSESSMENT_CONTENT_ITEM_DESCRIPTION |
CHARACTER VARYING(255) |
255 |
| 5 |
ASSESSMENT_CONTENT_ITEM_NAME |
CHARACTER VARYING(256) |
256 |
| 6 |
ASSESSMENT_CONTENT_ITEM_NUMBER_OF_ITEM |
CHARACTER VARYING(20) |
20 |
| 7 |
ASSESSMENT_CONTENT_ITEM_BRAND |
CHARACTER VARYING(255) |
255 |
| 8 |
ASSESSMENT_CONTENT_ITEM_DATE_ACQUIRED |
TIMESTAMP |
8 |
| 9 |
ASSESSMENT_CONTENT_ITEM_CREATE_DATE |
TIMESTAMP |
8 |
| 10 |
CLAIM_COANTACT_NAME_AGENT |
CHARACTER VARYING(120) |
120 |
| 11 |
CLAIM_COANTACT_NAME_CONSIGNEE |
CHARACTER VARYING(120) |
120 |
| 12 |
CLAIM_COANTACT_NAME_CONSIGNOR |
CHARACTER VARYING(120) |
120 |
| 13 |
ASSESSMENT_CONTENT_ITEM_COMMENT |
CHARACTER VARYING(255) |
255 |
| 14 |
CLAIM_INITIAL_CLOSED_DATE |
TIMESTAMP |
8 |
| 15 |
CLAIM_LATEST_CLOSED_DATE |
TIMESTAMP |
8 |
| 16 |
CLAIM_CREATED_DATE |
TIMESTAMP |
8 |
| 17 |
CLAIM_LODGEMENT_DATE |
TIMESTAMP |
8 |
| 18 |
INSURED_NAME |
CHARACTER VARYING(181) |
181 |
| 19 |
ASSESSMENT_CONTENT_ITEM_SERVICE_PROVIDER_NAME |
CHARACTER VARYING(181) |
181 |
| 20 |
POLICY_NUMBER |
CHARACTER VARYING(40) |
40 |
| 21 |
CLAIM_NUMBER |
CHARACTER VARYING(40) |
40 |
| 22 |
EXPOSURE_NUMBER |
CHARACTER VARYING(40) |
40 |
| 23 |
EXPOSURE_PRIMARY_COVERAGE |
CHARACTER VARYING(256) |
256 |
| 24 |
EXPOSURE_COVERAGE_SUBTYPE |
CHARACTER VARYING(256) |
256 |
| 25 |
CLAIM_STATUS |
CHARACTER VARYING(256) |
256 |
| 26 |
EXPOSURE_STATUS |
CHARACTER VARYING(256) |
256 |
| 27 |
CLAIM_LOSS_DATE |
TIMESTAMP |
8 |
| 28 |
EXTERNAL_REFERENCE_NUMBER |
CHARACTER VARYING(42) |
42 |
| 29 |
LOSS_CAUSE |
CHARACTER VARYING(256) |
256 |
| 30 |
LOSS_DETAILS |
CHARACTER VARYING(2000) |
2000 |
| 31 |
CLAIM_LOSS_DURATION |
INTEGER |
4 |
| 32 |
CERTIFICATE_NUMBER |
CHARACTER VARYING(64) |
64 |
| 33 |
CERTIFICATE_DATE |
CHARACTER VARYING(64) |
64 |
| 34 |
CERTIFICATE_SUM_INSURED |
CHARACTER VARYING(64) |
64 |
| 35 |
ESTABLISHMENT_NUMBER |
CHARACTER VARYING(64) |
64 |
| 36 |
EXTERNAL_CLAIM_REFERENCE_NUMBER |
CHARACTER VARYING(64) |
64 |
| 37 |
EXTERNAL_CLIENT_REFERENCE_NUMBER |
CHARACTER VARYING(64) |
64 |
| 38 |
EXTERNAL_INVOICE_NUMBER |
CHARACTER VARYING(64) |
64 |
| 39 |
VESSEL_NAME |
CHARACTER VARYING(64) |
64 |
| 40 |
COUNTRY_OF_DISCHARGE |
CHARACTER VARYING(64) |
64 |
| 41 |
COUNTRY_OF_ORIGIN |
CHARACTER VARYING(64) |
64 |
| 42 |
PORT_OF_DISCHARGE |
CHARACTER VARYING(64) |
64 |
| 43 |
PORT_OF_ORIGIN |
CHARACTER VARYING(64) |
64 |
| 44 |
EXPOSURE_EXCESS_RECOVERY_STATUS |
CHARACTER VARYING(14) |
14 |
| 45 |
EXPOSURE_SALVAGE_RECOVERY_STATUS |
CHARACTER VARYING(14) |
14 |
| 46 |
EXPOSURE_DEBT_RECOVERY_STATUS |
CHARACTER VARYING(14) |
14 |
| 47 |
EXCESS_AMOUNT |
NUMERIC(18,2) |
19 |
| 48 |
RECOVERY_AMOUNT |
NUMERIC(38,2) |
19 |
| 49 |
GROSS_INCURRED_AMOUNT |
NUMERIC(38,2) |
19 |
| 50 |
GROSS_PAID_AMOUNT |
NUMERIC(38,2) |
19 |
| 51 |
REMAINING_RESERVES |
NUMERIC(38,2) |
19 |
| 52 |
OUTSTANDING_RECOVERY_AMOUNT |
NUMERIC(38,2) |
19 |
| 53 |
EXPOSURE_MAX_TRANSACTION_UPDATE_TIME |
TIMESTAMP |
8 |
| 54 |
EXCESS_DESCRIPTION |
CHARACTER VARYING(255) |
255 |