PRT_ENTAIL

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 ENIPERMM SMALLINT 2
10 ENIPERWK SMALLINT 2
11 ENIPERDD SMALLINT 2
12 ENSPECTYP CHARACTER VARYING(1) 1
13 ENPROFTSI NUMERIC(11,0) 19
14 ENPRFEES NUMERIC(11,0) 19
15 ENWAGES NUMERIC(11,0) 19
16 ENADDCST NUMERIC(11,0) 19
17 ENSTANDCH NUMERIC(11,0) 19
18 ENOTHDESC CHARACTER VARYING(15) 15
19 ENOTHVL NUMERIC(11,0) 19
20 ENCMATDAM NUMERIC(11,0) 19
21 ENCINCWRK NUMERIC(11,0) 19
22 ENCMEDIA NUMERIC(11,0) 19
23 ENCREREC NUMERIC(11,0) 19
24 ENCTRANST NUMERIC(11,0) 19
25 ENCAIRCON NUMERIC(11,0) 19
26 ENCPOWER NUMERIC(11,0) 19
27 ENCOTHDES CHARACTER VARYING(15) 15
28 ENCOTHVL NUMERIC(11,0) 19
29 ENBDOWNSI NUMERIC(11,0) 19
30 ENSPOIL NUMERIC(11,0) 19
31 ENEXCPERC SMALLINT 2
32 ENEXCMIN SMALLINT 2
33 ENSTANDBY CHARACTER VARYING(1) 1
34 ENREINST CHARACTER VARYING(1) 1
35 ENCRACK CHARACTER VARYING(1) 1
36 ENFULLAUT CHARACTER VARYING(1) 1
37 ENOVRHEAT CHARACTER VARYING(1) 1
38 ENCOLLAPS CHARACTER VARYING(1) 1
39 ENFLOOD CHARACTER VARYING(1) 1
40 ENGASEXP CHARACTER VARYING(1) 1
41 ENPERILS CHARACTER VARYING(1) 1
42 ENACCDAM CHARACTER VARYING(1) 1
43 ENEXPIDIT CHARACTER VARYING(1) 1
44 ENROCCUP CHARACTER VARYING(4) 4
45 ENMLTDISC CHARACTER VARYING(2) 2
46 ENOWNSURR CHARACTER VARYING(1) 1
47 ENRICODE CHARACTER VARYING(2) 2
48 ENBOILSI NUMERIC(11,0) 19
49 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
50 RECORD_TYPE CHARACTER VARYING(16) 16
51 COMMIT_TIMESTAMP TIMESTAMP 8
52 EXTRACT_TIMESTAMP TIMESTAMP 8
53 CDC_ID BIGINT 8
54 COMPANY_CDC SMALLINT 2
55 POLICY_CDC BIGINT 8
56 ACTIVTO_CDC DATE 4
57 EFFECTDTE_CDC DATE 4
58 DW_TIMESTAMP TIMESTAMP 8