INT_WC_MANZ_NICHE_CHG0208107

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 GLPRODUCT CHARACTER VARYING(1) 1
2 POLICYNUMBER CHARACTER VARYING(15) 15
3 POLICYNO INTEGER 4
4 TERMIDENT BIGINT 8
5 COVERAGENUMBER SMALLINT 2
6 FUND CHARACTER(10) 10
7 STATE CHARACTER(10) 10
8 COMPANY CHARACTER(10) 10
9 POLICYEFFECTIVEDATE DATE 4
10 TERMEFFECTIVEDATE DATE 4
11 TERMEXPIRYDATE DATE 4
12 ANZSIC_2006 CHARACTER(8) 8
13 ANZSIC_1993 CHARACTER(8) 8
14 WIC CHARACTER VARYING(1) 1
15 HAZARDINDEX NUMERIC(5,2) 19
16 SCHEME CHARACTER(27) 27
17 BRANCH SMALLINT 2
18 REGION CHARACTER VARYING(1) 1
19 AGENT_GROUP CHARACTER VARYING(60) 60
20 ACCOUNT1 CHARACTER VARYING(10) 10
21 ACCOUNT2 CHARACTER VARYING(1) 1
22 ACCOUNTTYPE1 CHARACTER VARYING(1) 1
23 ACCOUNTTYPE2 CHARACTER VARYING(1) 1
24 DISTN1 CHARACTER(20) 20
25 DISTN2 CHARACTER VARYING(1) 1
26 PROVISIONAL INTEGER 4
27 TOTALANZSICS BIGINT 8
28 WAGES_ACTUAL NUMERIC(14,2) 19
29 WAGES_ESTIMATE NUMERIC(14,2) 19
30 WAGES NUMERIC(38,0) 19
31 STAFF INTEGER 4
32 STAFF_ESTIMATE INTEGER 4
33 BASICRATEDPREM NUMERIC(12,2) 19
34 GROSSPREM NUMERIC(12,2) 19
35 BONUS NUMERIC(12,2) 19
36 COMMONLAW NUMERIC(12,2) 19
37 XSDELPREM NUMERIC(12,2) 19
38 ADMIN NUMERIC(12,2) 19
39 ITC NUMERIC(12,2) 19
40 PREMDISCOUNT NUMERIC(12,2) 19
41 INTEREST NUMERIC(12,2) 19
42 OTHERCHARGES NUMERIC(12,2) 19
43 DUSTDISEASE NUMERIC(12,2) 19
44 SFUND NUMERIC(12,2) 19
45 STAMPDUTY NUMERIC(12,2) 19
46 GST NUMERIC(12,2) 19
47 COMMISSION NUMERIC(12,2) 19
48 GSTONCOMMISSION NUMERIC(12,2) 19
49 CED NUMERIC(12,2) 19
50 OSHPP NUMERIC(12,2) 19
51 POLICYSTATUS CHARACTER(1) 1
52 LINEOFBUSINESSCODE CHARACTER VARYING(1) 1
53 UNDERWRITERCODE CHARACTER(8) 8
54 CLIENTCLASS CHARACTER VARYING(1) 1
55 COMPANYPREFIX CHARACTER VARYING(1) 1
56 CLIENTPOLICY INTEGER 4
57 CLIENTAGENT INTEGER 4
58 CLIENTAGENT2 CHARACTER VARYING(1) 1
59 CANCELREVIVEEFFDATE CHARACTER VARYING(1) 1
60 POLICYSTATUS_TERM CHARACTER VARYING(1) 1
61 COY CHARACTER VARYING(1) 1
62 CANCELLAPSEREASON CHARACTER VARYING(2) 2
63 RENEWALSTATUS CHARACTER VARYING(1) 1
64 DECLRN CHARACTER VARYING(1) 1
65 NAMEREF INTEGER 4
66 NAME CHARACTER VARYING(80) 80
67 SOURCE_SYSTEM CHARACTER VARYING(7) 7
68 BURNERIND CHARACTER VARYING(1) 1
69 FRONT CHARACTER VARYING(1) 1
70 POLICYTYPE INTEGER 4
71 SEQPOLICYNO INTEGER 4
72 MULTI_LOC_FLAG CHARACTER VARYING(1) 1
73 NO_OF_LOC BIGINT 8
74 MDLRATE NUMERIC(5,2) 19
75 TECHRATE NUMERIC(5,2) 19
76 INDRATE NUMERIC(5,2) 19
77 OVRMDLRATE NUMERIC(5,2) 19
78 OVRUWRATE NUMERIC(5,2) 19
79 GZTADJRATE NUMERIC(5,2) 19
80 RATEOVRREAS CHARACTER(2) 2
81 VARUWMODEL NUMERIC(5,2) 19
82 VARTECHUW NUMERIC(5,2) 19
83 VARINDSTUW NUMERIC(5,2) 19
84 WAGESRATE NUMERIC(11,2) 19
85 UWRATE NUMERIC(5,2) 19
86 OCCMINPREM NUMERIC(11,2) 19
87 MINPREREAS CHARACTER(2) 2
88 MINPREM_B NUMERIC(11,2) 19
89 MINPREM_E NUMERIC(38,8) 19
90 MINPREMADJ_B NUMERIC(38,6) 19
91 MINPREMADJ_E NUMERIC(38,12) 19
92 CEDREFPCT SMALLINT 2
93 CEDPRMPCT SMALLINT 2
94 MAXCEDREF SMALLINT 2
95 IBNRIBNER SMALLINT 2
96 CEDPREMTH INTEGER 4
97 CEDINCMTH SMALLINT 2
98 CEDTERMST DATE 4
99 CEDTERMEN DATE 4
100 CEDCALCDT DATE 4
101 POLICY_TERM_OFFERING CHARACTER(4) 4
102 CLAIM_BASIS CHARACTER(1) 1
103 INTERIM_ADJ_FACTOR CHARACTER VARYING(19) 19
104 FINAL_ADJ_FACTOR CHARACTER VARYING(19) 19
105 NO_OF_YEARS SMALLINT 2
106 CALL_UP_FREQ CHARACTER(1) 1
107 MAX_PREMIUM NUMERIC(11,0) 19
108 MAX_RATE NUMERIC(5,2) 19
109 MIN_PREMIUM NUMERIC(11,0) 19
110 MIN_RATE NUMERIC(5,2) 19
111 SAQ CHARACTER VARYING(4) 4
112 SAQANS1 CHARACTER VARYING(4) 4
113 SAQANS2 CHARACTER VARYING(4) 4
114 SAQANS3 CHARACTER VARYING(4) 4
115 SAQANS4 CHARACTER VARYING(4) 4
116 SAQANS5 CHARACTER VARYING(4) 4
117 RMTYPE CHARACTER(34) 34
118 RMINCOFF INTEGER 4
119 RMINCPAID INTEGER 4
120 RMINCEARN INTEGER 4
121 MULTI_YEAR CHARACTER(2) 2
122 CAT_C CHARACTER(1) 1
123 RENLIKEIND CHARACTER(1) 1
124 FREE_FORMAT_FLAG CHARACTER VARYING(1) 1
125 STD_CLAUSE_FLAG CHARACTER VARYING(1) 1
126 INSTAL_FREQ CHARACTER(1) 1
127 NO_OF_BUNDLES BIGINT 8
128 NAT_ACCOUNT CHARACTER(60) 60
129 NAT_OWNER CHARACTER(60) 60
130 KAM1 CHARACTER(60) 60
131 KAM2 CHARACTER(60) 60
132 AGENT_NAME CHARACTER VARYING(40) 40
133 AGENT_TYPE CHARACTER(1) 1
134 AGENT_TYPE_DESC CHARACTER(20) 20
135 AGENT_CLUSTER CHARACTER VARYING(37) 37
136 CHANNEL CHARACTER(10) 10
137 WAGESDECSTAT CHARACTER(2) 2
138 ACTWAGEDECST CHARACTER(2) 2
139 RERATE INTEGER 4
140 ITMSTATUS CHARACTER(1) 1
141 PREVIOUS_POLICY_NUMBER CHARACTER VARYING(14) 14
142 PREVIOUS_INS_COMPANY CHARACTER VARYING(4) 4
143 LINK_POLICY CHARACTER VARYING(15) 15
144 COMMIT_TIMESTAMP TIMESTAMP 8