INT_WCOM_TXN_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 QTEPRDUCT CHARACTER(3) 3
5 POLICY INTEGER 4
6 POLICY_NUMBER CHARACTER VARYING(12) 12
7 POLICY_TERMSTART INTEGER 4
8 ITEMNO SMALLINT 2
9 TRANCNT SMALLINT 2
10 TRANSACTION_DATE_KEY INTEGER 4
11 TRANSACTION_TIME INTEGER 4
12 EFFECTDTE INTEGER 4
13 DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
14 DISTRIBUTION_CHANNEL_LEVEL1 CHARACTER VARYING(13) 13
15 DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
16 DISTRIBUTION_CHANNEL_LEVEL2 CHARACTER VARYING(29) 29
17 CPBUSSRC CHARACTER(10) 10
18 AGENTTYPE CHARACTER(1) 1
19 AGTACCTYP CHARACTER(1) 1
20 AGENT_NAME CHARACTER VARYING(81) 81
21 AGENT_GROUP CHARACTER VARYING(75) 75
22 AGENT_CLUSTER CHARACTER VARYING(67) 67
23 CORP_PARTNER CHARACTER VARYING(81) 81
24 POLICY_INCEPTION_DATE_KEY INTEGER 4
25 POLICY_DUE_DATE_KEY INTEGER 4
26 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
27 POLICY_STAGE_LEVEL1_KEY BIGINT 8
28 POLICY_STAGE_LEVEL2 CHARACTER VARYING(25) 25
29 POLICY_STAGE_LEVEL2_KEY BIGINT 8
30 POLICY_STAGE_LEVEL3 CHARACTER VARYING(10) 10
31 ITEM_TERM_EFFECTIVE_DATE_KEY INTEGER 4
32 ITEM_TERM_EXPIRY_DATE_KEY INTEGER 4
33 ITEM_CLASS CHARACTER(3) 3
34 ITEM_SUBCLASS CHARACTER(3) 3
35 TRAN_TYPE CHARACTER VARYING(2) 2
36 TRANSACTION_REASON_CODE CHARACTER VARYING(4) 4
37 TRANSACTION_REASON_DESCRIPTION CHARACTER(20) 20
38 HAZARD_INDEX CHARACTER VARYING(10) 10
39 HAZARD_INDEX_KEY_TYPE INTEGER 4
40 ITEM_RISK_ADDRESS CHARACTER VARYING(150) 150
41 ITEM_RISK_POSTCODE NUMERIC(6,0) 19
42 EXTENSION_LEVEL1_NAME CHARACTER(1) 1
43 EXTENSION_LEVEL1_KEY INTEGER 4
44 EXTENSION_LEVEL2_NAME CHARACTER VARYING(60) 60
45 CANCEL_REASON_CODE CHARACTER VARYING(2) 2
46 CANCEL_REASON_DESC CHARACTER VARYING(60) 60
47 MIN_PREM_FLAG_TRAN CHARACTER VARYING(1) 1
48 INFORCE_TO_DATE INTEGER 4
49 PREVIOUS_POLICY_NUMBER CHARACTER(14) 14
50 POLICY_STATUS CHARACTER VARYING(1) 1
51 CLIENT INTEGER 4
52 AGENT INTEGER 4
53 AGENCY_NUMBER INTEGER 4
54 POLICY_TERM_OFFERING CHARACTER VARYING(4) 4
55 REFUND_REASON_CODE CHARACTER(2) 2
56 REFUND_REASON_KEY INTEGER 4
57 REFUND_REASON CHARACTER VARYING(65) 65
58 ITEM_TERM_STATUS CHARACTER(1) 1
59 TRANSACTION_COUNT INTEGER 4
60 BASIC_PREMIUM NUMERIC(11,2) 19
61 GROSS_FULL_TERM_PAID_POLICY_COUNT INTEGER 4
62 NET_FULL_TERM_PAID_POLICY_COUNT INTEGER 4
63 TOTAL_PAID_POLICY_COUNT INTEGER 4
64 ISSUED_QUOTE_COUNT INTEGER 4
65 ISSUED_QUOTE_PREMIUM NUMERIC(15,2) 19
66 NET_NB_COUNT INTEGER 4
67 NET_NB_PREMIUM NUMERIC(15,2) 19
68 GROSS_NB_COUNT INTEGER 4
69 GROSS_NB_PREMIUM NUMERIC(15,2) 19
70 TOTAL_PAID_POLICY_PREMIUM NUMERIC(11,2) 19
71 CHARGES NUMERIC(11,2) 19
72 GST NUMERIC(11,2) 19
73 STAMP_DUTY NUMERIC(11,2) 19
74 DISCOUNT_PC NUMERIC(4,2) 19
75 DISCOUNT_RC CHARACTER(2) 2
76 LOADING_PC NUMERIC(5,2) 19
77 LOADING_RC CHARACTER(2) 2
78 POLICY_ITEM_TERM_LATEST BIGINT 8
79 ITEM_COUNT INTEGER 4
80 POLICY_TERM_LATEST BIGINT 8
81 POLICY_COUNT INTEGER 4
82 EFFECTIVE_DAYS NUMERIC(12,2) 19
83 REMAINING_DAYS INTEGER 4
84 PROPORTIONED_VALUE NUMERIC(18,8) 19
85 EARNED_PREMIUM NUMERIC(12,2) 19
86 ESTWAGES NUMERIC(11,0) 19
87 ACTWAGES NUMERIC(11,0) 19
88 ESTNOEMP INTEGER 4
89 ACTNOEMP INTEGER 4
90 COMMISSION NUMERIC(11,2) 19
91 COMMISSION_ADJ NUMERIC(4,2) 19
92 COMM_ADJ_RC CHARACTER VARYING(65) 65
93 IDP CHARACTER VARYING(50) 50
94 POLICY_TERM_IND BIGINT 8
95 PREVIOUS_INSURER CHARACTER(9) 9
96 PREVIOUS_INSURER_KEY BIGINT 8
97 IDCL CHARACTER VARYING(3) 3
98 PI_ACT_CL CHARACTER VARYING(3) 3
99 USERID CHARACTER VARYING(8) 8