INT_PCSRCPN_MYTAIL

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 VARYING(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 VARYING(1) 1
16 MYTRANSIT INTEGER 4
17 MYBUSHR INTEGER 4
18 MYNONBUS INTEGER 4
19 MYSAFE INTEGER 4
20 MYRESDENT INTEGER 4
21 MYDAMSAFE INTEGER 4
22 MYPREMISE INTEGER 4
23 MYSAFEMKE CHARACTER VARYING(30) 30
24 MYSAFETY CHARACTER VARYING(2) 2
25 MYSAFEFIX CHARACTER VARYING(1) 1
26 MYSAFEYR SMALLINT 2
27 MYBURALM CHARACTER VARYING(2) 2
28 MYTRANSI INTEGER 4
29 MYBUSSI INTEGER 4
30 MYNOBUSSI INTEGER 4
31 MYSAFESI INTEGER 4
32 MYRESDTSI INTEGER 4
33 MYPREMSSI INTEGER 4
34 MYROCCUP CHARACTER VARYING(4) 4
35 MYMLTDISC CHARACTER VARYING(2) 2
36 MYRESIST CHARACTER VARYING(1) 1