PRT_CTP_CTPTAIL

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER(1) 1
9 MVREG CHARACTER(12) 12
10 CTPNO CHARACTER(12) 12
11 REGOID NUMERIC(10,0) 19
12 CLASSCODE CHARACTER(4) 4
13 VEHID NUMERIC(15,0) 19
14 VINCHAS CHARACTER(25) 25
15 ENGNO CHARACTER(30) 30
16 VEHTYPE CHARACTER(4) 4
17 MAKE CHARACTER(6) 6
18 MODEL CHARACTER(10) 10
19 MODELVAR CHARACTER(10) 10
20 MANUFYEAR SMALLINT 2
21 MANUFMTH SMALLINT 2
22 SHAPE CHARACTER(4) 4
23 TRANSTYPE CHARACTER(1) 1
24 GEARS SMALLINT 2
25 FUELTYPE CHARACTER(4) 4
26 COLOURCD1 CHARACTER(4) 4
27 COLOURCD2 CHARACTER(4) 4
28 ENGCAP INTEGER 4
29 DOORS SMALLINT 2
30 SEATS SMALLINT 2
31 TAREWEIGHT INTEGER 4
32 GCMWEIGHT INTEGER 4
33 GVMWEIGHT INTEGER 4
34 CYLINDERS SMALLINT 2
35 CYLROTORIND CHARACTER(1) 1
36 NVIC CHARACTER(6) 6
37 VEHCAT CHARACTER(2) 2
38 PLATETYPE CHARACTER(1) 1
39 PRIVBUS CHARACTER(1) 1
40 REGTYPE CHARACTER(4) 4
41 REGUSE CHARACTER(4) 4
42 REGCOND CHARACTER(1) 1
43 PRMTERM CHARACTER(1) 1
44 AREA CHARACTER(2) 2
45 STAMPDTE INTEGER 4
46 PAYMNTDTE INTEGER 4
47 NCBIND CHARACTER(1) 1
48 NCBPCT SMALLINT 2
49 YEARLYKM CHARACTER(2) 2
50 YDBIRTHDTE INTEGER 4
51 YDGENDER CHARACTER(1) 1
52 NOYRLICOBT SMALLINT 2
53 TRANSFERDTE INTEGER 4
54 ITCESTATUS CHARACTER(1) 1
55 REGENDDTE INTEGER 4
56 NEXTRNWTERM CHARACTER(1) 1
57 ATFAULTACCDS SMALLINT 2
58 MVINSURER CHARACTER(4) 4
59 MVINSTYPE CHARACTER(1) 1
60 MVPOLNO CHARACTER(12) 12
61 MVINSYEARS SMALLINT 2
62 PILLIONPSNG CHARACTER(1) 1
63 TRAFFICOFFS SMALLINT 2
64 COMREGVEH CHARACTER(1) 1
65 RISKPCT NUMERIC(5,2) 19
66 RUNNO INTEGER 4
67 EXEMPTCD CHARACTER(4) 4
68 LURN CHARACTER(38) 38
69 LURNSCALE CHARACTER(1) 1
70 MVPOLMTHDUE SMALLINT 2
71 USEBYDTE INTEGER 4
72 CHKDGT CHARACTER(1) 1
73 PRORATAFLAG CHARACTER(1) 1
74 FUTUREITCE CHARACTER(1) 1
75 REGCTPSTIND CHARACTER(1) 1
76 GVM4P5IND CHARACTER(1) 1
77 STOCKNUM CHARACTER(12) 12
78 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
79 RECORD_TYPE CHARACTER VARYING(16) 16
80 COMMIT_TIMESTAMP TIMESTAMP 8
81 EXTRACT_TIMESTAMP TIMESTAMP 8
82 CDC_ID BIGINT 8
83 COMPANY_CDC SMALLINT 2
84 AGREEMENT_TYPE_CDC CHARACTER(3) 3
85 POLICY_CDC INTEGER 4
86 ACTIVTO_CDC DATE 4
87 EFFECTDTE_CDC DATE 4
88 DW_TIMESTAMP TIMESTAMP 8
89 REGOPDOB INTEGER 4
90 DEMERITPTS SMALLINT 2
91 LICCANCNT SMALLINT 2
92 ESTREG CHARACTER(1) 1
93 NOATFLTACC SMALLINT 2
94 STDEXCESS INTEGER 4
95 VOLEXCESS INTEGER 4
96 IMPEXCESS INTEGER 4