PRT_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
72 CAMPAPPLIED CHARACTER(10) 10
73 TRANSID CHARACTER(50) 50
74 ACTTOPC NUMERIC(5,2) 19
75 NSWTOPC NUMERIC(5,2) 19
76 NTTOPC NUMERIC(5,2) 19
77 QLDTOPC NUMERIC(5,2) 19
78 SATOPC NUMERIC(5,2) 19
79 TASTOPC NUMERIC(5,2) 19
80 VICTOPC NUMERIC(5,2) 19
81 WATOPC NUMERIC(5,2) 19
82 ACTSIPC NUMERIC(5,2) 19
83 NSWSIPC NUMERIC(5,2) 19
84 NTSIPC NUMERIC(5,2) 19
85 QLDSIPC NUMERIC(5,2) 19
86 SASIPC NUMERIC(5,2) 19
87 TASSIPC NUMERIC(5,2) 19
88 VICSIPC NUMERIC(5,2) 19
89 WASIPC NUMERIC(5,2) 19