INT_WCOM_COVERNOTE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 EFFECTDTE INTEGER 4
4 POLICY INTEGER 4
5 POLICY_NUMBER CHARACTER VARYING(12) 12
6 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
7 POLICY_STAGE_LEVEL2 CHARACTER VARYING(25) 25
8 POLICY_STAGE_LEVEL3 CHARACTER VARYING(10) 10
9 PRODUCT CHARACTER(3) 3
10 QTEPRDUCT CHARACTER(3) 3
11 TRANSACTION_DATE_KEY INTEGER 4
12 REVERSAL_TIMESTAMP TIMESTAMP 8
13 RISKSTATE_KEY CHARACTER(2) 2
14 CLIENT INTEGER 4
15 ANZSICCD_1993 CHARACTER(8) 8
16 ANZSICCD_2006 CHARACTER(8) 8
17 POLICY_DUE_DATE_KEY INTEGER 4
18 POLICY_STATUS CHARACTER(1) 1
19 HAZARD_INDEX CHARACTER VARYING(10) 10
20 HAZARD_INDEX_KEY_TYPE INTEGER 4
21 TRANSACTION_TIME INTEGER 4
22 ITEMNO SMALLINT 2
23 POLICY_INCEPTION_DATE_KEY INTEGER 4
24 ITEM_TERM_EFFECTIVE_DATE_KEY INTEGER 4
25 ITEM_TERM_EXPIRY_DATE_KEY INTEGER 4
26 PREVIOUS_POLICY_NUMBER CHARACTER(14) 14
27 ITEM_LOCATNREF INTEGER 4
28 ITEM_CLASS CHARACTER(3) 3
29 ITEM_SUM_INSURED INTEGER 4
30 EXTENSION_TYPE CHARACTER(4) 4
31 POLICY_TERMSTART INTEGER 4
32 CANCEL_REASON_CODE CHARACTER VARYING(1) 1
33 MIN_PREM_FLAG_TRAN CHARACTER VARYING(1) 1
34 AGENT INTEGER 4
35 TRANSACTION_REASON_CODE CHARACTER VARYING(4) 4
36 TRAN_TYPE CHARACTER VARYING(2) 2
37 ITEM_SUBCLASS CHARACTER(3) 3
38 PREMREAST CHARACTER(2) 2
39 COMM_ADJ_RC CHARACTER VARYING(65) 65
40 CPBUSSRC CHARACTER(10) 10
41 BASIC_PREMIUM NUMERIC(11,2) 19
42 TRANCNT SMALLINT 2
43 ESTWAGES NUMERIC(11,0) 19
44 ACTWAGES NUMERIC(11,0) 19
45 ESTNOEMP INTEGER 4
46 ACTNOEMP INTEGER 4
47 CHARGES NUMERIC(11,2) 19
48 STAMP_DUTY NUMERIC(11,2) 19
49 GST NUMERIC(11,2) 19
50 REBATEPC NUMERIC(4,2) 19
51 DISCREAS CHARACTER(2) 2
52 LOADINGPC NUMERIC(5,2) 19
53 LOADREAS CHARACTER(2) 2
54 EFFECTIVE_DAYS NUMERIC(12,2) 19
55 REMAINING_DAYS INTEGER 4
56 PROPORTIONED_VALUE NUMERIC(12,8) 19
57 EARNED_PREMIUM NUMERIC(12,2) 19
58 COMMISSION NUMERIC(11,2) 19
59 COMMISSION_ADJ NUMERIC(4,2) 19
60 PREVIOUS_INSURER CHARACTER(9) 9
61 USERID CHARACTER VARYING(1) 1
62 ROW_RANK BIGINT 8