INT_PCSRCPN_PROPOSAL

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 EFFECTDTE INTEGER 4
13 ACTIVTO INTEGER 4
14 IMAGEFLAG CHARACTER(1) 1
15 PRVINSIND CHARACTER(1) 1
16 PRVINSDUE INTEGER 4
17 PRVINSCOY CHARACTER(4) 4
18 PRVINSPOL CHARACTER(14) 14
19 PRVINSCAN CHARACTER(1) 1
20 PRVREFUSD CHARACTER(1) 1
21 CRIMCONV CHARACTER(1) 1
22 BANKRUPT CHARACTER(1) 1
23 NEWINSCOY CHARACTER(4) 4
24 CANSURVEY CHARACTER(1) 1
25 COMPETCOY CHARACTER(4) 4
26 COMPETPRM INTEGER 4
27 CPBUSSRC CHARACTER(10) 10
28 CPCUSTNO CHARACTER(10) 10
29 CPBRANCH CHARACTER(6) 6
30 CPSTAFFNO CHARACTER(10) 10
31 NATURBUS CHARACTER(1) 1
32 MAINOCCUP CHARACTER(4) 4
33 YRBUSEST SMALLINT 2
34 TURNOVER INTEGER 4
35 PREMISCNT SMALLINT 2
36 STAFFCNT SMALLINT 2
37 MVEHCNT SMALLINT 2
38 LOCATNREF INTEGER 4
39 FIREPROT CHARACTER(1) 1
40 FINLOSS CHARACTER(1) 1
41 SECTNCNT SMALLINT 2
42 NATUROCC CHARACTER(1) 1
43 UWRITER CHARACTER(8) 8
44 ANNPOLBAS CHARACTER(1) 1
45 PAYFREQ CHARACTER(1) 1
46 MPDISC CHARACTER(1) 1
47 PACKAGE CHARACTER(4) 4
48 OPPNTYID CHARACTER(52) 52
49 CAMPCODE CHARACTER(10) 10
50 LOYDATE INTEGER 4
51 COMNDUEIND CHARACTER(1) 1
52 POLTERMUNTS SMALLINT 2
53 POLTERMUNTCD CHARACTER(1) 1
54 ENDCNSNT CHARACTER(1) 1
55 TELMBENEFIT CHARACTER(1) 1
56 TELMLINK CHARACTER(1) 1
57 EXTREFNO1 CHARACTER(15) 15
58 EXTREFNO2 CHARACTER(15) 15