INT_PCSRCPN_PRT_CLMSTAMV

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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