PRT_MVDRIVER

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 POLICY INTEGER 4
3 ITEMNO SMALLINT 2
4 EFFECTDTE INTEGER 4
5 ACTIVTO INTEGER 4
6 TRANCNT SMALLINT 2
7 IMAGEFLAG CHARACTER(1) 1
8 MVDRIVNO NUMERIC(2,0) 19
9 NAMESEQ INTEGER 4
10 MVSEX CHARACTER(1) 1
11 MVBTHDTE INTEGER 4
12 MVPCUSE SMALLINT 2
13 MVLICOBT SMALLINT 2
14 MVLICCAN CHARACTER(1) 1
15 CLIENT INTEGER 4
16 MVDRVXS INTEGER 4
17 MVDRVEXCL CHARACTER(1) 1
18 MVDRVPTS SMALLINT 2
19 MVDRVXSOR CHARACTER(1) 1
20 MVDRVTYP CHARACTER(1) 1
21 MVLICTYP CHARACTER(1) 1
22 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
23 RECORD_TYPE CHARACTER VARYING(16) 16
24 COMMIT_TIMESTAMP TIMESTAMP 8
25 EXTRACT_TIMESTAMP TIMESTAMP 8
26 CDC_ID BIGINT 8
27 DW_TIMESTAMP TIMESTAMP 8
28 COMPANY_CDC SMALLINT 2
29 POLICY_CDC INTEGER 4
30 ACTIVTO_CDC DATE 4
31 EFFECTDTE_CDC DATE 4
32 PRODUCT CHARACTER(3) 3
33 MVOCCUP CHARACTER(4) 4
34 MVLICNUM CHARACTER(10) 10
35 AGREEMENT_TYPE_CDC CHARACTER(3) 3
36 TRAINING CHARACTER(1) 1