PRT_CLTAIL

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 CLPROFIT NUMERIC(11,0) 19
10 CLPROFCDE CHARACTER VARYING(1) 1
11 CLPROFFEE NUMERIC(11,0) 19
12 CLWAGENOT NUMERIC(11,0) 19
13 CLINDMPER SMALLINT 2
14 CLCNSTR CHARACTER VARYING(1) 1
15 CLCNSTRYR SMALLINT 2
16 CLROCCUP CHARACTER VARYING(4) 4
17 CLSPRNKLR CHARACTER VARYING(1) 1
18 CLSMOKDET CHARACTER VARYING(1) 1
19 CLALARM CHARACTER VARYING(1) 1
20 CLFLOOD CHARACTER VARYING(1) 1
21 CLERTHQAK CHARACTER VARYING(1) 1
22 CLSTORM CHARACTER VARYING(1) 1
23 CLAIRCRFT CHARACTER VARYING(1) 1
24 CLEXPLOSN CHARACTER VARYING(1) 1
25 CLIMPACT CHARACTER VARYING(1) 1
26 CLRIOTSTK CHARACTER VARYING(1) 1
27 CLRTSSTKM CHARACTER VARYING(1) 1
28 CLSTMRAIN CHARACTER VARYING(1) 1
29 CLWTRLKNG CHARACTER VARYING(1) 1
30 CLWIND CHARACTER VARYING(1) 1
31 CLWAGES NUMERIC(11,0) 19
32 CLPREPEXP NUMERIC(11,0) 19
33 CLPAYROLL NUMERIC(11,0) 19
34 CLCSTWORK NUMERIC(11,0) 19
35 CLADDEXP NUMERIC(11,0) 19
36 CLSPECITM NUMERIC(11,0) 19
37 CLDESC CHARACTER VARYING(80) 80
38 CLTIMEXS SMALLINT 2
39 CLWGDBWK1 SMALLINT 2
40 CLWGDBPCT SMALLINT 2
41 CLWGDBWK2 SMALLINT 2
42 CLWGDBCNS SMALLINT 2
43 CLPAYWK1 SMALLINT 2
44 CLPAYPCT SMALLINT 2
45 CLPAYWK2 SMALLINT 2
46 CLPAYCNS SMALLINT 2
47 CLWGWKS SMALLINT 2
48 CLRENTREC NUMERIC(11,0) 19
49 CLACCTREC NUMERIC(11,0) 19
50 CLFUSION NUMERIC(6,0) 19
51 CLFUSEXS SMALLINT 2
52 CLNWCNSTR CHARACTER VARYING(2) 2
53 CLRICNST CHARACTER VARYING(1) 1
54 CLPUBUTIL CHARACTER VARYING(1) 1
55 CLPUEXS SMALLINT 2
56 CLSUPPRM CHARACTER VARYING(1) 1
57 CLSPPCT SMALLINT 2
58 CLFLOODLD SMALLINT 2
59 CLMULTSEC SMALLINT 2
60 UWPOINTS CHARACTER VARYING(3) 3
61 UWCATG CHARACTER VARYING(2) 2
62 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
63 RECORD_TYPE CHARACTER VARYING(16) 16
64 COMMIT_TIMESTAMP TIMESTAMP 8
65 EXTRACT_TIMESTAMP TIMESTAMP 8
66 CDC_ID BIGINT 8
67 COMPANY_CDC SMALLINT 2
68 POLICY_CDC BIGINT 8
69 ACTIVTO_CDC DATE 4
70 EFFECTDTE_CDC DATE 4
71 DW_TIMESTAMP TIMESTAMP 8