PRT_PRTAIL

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