PRT_HST_PREMTRAN

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 ITEMNO SMALLINT 2
5 TRANDATE INTEGER 4
6 TRANTIME INTEGER 4
7 STATE SMALLINT 2
8 BRANCH SMALLINT 2
9 COYISSUED SMALLINT 2
10 TRANCNT SMALLINT 2
11 RISKSTATE CHARACTER(2) 2
12 CLIENT INTEGER 4
13 AGENT INTEGER 4
14 REP SMALLINT 2
15 CLASS CHARACTER(3) 3
16 SUBCLASS CHARACTER(3) 3
17 EFFECTDTE INTEGER 4
18 DUEDATE INTEGER 4
19 ACTMONTH INTEGER 4
20 SUMINS INTEGER 4
21 SUMINSCDE CHARACTER(3) 3
22 FIREBRIG CHARACTER(1) 1
23 TBASICPRM NUMERIC(11,2) 19
24 TCHARGES NUMERIC(11,2) 19
25 TSTMPDUTY NUMERIC(11,2) 19
26 TCOMMISN NUMERIC(11,2) 19
27 ATRNTYPE CHARACTER(2) 2
28 REASONCDE CHARACTER(2) 2
29 BUSNESSRC CHARACTER(4) 4
30 CHRGECODE CHARACTER(2) 2
31 TAILORGRP CHARACTER(2) 2
32 GLUPDNO INTEGER 4
33 CHGEXCLUD CHARACTER(2) 2
34 SDEXCLUD CHARACTER(2) 2
35 SDPREMT NUMERIC(11,2) 19
36 TGST NUMERIC(11,2) 19
37 GSTEXCLUD CHARACTER(2) 2
38 TCOMMGST NUMERIC(11,2) 19
39 GSTCOMMEX CHARACTER(2) 2
40 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 RECORD_TYPE CHARACTER VARYING(16) 16
42 COMMIT_TIMESTAMP TIMESTAMP 8
43 EXTRACT_TIMESTAMP TIMESTAMP 8
44 CDC_ID BIGINT 8
45 POLICY_CDC BIGINT 8
46 DUEDATE_CDC DATE 4
47 EFFECTDTE_CDC DATE 4
48 TRANDATE_CDC DATE 4
49 AGREEMENT_TYPE_CDC CHARACTER(3) 3
50 DW_TIMESTAMP TIMESTAMP 8
51 COMPANY_CDC SMALLINT 2