PRT_CVTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 EFFECTDTE INTEGER 4
6 ACTIVTO INTEGER 4
7 TRANCNT SMALLINT 2
8 IMAGEFLAG CHARACTER(1) 1
9 CVRATING CHARACTER(2) 2
10 CVYRSONRT NUMERIC(2,0) 19
11 CVNCBREVW INTEGER 4
12 CVNCBPC NUMERIC(3,1) 19
13 CVSIDESC CHARACTER(1) 1
14 CVSIDLGDE NUMERIC(7,0) 19
15 CVMAKE CHARACTER(4) 4
16 CVMODEL CHARACTER(6) 6
17 CVMANUFYR SMALLINT 2
18 CVYEARSEQ CHARACTER(1) 1
19 CVREG CHARACTER(12) 12
20 CVVEHCLS CHARACTER(3) 3
21 SEQUENCE INTEGER 4
22 CVACCESRY CHARACTER(1) 1
23 CVMODS CHARACTER(1) 1
24 CVHEALTH CHARACTER(1) 1
25 CVSURVEY CHARACTER(1) 1
26 CVPDAMAGE CHARACTER(1) 1
27 CVAGEDRVR NUMERIC(3,0) 19
28 CVBERTHS CHARACTER(1) 1
29 CVLENGTH NUMERIC(5,0) 19
30 CVBODTYP2 CHARACTER(2) 2
31 CVFUEL CHARACTER(1) 1
32 CVANNEX CHARACTER(1) 1
33 CVSAFETY CHARACTER(1) 1
34 CVHIRED CHARACTER(1) 1
35 CVCHASSIS CHARACTER(20) 20
36 CVGAPCVR CHARACTER(1) 1
37 CVNCBCONF CHARACTER(1) 1
38 CVVEHUSE CHARACTER(1) 1
39 CVPURCHDT INTEGER 4
40 CVPRICE INTEGER 4
41 CVOWNER CHARACTER(1) 1
42 CVFINANCE CHARACTER(1) 1
43 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 RECORD_TYPE CHARACTER VARYING(16) 16
45 COMMIT_TIMESTAMP TIMESTAMP 8
46 EXTRACT_TIMESTAMP TIMESTAMP 8
47 CDC_ID BIGINT 8
48 LURN CHARACTER(38) 38
49 LURNSCALE CHARACTER(1) 1
50 NVIC CHARACTER(6) 6
51 VEHCAT CHARACTER(2) 2
52 CVOFFROAD CHARACTER(1) 1
53 CVAXLE CHARACTER(1) 1
54 CVCNSTR CHARACTER(1) 1
55 DW_TIMESTAMP TIMESTAMP 8
56 COMPANY_CDC SMALLINT 2
57 AGREEMENT_TYPE_CDC CHARACTER(3) 3
58 POLICY_CDC INTEGER 4
59 ACTIVTO_CDC DATE 4
60 EFFECTDTE_CDC DATE 4
61 DATACONF CHARACTER(1) 1
62 CVSTORAGE CHARACTER(1) 1