PRT_MVTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 POLICY INTEGER 4
3 ITEMNO SMALLINT 2
4 EFFECTDTE INTEGER 4
5 ACTIVTO INTEGER 4
6 TRANCNT SMALLINT 2
7 IMAGEFLAG CHARACTER(1) 1
8 MVYRSONRT NUMERIC(2,0) 19
9 MVNCBCONF CHARACTER(1) 1
10 MVNCBREVW INTEGER 4
11 MVNCBPROT CHARACTER(1) 1
12 MVNCBPC NUMERIC(3,1) 19
13 MVSIDESC CHARACTER(1) 1
14 MVSIDLGDE NUMERIC(7,0) 19
15 MVMANUFYR SMALLINT 2
16 MVYEARSEQ CHARACTER(1) 1
17 MVGEARS NUMERIC(1,0) 19
18 MVENGCAP SMALLINT 2
19 MVFUEL CHARACTER(1) 1
20 MVTRANS CHARACTER(1) 1
21 MVTONNES NUMERIC(2,0) 19
22 MVTHFTDEV CHARACTER(1) 1
23 MVRADIO SMALLINT 2
24 MVAIRCOND SMALLINT 2
25 MVACCESS SMALLINT 2
26 MVLPG CHARACTER(1) 1
27 MVLPGAPRV CHARACTER(1) 1
28 MVGARGING CHARACTER(1) 1
29 MVRDWORTH CHARACTER(1) 1
30 MVFLAMEGD CHARACTER(1) 1
31 MVVEHUSE CHARACTER(1) 1
32 MVSCRNEXT CHARACTER(1) 1
33 MVNAMDDRV CHARACTER(1) 1
34 MVDRVDETS CHARACTER(1) 1
35 SEQUENCE INTEGER 4
36 MVRESTDRV CHARACTER(1) 1
37 MVGAPCVR CHARACTER(1) 1
38 MVFINANCE CHARACTER(1) 1
39 MVNOVDISC CHARACTER(1) 1
40 MVTRAILER CHARACTER(1) 1
41 MVACCESRY CHARACTER(1) 1
42 MVMODS CHARACTER(1) 1
43 MVHEALTH CHARACTER(1) 1
44 MVSURVEY CHARACTER(1) 1
45 MVPDAMAGE CHARACTER(1) 1
46 MVAGEDRVR NUMERIC(3,0) 19
47 MVRACGEXT CHARACTER(1) 1
48 MVTHFTEXC INTEGER 4
49 MVCHCEREP CHARACTER(1) 1
50 MVSLVRGHT CHARACTER(1) 1
51 MVVEHSI INTEGER 4
52 MVEXTRASI INTEGER 4
53 MVVOLXS INTEGER 4
54 MVPURCHDT INTEGER 4
55 MVPRICE INTEGER 4
56 MVOWNER CHARACTER(1) 1
57 MVLENGTH NUMERIC(5,0) 19
58 MVGENDER CHARACTER(1) 1
59 MVHIRECAR CHARACTER(1) 1
60 LURNSCALE CHARACTER(1) 1
61 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
62 RECORD_TYPE CHARACTER VARYING(16) 16
63 COMMIT_TIMESTAMP TIMESTAMP 8
64 EXTRACT_TIMESTAMP TIMESTAMP 8
65 CDC_ID BIGINT 8
66 COMPANY_CDC SMALLINT 2
67 POLICY_CDC INTEGER 4
68 ACTIVTO_CDC DATE 4
69 EFFECTDTE_CDC DATE 4
70 SPECDISC CHARACTER(1) 1
71 LIFENEWOLD CHARACTER(1) 1
72 OWNERSHIP SMALLINT 2
73 DW_TIMESTAMP TIMESTAMP 8
74 PRODUCT CHARACTER(3) 3
75 MVPREVINS CHARACTER(4) 4
76 MVRATING CHARACTER(2) 2
77 MVCATGORY CHARACTER(2) 2
78 MVMAKE CHARACTER(4) 4
79 MVMODEL CHARACTER(6) 6
80 MVSTAMAKE CHARACTER(4) 4
81 MVBODTYPE CHARACTER(2) 2
82 MVENGNO CHARACTER(20) 20
83 MVREG CHARACTER(12) 12
84 MVNOCYL CHARACTER(3) 3
85 MVMODCDE1 CHARACTER(2) 2
86 MVMODCDE2 CHARACTER(2) 2
87 MVMODCDE3 CHARACTER(2) 2
88 MVMODCDE4 CHARACTER(2) 2
89 MVMODCDE5 CHARACTER(2) 2
90 MVMODCDE6 CHARACTER(2) 2
91 MVVEHCLS CHARACTER(3) 3
92 MVSERIES CHARACTER(2) 2
93 MVRADIUS CHARACTER(3) 3
94 MVYEARLYK CHARACTER(2) 2
95 MVALARM CHARACTER(4) 4
96 MVFAMILY CHARACTER(2) 2
97 LURN CHARACTER(38) 38
98 AGREEMENT_TYPE_CDC CHARACTER(3) 3
99 NVIC CHARACTER(6) 6
100 VEHCAT CHARACTER(2) 2
101 PURCHBAND CHARACTER(1) 1
102 OTHRDISC CHARACTER(1) 1
103 REGENDDTE INTEGER 4
104 DRVASSIST CHARACTER(1) 1
105 DATACONF CHARACTER(1) 1
106 MVPARKN CHARACTER(1) 1
107 MVCOLOUR CHARACTER(4) 4
108 MVCLMOCEP SMALLINT 2
109 MVCLMAFEP SMALLINT 2
110 MVCLMOCNE SMALLINT 2
111 MVCLMNH SMALLINT 2
112 MVCLMWIND SMALLINT 2
113 DAYTMEPARK CHARACTER(1) 1
114 DAYPARKCITY CHARACTER(40) 40
115 DAYPARKPCDE NUMERIC(6,0) 19
116 PEAKHRDRIVNG CHARACTER(1) 1
117 WFHFREQ CHARACTER(1) 1