PRT_CTP_PROPOSAL

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 POLICY INTEGER 4
3 TRANCNT SMALLINT 2
4 EFFECTDTE INTEGER 4
5 ACTIVTO INTEGER 4
6 IMAGEFLAG CHARACTER(1) 1
7 PRVINSIND CHARACTER(1) 1
8 PRVINSDUE INTEGER 4
9 PRVINSCAN CHARACTER(1) 1
10 PRVREFUSD CHARACTER(1) 1
11 CRIMCONV CHARACTER(1) 1
12 BANKRUPT CHARACTER(1) 1
13 CANSURVEY CHARACTER(1) 1
14 COMPETPRM INTEGER 4
15 NATURBUS CHARACTER(1) 1
16 YRBUSEST SMALLINT 2
17 TURNOVER INTEGER 4
18 PREMISCNT SMALLINT 2
19 STAFFCNT SMALLINT 2
20 MVEHCNT SMALLINT 2
21 LOCATNREF INTEGER 4
22 FIREPROT CHARACTER(1) 1
23 FINLOSS CHARACTER(1) 1
24 SECTNCNT SMALLINT 2
25 NATUROCC CHARACTER(1) 1
26 ANNPOLBAS CHARACTER(1) 1
27 PAYFREQ CHARACTER(1) 1
28 MPDISC CHARACTER(1) 1
29 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 RECORD_TYPE CHARACTER VARYING(16) 16
31 COMMIT_TIMESTAMP TIMESTAMP 8
32 EXTRACT_TIMESTAMP TIMESTAMP 8
33 CDC_ID BIGINT 8
34 COMPANY_CDC SMALLINT 2
35 EFFECTDTE_CDC DATE 4
36 ACTIVTO_CDC DATE 4
37 POLICY_CDC INTEGER 4
38 LOYDATE INTEGER 4
39 DW_TIMESTAMP TIMESTAMP 8
40 PRODUCT CHARACTER(3) 3
41 PRVINSCOY CHARACTER(4) 4
42 PRVINSPOL CHARACTER(14) 14
43 NEWINSCOY CHARACTER(4) 4
44 COMPETCOY CHARACTER(4) 4
45 CPBUSSRC CHARACTER(10) 10
46 CPCUSTNO CHARACTER(10) 10
47 CPBRANCH CHARACTER(6) 6
48 CPSTAFFNO CHARACTER(10) 10
49 MAINOCCUP CHARACTER(4) 4
50 UWRITER CHARACTER(8) 8
51 PACKAGE CHARACTER(4) 4
52 OPPNTYID CHARACTER(52) 52
53 AGREEMENT_TYPE_CDC CHARACTER(3) 3
54 CAMPCODE CHARACTER(10) 10
55 COMNDUEIND CHARACTER(1) 1
56 POLTERMUNTS SMALLINT 2
57 POLTERMUNTCD CHARACTER(1) 1
58 ENDCNSNT CHARACTER(1) 1
59 VOLCANIND CHARACTER(1) 1
60 PRVINSYRS SMALLINT 2
61 TELMBENEFIT CHARACTER(1) 1
62 TELMLINK CHARACTER(1) 1
63 EXTREFNO1 CHARACTER(15) 15
64 EXTREFNO2 CHARACTER(15) 15
65 ANZSICCD CHARACTER(8) 8
66 EXTREFNO3 CHARACTER(20) 20
67 EXTREFDT1 INTEGER 4
68 CORPBRANCH CHARACTER(20) 20
69 CORPUSER CHARACTER(20) 20
70 BROKERFEE NUMERIC(11,2) 19
71 BRKFEEGST NUMERIC(11,2) 19