INT_PCSRCPN_CWTAIL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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