INT_GI_POLICY_RISK_C15_WC

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COVERAGEKEY BIGINT 8
2 COMPANY INTEGER 4
3 PRODUCT CHARACTER VARYING(30) 30
4 POLICY BIGINT 8
5 ITEMNO INTEGER 4
6 TRANCNT INTEGER 4
7 RISK INTEGER 4
8 MAINRISK CHARACTER VARYING(30) 30
9 MULTIRISKFLAG CHARACTER VARYING(30) 30
10 STATERISK CHARACTER VARYING(30) 30
11 ADDRESSREFERENCE INTEGER 4
12 RISKADDRESSLINE1 CHARACTER VARYING(75) 75
13 RISKADDRESSLINE2 CHARACTER VARYING(40) 40
14 POSTCODERISK CHARACTER VARYING(30) 30
15 RISKOCCUPATIONCODE CHARACTER VARYING(30) 30
16 SUMINSURED NUMERIC(15,0) 19