INT_PCSRCPN_CLTAIL

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