INT_PCSRCPN_ENTAIL

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