INT_PCSRCPN_MCTAIL

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