INT_PCSRCPN_ITMPREM_SNAP

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 INTEGER 4
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 TRANCNT SMALLINT 2
13 EFFECTDTE INTEGER 4
14 ACTIVTO INTEGER 4
15 IMAGEFLAG CHARACTER(1) 1
16 PREMTYPE CHARACTER(1) 1
17 PREMCAT CHARACTER(16) 16
18 PREAMT NUMERIC(15,6) 19
19 RATEPC NUMERIC(9,6) 19