PRT_MVEXCESS

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 CLASS CHARACTER VARYING(3) 3
5 SUBCLASS CHARACTER VARYING(3) 3
6 MVVEHCLS CHARACTER VARYING(3) 3
7 MVCATGORY CHARACTER VARYING(2) 2
8 MVRATING CHARACTER VARYING(2) 2
9 MVNCBPC NUMERIC(3,1) 19
10 EFFECTDTE INTEGER 4
11 ACTIVTO INTEGER 4
12 EXCESS INTEGER 4
13 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 RECORD_TYPE CHARACTER VARYING(16) 16
15 COMMIT_TIMESTAMP TIMESTAMP 8
16 EXTRACT_TIMESTAMP TIMESTAMP 8
17 CDC_ID BIGINT 8
18 COMPANY_CDC SMALLINT 2
19 ACTIVTO_CDC DATE 4
20 EFFECTDTE_CDC DATE 4
21 DW_TIMESTAMP TIMESTAMP 8