PRT_POLMESS

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 ACTIVFROM INTEGER 4
5 ACTIVTO INTEGER 4
6 TRANCNT SMALLINT 2
7 IMAGEFLAG CHARACTER VARYING(1) 1
8 LINENO CHARACTER VARYING(6) 6
9 MSGDATE INTEGER 4
10 POLMSG CHARACTER VARYING(70) 70
11 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 RECORD_TYPE CHARACTER VARYING(16) 16
13 COMMIT_TIMESTAMP TIMESTAMP 8
14 EXTRACT_TIMESTAMP TIMESTAMP 8
15 CDC_ID BIGINT 8
16 COMPANY_CDC SMALLINT 2
17 POLICY_CDC BIGINT 8
18 ACTIVTO_CDC DATE 4
19 DW_TIMESTAMP TIMESTAMP 8