INT_WCOM_TXN_REFERRALS_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 POLICY INTEGER 4
5 POLICY_NUMBER CHARACTER VARYING(12) 12
6 POLICY_TERMSTART_KEY INTEGER 4
7 REF_ITEMNO SMALLINT 2
8 TXN_ITEMNO SMALLINT 2
9 REF_TRANCNT SMALLINT 2
10 TXN_TRANCNT SMALLINT 2
11 DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
12 DISTRIBUTION_CHANNEL_LEVEL1 CHARACTER VARYING(13) 13
13 DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
14 DISTRIBUTION_CHANNEL_LEVEL2 CHARACTER VARYING(29) 29
15 LINENO SMALLINT 2
16 WARNNO CHARACTER(4) 4
17 VOIDFLAG CHARACTER(1) 1
18 CLASS CHARACTER(3) 3
19 SUBCLASS CHARACTER(3) 3
20 CONTEXT CHARACTER(8) 8
21 REFERTYPE_CODE CHARACTER(2) 2
22 REFERKEY CHARACTER(8) 8
23 VALUEX1 CHARACTER(20) 20
24 VALUEN1 NUMERIC(15,4) 19
25 VALUEX2 CHARACTER(20) 20
26 VALUEN2 NUMERIC(15,4) 19
27 LEVEL CHARACTER(2) 2
28 STATUS_CODE CHARACTER(1) 1
29 APPLID CHARACTER(4) 4
30 PROGID CHARACTER(8) 8
31 SYSTEM_AGENT_NUMBER INTEGER 4
32 AGENCY_NUMBER INTEGER 4
33 REFERBY CHARACTER(8) 8
34 REFERDATE INTEGER 4
35 REFERTIME INTEGER 4
36 EFFECTDTE INTEGER 4
37 ACTIONBY CHARACTER(8) 8
38 ACTDATE INTEGER 4
39 ACTTIME INTEGER 4
40 ERRNO CHARACTER(4) 4
41 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
42 POLICY_STAGE_LEVEL1_KEY BIGINT 8
43 POLICY_STAGE_LEVEL2 CHARACTER VARYING(25) 25
44 POLICY_STAGE_LEVEL2_KEY BIGINT 8
45 POLICY_STAGE_LEVEL3 CHARACTER VARYING(10) 10
46 TRANSACTION_REASON_CODE CHARACTER VARYING(9) 9
47 TRANSACTION_REASON_DESCRIPTION CHARACTER(20) 20
48 CPSTAFF_NUMBER CHARACTER VARYING(10) 10
49 ANZSICCD_1993_KEY BIGINT 8
50 ANZSICCD_2006_KEY BIGINT 8
51 ANZSICIR_2006_KEY BIGINT 8
52 POLICY_TRANSACTION_DATE_KEY INTEGER 4
53 POLICY_EXPIRY_DATE INTEGER 4
54 INFORCE_TO_DATE_KEY INTEGER 4
55 ITEM_RISK_STATE_KEY INTEGER 4
56 PREM_BAND_KEY INTEGER 4
57 PREM_SEGMENT_KEY INTEGER 4
58 HAZARD_INDEX_KEY INTEGER 4
59 PREV_INSURANCE_YEARS_KEY INTEGER 4
60 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
61 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
62 ITEM_DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
63 ITEM_DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
64 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
65 PRIORCLM_KEY INTEGER 4
66 MIN_PREM_FLAG_POL_KEY INTEGER 4
67 MULTIANZSIC_FLAG_KEY INTEGER 4
68 EXTENSION_LEVEL1_KEY INTEGER 4
69 EXTENSION_LEVEL2_KEY BIGINT 8
70 POLICY_TERM_OFFERING_KEY BIGINT 8
71 GROUP_OFFERING_KEY BIGINT 8
72 SCHEME_KEY BIGINT 8
73 INSTALFRQ CHARACTER(2) 2
74 POLICY_DURATION_KEY INTEGER 4
75 MULTIYEAR_KEY INTEGER 4
76 GAZETTEPLUS75_KEY INTEGER 4
77 RENLIKEIND_KEY CHARACTER VARYING(4) 4
78 CAT_C CHARACTER VARYING(2) 2
79 CANCEL_ON_INCEPTION_KEY INTEGER 4
80 ISSUEDSTATE_KEY INTEGER 4
81 PREVIOUS_INSURER_KEY BIGINT 8
82 AGENT INTEGER 4
83 UW_CODE CHARACTER VARYING(8) 8
84 AGENT_NAME CHARACTER VARYING(81) 81
85 PREV_INSURER_GROUP_KEY BIGINT 8
86 POLICY_INFORCE_KEY INTEGER 4