INT_RISK_ADDRESS

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RISK_CCR_CC_CLAIM_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 RISK_CCR_CC_CLAIM_ID BIGINT 8
3 RISK_CCR_CC_ADDRESS_ADDRESSLINE1 CHARACTER VARYING(55) 55
4 RISK_CCR_CC_ADDRESS_ADDRESSLINE2 CHARACTER VARYING(55) 55
5 RISK_CCR_CC_ADDRESS_ADDRESSLINE3 CHARACTER VARYING(55) 55
6 RISK_CCR_CC_ADDRESS_CITY CHARACTER VARYING(60) 60
7 RISK_CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
8 RISK_CCR_CC_ADDRESS_STATE BIGINT 8
9 RISK_CCR_CC_INCIDENT_SC_INSUREDVEHICLE BIGINT 8
10 RISK_CCR_CC_ADDRESS_COUNTRY BIGINT 8
11 FLEET_IND CHARACTER VARYING(9) 9
12 SC_COVERAGE BIGINT 8
13 RISK_CCR_CC_ADDRESS_LONGITUDE NUMERIC(8,5) 19
14 RISK_CCR_CC_ADDRESS_LATITUDE NUMERIC(7,5) 19