PRT_ELTAIL

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 ELROCCUP CHARACTER VARYING(4) 4
10 ELSICCODE CHARACTER VARYING(3) 3
11 ELCVRTYPE CHARACTER VARYING(2) 2
12 ELLOIPRIM NUMERIC(11,0) 19
13 ELPRIMWRD CHARACTER VARYING(1) 1
14 ELPRIMPRM INTEGER 4
15 ELLOIGDPR NUMERIC(11,0) 19
16 ELOTHLOI NUMERIC(11,0) 19
17 ELUNDLMT NUMERIC(11,0) 19
18 ELNETRATE INTEGER 4
19 ELFORMCVR CHARACTER VARYING(1) 1
20 ELEXCINS1 CHARACTER VARYING(30) 30
21 ELEXCCVR1 CHARACTER VARYING(1) 1
22 ELEXCPOL1 CHARACTER VARYING(20) 20
23 ELEXCLOI1 NUMERIC(11,0) 19
24 ELEXCINS2 CHARACTER VARYING(30) 30
25 ELEXCCVR2 CHARACTER VARYING(1) 1
26 ELEXCPOL2 CHARACTER VARYING(20) 20
27 ELEXCLOI2 NUMERIC(11,0) 19
28 ELEXCINS3 CHARACTER VARYING(30) 30
29 ELEXCCVR3 CHARACTER VARYING(1) 1
30 ELEXCPOL3 CHARACTER VARYING(20) 20
31 ELEXCLOI3 NUMERIC(11,0) 19
32 ELEXCINS4 CHARACTER VARYING(30) 30
33 ELEXCCVR4 CHARACTER VARYING(1) 1
34 ELEXCPOL4 CHARACTER VARYING(20) 20
35 ELEXCLOI4 NUMERIC(11,0) 19
36 ELEXCINS5 CHARACTER VARYING(30) 30
37 ELEXCCVR5 CHARACTER VARYING(1) 1
38 ELEXCPOL5 CHARACTER VARYING(20) 20
39 ELEXCLOI5 NUMERIC(11,0) 19
40 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 RECORD_TYPE CHARACTER VARYING(16) 16
42 COMMIT_TIMESTAMP TIMESTAMP 8
43 EXTRACT_TIMESTAMP TIMESTAMP 8
44 CDC_ID BIGINT 8
45 COMPANY_CDC SMALLINT 2
46 POLICY_CDC BIGINT 8
47 ACTIVTO_CDC DATE 4
48 EFFECTDTE_CDC DATE 4
49 DW_TIMESTAMP TIMESTAMP 8