INT_GI_POLICY_ITEMPREM_NPT_PI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY INTEGER 4
2 PRODUCT CHARACTER VARYING(30) 30
3 POLICY INTEGER 4
4 ITEMNO INTEGER 4
5 TRANCNT INTEGER 4
6 COVERAGEKEY BIGINT 8
7 RISKCLMSWEIGHT NUMERIC(15,6) 19
8 ACTUARIAL NUMERIC(15,6) 19
9 BASEPREM NUMERIC(15,6) 19
10 CAMPAIGN NUMERIC(15,6) 19
11 CAPPING NUMERIC(15,6) 19
12 COMMISSION NUMERIC(15,6) 19
13 INSTALMENT NUMERIC(15,6) 19
14 OVERRIDE NUMERIC(15,6) 19
15 RETAILPREM NUMERIC(15,6) 19
16 SENIORCARD NUMERIC(15,6) 19
17 MULTIPROD NUMERIC(15,6) 19
18 SINGLECOMB NUMERIC(15,6) 19
19 STAFF NUMERIC(15,6) 19