INT_PCSRCPN_POLICY

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 TRANCNT SMALLINT 2
12 IMAGEFLAG CHARACTER(1) 1
13 COMPLTIND CHARACTER(1) 1
14 CLIENT INTEGER 4
15 STATE SMALLINT 2
16 BRANCH SMALLINT 2
17 PRVPOLREF CHARACTER(14) 14
18 EFFECTDTE INTEGER 4
19 ACTIVTO INTEGER 4
20 POLSTATUS CHARACTER(1) 1
21 REASON SMALLINT 2
22 INCEPTION INTEGER 4
23 TIMEFROM SMALLINT 2
24 TIMETO SMALLINT 2
25 REP SMALLINT 2
26 AGENT INTEGER 4
27 POLICYFEE NUMERIC(7,2) 19
28 DUEDATE INTEGER 4
29 RNWALTERM SMALLINT 2
30 REVIEWIND CHARACTER(1) 1
31 NTCETO CHARACTER(1) 1
32 NTCEPROD CHARACTER(1) 1
33 NTCETYPE CHARACTER(1) 1
34 CLAUSEIND CHARACTER(1) 1
35 SPCLSIND CHARACTER(1) 1
36 MSGIND CHARACTER(1) 1
37 FORM CHARACTER(10) 10
38 BUSNESSRC CHARACTER(4) 4
39 COYISSUED SMALLINT 2
40 STISSUED CHARACTER(2) 2
41 CUSTREF CHARACTER(14) 14
42 DEBITBSB INTEGER 4
43 DEBITACC INTEGER 4
44 INSTALFRQ CHARACTER(1) 1
45 INSTALAMT NUMERIC(9,2) 19
46 INSTALVAR NUMERIC(9,2) 19
47 PRIORCLM CHARACTER(1) 1
48 CANCDECLN CHARACTER(1) 1
49 IMPEXCESS CHARACTER(1) 1
50 LOCKUSER CHARACTER(8) 8
51 LOCKDATE INTEGER 4
52 LOCKTIME INTEGER 4
53 QTEPRDUCT CHARACTER(3) 3
54 BRCHRESP SMALLINT 2
55 BUSDESC CHARACTER(1) 1
56 SEQPOLICY INTEGER 4
57 TERMSTART INTEGER 4
58 CNOTEEND INTEGER 4
59 DISCGRP CHARACTER(1) 1
60 REPLPOLNO CHARACTER(14) 14