PRT_NMCTAIL

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 TRANCNT SMALLINT 2
6 EFFECTDTE INTEGER 4
7 ACTIVTO INTEGER 4
8 IMAGEFLAG CHARACTER VARYING(1) 1
9 CUSTCODE CHARACTER VARYING(3) 3
10 CMMDTYCDE CHARACTER VARYING(3) 3
11 STRGPRD SMALLINT 2
12 TURNOVER NUMERIC(11,0) 19
13 LEGALEXP NUMERIC(11,0) 19
14 COUNTLIM SMALLINT 2
15 WEEKLYLIM NUMERIC(11,0) 19
16 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 RECORD_TYPE CHARACTER VARYING(16) 16
18 COMMIT_TIMESTAMP TIMESTAMP 8
19 EXTRACT_TIMESTAMP TIMESTAMP 8
20 CDC_ID BIGINT 8
21 COMPANY_CDC SMALLINT 2
22 POLICY_CDC BIGINT 8
23 ACTIVTO_CDC DATE 4
24 EFFECTDTE_CDC DATE 4
25 DW_TIMESTAMP TIMESTAMP 8