INT_PCSRCPN_MVDRIVER

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 MVDRIVNO NUMERIC(2,0) 19
17 NAMESEQ INTEGER 4
18 MVSEX CHARACTER(1) 1
19 MVBTHDTE INTEGER 4
20 MVPCUSE SMALLINT 2
21 MVOCCUP CHARACTER(4) 4
22 MVLICNUM CHARACTER(10) 10
23 MVLICOBT SMALLINT 2
24 MVLICCAN CHARACTER(1) 1
25 CLIENT INTEGER 4
26 MVDRVXS INTEGER 4
27 MVDRVEXCL CHARACTER(1) 1
28 MVDRVPTS SMALLINT 2
29 MVDRVXSOR CHARACTER(1) 1
30 MVDRVTYP CHARACTER(1) 1
31 MVLICTYP CHARACTER(1) 1
32 TRAINING CHARACTER(1) 1