INT_GI_POLICY_TRANSACTION_INS_CI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COVERAGEKEY BIGINT 8
2 POLICY BIGINT 8
3 POLICYNUMBER CHARACTER VARYING(30) 30
4 PRODUCT CHARACTER VARYING(30) 30
5 CLASS CHARACTER VARYING(30) 30
6 SUBCLASS CHARACTER VARYING(30) 30
7 ITEMNO INTEGER 4
8 RISK INTEGER 4
9 TRANCNT INTEGER 4
10 TERMIDENT INTEGER 4
11 INFORCEINCDATE DATE 4
12 INFORCEEXPDATE DATE 4
13 TRANINFORCE INTEGER 4
14 TERMINCDATE DATE 4
15 TERMEXPDATE DATE 4
16 COMPANY INTEGER 4
17 OCCUPATN CHARACTER VARYING(30) 30
18 BUSNESSRC CHARACTER VARYING(30) 30
19 PRVPOLREF CHARACTER VARYING(30) 30
20 AGTACCTYP CHARACTER VARYING(30) 30
21 AGENTNUMBER CHARACTER VARYING(30) 30
22 AGENTNAME CHARACTER VARYING(50) 50
23 CLIENTNUMBER CHARACTER VARYING(30) 30
24 GLCHANNEL CHARACTER VARYING(30) 30
25 GLPRODUCT CHARACTER VARYING(30) 30
26 GLCLASS CHARACTER VARYING(30) 30
27 GLENTITY CHARACTER VARYING(30) 30
28 GLSTATE CHARACTER VARYING(30) 30
29 GLCATGORY CHARACTER VARYING(30) 30
30 GLCENTRE CHARACTER VARYING(30) 30
31 PCODE CHARACTER VARYING(30) 30
32 STATERISK CHARACTER VARYING(30) 30
33 POSTCODERISK CHARACTER VARYING(30) 30
34 PRODIMKEY CHARACTER VARYING(30) 30