INT_PCSRCPN_RCWTAIL

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 BLDLICNO CHARACTER VARYING(20) 20
17 BLDCOYTYP CHARACTER VARYING(2) 2
18 BLDGRP INTEGER 4
19 BLDCAT CHARACTER VARYING(1) 1
20 TURNLMT INTEGER 4
21 BLDTYP CHARACTER VARYING(1) 1
22 ARCHSRCE CHARACTER VARYING(1) 1
23 DWELLTYPE CHARACTER VARYING(2) 2
24 POLLMT INTEGER 4
25 APPLNO CHARACTER VARYING(12) 12
26 RCWPOLTYP CHARACTER VARYING(1) 1
27 EXTBENIND CHARACTER VARYING(1) 1
28 CAPOLPRD CHARACTER VARYING(3) 3
29 CAPOLNO INTEGER 4
30 CASHARE INTEGER 4