PRT_MRTAIL

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