PRT_ISPRMTRN

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 TRANDATE INTEGER 4
6 TRANTIME INTEGER 4
7 SEQUENCE SMALLINT 2
8 TRANCNT SMALLINT 2
9 STATE SMALLINT 2
10 RISKSTATE CHARACTER VARYING(2) 2
11 FIREBRIG CHARACTER VARYING(1) 1
12 TBASICPRM NUMERIC(13,2) 19
13 TCHARGES NUMERIC(13,2) 19
14 TSTMPDUTY NUMERIC(13,2) 19
15 CHRGECODE CHARACTER VARYING(2) 2
16 CHGEXCLUD CHARACTER VARYING(2) 2
17 SDEXCLUD CHARACTER VARYING(2) 2
18 SDPREMT NUMERIC(13,2) 19
19 TGST NUMERIC(13,2) 19
20 GSTEXCLUD CHARACTER VARYING(2) 2
21 GSTPREMT NUMERIC(13,2) 19
22 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
23 RECORD_TYPE CHARACTER VARYING(16) 16
24 COMMIT_TIMESTAMP TIMESTAMP 8
25 EXTRACT_TIMESTAMP TIMESTAMP 8
26 CDC_ID BIGINT 8
27 COMPANY_CDC SMALLINT 2
28 POLICY_CDC BIGINT 8
29 TRANDATE_CDC DATE 4
30 DW_TIMESTAMP TIMESTAMP 8