INT_PCSRCPN_MRTAIL

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 MRREGSIND CHARACTER(1) 1
17 MRPOINTS SMALLINT 2
18 MRSIDESC CHARACTER(1) 1
19 MRSIDLGDE NUMERIC(7,0) 19
20 SEQUENCE INTEGER 4
21 MRMODCDE1 CHARACTER(2) 2
22 MRMODCDE2 CHARACTER(2) 2
23 MRMODCDE3 CHARACTER(2) 2
24 MRMODCDE4 CHARACTER(2) 2
25 MRMODCDE5 CHARACTER(2) 2
26 MRMODCDE6 CHARACTER(2) 2
27 MRMANUFYR SMALLINT 2
28 MRMAKE CHARACTER(4) 4
29 MRMODEL CHARACTER(40) 40
30 MRENGSIZE SMALLINT 2
31 MRLENGTH NUMERIC(3,1) 19
32 MRBERTH CHARACTER(1) 1
33 MRAXLES CHARACTER(1) 1
34 MRWEIGHT CHARACTER(1) 1
35 MRFRQUSE CHARACTER(1) 1
36 MRTRACTION CHARACTER(1) 1
37 MRTRAILER CHARACTER(1) 1
38 MRENGIMOB CHARACTER(1) 1
39 MRSAFTYSW CHARACTER(1) 1
40 MRALARM CHARACTER(1) 1
41 MRVEHUSE CHARACTER(1) 1
42 MRFIREEXT CHARACTER(1) 1
43 MRTRCKDEV CHARACTER(1) 1
44 MRLAMGL CHARACTER(1) 1
45 MRSMOKEDT CHARACTER(1) 1
46 MRNOVDISC CHARACTER(1) 1
47 MRRATING CHARACTER(2) 2
48 MRYRSONRT NUMERIC(2,0) 19
49 MRAGEDRVR NUMERIC(3,0) 19
50 MRSECALRM CHARACTER(1) 1
51 MRFINANCE CHARACTER(1) 1
52 MRDOORLCK CHARACTER(1) 1
53 MRKEYWIND CHARACTER(1) 1
54 MRDOORSEC CHARACTER(1) 1
55 MRPDAMAGE CHARACTER(1) 1
56 MRREG CHARACTER(12) 12
57 MRGAPCVR CHARACTER(1) 1
58 MRACCESRY CHARACTER(1) 1
59 MRVINNO CHARACTER(25) 25
60 MRMODS CHARACTER(1) 1
61 MRDRVDETS CHARACTER(1) 1
62 LURN CHARACTER(38) 38
63 LURNSCALE CHARACTER(1) 1
64 DATACONF CHARACTER(1) 1