INT_PCSRCPN_ITEM

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