INT_PCSRCPN_PRTAIL

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 PRGENLIAB NUMERIC(11,0) 19
17 PRPRDLIAB NUMERIC(11,0) 19
18 PRROCCUP CHARACTER VARYING(4) 4
19 PRSICCODE CHARACTER VARYING(3) 3
20 PRRATEMTH CHARACTER VARYING(2) 2
21 PRFACTNO CHARACTER VARYING(6) 6
22 PRWAGES NUMERIC(11,0) 19
23 PRTURNOVR NUMERIC(11,0) 19
24 PRCONTVAL NUMERIC(11,0) 19
25 PRBRDACCT CHARACTER VARYING(1) 1
26 PRTOCPOLT CHARACTER VARYING(1) 1
27 PRLOIPOLT NUMERIC(11,0) 19
28 PRPROPLGL NUMERIC(11,0) 19
29 PRPPLCEXC INTEGER 4
30 PRWRKEXCL CHARACTER VARYING(1) 1
31 PRLIABXPT CHARACTER VARYING(1) 1
32 PRASBEXCL CHARACTER VARYING(1) 1
33 PRCVRTYPE CHARACTER VARYING(2) 2
34 PRCRSLIAB CHARACTER VARYING(1) 1
35 PRHOISTCR CHARACTER VARYING(1) 1
36 PRGDSSOLD CHARACTER VARYING(1) 1
37 PRINDEMPR CHARACTER VARYING(1) 1
38 PRCARPARK CHARACTER VARYING(1) 1
39 PRELVESCL CHARACTER VARYING(1) 1
40 PRENGBLDS CHARACTER VARYING(1) 1
41 PRTRMTRSK CHARACTER VARYING(1) 1
42 PRPRPOWNR CHARACTER VARYING(1) 1
43 PRLIABMBR CHARACTER VARYING(1) 1
44 PRBLDGALT CHARACTER VARYING(1) 1
45 PRINDEMLS CHARACTER VARYING(1) 1
46 PRWRKAWAY CHARACTER VARYING(1) 1
47 PRDMGPROP CHARACTER VARYING(1) 1
48 PRTPPDEXC INTEGER 4
49 PRMULTSEC CHARACTER VARYING(2) 2
50 PRTENLIAB NUMERIC(11,0) 19
51 PRTENEXC INTEGER 4
52 PRDRVRSK NUMERIC(11,0) 19
53 PRDRVEXC INTEGER 4
54 PRINNLIAB NUMERIC(11,0) 19
55 PRINNEXC INTEGER 4