PRT_RCWTAIL

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 BLDLICNO CHARACTER VARYING(20) 20
10 BLDCOYTYP CHARACTER VARYING(2) 2
11 BLDGRP INTEGER 4
12 BLDCAT CHARACTER VARYING(1) 1
13 TURNLMT INTEGER 4
14 BLDTYP CHARACTER VARYING(1) 1
15 ARCHSRCE CHARACTER VARYING(1) 1
16 DWELLTYPE CHARACTER VARYING(2) 2
17 POLLMT INTEGER 4
18 APPLNO CHARACTER VARYING(12) 12
19 RCWPOLTYP CHARACTER VARYING(1) 1
20 EXTBENIND CHARACTER VARYING(1) 1
21 CAPOLPRD CHARACTER VARYING(3) 3
22 CAPOLNO INTEGER 4
23 CASHARE INTEGER 4
24 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 RECORD_TYPE CHARACTER VARYING(16) 16
26 COMMIT_TIMESTAMP TIMESTAMP 8
27 EXTRACT_TIMESTAMP TIMESTAMP 8
28 CDC_ID BIGINT 8
29 COMPANY_CDC SMALLINT 2
30 POLICY_CDC BIGINT 8
31 ACTIVTO_CDC DATE 4
32 EFFECTDTE_CDC DATE 4
33 DW_TIMESTAMP TIMESTAMP 8