INT_DIA_INSTAL_PREM_TXN

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 PRODUCT CHARACTER(3) 3
3 POLICY INTEGER 4
4 POLICYNUMBER CHARACTER VARYING(12) 12
5 TERMSTART INTEGER 4
6 ITEMNO SMALLINT 2
7 CLASS CHARACTER(3) 3
8 SUBCLASS CHARACTER(3) 3
9 RISK_STATE_CODE CHARACTER(2) 2
10 RISK_STATE CHARACTER(20) 20
11 INSTSEQ SMALLINT 2
12 ACTMONTH CHARACTER VARYING(6) 6
13 ACCTMTH_EOM_DATE_INT INTEGER 4
14 ACCTMTH_EOM_DATE CHARACTER(11) 11
15 PAYSEQ SMALLINT 2
16 INSTTYPE CHARACTER(1) 1
17 STATE SMALLINT 2
18 BRANCH SMALLINT 2
19 BRANCH_NM CHARACTER(10) 10
20 TRANCNT SMALLINT 2
21 INSTAMT NUMERIC(11,2) 19
22 BASIC_PREM NUMERIC(11,2) 19
23 FSL NUMERIC(11,2) 19
24 TGST NUMERIC(11,2) 19
25 STAMP_DUTY NUMERIC(11,2) 19
26 SDEXCLUD CHARACTER(2) 2
27 GSTEXCLUD CHARACTER(2) 2
28 CHGEXCLUD CHARACTER(2) 2
29 DESTINATION CHARACTER(20) 20
30 DEST_CODE CHARACTER(1) 1
31 INSTALFRQ CHARACTER(1) 1
32 POLICY_TERM_ROW_FND CHARACTER VARYING(1) 1
33 CTE_POLICY_LATEST_ROW_FND CHARACTER VARYING(1) 1
34 ITEM_TERM_ROW_FND CHARACTER VARYING(1) 1
35 CTE_ITEM_LATEST_ROW_FND CHARACTER VARYING(1) 1