PRT_POLCIDTL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 TRANCNT SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 IMAGEFLAG CHARACTER(1) 1
8 CEDFLAG CHARACTER(1) 1
9 CEDTYPE CHARACTER(1) 1
10 CEDREFPCT SMALLINT 2
11 CEDPRMPCT SMALLINT 2
12 MAXCEDREF SMALLINT 2
13 IBNRIBNER SMALLINT 2
14 CEDPREMTH INTEGER 4
15 CEDINCMTH SMALLINT 2
16 CEDTERMST INTEGER 4
17 CEDTERMEN INTEGER 4
18 CEDCALCDT INTEGER 4
19 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
20 RECORD_TYPE CHARACTER VARYING(16) 16
21 COMMIT_TIMESTAMP TIMESTAMP 8
22 EXTRACT_TIMESTAMP TIMESTAMP 8
23 CDC_ID BIGINT 8
24 COMPANY_CDC SMALLINT 2
25 POLICY_CDC BIGINT 8
26 ACTIVTO_CDC DATE 4
27 DW_TIMESTAMP TIMESTAMP 8
28 TERMOFFER CHARACTER(4) 4
29 CLMBASIS CHARACTER(1) 1
30 NUMOFYRS SMALLINT 2
31 CALLUPFRQ CHARACTER(1) 1
32 INTADJFACT1 SMALLINT 2
33 INTADJFACT2 SMALLINT 2
34 FINADJFACT1 SMALLINT 2
35 FINADJFACT2 SMALLINT 2
36 MINPREM NUMERIC(11,0) 19
37 MAXPREM NUMERIC(11,0) 19
38 MINRATE NUMERIC(5,2) 19
39 MAXRATE NUMERIC(5,2) 19
40 URAFLAG CHARACTER(1) 1
41 URADATE INTEGER 4
42 URASCORE NUMERIC(5,2) 19
43 RMTYPE CHARACTER(1) 1
44 RMINCOFF INTEGER 4
45 RMINCPAID INTEGER 4
46 RMINCEARN INTEGER 4
47 MULTIYEAR CHARACTER(2) 2
48 PRMOVRRSN CHARACTER(2) 2
49 INJMGTTYP CHARACTER(2) 2
50 CATEGORYCD CHARACTER(1) 1
51 RENLIKEIND CHARACTER(1) 1
52 LOCKRATEIND CHARACTER(1) 1
53 WORDING CHARACTER(10) 10
54 VERSION NUMERIC(3,1) 19
55 ANNLIMIT INTEGER 4
56 CLMADJFACT1 INTEGER 4
57 CLMADJFACT2 INTEGER 4
58 FLOAT INTEGER 4
59 CLMHANDLFEE INTEGER 4
60 NETRETIND CHARACTER VARYING(1) 1