CMT_STG_PI_POLICY_TRANSACTION_RESILIUM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
2 POLICY_NO BIGINT 8
3 ITEM_NO SMALLINT 2
4 PRODUCT_TYPE_CODE CHARACTER VARYING(3) 3
5 PRODUCT_CLASS_CODE CHARACTER VARYING(2) 2
6 PRODUCT_SUBCLASS CHARACTER VARYING(2) 2
7 PRODUCT_EXTRA_KEY1 CHARACTER VARYING(1) 1
8 PRODUCT_EXTRA_KEY2 CHARACTER VARYING(10) 10
9 RISK_STATE CHARACTER(2) 2
10 RISK_POSTCODE CHARACTER VARYING(4) 4
11 TRANSACTION_DATE DATE 4
12 TRANTIME_REF INTEGER 4
13 TRANSACTION_TYPE CHARACTER VARYING(2) 2
14 SCHEDULE_START DATE 4
15 SCHEDULE_END DATE 4
16 TERM_START DATE 4
17 INCEPTION_DATE DATE 4
18 DUE_DATE DATE 4
19 TRAN_BASIC_PREM NUMERIC(38,2) 19
20 TRAN_BASIC_CHARGES NUMERIC(11,2) 19
21 TRAN_BASIC_STMPDTY NUMERIC(11,2) 19
22 TRAN_BASIC_COMSN NUMERIC(11,2) 19
23 TRAN_BASIC_GST NUMERIC(11,2) 19
24 TRAN_BASIC_CHARGE2 NUMERIC(11,2) 19
25 TRAN_BASIC_CHARGE3 NUMERIC(11,2) 19
26 TRAN_BASIC_CHARGE4 NUMERIC(11,2) 19
27 TRAN_BASIC_CHARGE5 NUMERIC(11,2) 19
28 TRAN_BASIC_CHARGE6 NUMERIC(11,2) 19
29 NB_INDICATOR CHARACTER VARYING(2) 2
30 CHANNEL_KEY1 CHARACTER(10) 10
31 CHANNEL_KEY2 CHARACTER(10) 10
32 TEAM_KEY1 CHARACTER VARYING(10) 10
33 TEAM_KEY2 CHARACTER VARYING(10) 10
34 RISK_TYPE CHARACTER VARYING(20) 20
35 RISK_COUNT NUMERIC(16,2) 19
36 UNIT_COUNT INTEGER 4
37 DM_TIMESTAMP TIMESTAMP 8
38 PREV_POLICY_TYPE CHARACTER(3) 3
39 PREV_POLICY_NO INTEGER 4
40 INSTALMENT_FREQ CHARACTER(1) 1
41 SOURCE_SYSTEM_POLICY_ID CHARACTER(10) 10
42 CANCEL_REASON_ID CHARACTER(3) 3
43 POLICY_STAGE_KEY3 CHARACTER VARYING(4) 4
44 POLICY_STAGE_KEY4 CHARACTER VARYING(6) 6
45 POLICY_STAGE_KEY5 CHARACTER VARYING(4) 4
46 REV_TRANSACTION_DATE DATE 4
47 REV_TRANTIME_REF INTEGER 4
48 REV_TRAN_TYPE CHARACTER(2) 2
49 FULL_RISK_CANCELLATION_FLAG CHARACTER(1) 1
50 REINSTATED_FLAG CHARACTER(1) 1
51 REVERSED_FLAG CHARACTER(1) 1
52 NEGATIVE_GWP_FLAG CHARACTER(1) 1
53 AT_RENEWAL_CANCELLATION_FLAG CHARACTER(1) 1
54 SAME_DAY_CANCELLATION_FLAG CHARACTER(1) 1
55 RATING_ADDRESS INTEGER 4
56 MODULE_NO SMALLINT 2