INT_WC_PRT_POLCIDTL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICY INTEGER 4
2 COMPANY SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 TRANCNT SMALLINT 2
5 TERMIDENT BIGINT 8
6 ROW_ID BIGINT 8
7 CED_IND CHARACTER VARYING(1) 1
8 PRMOVRRSN CHARACTER(2) 2
9 CEDREFPCT SMALLINT 2
10 CEDPRMPCT SMALLINT 2
11 MAXCEDREF SMALLINT 2
12 IBNRIBNER SMALLINT 2
13 CEDPREMTH INTEGER 4
14 CEDINCMTH SMALLINT 2
15 CEDTERMST INTEGER 4
16 CEDTERMEN INTEGER 4
17 CEDCALCDT INTEGER 4
18 BURNER_IND CHARACTER VARYING(1) 1
19 TERMOFFER CHARACTER(4) 4
20 CLMBASIS CHARACTER(1) 1
21 INTADJFACT1 SMALLINT 2
22 INTADJFACT2 SMALLINT 2
23 INTADJFACT CHARACTER VARYING(19) 19
24 FINADJFACT1 SMALLINT 2
25 FINADJFACT2 SMALLINT 2
26 FINADJFACT CHARACTER VARYING(19) 19
27 NUMOFYRS SMALLINT 2
28 CALLUPFRQ CHARACTER(1) 1
29 MAXPREM NUMERIC(11,0) 19
30 MAXRATE NUMERIC(5,2) 19
31 MINPREM NUMERIC(11,0) 19
32 MINRATE NUMERIC(5,2) 19
33 RMTYPE CHARACTER(1) 1
34 RMINCOFF INTEGER 4
35 RMINCPAID INTEGER 4
36 RMINCEARN INTEGER 4
37 MULTIYEAR CHARACTER(2) 2
38 CATEGORYCD CHARACTER(1) 1
39 RENLIKEIND CHARACTER(1) 1