INT_WCOM_ITEM_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 COMPANY SMALLINT 2
3 POLICY INTEGER 4
4 POLICY_NUMBER CHARACTER VARYING(12) 12
5 PRODUCT CHARACTER(3) 3
6 QTEPRDUCT CHARACTER(3) 3
7 POLICY_DUE_DATE_KEY INTEGER 4
8 ITEMNO SMALLINT 2
9 POLICY_TERMSTART INTEGER 4
10 ITEM_TERM_STATUS CHARACTER(1) 1
11 ITEM_RISKSTATE_KEY INTEGER 4
12 ITEM_RISKSTATE_NAME CHARACTER(10) 10
13 ITEM_CANCEL_REASON_CODE CHARACTER VARYING(2) 2
14 ITEM_CANCEL_REASON_KEY CHARACTER VARYING(4) 4
15 ITEM_CANCEL_REASON_DESC CHARACTER VARYING(60) 60
16 MIN_PREM_FLAG_ITEM CHARACTER VARYING(1) 1
17 LAST_ITEM_AGENT INTEGER 4
18 LAST_ITEM_ITCE NUMERIC(6,2) 19
19 ANZSICCD_1993 CHARACTER VARYING(8) 8
20 ANZSICCD_1993_KEY BIGINT 8
21 ANZSICCD_2006 CHARACTER(8) 8
22 ANZSICCD_2006_KEY BIGINT 8
23 INDUSTRY_RISK_NAME NATIONAL CHARACTER VARYING(250) 250
24 ANZSICIR_2006_KEY BIGINT 8
25 EXTENSION_LEVEL1_KEY INTEGER 4
26 EXTENSION_LEVEL1_NAME CHARACTER(1) 1
27 EXTENSION_LEVEL2_NAME CHARACTER VARYING(60) 60
28 EXTENSION_LEVEL2_KEY BIGINT 8
29 HAZARD_INDEX CHARACTER VARYING(10) 10
30 HAZARD_INDEX_KEY INTEGER 4
31 POLICY_ITEM_TERM_LATEST BIGINT 8
32 POLICY_TERM_LATEST BIGINT 8
33 IDP CHARACTER VARYING(50) 50
34 POLICY_TERM_IND BIGINT 8
35 POLICY_LATEST BIGINT 8
36 POLICY_TERM_STATUS CHARACTER VARYING(1) 1
37 INITIAL_ESTIMATED_WAGES NUMERIC(11,0) 19
38 CURRENT_WAGES NUMERIC(11,0) 19
39 INITIAL_ESTIMATED_NOEMP INTEGER 4
40 CURRENT_NOEMP INTEGER 4
41 MINIMUM_PREMIUM NUMERIC(11,2) 19
42 TOTAL_BASE_PREMIUM NUMERIC(11,2) 19
43 TOTAL_TECHNICAL_PREMIUM NUMERIC(15,2) 19
44 TOTAL_MODEL_PREMIUM NUMERIC(15,2) 19
45 TOTAL_INDUSTRY_PREMIUM NUMERIC(15,2) 19
46 TECHRATE NUMERIC(5,2) 19
47 MDLRATE NUMERIC(5,2) 19
48 INDRATE NUMERIC(5,2) 19
49 MODELUW_VARIANCE NUMERIC(5,2) 19
50 TECHUW_VARIANCE NUMERIC(5,2) 19
51 INDUW_VARIANCE NUMERIC(5,2) 19
52 OVERALL_MOD_RATE NUMERIC(5,2) 19
53 OVERALL_UW_RATE NUMERIC(5,2) 19
54 UWRATE_ADJ NUMERIC(5,2) 19
55 UWRATE_ADJ_RC CHARACTER(2) 2
56 PURE_MODEL_RATE NUMERIC(5,2) 19
57 WA_GAZETTE_DISCOUNT CHARACTER VARYING(1) 1
58 EXT_BASE_PREM_ADJ NUMERIC(11,2) 19
59 EXT_BASE_PREM_ADJ_RC CHARACTER(2) 2
60 LAST_MIN_PREM_ADJ NUMERIC(11,2) 19
61 LAST_MIN_PREM_ADJ_RC CHARACTER(2) 2
62 ITEM_CLASS CHARACTER(3) 3
63 ITEM_SUBCLASS CHARACTER(3) 3
64 EFFECTIVE_DAYS_WAGES NUMERIC(12,2) 19
65 PROPORTIONED_VALUE_WAGES NUMERIC(12,8) 19
66 EARNED_WAGES NUMERIC(15,2) 19
67 REGO_NO CHARACTER(12) 12
68 BASE_PREMIUM_RATE NUMERIC(27,14) 19
69 TECHNICAL_PREMIUM_RATE NUMERIC(5,2) 19
70 MODEL_PREMIUM_RATE NUMERIC(5,2) 19
71 INDUSTRY_PREMIUM_RATE NUMERIC(5,2) 19
72 GAZETTEPLUS75 CHARACTER VARYING(1) 1
73 GAZETTEPLUS75_KEY INTEGER 4
74 WAGEDEC_ACT CHARACTER(2) 2
75 WAGEDEC_EST CHARACTER(2) 2
76 NEW_TERM_DUE_DATE CHARACTER VARYING(200) 200
77 RBASICPRM NUMERIC(11,2) 19
78 LY_WAGES NUMERIC(12,1) 19
79 LY_RATE NUMERIC(5,2) 19
80 LY_MIN_PREM_ITEM CHARACTER VARYING(1) 1
81 CANCEL_ON_INCEPTION CHARACTER VARYING(1) 1
82 ISSUEDSTATE_KEY INTEGER 4
83 ISSUEDSTATE_NAME CHARACTER(10) 10
84 PREVIOUS_INSURER CHARACTER(9) 9
85 PREVIOUS_INSURER_KEY BIGINT 8
86 AGENCY_NUMBER INTEGER 4
87 PREV_INSURER_GROUP CHARACTER VARYING(8) 8