INT_PCSRCPN_CVTAIL

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 CVRATING CHARACTER(2) 2
17 CVYRSONRT NUMERIC(2,0) 19
18 CVNCBREVW INTEGER 4
19 CVNCBPC NUMERIC(3,1) 19
20 CVSIDESC CHARACTER(1) 1
21 CVSIDLGDE NUMERIC(7,0) 19
22 CVMAKE CHARACTER(4) 4
23 CVMODEL CHARACTER(6) 6
24 CVMANUFYR SMALLINT 2
25 CVYEARSEQ CHARACTER(1) 1
26 CVREG CHARACTER(12) 12
27 CVVEHCLS CHARACTER(3) 3
28 SEQUENCE INTEGER 4
29 CVACCESRY CHARACTER(1) 1
30 CVMODS CHARACTER(1) 1
31 CVHEALTH CHARACTER(1) 1
32 CVSURVEY CHARACTER(1) 1
33 CVPDAMAGE CHARACTER(1) 1
34 CVAGEDRVR NUMERIC(3,0) 19
35 CVBERTHS CHARACTER(1) 1
36 CVLENGTH NUMERIC(5,0) 19
37 CVBODTYP2 CHARACTER(2) 2
38 CVFUEL CHARACTER(1) 1
39 CVANNEX CHARACTER(1) 1
40 CVSAFETY CHARACTER(1) 1
41 CVHIRED CHARACTER(1) 1
42 CVCHASSIS CHARACTER(20) 20
43 CVGAPCVR CHARACTER(1) 1
44 CVNCBCONF CHARACTER(1) 1
45 CVVEHUSE CHARACTER(1) 1
46 CVPURCHDT INTEGER 4
47 CVPRICE INTEGER 4
48 CVOWNER CHARACTER(1) 1
49 CVFINANCE CHARACTER(1) 1
50 LURN CHARACTER(38) 38
51 LURNSCALE CHARACTER(1) 1
52 NVIC CHARACTER(6) 6
53 VEHCAT CHARACTER(2) 2
54 CVOFFROAD CHARACTER(1) 1
55 CVAXLE CHARACTER(1) 1
56 CVCNSTR CHARACTER(1) 1
57 DATACONF CHARACTER(1) 1