INT_BASE_PI_JCI_ITEM_TRANCNT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RN BIGINT 8
2 COMPANY SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 POLICY INTEGER 4
5 ITEMNO SMALLINT 2
6 EFFECTDTE INTEGER 4
7 ACTIVTO INTEGER 4
8 TRANCNT SMALLINT 2
9 IMAGEFLAG CHARACTER(1) 1
10 COMPLTIND CHARACTER(1) 1
11 ITMSTATUS CHARACTER(1) 1
12 REASONCDE CHARACTER(2) 2
13 CLASS CHARACTER(3) 3
14 SUBCLASS CHARACTER(3) 3
15 RISKDESC1 CHARACTER(50) 50
16 RISKDESC2 CHARACTER(50) 50
17 RISKSTATE CHARACTER(2) 2
18 OCCUPATN CHARACTER(4) 4
19 SUMINS INTEGER 4
20 SUMINSCDE CHARACTER(3) 3
21 EXCESS INTEGER 4
22 EXCESSTYP CHARACTER(1) 1
23 DISTRICT CHARACTER(2) 2
24 INDEXIND CHARACTER(1) 1
25 REBATEPC NUMERIC(4,2) 19
26 LOADINGPC NUMERIC(5,2) 19
27 RATEBASE NUMERIC(6,2) 19
28 RATEPC NUMERIC(6,4) 19
29 FIREBRIG CHARACTER(1) 1
30 MANCOMRTE NUMERIC(4,2) 19
31 MODULENO SMALLINT 2
32 MCIBASIC CHARACTER(1) 1
33 MCICOMM CHARACTER(1) 1
34 CHRGECODE CHARACTER(2) 2
35 CBASICPRM NUMERIC(11,2) 19
36 CCHARGES NUMERIC(11,2) 19
37 CSTMPDUTY NUMERIC(11,2) 19
38 CCOMMISN NUMERIC(11,2) 19
39 RBASICPRM NUMERIC(11,2) 19
40 RCHARGES NUMERIC(11,2) 19
41 RSTMPDUTY NUMERIC(11,2) 19
42 RCOMMISN NUMERIC(11,2) 19
43 TBASICPRM NUMERIC(11,2) 19
44 TCHARGES NUMERIC(11,2) 19
45 TSTMPDUTY NUMERIC(11,2) 19
46 TCOMMISN NUMERIC(11,2) 19
47 MINPRMIND CHARACTER(1) 1
48 RISKNO NUMERIC(6,0) 19
49 STATSCODE CHARACTER(1) 1
50 SCHEDLIND CHARACTER(1) 1
51 LOCATNREF INTEGER 4
52 OPIND CHARACTER(1) 1
53 TRANSDAYS SMALLINT 2
54 TAILORGRP CHARACTER(2) 2
55 TRANDATE INTEGER 4
56 DUEDATE INTEGER 4
57 TYPEOFPOL CHARACTER(1) 1
58 COINSPC NUMERIC(5,3) 19
59 MULTIGRP CHARACTER(2) 2
60 ATRNTYPE CHARACTER(2) 2
61 CLAUSES CHARACTER(1) 1
62 NATCOVER CHARACTER(1) 1
63 EXCCOVER NUMERIC(11,0) 19
64 TIMEFROM SMALLINT 2
65 TIMETO SMALLINT 2
66 CEDECOYPN NUMERIC(4,2) 19
67 CEDECOYSI NUMERIC(11,0) 19
68 ORCOMRATE NUMERIC(5,2) 19
69 TERMINCEP INTEGER 4
70 MANRIIND CHARACTER(1) 1
71 RIAMNDIND CHARACTER(1) 1
72 PRINTITEM CHARACTER(1) 1
73 PRTITEMNO SMALLINT 2
74 PREMREASA CHARACTER(2) 2
75 COMREAS CHARACTER(2) 2
76 CHGEXCLUD CHARACTER(2) 2
77 SDPREMA NUMERIC(11,2) 19
78 SDEXCLUD CHARACTER(2) 2
79 EMLKEYSI NUMERIC(11,0) 19
80 EMLPC SMALLINT 2
81 SDPREMT NUMERIC(11,2) 19
82 USERSTSD NUMERIC(11,2) 19
83 PREMREAST CHARACTER(2) 2
84 HIGHCOM CHARACTER(2) 2
85 USERSTSDT NUMERIC(11,2) 19
86 SEQPOLNO INTEGER 4
87 BASICGRP CHARACTER(2) 2
88 PBASICPRM NUMERIC(11,2) 19
89 PCHARGES NUMERIC(11,2) 19
90 PSTMPDUTY NUMERIC(11,2) 19
91 PCOMMISN NUMERIC(11,2) 19
92 CGST NUMERIC(11,2) 19
93 RGST NUMERIC(11,2) 19
94 TGST NUMERIC(11,2) 19
95 PGST NUMERIC(11,2) 19
96 POLPART CHARACTER(1) 1
97 CLUSTERKEY INTEGER 4
98 PAYCHANNEL CHARACTER(1) 1
99 CHRGECODE2 CHARACTER(2) 2
100 CHGEXCLUD2 CHARACTER(2) 2
101 CCHARGES2 NUMERIC(11,2) 19
102 RCHARGES2 NUMERIC(11,2) 19
103 TCHARGES2 NUMERIC(11,2) 19
104 PCHARGES2 NUMERIC(11,2) 19
105 CHRGECODE3 CHARACTER(2) 2
106 CHGEXCLUD3 CHARACTER(2) 2
107 CCHARGES3 NUMERIC(11,2) 19
108 RCHARGES3 NUMERIC(11,2) 19
109 TCHARGES3 NUMERIC(11,2) 19
110 PCHARGES3 NUMERIC(11,2) 19
111 CHRGECODE4 CHARACTER(2) 2
112 CHGEXCLUD4 CHARACTER(2) 2
113 CCHARGES4 NUMERIC(11,2) 19
114 RCHARGES4 NUMERIC(11,2) 19
115 TCHARGES4 NUMERIC(11,2) 19
116 PCHARGES4 NUMERIC(11,2) 19
117 CHRGECODE5 CHARACTER(2) 2
118 CHGEXCLUD5 CHARACTER(2) 2
119 CCHARGES5 NUMERIC(11,2) 19
120 RCHARGES5 NUMERIC(11,2) 19
121 TCHARGES5 NUMERIC(11,2) 19
122 PCHARGES5 NUMERIC(11,2) 19
123 CHRGECODE6 CHARACTER(2) 2
124 CHGEXCLUD6 CHARACTER(2) 2
125 CCHARGES6 NUMERIC(11,2) 19
126 RCHARGES6 NUMERIC(11,2) 19
127 TCHARGES6 NUMERIC(11,2) 19
128 PCHARGES6 NUMERIC(11,2) 19
129 ADMINFEE NUMERIC(4,2) 19
130 RISKPCT NUMERIC(5,2) 19
131 LURN CHARACTER(38) 38
132 LURNSCALE CHARACTER(1) 1
133 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
134 RECORD_TYPE CHARACTER VARYING(16) 16
135 COMMIT_TIMESTAMP TIMESTAMP 8
136 EXTRACT_TIMESTAMP TIMESTAMP 8