PRT_MYTAIL

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER VARYING(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 VARYING(1) 1
9 MYTRANSIT INTEGER 4
10 MYBUSHR INTEGER 4
11 MYNONBUS INTEGER 4
12 MYSAFE INTEGER 4
13 MYRESDENT INTEGER 4
14 MYDAMSAFE INTEGER 4
15 MYPREMISE INTEGER 4
16 MYSAFEMKE CHARACTER VARYING(30) 30
17 MYSAFETY CHARACTER VARYING(2) 2
18 MYSAFEFIX CHARACTER VARYING(1) 1
19 MYSAFEYR SMALLINT 2
20 MYBURALM CHARACTER VARYING(2) 2
21 MYTRANSI INTEGER 4
22 MYBUSSI INTEGER 4
23 MYNOBUSSI INTEGER 4
24 MYSAFESI INTEGER 4
25 MYRESDTSI INTEGER 4
26 MYPREMSSI INTEGER 4
27 MYROCCUP CHARACTER VARYING(4) 4
28 MYMLTDISC CHARACTER VARYING(2) 2
29 MYRESIST CHARACTER VARYING(1) 1
30 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
31 RECORD_TYPE CHARACTER VARYING(16) 16
32 COMMIT_TIMESTAMP TIMESTAMP 8
33 EXTRACT_TIMESTAMP TIMESTAMP 8
34 CDC_ID BIGINT 8
35 COMPANY_CDC SMALLINT 2
36 POLICY_CDC BIGINT 8
37 ACTIVTO_CDC DATE 4
38 EFFECTDTE_CDC DATE 4
39 DW_TIMESTAMP TIMESTAMP 8