PRT_ITEM_WITH_DEL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(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(1) 1
9 COMPLTIND CHARACTER(1) 1
10 ITMSTATUS CHARACTER(1) 1
11 REASONCDE CHARACTER(2) 2
12 CLASS CHARACTER(3) 3
13 SUBCLASS CHARACTER(3) 3
14 RISKDESC1 CHARACTER(50) 50
15 RISKDESC2 CHARACTER(50) 50
16 RISKSTATE CHARACTER(2) 2
17 OCCUPATN CHARACTER(4) 4
18 SUMINS INTEGER 4
19 SUMINSCDE CHARACTER(3) 3
20 EXCESS INTEGER 4
21 EXCESSTYP CHARACTER(1) 1
22 DISTRICT CHARACTER(2) 2
23 INDEXIND CHARACTER(1) 1
24 REBATEPC NUMERIC(4,2) 19
25 LOADINGPC NUMERIC(5,2) 19
26 RATEBASE NUMERIC(6,2) 19
27 RATEPC NUMERIC(6,4) 19
28 FIREBRIG CHARACTER(1) 1
29 MANCOMRTE NUMERIC(4,2) 19
30 MODULENO SMALLINT 2
31 MCIBASIC CHARACTER(1) 1
32 MCICOMM CHARACTER(1) 1
33 CHRGECODE CHARACTER(2) 2
34 CBASICPRM NUMERIC(11,2) 19
35 CCHARGES NUMERIC(11,2) 19
36 CSTMPDUTY NUMERIC(11,2) 19
37 CCOMMISN NUMERIC(11,2) 19
38 RBASICPRM NUMERIC(11,2) 19
39 RCHARGES NUMERIC(11,2) 19
40 RSTMPDUTY NUMERIC(11,2) 19
41 RCOMMISN NUMERIC(11,2) 19
42 TBASICPRM NUMERIC(11,2) 19
43 TCHARGES NUMERIC(11,2) 19
44 TSTMPDUTY NUMERIC(11,2) 19
45 TCOMMISN NUMERIC(11,2) 19
46 MINPRMIND CHARACTER(1) 1
47 RISKNO NUMERIC(6,0) 19
48 STATSCODE CHARACTER(1) 1
49 SCHEDLIND CHARACTER(1) 1
50 LOCATNREF INTEGER 4
51 OPIND CHARACTER(1) 1
52 TRANSDAYS SMALLINT 2
53 TAILORGRP CHARACTER(2) 2
54 TRANDATE INTEGER 4
55 DUEDATE INTEGER 4
56 TYPEOFPOL CHARACTER(1) 1
57 COINSPC NUMERIC(5,3) 19
58 MULTIGRP CHARACTER(2) 2
59 ATRNTYPE CHARACTER(2) 2
60 CLAUSES CHARACTER(1) 1
61 NATCOVER CHARACTER(1) 1
62 EXCCOVER NUMERIC(11,0) 19
63 TIMEFROM SMALLINT 2
64 TIMETO SMALLINT 2
65 CEDECOYPN NUMERIC(4,2) 19
66 CEDECOYSI NUMERIC(11,0) 19
67 ORCOMRATE NUMERIC(5,2) 19
68 TERMINCEP INTEGER 4
69 MANRIIND CHARACTER(1) 1
70 RIAMNDIND CHARACTER(1) 1
71 PRINTITEM CHARACTER(1) 1
72 PRTITEMNO SMALLINT 2
73 PREMREASA CHARACTER(2) 2
74 COMREAS CHARACTER(2) 2
75 CHGEXCLUD CHARACTER(2) 2
76 SDPREMA NUMERIC(11,2) 19
77 SDEXCLUD CHARACTER(2) 2
78 EMLKEYSI NUMERIC(11,0) 19
79 EMLPC SMALLINT 2
80 SDPREMT NUMERIC(11,2) 19
81 USERSTSD NUMERIC(11,2) 19
82 PREMREAST CHARACTER(2) 2
83 HIGHCOM CHARACTER(2) 2
84 USERSTSDT NUMERIC(11,2) 19
85 SEQPOLICY INTEGER 4
86 CGST NUMERIC(11,2) 19
87 RGST NUMERIC(11,2) 19
88 TGST NUMERIC(11,2) 19
89 CCOMMGST NUMERIC(11,2) 19
90 GSTEXCLUD CHARACTER(2) 2
91 RCOMMGST NUMERIC(11,2) 19
92 GSTCOMMEX CHARACTER(2) 2
93 TCOMMGST NUMERIC(11,2) 19
94 GSTORIDE CHARACTER(1) 1
95 LOADREAS CHARACTER(2) 2
96 DISCREAS CHARACTER(2) 2
97 TERPRMIND CHARACTER(1) 1
98 TERRREAS CHARACTER(2) 2
99 FIELD01 CHARACTER(1) 1
100 FIELD02 CHARACTER(1) 1
101 FIELD03 CHARACTER(2) 2
102 FIELD04 CHARACTER(2) 2
103 FIELD05 CHARACTER(4) 4
104 FIELD06 CHARACTER(4) 4
105 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
106 RECORD_TYPE CHARACTER VARYING(16) 16
107 COMMIT_TIMESTAMP TIMESTAMP 8
108 EXTRACT_TIMESTAMP TIMESTAMP 8
109 CDC_ID BIGINT 8
110 COMPANY_CDC SMALLINT 2
111 AGREEMENT_TYPE_CDC CHARACTER(3) 3
112 EFFECTDTE_CDC DATE 4
113 ACTIVTO_CDC DATE 4
114 POLICY_CDC INTEGER 4
115 DW_TIMESTAMP TIMESTAMP 8