PRT_CWTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 CWCPER1 INTEGER 4
10 CWCPER2 INTEGER 4
11 CWMPERMTH SMALLINT 2
12 CWCVALUE NUMERIC(11,0) 19
13 CWMATSUPP NUMERIC(11,0) 19
14 CWRMVEDEY CHARACTER VARYING(1) 1
15 CWRMVEDEB NUMERIC(11,0) 19
16 CWPRFEE1Y CHARACTER VARYING(1) 1
17 CWPRFEE1 NUMERIC(11,0) 19
18 CWEXPENSY CHARACTER VARYING(1) 1
19 CWEXPENSE NUMERIC(11,0) 19
20 CWTBUILD NUMERIC(11,0) 19
21 CWPLANTEQ NUMERIC(11,0) 19
22 CWEXISTST NUMERIC(11,0) 19
23 CWSVAR1DE CHARACTER VARYING(26) 26
24 CWSVAR1VL NUMERIC(11,0) 19
25 CWMAJPERL INTEGER 4
26 CWMINPERL INTEGER 4
27 CWTESTCOM INTEGER 4
28 CWDVAR1DE CHARACTER VARYING(12) 12
29 CWDVAR1VL INTEGER 4
30 CWDVAR2DE CHARACTER VARYING(12) 12
31 CWDVAR2VL INTEGER 4
32 CWTPPD INTEGER 4
33 CWTRANSIT NUMERIC(11,0) 19
34 CWWKRWKR INTEGER 4
35 CWLVAR1DE CHARACTER VARYING(12) 12
36 CWLVAR1VL INTEGER 4
37 CWIPERMTH SMALLINT 2
38 CWGRPROFT NUMERIC(11,0) 19
39 CWRENTAL NUMERIC(11,0) 19
40 CWINCCOST NUMERIC(11,0) 19
41 CWPRFEE2 NUMERIC(11,0) 19
42 CWSTCHRGS NUMERIC(11,0) 19
43 CWCVAR1DE CHARACTER VARYING(26) 26
44 CWCVAR1VL NUMERIC(11,0) 19
45 CWDEDDAYS SMALLINT 2
46 CWDVAR3VL INTEGER 4
47 CWDVAR4DE CHARACTER VARYING(25) 25
48 CWDVAR5DE CHARACTER VARYING(25) 25
49 CWPERCAT CHARACTER VARYING(1) 1
50 CWRISK CHARACTER VARYING(2) 2
51 CWCTYPE CHARACTER VARYING(3) 3
52 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
53 RECORD_TYPE CHARACTER VARYING(16) 16
54 COMMIT_TIMESTAMP TIMESTAMP 8
55 EXTRACT_TIMESTAMP TIMESTAMP 8
56 CDC_ID BIGINT 8
57 COMPANY_CDC SMALLINT 2
58 POLICY_CDC BIGINT 8
59 ACTIVTO_CDC DATE 4
60 EFFECTDTE_CDC DATE 4
61 DW_TIMESTAMP TIMESTAMP 8