INT_DIA_WRITTEN_PREM_TXN_PI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANS_DT CHARACTER(11) 11
2 EFFECTIVE_DT CHARACTER(11) 11
3 DUEDATE_DT CHARACTER(11) 11
4 TRANDATE_INT INTEGER 4
5 EFFECTDTE_INT INTEGER 4
6 DUEDATE_INT INTEGER 4
7 COMPANY SMALLINT 2
8 PRODUCT CHARACTER(3) 3
9 POLICY INTEGER 4
10 POLICYNUMBER CHARACTER VARYING(12) 12
11 CLASS CHARACTER(3) 3
12 SUBCLASS CHARACTER(3) 3
13 ITEMNO SMALLINT 2
14 TRANTYPE CHARACTER(2) 2
15 RISK_STATE_CODE CHARACTER(2) 2
16 RISK_STATE CHARACTER(20) 20
17 ISSUE_STATE SMALLINT 2
18 MAJORGRP CHARACTER(3) 3
19 BRANCH_ID SMALLINT 2
20 BRANCH_NM CHARACTER(10) 10
21 SDEXCLUD CHARACTER(2) 2
22 GSTEXCLUD CHARACTER(2) 2
23 CHGEXCLUD CHARACTER(2) 2
24 FIREBRIG CHARACTER(1) 1
25 FSLGROUP CHARACTER(4) 4
26 DESTINATION CHARACTER(20) 20
27 DEST_CODE CHARACTER(1) 1
28 AGTACCTYP CHARACTER(1) 1
29 BASIC_PREM NUMERIC(11,2) 19
30 FSL NUMERIC(11,2) 19
31 STAMP_DUTY NUMERIC(11,2) 19
32 TGST NUMERIC(11,2) 19
33 ACTMONTH CHARACTER VARYING(6) 6
34 TRANCNT SMALLINT 2
35 TRANTIME INTEGER 4
36 TERMSTART CHARACTER(11) 11
37 TERMSTART_INT INTEGER 4
38 INSTALFRQ CHARACTER(1) 1
39 IS_INSTAL_POLICY CHARACTER(1) 1
40 IS_INSTAL_DIA_APPLICABLE CHARACTER(1) 1
41 POLICY_TERM_ROW_FND CHARACTER VARYING(1) 1
42 CTE_POLICY_LATEST_TERM_ROW_FND CHARACTER VARYING(1) 1
43 SRC CHARACTER VARYING(20) 20