FCT_WCOM_TXN_REFERRALS_DT_INSIGHT_Q1

Database

INSNZP01

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 WARNING_DESCRIPTION CHARACTER(60) 60
18 VOIDFLAG CHARACTER(1) 1
19 CLASS CHARACTER(3) 3
20 SUBCLASS CHARACTER(3) 3
21 ITEM_SUBCLASS_KEY BIGINT 8
22 CONTEXT CHARACTER(8) 8
23 REFERTYPE_CODE CHARACTER(2) 2
24 REFERTYPE_DESCRIPTION CHARACTER(30) 30
25 REFERKEY CHARACTER(8) 8
26 VALUEX1 CHARACTER(20) 20
27 VALUEN1 NUMERIC(15,4) 19
28 VALUEX2 CHARACTER(20) 20
29 VALUEN2 NUMERIC(15,4) 19
30 LEVEL CHARACTER(2) 2
31 STATUS_CODE CHARACTER(1) 1
32 STATUS_DESCRIPTION CHARACTER(30) 30
33 APPLID CHARACTER(4) 4
34 PROGID CHARACTER(8) 8
35 SYSTEM_AGENT_NUMBER INTEGER 4
36 AGENCY_NUMBER INTEGER 4
37 REFERBY CHARACTER(8) 8
38 REFERDATE INTEGER 4
39 REFERTIME INTEGER 4
40 EFFECTDTE INTEGER 4
41 ACTIONBY CHARACTER(8) 8
42 ACTDATE INTEGER 4
43 ACTTIME INTEGER 4
44 ERRNO CHARACTER(4) 4
45 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
46 POLICY_STAGE_LEVEL1_KEY BIGINT 8
47 POLICY_STAGE_LEVEL2 CHARACTER VARYING(25) 25
48 POLICY_STAGE_LEVEL2_KEY BIGINT 8
49 POLICY_STAGE_LEVEL3 CHARACTER VARYING(10) 10
50 TRANSACTION_REASON_CODE CHARACTER VARYING(9) 9
51 TRANSACTION_REASON_DESCRIPTION CHARACTER(20) 20
52 CPSTAFF_NUMBER CHARACTER VARYING(10) 10
53 ANZSICCD_1993_KEY BIGINT 8
54 ANZSIC_1993_CODE NATIONAL CHARACTER VARYING(5) 5
55 ANZSIC_1993_DESC NATIONAL CHARACTER VARYING(75) 75
56 ANZSICCD_2006_KEY BIGINT 8
57 ANZSIC_2006_CODE BIGINT 8
58 ANZSIC_2006_DESC NATIONAL CHARACTER VARYING(250) 250
59 ANZSICIR_2006_KEY BIGINT 8
60 UW_CODE CHARACTER VARYING(8) 8
61 AGENT INTEGER 4
62 AGENT_NAME CHARACTER VARYING(81) 81
63 UNDERWRITER_KEY BIGINT 8
64 POLICY_TRANSACTION_DATE_KEY INTEGER 4
65 POLICY_EXPIRY_DATE INTEGER 4
66 INFORCE_TO_DATE_KEY INTEGER 4
67 ITEM_RISK_STATE_KEY INTEGER 4
68 PREM_BAND_KEY INTEGER 4
69 PREM_SEGMENT_KEY INTEGER 4
70 HAZARD_INDEX_KEY INTEGER 4
71 PREV_INSURANCE_YEARS_KEY INTEGER 4
72 POLICY_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
73 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
74 ITEM_DISTRIBUTION_CHANNEL_LEVEL1_KEY BIGINT 8
75 ITEM_DISTRIBUTION_CHANNEL_LEVEL2_KEY BIGINT 8
76 BUSINESS_SOURCE_OF_SALES_KEY CHARACTER VARYING(20) 20
77 PRIORCLM_KEY INTEGER 4
78 MIN_PREM_FLAG_POL_KEY INTEGER 4
79 MULTIANZSIC_FLAG_KEY INTEGER 4
80 EXTENSION_LEVEL1_KEY INTEGER 4
81 EXTENSION_LEVEL2_KEY BIGINT 8
82 POLICY_TERM_OFFERING_KEY BIGINT 8
83 GROUP_OFFERING_KEY BIGINT 8
84 SCHEME_KEY BIGINT 8
85 INSTALFRQ CHARACTER(2) 2
86 POLICY_DURATION_KEY INTEGER 4
87 MULTIYEAR_KEY INTEGER 4
88 GAZETTEPLUS75_KEY INTEGER 4
89 RENLIKEIND_KEY CHARACTER VARYING(4) 4
90 CAT_C CHARACTER VARYING(2) 2
91 CANCEL_ON_INCEPTION_KEY INTEGER 4
92 ISSUEDSTATE_KEY INTEGER 4
93 PREVIOUS_INSURER_KEY BIGINT 8
94 PREV_INSURER_GROUP_KEY BIGINT 8
95 POLICY_INFORCE_KEY INTEGER 4