INT_WC_PRT_POLICY

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 TERMSTART INTEGER 4
5 TRANCNT SMALLINT 2
6 LINK_POLICY CHARACTER VARYING(15) 15
7 TERMIDENT BIGINT 8
8 PROTECT_TERMIDENT BIGINT 8
9 COGEN_TERMIDENT INTEGER 4
10 PRVPOLREF CHARACTER(14) 14
11 SEQPOLICY INTEGER 4
12 POLSTATUS CHARACTER(1) 1
13 INCEPTION INTEGER 4
14 DUEDATE INTEGER 4
15 ACTIVTO INTEGER 4
16 EFFECTDTE INTEGER 4
17 BRANCH SMALLINT 2
18 BUSNESSRC CHARACTER(4) 4
19 AGENT INTEGER 4
20 STATE SMALLINT 2
21 BRCHRESP SMALLINT 2
22 CLIENT INTEGER 4
23 REASON SMALLINT 2
24 QTEPRDUCT CHARACTER(3) 3
25 IMAGEFLAG CHARACTER(1) 1
26 COYISSUED SMALLINT 2
27 INSTALFRQ CHARACTER(1) 1
28 COMPLTIND CHARACTER(1) 1
29 AGREEMENT_TYPE_CDC CHARACTER(3) 3
30 NTCETYPE CHARACTER(1) 1
31 COMMIT_TIMESTAMP TIMESTAMP 8