INT_GI_POLICY_RISK_C15_CI_01

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COVERAGEKEY BIGINT 8
2 POLICYNUMBER CHARACTER(10) 10
3 COMPANY INTEGER 4
4 PRODUCT CHARACTER(2) 2
5 CLASS CHARACTER(2) 2
6 SUBCLASS CHARACTER VARYING(3) 3
7 REVERSALINDIC BYTEINT 1
8 POLICY BIGINT 8
9 ITEMNO INTEGER 4
10 TERMIDENT CHARACTER(3) 3
11 SEQUENCENUMBER CHARACTER(3) 3
12 TRANCNT BIGINT 8
13 TRANCNT_ALCHEMY BIGINT 8
14 RISK INTEGER 4
15 MAINRISK CHARACTER VARYING(1) 1
16 STATERISK CHARACTER VARYING(3) 3
17 MULTIRISKFLAG CHARACTER VARYING(1) 1
18 RISKOCCUPATIONCODE CHARACTER(5) 5
19 POSTCODERISK CHARACTER(4) 4
20 RISKADDRESSLINE1 CHARACTER(75) 75
21 RISKADDRESSLINE2 CHARACTER(75) 75
22 ADDRESSREFERENCE INTEGER 4
23 SUMINSURED NUMERIC(11,0) 19