INT_PCSRCPN_MVTAIL

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 PRODUCT CHARACTER(3) 3
10 POLICY INTEGER 4
11 ITEMNO SMALLINT 2
12 EFFECTDTE INTEGER 4
13 ACTIVTO INTEGER 4
14 TRANCNT SMALLINT 2
15 IMAGEFLAG CHARACTER(1) 1
16 MVPREVINS CHARACTER(4) 4
17 MVRATING CHARACTER(2) 2
18 MVYRSONRT NUMERIC(2,0) 19
19 MVNCBCONF CHARACTER(1) 1
20 MVNCBREVW INTEGER 4
21 MVNCBPROT CHARACTER(1) 1
22 MVNCBPC NUMERIC(3,1) 19
23 MVSIDESC CHARACTER(1) 1
24 MVSIDLGDE NUMERIC(7,0) 19
25 MVCATGORY CHARACTER(2) 2
26 MVMAKE CHARACTER(4) 4
27 MVMODEL CHARACTER(6) 6
28 MVSTAMAKE CHARACTER(4) 4
29 MVBODTYPE CHARACTER(2) 2
30 MVMANUFYR SMALLINT 2
31 MVYEARSEQ CHARACTER(1) 1
32 MVGEARS NUMERIC(1,0) 19
33 MVENGCAP SMALLINT 2
34 MVFUEL CHARACTER(1) 1
35 MVTRANS CHARACTER(1) 1
36 MVENGNO CHARACTER(20) 20
37 MVREG CHARACTER(12) 12
38 MVTONNES NUMERIC(2,0) 19
39 MVNOCYL CHARACTER(3) 3
40 MVTHFTDEV CHARACTER(1) 1
41 MVRADIO SMALLINT 2
42 MVAIRCOND SMALLINT 2
43 MVACCESS SMALLINT 2
44 MVLPG CHARACTER(1) 1
45 MVLPGAPRV CHARACTER(1) 1
46 MVMODCDE1 CHARACTER(2) 2
47 MVMODCDE2 CHARACTER(2) 2
48 MVMODCDE3 CHARACTER(2) 2
49 MVMODCDE4 CHARACTER(2) 2
50 MVMODCDE5 CHARACTER(2) 2
51 MVMODCDE6 CHARACTER(2) 2
52 MVGARGING CHARACTER(1) 1
53 MVRDWORTH CHARACTER(1) 1
54 MVFLAMEGD CHARACTER(1) 1
55 MVVEHUSE CHARACTER(1) 1
56 MVSCRNEXT CHARACTER(1) 1
57 MVNAMDDRV CHARACTER(1) 1
58 MVVEHCLS CHARACTER(3) 3
59 MVDRVDETS CHARACTER(1) 1
60 MVSERIES CHARACTER(2) 2
61 SEQUENCE INTEGER 4
62 MVRADIUS CHARACTER(3) 3
63 MVRESTDRV CHARACTER(1) 1
64 MVGAPCVR CHARACTER(1) 1
65 MVFINANCE CHARACTER(1) 1
66 MVNOVDISC CHARACTER(1) 1
67 MVTRAILER CHARACTER(1) 1
68 MVACCESRY CHARACTER(1) 1
69 MVMODS CHARACTER(1) 1
70 MVHEALTH CHARACTER(1) 1
71 MVSURVEY CHARACTER(1) 1
72 MVPDAMAGE CHARACTER(1) 1
73 MVYEARLYK CHARACTER(2) 2
74 MVAGEDRVR NUMERIC(3,0) 19
75 MVRACGEXT CHARACTER(1) 1
76 MVTHFTEXC INTEGER 4
77 MVCHCEREP CHARACTER(1) 1
78 MVSLVRGHT CHARACTER(1) 1
79 MVVEHSI INTEGER 4
80 MVEXTRASI INTEGER 4
81 MVALARM CHARACTER(4) 4
82 MVVOLXS INTEGER 4
83 MVPURCHDT INTEGER 4
84 MVPRICE INTEGER 4
85 MVOWNER CHARACTER(1) 1
86 MVLENGTH NUMERIC(5,0) 19
87 MVGENDER CHARACTER(1) 1
88 MVHIRECAR CHARACTER(1) 1
89 MVFAMILY CHARACTER(2) 2
90 LURN CHARACTER(38) 38
91 LURNSCALE CHARACTER(1) 1
92 NVIC CHARACTER(6) 6
93 VEHCAT CHARACTER(2) 2
94 SPECDISC CHARACTER(1) 1
95 LIFENEWOLD CHARACTER(1) 1
96 OWNERSHIP SMALLINT 2
97 PURCHBAND CHARACTER(1) 1
98 OTHRDISC CHARACTER(1) 1
99 REGENDDTE INTEGER 4
100 DRVASSIST CHARACTER(1) 1
101 DATACONF CHARACTER(1) 1
102 MVPARKN CHARACTER(1) 1
103 MVCOLOUR CHARACTER(4) 4