INT_WC_UNPROC_POL_ITEM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICY INTEGER 4
2 COMPANY SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 ITEMNO SMALLINT 2
5 ITMSTATUS CHARACTER(1) 1
6 ITEM_IMAGEFLAG CHARACTER(1) 1
7 GHOST_TERM_IND CHARACTER VARYING(1) 1
8 ITEM_CLASS CHARACTER(3) 3
9 ITEM_TRANCNT SMALLINT 2
10 ITEM_AGREEMENT_TYPE_CDC CHARACTER(3) 3
11 SUBCLASS CHARACTER(3) 3
12 ATRNTYPE CHARACTER(2) 2
13 SUMINS INTEGER 4
14 RISKSTATE CHARACTER(2) 2
15 TERMINCEP INTEGER 4
16 TRANDATE INTEGER 4
17 ITEM_EFFECTDTE INTEGER 4
18 ITEM_ACTIVTO INTEGER 4
19 ITEM_DUEDATE INTEGER 4
20 BASICPRM NUMERIC(11,2) 19
21 CHARGES NUMERIC(11,2) 19
22 STMPDUTY NUMERIC(11,2) 19
23 GST NUMERIC(11,2) 19
24 COMMISN NUMERIC(11,2) 19
25 COMMGST NUMERIC(11,2) 19
26 POL_AGREEMENT_TYPE_CDC CHARACTER(3) 3
27 POL_TERMIDENT BIGINT 8
28 POL_TRANCNT SMALLINT 2
29 POL_TERMSTART INTEGER 4
30 POL_STATE SMALLINT 2
31 POL_BRCHRESP SMALLINT 2
32 POL_COYISSUED SMALLINT 2
33 POL_COMPLTIND CHARACTER(1) 1
34 POL_SEQPOLICY INTEGER 4
35 POL_QTEPRDUCT CHARACTER(3) 3
36 POL_POLSTATUS CHARACTER(1) 1
37 POL_CLIENT INTEGER 4
38 POL_AGENT INTEGER 4
39 POL_INCEPTION INTEGER 4
40 POL_DUEDATE INTEGER 4
41 POL_EFFECTDTE INTEGER 4
42 POL_ACTIVTO INTEGER 4
43 POL_PRVPOLREF CHARACTER(14) 14
44 POL_IMAGEFLAG CHARACTER(1) 1
45 POL_REASON SMALLINT 2
46 POL_INSTALFRQ CHARACTER(1) 1
47 POL_BUSNESSRC CHARACTER(4) 4
48 COMMIT_TIMESTAMP TIMESTAMP 8
49 ROW_ID BIGINT 8
50 TBASICPRM_ITEM NUMERIC(38,2) 19