INT_PCSRCPN_PROPTAIL

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 TRANCNT SMALLINT 2
13 EFFECTDTE INTEGER 4
14 ACTIVTO INTEGER 4
15 IMAGEFLAG CHARACTER VARYING(1) 1
16 OCCUPATN CHARACTER VARYING(4) 4
17 LOSSRATIO NUMERIC(11,2) 19
18 VOLEXCESS SMALLINT 2
19 RATESIZE INTEGER 4
20 BUILDSI INTEGER 4
21 CONTSI INTEGER 4
22 STOCKSI INTEGER 4
23 TOBLIQSI INTEGER 4
24 TRANSBHSI INTEGER 4
25 INSAFESI INTEGER 4
26 OTHERSI INTEGER 4
27 CONSTRUCT CHARACTER VARYING(1) 1
28 SECURTY CHARACTER VARYING(1) 1
29 LOCALITY CHARACTER VARYING(2) 2
30 SURVEY CHARACTER VARYING(1) 1
31 SRVYGRD CHARACTER VARYING(3) 3
32 SRVYREF CHARACTER VARYING(12) 12
33 RPLCMNT CHARACTER VARYING(1) 1
34 FLOOD CHARACTER VARYING(2) 2
35 HISTRATE CHARACTER VARYING(4) 4
36 CLAIMCNT SMALLINT 2