PRT_CLMSTAMV

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 CLAIMNO NUMERIC(11,0) 19
3 DRVTRNCNT SMALLINT 2
4 MVAGEEXC NUMERIC(5,0) 19
5 MVGROUP CHARACTER VARYING(1) 1
6 MVTOTLOSS CHARACTER VARYING(1) 1
7 MVNCBEFF CHARACTER VARYING(1) 1
8 MVNOCKFOR CHARACTER VARYING(2) 2
9 MVROADCON CHARACTER VARYING(1) 1
10 MVCONCESS CHARACTER VARYING(1) 1
11 MVVISIBIL CHARACTER VARYING(1) 1
12 NAMESEQ INTEGER 4
13 MVNAMEREF INTEGER 4
14 MVSEX CHARACTER VARYING(1) 1
15 MVBTHDTE INTEGER 4
16 MVPCUSE SMALLINT 2
17 MVOCCUP CHARACTER VARYING(4) 4
18 MVLICNUM CHARACTER VARYING(10) 10
19 MVLICOBT SMALLINT 2
20 MVLICCAN CHARACTER VARYING(1) 1
21 MVDEFECT1 CHARACTER VARYING(2) 2
22 MVDEFECT2 CHARACTER VARYING(2) 2
23 MVDEFECT3 CHARACTER VARYING(2) 2
24 MVRATING CHARACTER VARYING(2) 2
25 MVYRSONRT NUMERIC(2,0) 19
26 MVNCBREVW INTEGER 4
27 MVNCBPROT CHARACTER VARYING(1) 1
28 MVNCBPC NUMERIC(3,1) 19
29 MVSIDESC CHARACTER VARYING(1) 1
30 MVCATGORY CHARACTER VARYING(2) 2
31 MVMAKE CHARACTER VARYING(4) 4
32 MVMODEL CHARACTER VARYING(6) 6
33 MVSTAMAKE CHARACTER VARYING(4) 4
34 MVBODTYPE CHARACTER VARYING(2) 2
35 MVMANUFYR SMALLINT 2
36 MVYEARSEQ CHARACTER VARYING(1) 1
37 MVGEARS NUMERIC(1,0) 19
38 MVENGCAP SMALLINT 2
39 MVFUEL CHARACTER VARYING(1) 1
40 MVTRANS CHARACTER VARYING(1) 1
41 MVENGNO CHARACTER VARYING(15) 15
42 MVREG CHARACTER VARYING(12) 12
43 MVTONNES NUMERIC(2,0) 19
44 MVNOCYL CHARACTER VARYING(3) 3
45 MVTHFTDEV CHARACTER VARYING(1) 1
46 MVRADIO SMALLINT 2
47 MVAIRCOND SMALLINT 2
48 MVACCESS SMALLINT 2
49 MVLPG CHARACTER VARYING(1) 1
50 MVLPGAPRV CHARACTER VARYING(1) 1
51 MVMODCDE1 CHARACTER VARYING(2) 2
52 MVMODCDE2 CHARACTER VARYING(2) 2
53 MVMODCDE3 CHARACTER VARYING(2) 2
54 MVMODCDE4 CHARACTER VARYING(2) 2
55 MVMODCDE5 CHARACTER VARYING(2) 2
56 MVMODCDE6 CHARACTER VARYING(2) 2
57 MVGARGING CHARACTER VARYING(1) 1
58 MVRDWORTH CHARACTER VARYING(1) 1
59 MVFLAMEGD CHARACTER VARYING(1) 1
60 MVVEHUSE CHARACTER VARYING(1) 1
61 MVSCRNEXT CHARACTER VARYING(1) 1
62 MVNAMDDRV CHARACTER VARYING(1) 1
63 MVVEHCLS CHARACTER VARYING(3) 3
64 MVSERIES CHARACTER VARYING(2) 2
65 SEQUENCE INTEGER 4
66 REPAIRED CHARACTER VARYING(1) 1
67 MVWITNESS CHARACTER VARYING(1) 1
68 MVDRVABLE CHARACTER VARYING(1) 1
69 MVVIP CHARACTER VARYING(1) 1
70 MVDRVTEST CHARACTER VARYING(1) 1
71 MVDRVRELN CHARACTER VARYING(1) 1
72 MVCONSENT CHARACTER VARYING(1) 1
73 MVDRVDECL CHARACTER VARYING(1) 1
74 MVIVSPEED SMALLINT 2
75 MVTPSPEED SMALLINT 2
76 MVTRAFLTS CHARACTER VARYING(1) 1
77 MVFAULTAD CHARACTER VARYING(1) 1
78 MVATFAULT CHARACTER VARYING(1) 1
79 MVCHARGED CHARACTER VARYING(1) 1
80 MVTPCLAIM CHARACTER VARYING(1) 1
81 MVAREADAM CHARACTER VARYING(2) 2
82 MVMDLDATE INTEGER 4
83 MOTEXIND CHARACTER VARYING(1) 1
84 DUEBKDTE INTEGER 4
85 USERCSC CHARACTER VARYING(4) 4
86 INSPNO INTEGER 4
87 MVVOLXS INTEGER 4
88 MVLICCLS CHARACTER VARYING(2) 2
89 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
90 RECORD_TYPE CHARACTER VARYING(16) 16
91 COMMIT_TIMESTAMP TIMESTAMP 8
92 EXTRACT_TIMESTAMP TIMESTAMP 8
93 CDC_ID BIGINT 8
94 COMPANY_CDC SMALLINT 2
95 DW_TIMESTAMP TIMESTAMP 8