PRT_MCTAIL

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 MCPREVINS CHARACTER(4) 4
10 MCRATING CHARACTER(2) 2
11 MCYRSONRT NUMERIC(2,0) 19
12 MCSIDESC CHARACTER(1) 1
13 MCSIDLGDE NUMERIC(7,0) 19
14 MCCATGORY CHARACTER(2) 2
15 MCMAKE CHARACTER(4) 4
16 MCMODEL CHARACTER(7) 7
17 MCTYPE CHARACTER(2) 2
18 MCMANUFYR SMALLINT 2
19 MCYEARSEQ CHARACTER(1) 1
20 MCENGCAP SMALLINT 2
21 MCREG CHARACTER(12) 12
22 MCREGSTRD CHARACTER(1) 1
23 SEQUENCE INTEGER 4
24 MCMODCDE1 CHARACTER(2) 2
25 MCMODCDE2 CHARACTER(2) 2
26 MCMODCDE3 CHARACTER(2) 2
27 MCMODCDE4 CHARACTER(2) 2
28 MCMODCDE5 CHARACTER(2) 2
29 MCMODCDE6 CHARACTER(2) 2
30 MCGARGING CHARACTER(1) 1
31 MCFRQUSE CHARACTER(2) 2
32 MCVEHUSE CHARACTER(1) 1
33 MCDRVDETS CHARACTER(1) 1
34 MCFINANCE CHARACTER(1) 1
35 MCMODS CHARACTER(1) 1
36 MCPDAMAGE CHARACTER(1) 1
37 MCAGEDRVR NUMERIC(3,0) 19
38 MCVEHSI NUMERIC(9,0) 19
39 MCVINNO CHARACTER(25) 25
40 MCGAPCVR CHARACTER(1) 1
41 MCGENDER CHARACTER(1) 1
42 MCTRANSIT CHARACTER(1) 1
43 MCTRAINNG CHARACTER(2) 2
44 MCYRSRIDE NUMERIC(2,0) 19
45 MCLICTYP CHARACTER(2) 2
46 MCYEARLYK CHARACTER(2) 2
47 MCTHFTDEV CHARACTER(1) 1
48 MCPRCHWEB CHARACTER(1) 1
49 MCCERTWEB CHARACTER(1) 1
50 MCAUTRNWL CHARACTER(1) 1
51 MCDISC1 CHARACTER(1) 1
52 MCDISC2 CHARACTER(1) 1
53 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
54 RECORD_TYPE CHARACTER VARYING(16) 16
55 COMMIT_TIMESTAMP TIMESTAMP 8
56 EXTRACT_TIMESTAMP TIMESTAMP 8
57 CDC_ID BIGINT 8
58 LURN CHARACTER(38) 38
59 LURNSCALE CHARACTER(1) 1
60 NVIC CHARACTER(6) 6
61 VEHCAT CHARACTER(2) 2
62 DW_TIMESTAMP TIMESTAMP 8
63 COMPANY_CDC SMALLINT 2
64 POLICY_CDC INTEGER 4
65 ACTIVTO_CDC DATE 4
66 EFFECTDTE_CDC DATE 4
67 AGREEMENT_TYPE_CDC CHARACTER(3) 3
68 DATACONF CHARACTER(1) 1